Skip to content
/
Migrating Google Adwords...
Last updated

Migrating Google Adwords Integrations

Complete the following steps to migrate from the Google Adwords data connector to the new Google Ads V2 connector. The old one uses Google Adwords API to import data, while the new version uses Google Ads API to ingest data.

Characteristics of Ingested Data

When migrating data from one place or version, it is worth being aware of how that data might be transformed. The following sections outline some important characteristics to be aware of.

Ad Performance Report

There are some deprecated metrics:

  • ClickAssistedConversions
  • ClickAssistedConversionsOverLastClickConversions
  • ClickAssistedConversionValue
  • AverageFrequencyImpressionAssistedConversions
  • ImpressionAssistedConversionsOverLastClickConversions
  • ImpressionAssistedConversionValue

Adgroup Performance Report

There are some unsupported predefined metrics:

  • AbsoluteTopImpressionPercentage (metrics.absolute_top_impression_percentage)
  • TopImpressionPercentage (metrics.top_impression_percentage)

There are some deprecated metrics:

  • ClickAssistedConversions
  • ClickAssistedConversionsOverLastClickConversions
  • ClickAssistedConversionValue
  • ImpressionAssistedConversions
  • ImpressionAssistedConversionsOverLastClickConversions
  • ImpressionAssistedConversionValue

Campaign Performance Report

There are some deprecated metrics:

  • AverageFrequency
  • ClickAssistedConversions
  • ClickAssistedConversionsOverLastClickConversions
  • ClickAssistedConversionValue
  • ImpressionReach
  • ImpressionAssistedConversions
  • ImpressionAssistedConversionsOverLastClickConversions
  • ImpressionAssistedConversionValue

Keywords Performance Report

There are some deprecated metrics:

  • ClickAssistedConversions
  • ClickAssistedConversionsOverLastClickConversions
  • ClickAssistedConversionValue
  • ImpressionAssistedConversions
  • ImpressionAssistedConversionsOverLastClickConversions
  • ImpressionAssistedConversionValue

Audience Performance Report (Not support)

The AUDIENCE_PERFORMANCE_REPORT returned data for both campaign-level and ad group-level audience criteria, while the Google Ads API provides this information in two separate resources: campaign_audience_view and ad_group_audience_view.

Date Range:

  • LAST_WEEK  option is unsupported.
  • segments.date is required for Date range except ALL_TIME

Create a New Google Ads V2 Connector

Go to Treasure Data Catalog, then search and select Google Ads v2.

In the dialog box, enter the values that you enter in your legacy Google Ads connector.

Using OAuth to authenticate the connector

Save Settings and Run the Legacy Google Adwords Data Connector One Last Time

You can save your legacy setting from TD Console or from the CLI.

Using TD Console

Save the Settings of Your Scheduled Legacy Google Adwords Connector and Run a Final Import

Go to Integration Hub > Sources. Search for your scheduled Google Adwords source, select the source and select Edit.

In the dialog box, copy the settings to use later:

Also copy any advanced settings:

Next, you configure one final run with the legacy data connector to create a temporary table against which you can run a config-diff. You use the diff to identify and confirm the latest data imported into Treasure Data.

Before running the final import with the legacy connector, make sure that you change the schedule to one run only:

After the job is complete, look at and copy config_diff in the job query information somewhere to use later.

Create New Google Adwords V2 Source

Go to Integration Hub > Authentication. Search for the new Google Ads V2 connection that you created:

Select the New Source. Fill in all basic settings and advanced settings that you copied in the preceding steps.

After completing the settings, choose the database and table job to populate data into, then schedule the job and provide a name for your new data connector. Select Save and then run the new data connector.

Using CLI and Workflow

Update in: type in your yml configuration from google_adwords to google_adwords_v2.

For example, your existing workflow configuration might look something like this:

in:
  type: google_adwords
  client_id: ${client_id}
  client_secret: ${client_secret}   
  refresh_token: ${refresh_token}   
  client_customer_id: ${client_customer_id}
  target: KEYWORDS_PERFORMANCE_REPORT
  include_predefined_metrics: true
  developer_token: ${developer_token}
  date_range: "TODAY"
out: {}
exec: {}
filters: []

Your new workflow configuration would look like this:

in:
  type: google_adwords_v2
  client_id: ${client_id}
  client_secret: ${client_secret}   
  refresh_token: ${refresh_token}   
  client_customer_id: ${client_customer_id}
  target: KEYWORDS_PERFORMANCE_REPORT
  include_predefined_metrics: true
  developer_token: ${developer_token}
  enable_multiple_page: false
  date_range: "TODAY"
out: {}
exec: {}
filters: []

Appendix

Migration Guide

https://developers.google.com/google-ads/api/docs/migration

Query Migration Tool

https://developers.google.com/google-ads/api/docs/migration/query-migration-tool

Query Validator

https://developers.google.com/google-ads/api/fields/v10/query_validator

Query Builder

https://developers.google.com/google-ads/api/fields/v10/ad_group_audience_view_query_builder

Previous page
Next page