/uploads/galerie/000124/Gads Cockpit.PNG

Detailed presentation of the GOOGLE ADS dashboard

Your GOOGLE ADS dashboard will contain 13 KPIs

and 7 dashboard pages

Home

Google Ads Home

Google Ads Home
Google Ads HomeGoogle Ads Home
Get a Home Page for your Google Ads dashboard

Cockpit

Google Ads Cockpit

Google Ads Cockpit
Google Ads CockpitGoogle Ads Cockpit
Better understand the performance of your digital marketing campaigns on Google Ads: Impressions, Clicks, Cost, Cost per Click, CTR...

Google Ads Top KPIs Trends

Google Ads Top KPIs Trends
Google Ads Top KPIs TrendsGoogle Ads Top KPIs Trends
Visualize how your Google Ads KPIs are evolving (Month-to-Date, Year-to-Date)

Google Ads Performance Cockpit

Google Ads Performance Cockpit
Google Ads Performance CockpitGoogle Ads Performance Cockpit
Visualize the performance on your top 4 Google Ads KPIs, how this performance evolves over time and who contributes to this performance

Campaign Performance

Top Campaigns

Top Campaigns
Top CampaignsTop Campaigns
Get an overview of the performance of your top campaigns on Google Ads

Campaign Efficiency

Campaign Efficiency
Campaign EfficiencyCampaign Efficiency
Visualize the life cycle of your campaigns: Total Clicks and relative Costs

Behavioral Analytics

Google Ads - Adhoc Analysis

Google Ads - Adhoc Analysis
Google Ads - Adhoc AnalysisGoogle Ads - Adhoc Analysis
Perform simple ad-hoc analysis on your Google Ads data set: analyze any of your KPIs across any dimension

Creating your GOOGLE ADS dashboard Step-by-Step

You want to get a clear understanding on your Google Ads results? You want to build a Tableau dashboard to better understand your Google Ads data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Google Ads data in less than 5 minutes!

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Google Ads data (whether it comes from: ERP, database, Excel, CSV file...)

You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):

  • date
    Date Reference date [ga:date] *** Use Google Analytics connector to extract data in Tableau *** (Date used for time-series analysis)
  • string
    Ad Distribution Network The networks used to deliver your ads (Content, Search, Search Partners...) [Advertising - ga:adDistributionNetwork]
  • string
    Campaign Campaign [Advertising - ga:campaign]
  • string
    Ad Group The name of your AdWords ad group [Advertising - ga:adGroup]
  • string
    Ad Content Ad Content [Advertising - ga:adContent]
  • string
    Destination URL The URL to which your Adwords ads referred traffic [Advertising - ga:adDestinationURL]
  • string
    Keyword Traffic Source [Acquisition - ga:sourceMedium]
  • numeric
    Cost Derived cost for the advertising campaign [Advertising - ga:adCost]
  • numeric
    Impressions The total number of campaign impressions [Advertising - ga:impressions]
  • numeric
    Clicks The total number of times users have clicked on an add to reach your property [Advertising - ga:adClicks]
  • numeric
    PageViews The total number of pageviews for your property [(Site Usage) Users - ga:pageviews]
  • numeric
    Sessions The total number of sessions [(Site Usage) Users - ga:sessions]
  • numeric
    Bounces The total number of single page (or single engagement hit) sessions for your property [(Site Usage) Users - ga:bounces]
  • numeric
    Time on Page How long a user spent on a particular page in seconds [(Site Usage) Behavior - ga:timeOnPage]
  • numeric
    Session Duration The total duration of user sessions represented in total seconds [Users - ga:sessionDuration]

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Google Ads' and upload your Tableau workbook (note: your data is NOT uploaded).

3rd STEP: Map your attributes

Map the attributes of your workbook on the attributes of the template.

Finally, click 'Confirm & Download'... and your Google Ads dashboard is already downloading :-)

Open the Tableau workbook file you received, it will automatically reconnect to your data sources.

Your Google Ads dashboard is now ready to be used or customized!


Other DataViz Packs