Providea workbookcontaining at least15 attributes
Geta ready-to-use,best-in-marketGOOGLE ADS dashboard
Google Ads Home
Google Ads Home![Google Ads Home]()
Get a Home Page for your Google Ads dashboard
Google Ads Cockpit
Google Ads Cockpit![Google Ads Cockpit]()
Get instant overview of your Google Ads KPIs: Impressions, Clicks, Cost, Cost per Click...
Campaign Efficiency
Campaign Efficiency![Campaign Efficiency]()
Visualize the life cycle of your campaigns: Total Clicks and relative Costs
Google Ads - Top Pages
Google Ads - Top Pages![Google Ads - Top Pages]()
Which web pages are the most seen on your web site?
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
- Total Cost
- Total Impressions
- Total Clicks
- Total Sessions
- Total Pageviews
- Total Bounces
- CTR %
- Cost per Click
- Impressions per Click
- Avg Duration (s)
- Avg Pageviews
- Bounce %
Detailed presentation of the GOOGLE ADS dashboard
Your GOOGLE ADS dashboard will contain 12 KPIs
- Total CostTotal derived cost for the advertising campaign
- Total ImpressionsTotal number of campaign impressions
- Total ClicksTotal number of times users have clicked on an add to reach your property
- Total SessionsTotal number of sessions
- Total PageviewsTotal number of pageviews
- Total BouncesTotal number of bounces
- CTR %Click Through Rate: Total Clicks / Total Impressions
- Cost per ClickAverage cost per click
- Impressions per ClickAverage number of impressions to generate one click
- Avg Duration (s)Average duration per Session (s)
- Avg PageviewsTotal of pageviews per session
- Bounce %Bounce rate
and 10 dashboard pages
Home
Google Ads Home
Google Ads Home![Google Ads Home]()
Get a Home Page for your Google Ads dashboard
Cockpit
Google Ads Cockpit
Google Ads Cockpit![Google Ads Cockpit]()
Get instant overview of your Google Ads KPIs: Impressions, Clicks, Cost, Cost per Click...
Google Ads Top KPIs Evolution
Google Ads Top KPIs Evolution![Google Ads Top KPIs Evolution]()
Visualize how your Google Ads KPIs are evolving (Month-to-Date, Year-to-Date)
Google Ads Top KPIs Overview
Google Ads Top KPIs Overview![Google Ads Top KPIs Overview]()
Get a transversal view on your top 6 Google Ads KPIs, split by the dimension of your choice
Web Traffic Analysis
Campaign Efficiency
Campaign Efficiency![Campaign Efficiency]()
Visualize the life cycle of your campaigns: Total Clicks and relative Costs
Google Ads - Top Pages
Google Ads - Top Pages![Google Ads - Top Pages]()
Which web pages are the most seen on your web site?
Trends Analysis
Google Ads Trends Analysis
Google Ads 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
Google Ads Segmentation 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
Google Ads Pareto Analysis![Google Ads Pareto Analysis]()
Perform a Pareto Analysis on any of your Google Ads KPIs: the 80/20 rule.
Google Ads KPI Performance
Google Ads KPI Performance![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!
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]
-
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) Bahavior - 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
Finance
Procurement
Digital Marketing
Processes
Case Management
Banking
Healthcare
Telecommunications
Fundraising
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!
Just give it a try here :-)
