Exercise and use case overview

These sample data sources outlined in the technical requirement section are representative of data sources you would use in marketing and advertising analytics. The three data sources contain jewelry store advertising, analytics, and sales data. The queries and approaches in this solution can be replicated and used for similar use cases, with actual business data. See the following diagram of the tables and some of the column associations.

Figure 11.2 – The advertising and sales datasets and their relationships

Reviewing Figure 11.2, you can see some of the possible relationships between the tables. The Ads Data and Google Analytics Data tables both have a DATE column (time and date, respectively). This can help us correlate ad keywords and site visits, possibly showing the effectiveness of advertising campaigns. The datetime column on the eCommerce Data table could then be used to determine whether an ad placement...