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.

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

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.