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 the BigQuery Data Transfer Service 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.

Google Ads API

The BigQuery Data Transfer Service for Google Ads periodically updates to support new columns and adapt to changes introduced by new Google Ads API versions. The BigQuery Data Transfer Service for Google Ads connector uses the supported API version in the Google Ads connector.

The following sections outline the changes when updating to a new Google Ads API version. Changes are organized by release date, and each entry provides information on the changes you need to make for you to continue receiving data from Google Ads.

For more information about the Google Ads API release schedule, see Timetable.

January 20, 2025

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: January 20, 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

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'

June 24, 2024

Google Ads transfers plans to update the Google Ads API version from v14 to v16. In this API upgrade, the column names for newly transferred data in the affected tables are changed. Also, some columns are deprecated. For more information, see Google Ads API upgrade.

Target start date: June 17, 2024
Delivery date: June 23, 2024

Tables affected	Deprecated columns	New columns
`ShoppingProductStats` `ShoppingProductConversionStats`	`segments_product_bidding_category_level1`	`segments_product_category_level1`
	`segments_product_bidding_category_level2`	`segments_product_category_level2`
	`segments_product_bidding_category_level3`	`segments_product_category_level3`
	`segments_product_bidding_category_level4`	`segments_product_category_level4`
	`segments_product_bidding_category_level5`	`segments_product_category_level5`
`ProductGroupStats`	`ad_group_criterion_listing_group_case_value_product_bidding_category_id`	`ad_group_criterion_listing_group_case_value_product_category_category_id`
	`ad_group_criterion_listing_group_case_value_product_bidding_category_level`	`ad_group_criterion_listing_group_case_value_product_category_level`
	`AssetGroupListingFilter`	`asset_group_listing_group_filter_case_value_product_bidding_category_id`	`asset_group_listing_group_filter_case_value_product_category_category_id`
		`asset_group_listing_group_filter_case_value_product_bidding_category_level`	`asset_group_listing_group_filter_case_value_product_category_level`
		`asset_group_listing_group_filter_vertical`	`asset_group_listing_group_filter_listing_source`

With Google Ads API v14, new columns, such as segments_product_category_level1 and segments_product_category_level2, were added to the BigQuery table schema but were populated with null. With the update to Google Ads API v16, these new columns will be populated with new values. Deprecated columns, such as segments_product_bidding_category_level1 and segments_product_bidding_category_level2, will be populated with null, but will still remain in the table schema.

For each pair of columns, only one column is populated with values from the Google Ads API while the other will be populated with null. To ensure your existing queries keep working after the update, update your queries to choose one of the two columns. For example, if you have the following statement in your SQL query:

segments_product_bidding_category_level1

Replace with the following statement that specifies the correct column:

IFNULL(segments_product_category_level1, segments_product_bidding_category_level1)

Transfer configurations that are created after June 24th 2024 will always use the new columns. Deprecated columns will still remain in the table schema but populated with null.