How to Copy Data Studio’s AdWords Template for Facebook, Bing and Twitter in 9 Minutes

GOOGLE DATA STUDIO TEMPLATES · 10-MINUTE READ · By Supermetrics on May 8 2017.

First things first. Let’s start with results. Here is the Adwords Overview template Google Data Studio offers.

And these are the reports I copied for Facebook, Bing and Twitter.

Facebook Ads

https://datastudio.google.com/open/0BxGPgjQHCLwZOEloOGp2em5TRUU

Data sheet here: https://docs.google.com/spreadsheets/d/19iGNmQGR14rWxKKZAFnBBnjkmQjbpXNpM52Jb1ufzxo/edit?usp=sharing

Bing Ads

https://datastudio.google.com/open/0BxGPgjQHCLwZQWlycnZqZHJaV28

Data sheet here: https://docs.google.com/spreadsheets/d/1tpP0UpQRtBZ9CzVXO-thO0t4k-RsCGVzVJHDYfPzAMU/edit?usp=sharing

Twitter Ads

https://datastudio.google.com/open/0BxGPgjQHCLwZdHpOTVdOQnBzMlk

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.

5 Responses to “How to Copy Data Studio’s AdWords Template for Facebook, Bing and Twitter in 9 Minutes”

  1. Mihai Sterian

    A really well planned resource! One thing I would recommend – with so many links, you should consider making them target = _blank so that they open in other windows. People will want to go back and forth to check them all, so it would be good to have the main article in a tab somewhere.

    Reply
    • Anna Shutko

      Hello Mihai, happy to hear you found the article useful! You’ve made a good point, I will fix the links. Thank you. – Anna from Supermetrics

      Reply
  2. Christian

    Question: what if we want to do the above, but include a second data source into the sheet. For example, all data comes from Bing Ads with the exception of conversions, which are tracked separately in Google Analytics. How would I combine GA conversion data and Bing Ads data into one so they match up and schedule a refresh on it?

    Reply

Leave a Comment

  • (will not be published)