SQL queries for drawing analysis
Budget: $30 – $250 USD
This is a potential use case for our business in terms of drawing insights. We work with social media creators who drive engagement to advertisers and these are some key metrics we need to track and would like to be able to do it ad hoc with a set of queries.
Below are data samples from 3 SQL tables: clicks, orders, and advertiser_program.
The clicks table tracks how many clicks an influencer drove to an advertiser in a given channel on a given day. Similarly, the orders table tracks how many orders an influencer drove to an advertiser in a given channel on a given day.
The advertiser_program table documents an advertiser’s id and name.
It is possible for an influencer to drive clicks but no orders to an advertiser on a given day via a given channel. It is also possible for an influencer to drive orders but no clicks to an advertiser on a given day via a given channel.
Below are data samples from 3 SQL tables: clicks, orders, and advertiser_program.
The clicks table tracks how many clicks an influencer drove to an advertiser in a given channel on a given day. Similarly, the orders table tracks how many orders an influencer drove to an advertiser in a given channel on a given day.
The advertiser_program table documents an advertiser’s id and name.
It is possible for an influencer to drive clicks but no orders to an advertiser on a given day via a given channel. It is also possible for an influencer to drive orders but no clicks to an advertiser on a given day via a given channel.