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_dateif 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.
