107 lines
5.7 KiB
Markdown
107 lines
5.7 KiB
Markdown
# 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](https://developers.google.com/google-ads/api/fields/v20/query_validator) 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
|
|
|
|
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**.
|
|
|
|
```note
|
|
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.
|
|
|
|
```note
|
|
Depending on destination type you may not be prompted to reset your data.
|
|
```
|
|
|
|
4. 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](/platform/operator-guides/clear).
|
|
|
|
|
|
## 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**.
|
|
|
|
```note
|
|
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.
|
|
|
|
```note
|
|
Depending on destination type you may not be prompted to reset your data.
|
|
```
|
|
|
|
4. 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](/platform/operator-guides/clear).
|
|
|
|
## 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](https://developers.google.com/google-ads/api/fields/v14/ad_group_ad).
|
|
|
|
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.
|