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.

Have more questions on this topic? Ask our AI assistant for in-depth insights.

Read more from sources 👇

The Only Digital Marketing Feed You'll Ever Need.

Stay informed your way. Tailored updates when and how you want them. 100% Free.

10,000+ Users

500+ Sources

1000+ Tools

Or

Related Posts

Tired of spending too much time creating audits for your clients?

Tired of spending too much time creating audits for your clients?

Featured
Google Display Network integrates with Demand Gen for expanded ad inventory controls

Google Display Network integrates with Demand Gen for expanded ad inventory controls

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Google Ads Expands WhatsApp Messaging to Performance Max Campaigns

Google Ads Expands WhatsApp Messaging to Performance Max Campaigns

Google introduces Asset Testing for Performance Max campaigns to measure creative impact

Google introduces Asset Testing for Performance Max campaigns to measure creative impact

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Google Ads Editor 2.9 Released with Performance Max and VRC Conversion Tools Trending ️‍🔥

Google Ads Editor 2.9 Released with Performance Max and VRC Conversion Tools

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Google Ads raises negative keyword limit for PMax campaigns from 100 to 10000 Trending ️‍🔥

Google Ads raises negative keyword limit for PMax campaigns from 100 to 10000

Ginny Marvin
Ginny Marvin

Official Source

Official Source

Ginny Marvin is a Official Source. The source has been verified by Swipe Insight team.

Official Source
Google Clarifies Ads Review Process for Policy Violations

Google Clarifies Ads Review Process for Policy Violations

Google
Google

Official Source

Official Source

Google is a Official Source. The source has been verified by Swipe Insight team.

Official Source
BigQuery Makes Analytics Hub Egress Controls and Data Clean Room Subscriptions Widely Available

BigQuery Makes Analytics Hub Egress Controls and Data Clean Room Subscriptions Widely Available

Google Cloud
Google Cloud

Official Source

Official Source

Google Cloud is a Official Source. The source has been verified by Swipe Insight team.

Official Source

Related Tools

Markifact logo

Markifact

Verified Tool

Verified Tool

Markifact is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Marketing Workflows Powered by AI

Featured
Marketing Auditor logo

Marketing Auditor

Verified Tool

Verified Tool

Marketing Auditor is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Automated audits for Google Ads and Analytics.

Get Featured Here

Showcase your tool in this list.

Contact Us
Sembot logo

Sembot

Maximize ROI with AI-driven marketing automation

Ad Management
Skai logo

Skai

AI-powered omnichannel marketing and optimization

Ad Management
Smartly.io logo

Smartly.io

Automate and optimize your ad campaigns effortlessly

Ad Management
Grasp logo

Grasp

Automated QA for flawless media buying campaigns

Ad Management
Databricks logo

Databricks

Generative AI-powered data intelligence platform

Data Engineering
GA4 SQL logo

GA4 SQL

Verified Tool

Verified Tool

GA4 SQL is a Verified Tool. Want to get this badge? Contact us.

Verified Tool

Generate GA4 BigQuery queries easily

Data Analysis
Zocket logo

Zocket

AI-powered marketing for optimized ad campaigns

Ad Creative
GoDataFeed logo

GoDataFeed

Optimize and manage product feeds across channels

Feed Management

Get Featured Here

Showcase your tool in this list.

Contact Us