Tables In CSV
- “Installs” has data about the amount of installs and GrossRev for each country.
GrossRev – The Revenue before Rev Share
- “Rates” has data about the payout we pay for an install in each country.
Table in this document
- “Rev Share” has data about the monthly revenues tiered model.
The ”Rates” table contains country, rate and the startdate . For example, the rate for BR install from 1.1.2020 is 0.01$ , But from 10.1.2020 the install rate changed to 0.02$
Write SQL query that will output the total traffic Net Revenues by country .
Expected results : Month, Country , Net Revenues
Write SQL query that will output the total traffic buying expenses by country.
Expected results : Month, Country, traffic buying expenses
“Installs” table example:
“Rates” table example:
“Rev Share” Table:
|Amount of Monthly Revenue||Revenue Share|
|Less than 100,000 $||70%|
|$100,000 – $250,000||73%|
|$250,000 - $1,000,000||76%|