Need SQL Queries
Posted by:
Saiyam Vora
Date: September 30, 2016 11:03AM
Hello, I need some help with SQL Queries. I have 2 tables that contain the following fields
advertiser_lookup
-advertiser_id
-advertiser_name
data_snippet
-Date
-advertiser_id
-site_id
-domain
-datacenter
-geo
-user_accepts_cookies? (TRUE/FALSE)
-user_has_data? (TRUE/FALSE)
-impressions
-spend
-requests_sent
-bid_volume
-total_bid_value
-total_wins
I need queries for the following by advertiser name.
Total requests sent
Total requests sent with user data
Percent requests sent with user data
Bid volume
Bid rate
Avg bid value (multiply your answer by 1000 to get to CPM)
Win volume
Win rate
Impressions
Avg spend (multiply your answer by 1000 to get to CPM)
All help is highly appreciated. Thank you.
Subject
Written By
Posted
Need SQL Queries
September 30, 2016 11:03AM
September 30, 2016 11:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.