How to create a dashboard with Google Ads

Google Ads provides a very powerful API to access its rich database. With DashThis‘s native integration of Google Ads, it’s easier than ever to create a great custom-paid search dashboard!

 

1 - How to integrate Google Ads to DashThis
2 - List of metrics and dimensions
3 - Notes/Limitations

 

1- Integrate Google Ads to DashThis


  • Permissions: In order to successfully connect Google Ads to DashThis, you only need to have read-only permissions. Should you require more information on Google's user roles and permissions, please visit Google's help center


How to connect Google Ads to DashThis:


Step 1 - Go to DashThis and click on the integrations page

Step 2 - Scroll down the list of available integrations and click on ADD + beside Google Ads

 

Screen Shot 2022-08-22 at 2.44.15 PM

 

Step 3 - You’re then redirected to Google where you will sign in as usual and allow DashThis to access your Google Ads data (don’t worry – we only use it to generate your dashboards!)



Screen Shot 2022-08-22 at 2.45.21 PM

 


Now you can create reports with Google Ads 🙌 Not sure which data to import? No problem! We created a periodic dashboard template to help you. Simply go to your Dashboard manager page and click on Create Dashboard, search through the periodic templates or write the integration's name, and find Google Ads Report.

Screen Shot 2022-08-22 at 4.20.38 PM

2 - List of metrics and dimensions

 

Metric Name Description
All Conversions Rate The total number of conversions is divided by the total interactions that can lead to conversions. Because you might receive more than one conversion per interaction, this conversion rate may be over 100%.
All Conversions Value The total value of all of your conversions that Google Ads measures across all conversion actions.
All Conversions Value / Click The total value of all of your conversions is divided by the total number of clicks.
All Conversions The total number of conversions that Google Ads measures across all conversion actions.
Average Conversion Value The total value of your conversions, across those conversion actions that you've chosen to include, is divided by the total number of conversions.
Avg. Conversion Value (All Conv.) The total value of all of your conversions that Google Ads measures across all conversion actions are divided by the total number of conversions that AdWords drives (including website, cross-device, and phone call conversions).
Avg. Conversion Value (Conv.) The total value of your conversions, across those conversion actions that you've chosen to include. This is divided by the total number of conversions.
Average Cost per View (CPV) The total cost of all your ad views is divided by the total number of views.
Clicks The total number of times users have clicked on your ad.
Click-Through-Rate (CTR) The total number of ad clicks is divided by the number of ad impressions.
Cost The total cost of your ads.
Conversions The total number of conversions, across those conversion actions you've chosen to include.
Conversion Rate The total number of conversions is divided by the total interactions that can lead to conversions. This only includes conversion actions that you've chosen to include.
Conversion Value The total value of conversions, across those conversion actions you've chosen to include.
Conversion Value / Click The total value of your conversions, across those conversion actions you've chosen to include, is divided by the total number of clicks.
Cost Per Click (CPC) The total cost of your ad is divided by the total number of clicks.
Cost / Conversions The total cost of your ads is divided by the conversion actions that you've chosen to include.
Cost / All Conversions The total cost divided by all conversions
Cost Per Thousand Impressions (CPM) The average cost of 1,000 impressions.
Cross-Device Conversions The number of times someone clicked on your ad and then completed a conversion on another device, browser, or app.
Daily Budget The average amount you would like to spend each day over the course of a month.
Display Lost IS (budget) The estimated percentage of impressions your ads didn't receive on the Display Network due to insufficient budget. This data is available at the campaign level only.
Display Impression Share Your ads' impressions on the Display Network are divided by the estimated number of impressions they were eligible to receive.
Effective Revenue Share (ERS) for Conv. The total cost of your ads is divided by the value of the conversion actions that you've chosen to include.
Effective Revenue Share (ERS) for All Conv. The total cost of your ads is divided by the value of all your conversions that Google Ads measures across all conversion actions.
First Page CPC The estimate of the CPC bid is required in order to show your ad on the first page of the search results. This number is usually shown in micros, but it may be prefixed with "auto: " or may simply be the string "auto" if automatic bidding is used.
Gmail Clicks to Website  The number of clicks on the expanded state of your Gmail ads leads to your landing page. *Important: this metric is not compatible with the dimension placement URL
Impressions The total number of ad campaign impressions
Impressions (Absolute Top) % The percentage of your impressions that are shown as the very first ad above the organic search results
Impressions (Top) % The percentage of your impressions that are shown anywhere above the organic search results
Phone Calls The total number of offline phone calls.
Phone Impressions The number of times either your ad showed your phone number or your number was shown on your website
Phone-Through Rate (PTR) The total number of phone calls received (phone calls) divided by the number of times your phone number was shown (phone impressions)
Quality Score The estimate of how relevant your ads, keywords, and landing pages are to a person seeing your ad. Higher Quality Scores typically lead to lower costs and better ad positions.
Remarketing List Size The total number of people on your remarketing list that could be reached.
Return on Ad Spend (ROAS in $) for Conv. The total transaction revenue for the conversion actions that you've chosen to include, is divided by the cost. This is shown as a dollar amount.
Return on Ad Spend (ROAS in %) for Conv. The total transaction revenue for the conversion actions that you've chosen to include, is divided by the cost. This is shown as a percentage.
Return on Ad Spend (ROAS in $) for All Conv. The total transaction revenue for all your conversions that Google Ads measures across all conversion actions are divided by the cost. This is shown as a dollar amount.
Return on Ad Spend (ROAS in %) for All Conv. The total transaction revenue for all your conversions that Google Ads measures across all conversion actions are divided by the cost. This is shown as a percentage.
Return on Investment (ROI) for Conv. The total value of all the conversion actions that you've chosen to include, minus the cost. This total is then divided by the cost.
Return on Investment (ROI) for All Conv. The total value of all your conversions that Google Ads measures across all conversion actions, minus the cost. This total is then divided by the cost.
Search Lost IS (budget) The estimated percentage of impressions your ads didn't receive on the Search Network due to insufficient budget.
Search Impression Share Your ads' impressions on the Search Network are divided by the estimated number of impressions they were eligible to receive.
Search Lost IS (rank) The estimated percentage of impressions your ads didn't receive on the Search Network due to poor Ad Rank.
Top of Page (CPC) The estimate of the CPC bid is required in order to show your ad on the top of the first page of search results.
Viewable Impressions The number of times your ad was deemed viewable. An ad is viewable when at least 50% of its area is visible for either 1 second for Display Network ads or 2 seconds for Video Ads.
Views The total number of times users have viewed your video ads.
View rate The number of views your TrueView video ad received is divided by its number of impressions (including thumbnail impressions for TrueView in-display ads).
Video played to 25% The percentage of impressions where the viewer watched is 25% of your video ad.
Video played to 50% The percentage of impressions where the viewer watched is 50% of your video ad.
Video played to 75% The percentage of impressions where the viewer watched is 75% of your video ad.
Video played to 100% The percentage of impressions where the viewer watched your entire video ad.
View-through Conv. The total number of view-through conversions. These occur when a user sees your ad, then later completes a conversion on your site without interacting with (e.g. clicking on) another ad.



    Dimension Name Description
    Ad Group The name of the Ad Group.
    Ad Group Status The status of the Ad Group.
    Ad Network The network (Content Search, Search Partners, etc.) is used to deliver the Ads.
    Age Range The user's age range.
    Description The descriptive text of an expanded text ad or responsive display ad.
    Campaign The name of the Campaign.
    Campaign Status The status of the Campaign.
    City The city in which the sessions originated.
    Click Type The component or property of an Ad, such as the headline or offer that users can click.
    Country The country in which the session originated.
    Customer Name The descriptive name of the user's account.
    Device The type of device on which there was an ad impression.
    Display Ad with Image The Ad itself, as well as its image.
    Display Keyword The display keyword used for the Ad.
    Gender The users gender.
    Headline The Ad headline for a text Ad.
    Keyword The keyword targeted for the Search Campaign Ad.
    Keywords without Match Type The aggregation of all versions of a keyword regardless of match type.
    Keyword Status The status of the Keyword.
    Label The label used in the account.
    Metro Area The metro area in which the session originated
    Offer ID The item ID of the product.
    Placement URL The URL of the site on which the Ad is displayed.
    Product Title* The title of the product.
    Product Type 1 The name of the product type level 1
    Product Type 2 The name of the product type level 2
    Product Type 3 The name of the product type level 3
    Product Type 4 The name of the product type level 4
    Product Type 5 The name of the product type level 5
    Region The region in which the session originated.
    Search Term The search term used that triggered your Ad.

     

     

    3- Notes/Limitations

    1. Auction insights are currently not available in the Google Ads API. To learn more about how to pull this information into DashThis, please visit this article.
    2. With Google Ads' new API, Performance Max, Smart campaigns, Local campaigns, and Discovery campaigns are now supported! 🎉
    3. Google Ads conversions metrics are refreshed for the current period and the previous 30 days. This means that if one of your campaigns brought conversion days or weeks after the user saw your ad, the data would be updated up to 30 days after the dashboard’s period is over.
    4. With our Google Ads integration, you can use the Ad dimension in a Multi-Column List widget. With this type of custom widget, you can see a reproduction of a google search result including your Ad, Campaign, and Ad Group.

      ad-multi-column

    5. To help you analyze customer activity on your website, you can link your Google Ads account with your Google Analytics account. More details regarding this information can be found in this article.
    6. Due to Google Ads' API restrictions, all Shopping dimensions can't be used with "Conversion Rate" and "All Conversion Rate" metrics; and the Product Title dimension can't be used with any metric related to Conversions (i.e. Conversions, Conversion Value, Cost per Conversion, Effective Revenue Share, ROAS, etc.) as well as the "Conversion Name" and "Conversion Type" filters.
    7. At this time, Local Service Ads are not available with the Google Ads API.
    8. Shopping Campaign Product images are not available with Google Ads API however, you can pull the product title depending on which metric you choose.

      image-1
    9. With the new Google Ads API, there is a graphic limitation with some ad types (list provided below). Please note that you should have access to the data however, ads will not display any description or image, only the ad ID (see screenshots below)

      Google Ads Shopping SmartAd ID example:

      ad_ID_google

      DashThis widget display example:

      ad_ID_widgetDT


    List of non-supported graphic ad types:

    APP_AD The ad is an app ad.
    APP_ENGAGEMENT_AD The ad is an app engagement ad.
    APP_PRE_REGISTRATION_AD Universal app pre-registration ad.
    DISCOVERY_CAROUSEL_AD Discovery carousel ad.
    DISCOVERY_MULTI_ASSET_AD Discovery multi-asset ad.
    DYNAMIC_HTML5_AD The ad is a display upload ad with one of the DYNAMIC_HTML5_* product types.
    HOTEL_AD The ad is a hotel ad.
    HTML5_UPLOAD_AD The ad is a display upload ad with the HTML5_UPLOAD_AD product type.
    IN_FEED_VIDEO_AD In-feed video ad.
    LEGACY_RESPONSIVE_DISPLAY_AD The ad is a legacy responsive display ad.
    LEGACY_APP_INSTALL_AD The ad is a legacy app install ad.
    LOCAL_AD The ad is a local ad.
    SHOPPING_SMART_AD The ad is a Smart Shopping ad.
    SHOPPING_PRODUCT_AD The ad is a standard Shopping ad.
    SHOPPING_COMPARISON_LISTING_AD The ad is a Shopping Comparison Listing ad.
    SMART_CAMPAIGN_AD Smart campaign ad.
    VIDEO_AD The ad is a video ad.
    VIDEO_BUMPER_AD Video bumper ad.
    VIDEO_OUTSTREAM_AD Video outstream ad.
    VIDEO_RESPONSIVE_AD Video responsive ad.
    VIDEO_NON_SKIPPABLE_IN_STREAM_AD Video non-skippable in-stream ad.
    VIDEO_TRUEVIEW_IN_STREAM_AD Video TrueView in-stream ad.
    UNSPECIFIED No value has been specified.
    UNKNOWN The received value is not known in this version.
    This is a response-only value.



    Should you need any assistance with Google Ads, please reach out to our Support Team 🤘