Google Ads

Google Ads allows marketers to retrieve statistics about their ads, ad groups, and campaigns running on Google.

For creating Pipelines using this Source, Hevo provides you a fully managed BigQuery data warehouse as a possible Destination. This option remains available till the time you set up your first BigQuery Destination irrespective of any other Destinations that you may have. With the managed warehouse, you are only charged the cost that Hevo incurs for your project in Google BigQuery. The invoice is generated at the end of each month and payment is recovered as per the payment instrument you have set up. You can now create your Pipeline and directly start analyzing your Source data. Read Hevo Managed Google BigQuery.

Hevo can replicate data from your Google Ads account into your Destination using one of the following APIs:

  • Google Ads API

  • Google AdWords (being sunset on 27 April, 2022)

Hevo fetches two types of objects in Google Ads:

  • Reports: These objects contain statistics of how your ads are performing. For example, the number of clicks received for the ad group on an android device.

  • Metadata (AdWords only): These objects contain information about the ads that you run on Google Ads. For example, the name of the ad or the campaign to which it belongs.

Following are some terms associated with Google Ads that you must be familiar with:

  • Attributed Resources (Google Ads API only): These are attributes from reports that are implicitly joined to another report because their metrics are relevant to the report.

  • Conversion Window: This is the period of time after an ad interaction such as an ad click or a video view, during which a conversion such as a purchase is recorded in Google Ads.

  • Dimensions: These are attributes in a report for which you want to see the statistics.

  • Metrics: These are statistical parameters that you measure for an ad or a campaign.

  • Segments: These are categories used to organize your data around selected criteria.

As an example, in the report for the number of clicks received for the ad group on an android device:

  • The number of clicks can be one of the metrics.

  • The name of the ad group can be the dimension.

  • The android device can be one of the segments.


Prerequisites

  • An active Google Ads account from which data is to be ingested.

  • The Manage permission is granted on the authenticated Google Ads account.


Select Google Ads as a Source

Perform the following steps to configure Google Ads as the Source in your Pipeline:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select Google Ads.

  4. Select the Google Ads version you wish to use for your pipeline (only for users with current AdWords Pipelines).

    Select Google Ads version

  5. In the Configure your Google Ads page, click + ADD GOOGLE ADS ACCOUNT. This redirects you to the Google Ads login page.

  6. Log in to your Google Ads account.

  7. Click Allow to authorize Hevo to access your Google Ads data.

    Click Allow


Specify Google Ads Connection Settings

In the Configure your Google Ads Source page, specify the connection settings for your Google Ads Source, as follows:


Migrating from the AdWords to the Ads API

Google is retiring the AdWords API on April 27, 2022. You must create new Pipelines with Google Ads API as a Source to continue retrieving data from your Google Ads account post this date.

Here a few resources get you familiar with the new API and help with this migration:

  • Migration Checklist: Refer to this document to know all you need to do to get started on your migration to the Google Ads API.

  • Resource mapping tables: There have been a few changes related to field and report names in the Google Ads API when compared to AdWords. Use this table to check for the mapping of your AdWords API reports and field names to their equivalents in the Google Ads API.

  • Querying tools: You need to use the Google Ads Query Language (GAQL) to query the Google Ads API for data instead of the AdWords Query Language (AWQL) used for the AdWords API.
    Use the:

    • Migration tool: To translate your AWQL queries to GAQL. This tool lets you input the original AWQL query and converts it into a new GAQL query. If the conversion is successful, the output will appear green.

    • Query Builder: To build queries using the new language. This tool allows you to select a Google Ads API resource type and displays the fields available for that resource to help you with in making the query.

    • Query Validator: To validate your queries. This tool lets you submit your GAQL queries for validation, if your query is valid, the tool allows you to continue with editing the query, otherwise a list of the relevant errors are displayed.


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Apr-11-2022 NA Added section, Migrating from AdWords to Ads API to help you migrate from AdWords to Google Ads API.
Feb-21-2022 1.82 New document.
Last updated on 28 Apr 2022