Project background

The company M develops mobile apps and buys traffic. It pays ad networks for app installs. To understand which campaigns are profitable and which are draining the budget, a marketing dashboard is needed: a single table that consolidates advertising costs and the revenue these campaigns have generated. Right now, this data is spread across four separate tables and isn’t linked.

Your assignment

Link separate tables together. Create a marketing dashboard – a single table that shows which advertising campaigns are profitable and which are not. Using this dashboard as a basis, build a Tableau dashboard with several visualizations of your choice. It’s very important to describe your entire calculation process in as much detail as possible.

Additional information

To access the Google BigQuery project, send your Google email address to the M company.

Table contents:

• non_org_installs_report – installations of an app from advertising sources;
• cost_table – advertising costs;
• ad_revenue_raw – in-app advertising revenue;
• in_app_events_report – subscriptions, purchases, and related events.

Data period: June – July 2026.