Understanding the data

After speaking with our marketing team, and the operations team that is collecting our data, we now know that the new data coming in will be conversion event data. We already have data on our geographies and marketing campaigns, and descriptive data on our conversion events.

Let’s first look at the data we already have in our systems. The first table we have is a country geography table with the following schema:

Figure 12.1 – Country dimension schema

Let’s take a look at some sample data from this table so we know what’s in it:

Figure 12.2 – Sample country dimension data

In Figure 12.3 we have a conversion events table. It has the following schema:

Figure 12.3 – Conversion event dimension schema

Let’s take a look at some sample data from this table so we know what’s in it:

Figure 12.4...