How to copy Data Studio’s Google Ads template for Facebook, Bing & Twitter in 9 minutes
10-MINUTE READ · By Supermetrics on May 8 2017.
UPDATE: This article tells how you can pull data into a Data Studio dashboard using Supermetrics for Google Sheets. Now you can create reports much more effectively with Supermetrics for Google Data Studio connectors. Start a free trial here.
First things first. Let’s start with results. Here is the Adwords Overview template Google Data Studio offers.
Facebook Ads
Data sheet here: https://docs.google.com/spreadsheets/d/19iGNmQGR14rWxKKZAFnBBnjkmQjbpXNpM52Jb1ufzxo/edit?usp=sharing
Bing Ads
Data sheet here: https://docs.google.com/spreadsheets/d/1tpP0UpQRtBZ9CzVXO-thO0t4k-RsCGVzVJHDYfPzAMU/edit?usp=sharing
Twitter Ads
Data sheet here: https://docs.google.com/spreadsheets/d/1omB2fntuTRCrXN7VhiiD6GYp1jgpbHT4KXGsHgJtyT8/edit?usp=sharing
It took me 3 minutes each, 9 minutes in total. I’ll walk you through how to do it step by step.
Copy the AdWords template for Bing
Bing is the most straightforward platform since its metrics and dimensions are almost identical with Adwords.
- Open Google Sheets, launch the Supermetrics add-on and connect to your Bing Ads account
- Select dates -> Whatever date range you want to report on. I used 13 months in this template.
- Select metrics -> Cost , Clicks, Impressions, Conversions
- Split by -> Date, Campaign name, Device type
- Click Get Data to Table to fetch your data
- Scheduled automatic refreshing for this sheet.
- Open Google’s [Sample] AdWords Overview Report, and USE TEMPLATE
- Click New Data Source drop-down menu, choose CREATE NEW DATA SOURCE, and then choose the sheet you just created
- Create calculated fields, CTR, Avg. CPC, Conv. rate, Cost / Conv. and Avg. CPM.
- Connect each chart with missing metrics to the right calculated fields
- Your Bing Ads report is ready!
Copy the AdWords template for Facebook
The only thing to note is to choose Impression device as Device type in Bing and Offsite conversions as Conversions in Bing. Otherwise, the steps are the same.
- Open Google Sheets, launch the Supermetrics add-on and connect to your Facebook Ads account
- Select dates -> Whatever date range you want to report on. I used 2016-01-01 to today in this template.
- Select metrics -> Cost , Clicks, Impressions, Offsite conversions
- Split by -> Date, Campaign name, Impression device
- Click Get Data to Table to fetch your data
- Scheduled automatic refreshing for this sheet.
- Open Google’s [Sample] AdWords Overview Report, and USE TEMPLATE
- Click New Data Source drop-down menu, choose CREATE NEW DATA SOURCE, and then choose the sheet you just created
- Create calculated fields, CTR, Avg. CPC, Conv. rate, Cost / Conv. and Avg. CPM.
- Connect each chart with missing metrics to the right calculated fields
- Your Facebook Ads report is ready!
Copy the AdWords template for Twitter
You can make an almost identical report for Twitter Ads apart from the device breakdown. Twitter offers a dimension called Platform which closely resembles to device. It includes iOS devices, Android devices, Blackberry phones and tablets, Desktop and laptop computers, Mobile web on other devices.
Otherwise, the steps are the same as steps to create a template for Facebook.
Closing thoughts
Before Data Studio offers native connectors for non-Google data sources, pulling data via the Sheets connector is the only option of making Data Studio truly a one-stop shop for reporting.
I admit that it would require a bit more work than using native connectors. But it’s rather straightforward to learn and an invaluable skill for fully harnessing Data Studio. After all, the long tail of digital marketing platforms and tools means Data Studio will never cover all of them. Once you get the hang of using the Sheets connector, you can create reports for any data source in minutes.
If you are using or plan to use Data Studio, what’s in your wish list of templates? Or do you already have any nice reports that we can help promote to our audiences? Feel free to tweet us.
Turn your marketing data into opportunity
We streamline your marketing data so you can focus on the insights.