BigQuery Data Transfer Service adds custom reports support for Google Ads

March 07, 2025 at 4:34:36 AM

TL;DR BigQuery Data Transfer Service now supports custom reports for Google Ads using Google Ads Query Language (GAQL) in transfer configurations. This feature allows ingestion of custom reports and fields beyond standard options and is generally available. The connector supports custom reports from all resources in the Google Ads API. Limitations include unsupported clauses like WHERE and ORDER BY, automatic appending of date segments, and restrictions on backfill runs.

BigQuery Data Transfer Service adds custom reports support for Google Ads

The BigQuery Data Transfer Service now allows the use of custom reports for Google Ads through Google Ads Query Language (GAQL) queries. This feature, which is generally available, enables users to ingest custom reports and fields beyond the standard offerings. The custom reports can pull data from all resources available in the supported Google Ads API version.

When creating a Google Ads transfer, users can specify these custom reports. However, there are limitations to consider:

The Google Ads connector does not support clauses such as WHERE, ORDER BY, LIMIT, and PARAMETERS. GAQL queries must follow the format: SELECT FIELD_NAME, FIELD_NAME,... FROM RESOURCE_NAME.
The connector automatically adds WHERE segments.date = run_date if a core date segment is included in the query, which may trigger validation errors that can be ignored.
GAQL queries lacking a segments.date field function as match tables, updated only once daily and not suitable for backfill runs. To backfill data, a segments.date field must be included.
A maximum of 100 custom reports is supported in a single transfer.