Building an Ad Campaign Dashboard with Supermetrics
As we've seen in the course, using Google Sheets as a data source allows you to infinitely expand the power of Data Studio.
What makes that really tick are Sheets Add-ons, like Supermetrics, that allow you to pull data from any data source (Twitter, Facebook, Adwords, Mailchimp, etc) into Google Sheets, without writing any code.
In this template, we'll use Supermetrics to pull FB Ads and Adwords data into Sheets, to build a multi-channel ad campaign dashboard.
Since Data Studio allows only one data source per chart, this allows us to compare both advertising platforms on *the same charts*.
Make a copy of the template here, and put it into action:
https://docs.google.com/spreadsheets/d/1PiIBbZUhlMQBCQtLH1M6cUvtrsTNuYQjZjzmO460sII/copy
What makes that really tick are Sheets Add-ons, like Supermetrics, that allow you to pull data from any data source (Twitter, Facebook, Adwords, Mailchimp, etc) into Google Sheets, without writing any code.
In this template, we'll use Supermetrics to pull FB Ads and Adwords data into Sheets, to build a multi-channel ad campaign dashboard.
Since Data Studio allows only one data source per chart, this allows us to compare both advertising platforms on *the same charts*.
Make a copy of the template here, and put it into action:
https://docs.google.com/spreadsheets/d/1PiIBbZUhlMQBCQtLH1M6cUvtrsTNuYQjZjzmO460sII/copy