Business dashboard template: GOOGLE ADS

Providea workbookcontaining at least15 attributes

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

Get a Home Page for your Google Ads dashboard

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

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

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

15 required attributes

13 KPIs

7 dashboard pages

Detailed presentation of the GOOGLE ADS dashboard

Total CostTotal derived cost for the advertising campaign
Total ImpressionsTotal number of campaign impressions
CPM (Cost per 1'000 impressions)Average Cost per 1'000 impressions
CTR (Click-Through-Rate)Click Through Rate: Total Clicks / Total Impressions
Impressions per ClickAverage number of impressions to generate one click
Total ClicksTotal number of times users have clicked on an add to reach your property
CPC (Cost per Click)Average cost per 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

Get a Home Page for your Google Ads dashboard

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

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

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

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

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

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

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

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] *** Use Google Analytics connector to extract data in Tableau *** (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]