Tableau Facebook Ads vs Google Ads Report Dashboard Template

  • Gert K 
FBvsGoogle tableau

This Facebook Ads vs Google Ads Report template for Tableau Desktop helps to visualise your performance data in one single place. If you are working for your agency, this template will help you to save timeThe target audience for agencies is clients. For internal teams, this dashboard helps with a high-level overview of the marketing performance. To get more granular data, additional columns can be loaded. By default, the template contains paid and non-paid data and contains an overview of the most commonly used channels.

You can easily compare your Google Ads vs Facebook Ads performance using different metrics and conversion data in this Tableau Facebook Ads vs Google Ads Report, like:

  • Campaign
  • Clicks
  • Impressions
  • Spend
  • Date
  • Sessions
  • Conversions
  • Revenue

The process to get started should not take you more than 5 minutes. The prerequisites to get it running are:

  • Tableau Desktop
  • Access to Google Analytics
  • Access to Google Ads
  • Access to Facebook Ads
 An important note before you start setting up the dashboard:
This dashboard blends together data from
  • Google Analytics (Conversions)
  • Facebook Ads (Clicks, Impressions, Spend)
  • Google Ads (Clicks, Impressions, Spend)

You will need to have your Facebook Ads tagged with UTM tags to see the Facebook Conversions (and optionally revenue).

To start using it

  1. Connect your data and sign up for a free trial, or log into your existing account, and connect data sources.register 
  2. Configure Google Analytics, Facebook Ads and Google Ads accounts

 

GA connection

 

Remember to copy your API Key – This template will show data only if your Google Analytics account is connected

  1. Download the template file here (Right click, save as…)
  2. Edit the connection in your dashboard copy to fetch your data.
  3. Copy this URL to Tableau (replace your API Key first)

https://connectors.windsor.ai/all?api_key=YOUR-API-KEY&date_preset=last_7d&fields=source,medium,campaign,clicks,impressions,spend,date,sessions,transactions,transactionRevenue

 

Here is how