Google Ads
API Documentation: Google Ads API Documentation
The Google Ads API allows you to access data related to your advertising accounts, campaigns, ad groups, ads, keywords, and performance metrics.
Source Setup Guide
Step 1
Click 
in the Edit Source form to the left.
Step 2
Follow the authentication flow (OAuth) on Google’s website to grant Extract the required permissions.
Step 3
Confirm you can see your email and profile picture, and that the source is Connected.
Step 4 - (Optional) Limit which accounts are synced
By default, Extract will discover and sync all accessible (non-manager) customer accounts available to the authenticated Google Ads user.
If you want to sync only specific accounts, configure Accounts to sync (accounts_to_sync) with a list of Google Ads Customer IDs to include.
Notes:
- Customer IDs are the numeric Google Ads account IDs (often shown with dashes in the UI, e.g.
123-456-7890). Use the format your Extract UI expects; the connector treats them as strings. - Any accounts not in this list will be skipped.
Step 5 - Custom Reports
You can create custom reports from the Google Ads API, tailored to your specific needs.
- Simplified configuration: Extract uses Google Ads Query Language (GAQL), allowing you to build reports using familiar
SELECTandFROMstatements. - Extensive options: Explore report options through the Google Ads Query Builder.
Before saving your custom report, you can use the Google Ads Query Validator to:
- Set up your query: Define the specific data you want to retrieve from Google Ads.
- Validate your query: Ensure the structure of your query is correct and will return the desired results.
- The
segments.datefield is managed automatically by our extraction process and should not be used in theWHEREclause. - When
segments.dateis included automatically, it enables Date Partition load mode; otherwise, the system will perform a Full Refresh. - When
segments.dateis included, the data stream will start from the backfill date set in your connection settings. - Custom reports currently do not support
LIMIT,ORDER BY, orPARAMETERSstatements.
Connection Setup Guide
Once you connected Google Ads to a destination, you will also need to configure:
- Connection Pull Schedule: Determines how frequently data is extracted from the source.
- Backfill (Days): Specifies the duration for which historical data will be retrieved during each connection run.
- Destination-specific settings: Settings such as “Dataset Name” or “Target Schema” (depending on your destination).
- Schema Migration Policy: Controls how Extract will handle schema changes from the source.
Connector Information
Schema ERD
Explore the interactive entity relationship diagram for Google Ads.