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 KPIs
Google Ads KPIs
Understand the contribution to the performance of your top Google Ads KPIs
Campaign Efficiency
Campaign Efficiency
Visualize the life cycle of your campaigns: Total Clicks and relative Costs
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
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 KPIs
Google Ads KPIs
Understand the contribution to the performance of your top Google Ads KPIs
Google Ads - Top KPIs Evolution
Google Ads - Top KPIs Evolution
Visualize how your Google Ads Performance is evolving (Month-to-Date, Year-to-Date)
Web Traffic Analysis
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 Analysis
Google Ads - Trends Analysis
Google Ads - Trends Analysis
Visualize the evolution of the KPI you selected: Trends, Performance & Year over Year
Segmentation Analysis
Google Ads - Segmentation Analysis
Google Ads - Segmentation Analysis
Visualize the value of the KPI you selected split by the dimension you selected (share analysis)
Google Ads - Pareto
Google Ads - Pareto
Pareto Analysis (80 / 20 analysis)
Google Ads - KPI Performance
Google Ads - KPI Performance
Visualize the overall performance of any KPI: evolution and breakdown by the dimension of your choice
Getting this GOOGLE ADS dashboard: step-by-step
You want to get a clear understanding on your Google Ads campaigns? You want to build a Tableau dashboard to better understand Google Ads data?
Using LinPack-for-Tableau.com, you can generate a stunning Tableau dashboard on Google Ads in less than 1 minute!
For this, just follow the instructions :-)
1st step: Create a Tableau workbook containing the connection definition to your Google Analytics account
You must retrieve at least the following attributes:
-
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]
The datasource screen should be configured as follow:
2nd step: On LinPack-for-Tableau.com, select 'create dashboard from template: Google Ads' and upload your Tableau workbook
3rd step: Map your attributes, click 'Confirm & Download'... you're done!!!
This Google Ads dashboard will help you better managing your campaign investments: What is the overall performance of your campaigns? What are the most efficient keywords?....
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 KPIs
Google Ads KPIs
Understand the contribution to the performance of your top Google Ads KPIs
Google Ads - Top KPIs Evolution
Google Ads - Top KPIs Evolution
Visualize how your Google Ads Performance is evolving (Month-to-Date, Year-to-Date)
Web Traffic Analysis
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 Analysis
Google Ads - Trends Analysis
Google Ads - Trends Analysis
Visualize the evolution of the KPI you selected: Trends, Performance & Year over Year
Segmentation Analysis
Google Ads - Segmentation Analysis
Google Ads - Segmentation Analysis
Visualize the value of the KPI you selected split by the dimension you selected (share analysis)
Google Ads - Pareto
Google Ads - Pareto
Pareto Analysis (80 / 20 analysis)
Google Ads - KPI Performance
Google Ads - KPI Performance
Visualize the overall performance of any KPI: evolution and breakdown by the dimension of your choice
Just try it here :-)
DON'T WANT TO READ? Play the video!
Enjoy and share your feedbacks with us so we can improve the solution :-)
