fbpx

SQL Data Analysis Exercises – Online Advertising

This SQL exercise is a part of a section dedicated for data analysts , providing data analysis tasks that require both business understanding and technical skills.

 

About this Exercise

In the Online Advertising Market, a merchant who wants to advertise a new product, can contact different publishers (such as Google or Facebook) and pay them for placing an ad (such as a banner, or video) in their platform.
In return, the online advertising platform gives the merchant metrics to help him measure his ad performance :

  • Clicks – Click happens when someone sees the ad and clicks on it, going to the website for more information.
  • Conversions – After that someone landed on the website, conversion happens when an action (you have defined as a converting action) takes place, for example: online purchase or a call to the business from a mobile phone

 

ERD General Description

The following database simulates data of an online advertising platform.

  • Within the Ads table you’ll find data regarding the various ads
  • Advertisers table lists the different advertisers
  • Clicks reflects the data regarding the clicks on every ad
  • Conversions table lists the clicked conversions

 

Diagram



 

To read more

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…