The challenge
Campaign data was spread across several advertising platforms and Salesforce, so getting a consistent view of performance meant manual exports and reconciliation.
Managers had no single place to see how campaigns were doing against their monthly targets.
Our approach
We used Coupler.io to bring the data from the different advertising platforms and Salesforce into Google BigQuery, then cleaned and stitched it into one consistent model.
Automated pipelines built with Dataform keep that model up to date without manual work.
Finally we imported the relevant tables into Power BI and designed dashboards that give managers a clear view of campaign performance and compare the metrics with monthly targets.
What we built
- Data integration from advertising platforms and Salesforce into BigQuery with Coupler.io
- Cleaned, stitched data model in Google BigQuery
- Automated Dataform pipelines
- Power BI dashboards for campaign performance against monthly targets