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 Display & Video 360 API, or for specific table names or values.

Display & Video 360 API

The BigQuery Data Transfer Service for Display & Video 360 connector periodically updates to support new columns and adapt to changes introduced by new Display & Video 360 API versions. The BigQuery Data Transfer Service for Display & Video 360 connector uses the supported API version to retrieve configuration data.

The following sections outline the changes when updating to a new Display & Video 360 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 Display & Video 360.

August 26, 2025

The Display & Video 360 connector plans to update the Display & Video 360 API version used to retrieve configuration data from v3 to v4. Changes from the API upgrade are listed in the following section. For more information, see Display & Video 360 API v3 to v4 migration guide.

This update for the Display & Video 360 connector is planned to start on August 26, 2025.

Deprecated Tables

The following tables will stop receiving new data. Existing data will remain, but no further updates will be populated.

CampaignTargeting
InsertionOrderTargeting

Tables with renamed columns

Tables affected	Deprecated columns	New columns
`AdGroupTargeting` `LineItemTargeting`	`audienceGroupDetails.includedFirstAndThirdPartyAudienceGroups`	`audienceGroupDetails.includedFirstPartyAndPartnerAudienceGroups`
	`audienceGroupDetails.includedFirstAndThirdPartyAudienceGroups.settings`	`audienceGroupDetails.includedFirstPartyAndPartnerAudienceGroups.settings`
	`audienceGroupDetails.includedFirstAndThirdPartyAudienceGroups.settings.firstAndThirdPartyAudienceId`	`audienceGroupDetails.includedFirstPartyAndPartnerAudienceGroups.settings.firstPartyAndPartnerAudienceId`
	`audienceGroupDetails.includedFirstAndThirdPartyAudienceGroups.settings.recency`	`audienceGroupDetails.includedFirstPartyAndPartnerAudienceGroups.settings.recency`
	`audienceGroupDetails.excludedFirstAndThirdPartyAudienceGroup`	`audienceGroupDetails.excludedFirstPartyAndPartnerAudienceGroup`
	`audienceGroupDetails.excludedFirstAndThirdPartyAudienceGroup.settings`	`audienceGroupDetails.excludedFirstPartyAndPartnerAudienceGroup.settings`
	`audienceGroupDetails.excludedFirstAndThirdPartyAudienceGroup.settings.firstAndThirdPartyAudienceId`	`audienceGroupDetails.excludedFirstPartyAndPartnerAudienceGroup.settings.firstPartyAndPartnerAudienceId`
	`audienceGroupDetails.excludedFirstAndThirdPartyAudienceGroup.settings.recency`	`audienceGroupDetails.excludedFirstPartyAndPartnerAudienceGroup.settings.recency`

Tables with deprecated columns

Tables affected	Deprecated columns
`Creative`	`reviewStatus.publisherReviewStatuses`

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.

This update for the Google Ads connector started on January 20, 2025, and was completed on February 4, 2025.

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.

This update for the Google Ads connector started on June 17, 2024, and was completed on 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.