Google Ads Migration Guide

Availability:

Airbyte Cloud Airbyte OSS PyAirbyte

Support Level:

Airbyte Connector

Connector Version:

3.7.9(Last updated a month ago)

CDK Version:

5.13.0

Sync Success Rate:

Usage Rate:

Upgrading to 3.0.0

This release upgrades the Google Ads API from Version 13 to Version 15 which causes the following changes in the schemas:

Stream	Current field name	New field name
ad_listing_group_criterion	ad_group_criterion.listing_group.case_value.product_bidding_category.id	ad_group_criterion.listing_group.case_value.product_category.category_id
ad_listing_group_criterion	ad_group_criterion.listing_group.case_value.product_bidding_category.level	ad_group_criterion.listing_group.case_value.product_category.level
shopping_performance_view	segments.product_bidding_category_level1	segments.product_category_level1
shopping_performance_view	segments.product_bidding_category_level2	segments.product_category_level2
shopping_performance_view	segments.product_bidding_category_level3	segments.product_category_level3
shopping_performance_view	segments.product_bidding_category_level4	segments.product_category_level4
shopping_performance_view	segments.product_bidding_category_level5	segments.product_category_level5
campaign	campaign.shopping_setting.sales_country	This field has been deleted

Users should:

• Refresh the source schema
• Reset affected streams after upgrading to ensure uninterrupted syncs.

Refresh affected schemas and reset data

1. Select Connections in the main navbar.
   1. Select the connection(s) affected by the update.
2. Select the Replication tab.
   1. Select Refresh source schema.
   2. Select OK.

Any detected schema changes will be listed for your review.

3. Select Save changes at the bottom of the page.
   1. Ensure the Reset affected streams option is checked.

Depending on destination type you may not be prompted to reset your data.

4. Select Save connection.

This will reset the data in your destination and initiate a fresh sync.

For more information on resetting your data in Airbyte, see this page.

Upgrading to 2.0.0

This release updates the Source Google Ads connector so that its default streams and stream names match the related resources in Google Ads API.

Users should:

• Refresh the source schema
• And reset affected streams after upgrading to ensure uninterrupted syncs.

Upgrading to 1.0.0

This release introduced fixes to the creation of custom query schemas. For instance, the field ad_group_ad.ad.final_urls in the custom query has had its type changed from {"type": "string"} to {"type": ["null", "array"], "items": {"type": "string"}}. Users should refresh the source schema and reset affected streams after upgrading to ensure uninterrupted syncs.