gads cockpit w2.PNG gads cockpit d2.PNG
15 required attributes
  • dateDate
  • stringAd Distribution Network
  • stringCampaign
  • stringAd Group
  • stringAd Content
  • stringDestination URL
  • stringKeyword
  • numericCost
  • numericImpressions
  • numericClicks
  • numericPageViews
  • numericSessions
  • numericBounces
  • numericTime on Page
  • numericSession 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

KPi 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

Visualization and 10 dashboard pages

Home

Google Ads - Home

Google Ads - Home
Google Ads - HomeGoogle Ads - Home
Get a Home Page for your Google Ads Dashboard

Cockpit

Google Ads Cockpit

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

Google Ads KPIs

Google Ads KPIs
Google Ads KPIsGoogle Ads KPIs
Understand the contribution to the performance of your top Google Ads KPIs

Google Ads - Top KPIs Evolution

Google Ads - Top KPIs Evolution
Google Ads - Top KPIs EvolutionGoogle 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
Campaign EfficiencyCampaign Efficiency
Visualize the life cycle of your campaigns: Total Clicks and relative Costs

Google Ads - Top Pages

Google Ads - Top Pages
Google Ads - Top PagesGoogle 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 AnalysisGoogle 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
Google Ads - Segmentation AnalysisGoogle 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
Google Ads - ParetoGoogle Ads - Pareto
Pareto Analysis (80 / 20 analysis)

Google Ads - KPI Performance

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

Google Ads KPIs

Google Ads KPIs
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
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
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 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 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
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
Google Ads - Pareto Google Ads - Pareto
Pareto Analysis (80 / 20 analysis)

Google Ads - KPI Performance

Google Ads - KPI Performance
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 :-)

 

Other #DataViz Packs