Business dashboard template: GOOGLE ADS

/uploads/galerie/000124/Gads Cockpit W.PNG

/uploads/galerie/000124/Gads Cockpit D.PNG

Providea workbookcontaining at least15 attributes

Geta ready-to-use,best-in-marketGOOGLE ADS dashboard

Google Ads Home

Get a Home Page for your Google Ads dashboard

Google Ads Cockpit

Get instant overview of your Google Ads KPIs: Impressions, Clicks, Cost, Cost per Click...

Google Ads Top KPIs Overview

Get a transversal view on your top 6 Google Ads KPIs, split by the dimension of your choice

Google Ads Top KPIs Evolution

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

15 required attributes

Date
Ad Distribution Network
Campaign
Ad Group
Ad Content
Destination URL
Keyword
Cost
Impressions
Clicks
PageViews
Sessions
Bounces
Time on Page
Session Duration

12 KPIs

10 dashboard pages

Detailed presentation of the GOOGLE ADS dashboard

Your GOOGLE ADS dashboard will contain 12 KPIs

Total CostTotal derived cost for the advertising campaign
Total ClicksTotal number of times users have clicked on an add to reach your property
Cost per ClickAverage cost per click
CTR %Click Through Rate: Total Clicks / Total Impressions
Total ImpressionsTotal number of campaign impressions
Impressions per ClickAverage number of impressions to generate one click
Total SessionsTotal number of sessions
Total PageviewsTotal number of pageviews
Total BouncesTotal number of bounces
Bounce %Bounce rate
Avg Duration (s)Average duration per Session (s)
Avg PageviewsTotal of pageviews per session

and 10 dashboard pages

Home

Google Ads Home

Get a Home Page for your Google Ads dashboard

Cockpit

Google Ads Cockpit

Get instant overview of your Google Ads KPIs: Impressions, Clicks, Cost, Cost per Click...

Google Ads Top KPIs Overview

Get a transversal view on your top 6 Google Ads KPIs, split by the dimension of your choice

Google Ads Top KPIs Evolution

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

Web Traffic Analysis

Campaign Efficiency

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

Google Ads - Top Pages

Which web pages are the most seen on your web site?

Trends Analysis

Google Ads Trends Analysis

Visualize the evolution of any of your Google Ads KPIs: Trends, Performance & Year over Year

Distribution Analysis

Google Ads Segmentation Analysis

Visualize the value of any of your Google Ads KPIs, split by the dimension you selected (market share analysis)

Google Ads Pareto Analysis

Perform a Pareto Analysis on any of your Google Ads KPIs: the 80/20 rule.

Google Ads KPI Performance

Visualize the overall performance of any of your Google Ads KPIs: what is the performance, how does this performance evolve, who contributes to this performance

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!

Google Ads dashboard Live Demo

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

Dashboard Template

Predefined (and customizable) KPIs
Predefined DataViz

3rd STEP: Map your attributes

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

The template attribute Your workbook attribute

Date Reference date [ga:date]

Ad Distribution Network The networks used to deliver your ads (Content, Search, Search Partners...) [Advertising - ga:adDistributionNetwork]

Campaign Campaign [Advertising - ga:campaign]

Ad Group The name of your AdWords ad group [Advertising - ga:adGroup]

Ad Content Ad Content [Advertising - ga:adContent]

Destination URL The URL to which your Adwords ads referred traffic [Advertising - ga:adDestinationURL]

Keyword Traffic Source [Acquisition - ga:sourceMedium]

Cost Derived cost for the advertising campaign [Advertising - ga:adCost]

Impressions The total number of campaign impressions [Advertising - ga:impressions]

Clicks The total number of times users have clicked on an add to reach your property [Advertising - ga:adClicks]

PageViews The total number of pageviews for your property [(Site Usage) Users - ga:pageviews]

Sessions The total number of sessions [(Site Usage) Users - ga:sessions]

Bounces The total number of single page (or single engagement hit) sessions for your property [(Site Usage) Users - ga:bounces]

Time on Page How long a user spent on a particular page in seconds [(Site Usage) Behavior - ga:timeOnPage]

Session Duration The total duration of user sessions represented in total seconds [Users - ga:sessionDuration]

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!

Just give it a try here :-)

Packs > Google Ads

Google Ads Home

Google Ads Cockpit

Google Ads Top KPIs Overview

Google Ads Top KPIs Evolution

Detailed presentation of the GOOGLE ADS dashboard

Your GOOGLE ADS dashboard will contain 12 KPIs

and 10 dashboard pages

Home

Google Ads Home

Cockpit

Google Ads Cockpit

Google Ads Top KPIs Overview

Google Ads Top KPIs Evolution

Web Traffic Analysis

Campaign Efficiency

Google Ads - Top Pages

Trends Analysis

Google Ads Trends Analysis

Distribution Analysis

Google Ads Segmentation Analysis

Google Ads Pareto Analysis

Google Ads KPI Performance

Creating your GOOGLE ADS dashboard Step-by-Step

1st STEP: Create the initial Tableau workbook file

2nd STEP: Upload your Tableau workbook file

Dashboard Template

Sales

Finance

Procurement

Digital Marketing

Supply Chain & Production

Human Resources

Processes

Case Management

Banking

Healthcare

Telecommunications

Fundraising

Insurance

3rd STEP: Map your attributes

Other #DataViz Packs

Dashboard Template

Sales

Finance

Procurement

Digital Marketing

Supply Chain & Production

Human Resources

Processes

Case Management

Banking

Healthcare

Telecommunications

Fundraising

Insurance

Custom Dashboard

Communicate & Monitor

Analyze & Understand

Legal

Contact