Providea workbookcontaining at least15 attributes
Geta ready-to-use,best-in-marketGOOGLE ADS dashboard
Google Ads Home
Google Ads Home
Get a Home Page for your Google Ads dashboard
Google Ads Cockpit
Google Ads Cockpit
Get instant overview of your Google Ads KPIs: Impressions, Clicks, Cost, Cost per Click...
Google Ads Top KPIs Overview
Google Ads Top KPIs Overview
Get a transverse view on your top 6 Google Ads KPIs, split by the dimension of your choice
Google Ads Top KPIs Evolution
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
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 11 dashboard pages
Home
Google Ads Home
Google Ads Home
Get a Home Page for your Google Ads dashboard
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 Overview
Google Ads Top KPIs Overview
Get a transverse view on your top 6 Google Ads KPIs, split by the dimension of your choice
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 Performance Cockpit
Google 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
Web Traffic Analytics
Campaign Efficiency
Campaign Efficiency
Visualize the life cycle of your campaigns: Total Clicks and relative Costs
Google Ads - Top Pages
Google Ads - Top Pages
Which web pages are the most seen on your web site?
Trends Analytics
Google Ads Trends Analysis
Google Ads Trends Analysis
Visualize the evolution of any of your Google Ads KPIs: Trends, Performance & Year over Year
Distribution Analytics
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
Perform a Pareto Analysis on any of your Google Ads KPIs: the 80/20 rule.
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] (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
Sales
Finance
Procurement
Digital Marketing
Project Management
Service Desk / Call Center
Sentiment Analysis
General Services
Banking
Healthcare
Telecommunications
Fundraising
Education
Insurance
Retail
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!
