Skip to content

Latest commit

 

History

History
3 lines (2 loc) · 352 Bytes

File metadata and controls

3 lines (2 loc) · 352 Bytes

Best ad group, a SQL version

Given the following data set, can you write a query that returns the top 3 performing ad groups each day? Performance is defined as the ratio between revenue and spend (e.g. revenue / spend), the higher the ratio the better peformance. The output of the query will be the date and array of the ad groups.