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

Data Studio the Lazy Way

Mastering Google's free dashboard tool

Already enrolled?
Sign in to continue learning.