BigQuery Data Transfer Service data source change log
This page provides details about changes to BigQuery Data Transfer Service data source
schemas and schema mappings. For information about upcoming changes to your data
source connectors, you can search this page for data sources, such as
Google Ads API or Facebook Ads API, or for specific table names or
values.
January 2025 - Google Ads API
Google Ads transfers plans to update the Google Ads API version from v16 to v18. After the API upgrade, the column values for newly transferred data in the affected tables will change. For more information, see Google Ads API upgrade.
- Target start date: 20 January 2025
- Delivery date: Pending
Table: p_ads_Campaign_customer_id
| Columns impacted | Old value (v16) | New value (v18) |
|---|---|---|
| campaign_advertising_channel_type | DISCOVERY | DEMAND_GEN |
Table: p_ads_Ad_customer_id
| Columns impacted | Old value (v16) | New value (v18) |
|---|---|---|
| ad_type |
DISCOVERY_MULTI_ASSET_AD DISCOVERY_CAROUSEL_AD DISCOVERY_VIDEO_RESPONSIVE_AD |
DEMAND_GEN_MULTI_ASSET_AD DEMAND_GEN_CAROUSEL_AD DEMAND_GEN_VIDEO_RESPONSIVE_AD |
Table: Asset
| Columns impacted | Old value (v16) | New value (v18) |
|---|---|---|
| asset_type | DISCOVERY_CAROUSEL_CARD | DEMAND_GEN_CAROUSEL_CARD |
To ensure your queries work after the update, change your queries to
select both old and new values. For example, if you have the following WHERE
condition in your SQL query:
WHERE asset_type='DISCOVERY_CAROUSEL_CARD'
Replace with the following statement:
WHERE asset_type='DISCOVERY_CAROUSEL_CARD' OR asset_type='DEMAND_GEN_CAROUSEL_CARD'