Google Ads Migration Guide

Upgrading to 4.0.0

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

Stream	Current field name	New field name
campaign	campaign.dynamic_search_ads_setting.feeds	This field has been deleted
user_interests	user_interest.availabilities	Updated advertisingChannelSubType enum for the Video channel: removed VIDEO_OUTSTREAM and added YOUTUBE_AUDIO.

For custom queries, the stream may fail if a field was removed during the API update. Additionally, some field values may have changed, such as user_interest.availabilities. You can use the Query Builder to validate your custom queries.

Users should:

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

Refresh affected schemas and reset data

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

note

Any detected schema changes will be listed for your review.

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

note

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

Select Save connection.

note

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 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

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

note

Any detected schema changes will be listed for your review.

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

note

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

Select Save connection.

note

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.