Troubleshoot the Google AdWords connector in Azure Data Factory and Azure Synapse

APPLIES TO: Azure Data Factory Azure Synapse Analytics

This article provides suggestions to troubleshoot common problems with the Google AdWords connector in Azure Data Factory and Azure Synapse.

Migrate to the new version of Google Ads API

Symptoms

You see a hint on the Google AdWords linked service configuration page. It reminds you to upgrade your linked service to a newer version before the legacy API is deprecated by Google.
Cause

Due to the sunset of Google AdWords API by April 27, 2022, you are recommended to migrate your existing linked service to the new version of Google Ads API before the date. Starting April 27, 2022, connection will start to fail because of the deprecation of Google AdWords API (see this link). Migration steps:
1. Open your Google AdWords connector linked service configuration page.
2. Edit the linked service and choose the new API version (select Google Ads).
3. Apply the changes.
Known issues and recommendations
1. The new Google Ads API doesn't provide a migration plan for below reports/tables:
  a. AD_CUSTOMIZERS_FEED_ITEM_REPORT
  b. CAMPAIGN_GROUP_PERFORMANCE_REPORT
  c. CAMPAIGN_NEGATIVE_KEYWORDS_PERFORMANCE_REPORT
  d. CAMPAIGN_NEGATIVE_LOCATIONS_REPORT
  e. CAMPAIGN_NEGATIVE_PLACEMENTS_PERFORMANCE_REPORT
  f. CREATIVE_CONVERSION_REPORT
  g. CRITERIA_PERFORMANCE_REPORT
  h. FINAL_URL_REPORT
  i. KEYWORDLESS_CATEGORY_REPORT
  j. MARKETPLACE_PERFORMANCE_REPORT
  k. TOP_CONTENT_PERFORMANCE_REPORT
2. The syntax for Google Ads query language is similar to AWQL from the AdWords API, but not identical. You can refer this document for more details.

For more troubleshooting help, try these resources: