Google Ads source for ELT & CDC


Description	Google Ads is an online advertising platform developed by Google, where advertisers bid to display brief advertisements, service offerings, product listings, or videos to web users.
Supported Replication	Initial Sync, Continuous Sync
Authentication Type	OAuth

Collections

Collection Name	Full/Initial Sync	Incremental/Continuous Sync	Supports Update	Supports Delete	Notes
Campaigns
https://developers.google.com/google-ads/api/fields/v19/campaign	✔	✔	✖	✖	•
Ad Groups
https://developers.google.com/google-ads/api/fields/v19/ad_group	✔	✔	✖	✖
Ad Group Ads
https://developers.google.com/google-ads/api/fields/v19/ad_group_ad	✔	✔	✖	✖

Reports

Collection Name	Full/Initial Sync	Incremental/Continuous Sync	Supports Update	Supports Delete	Notes
ACCOUNT_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/customer	✔	✔	✖	✖	Query Resource: `customer`
ADGROUP_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/ad_group	✔	✔	✖	✖	Query Resource: `ad_group`
AD_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/ad_group_ad	✔	✔	✖	✖	Query Resource: `ad_group_ad`
AGE_RANGE_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/age_range_view	✔	✔	✖	✖	Query Resource: `age_range_view`
AUDIENCE_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/ad_group_audience_view	✔	✔	✖	✖	Query Resource: `ad_group_audience_view`
AUTOMATIC_PLACEMENTS_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/group_placement_view	✔	✔	✖	✖	Query Resource: `group_placement_view`
BID_GOAL_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/bidding_strategy	✔	✔	✖	✖	Query Resource: `bidding_strategy`
BUDGET_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/campaign_budget	✔	✔	✖	✖	Query Resource: `campaign_budget`
CALL_METRICS_CALL_DETAILS_REPORT https://developers.google.com/google-ads/api/fields/v19/call_view	✔	✖	✖	✖	Query Resource: `call_view`
CAMPAIGN_AD_SCHEDULE_TARGET_REPORT https://developers.google.com/google-ads/api/fields/v19/ad_schedule_view	✔	✔	✖	✖	Query Resource: `ad_schedule_view`
CAMPAIGN_CRITERIA_REPORT https://developers.google.com/google-ads/api/fields/v19/campaign_criterion	✔	✖	✖	✖	Query Resource: `campaign_criterion`
CAMPAIGN_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/campaign	✔	✔	✖	✖	Query Resource: `campaign`
CAMPAIGN_SHARED_SET_REPORT https://developers.google.com/google-ads/api/fields/v19/campaign_shared_set	✔	✖	✖	✖	Query Resource: `campaign_shared_set`
CAMPAIGN_LOCATION_TARGET_REPORT https://developers.google.com/google-ads/api/fields/v19/location_view	✔	✔	✖	✖	Query Resource: `location_view`
CLICK_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/click_view	✔	✔	✖	✖	Query Resource: `click_view`
DISPLAY_KEYWORD_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/display_keyword_view	✔	✔	✖	✖	Query Resource: `display_keyword_view`
DISPLAY_TOPICS_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v12/topic_view	✔	✔	✖	✖	Query Resource: `topic_view`
GENDER_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/gender_view	✔	✔	✖	✖	Query Resource: `gender_view`
GEO_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/geographic_view	✔	✔	✖	✖	Query Resource: `geographic_view`
KEYWORDLESS_QUERY_REPORT https://developers.google.com/google-ads/api/fields/v19/dynamic_search_ads_search_term_view	✔	✔	✖	✖	Query Resource: `dynamic_search_ads_search_term_view`
KEYWORDS_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/keyword_view	✔	✔	✖	✖	Query Resource: `keyword_view`
LABEL_REPORT https://developers.google.com/google-ads/api/fields/v19/label	✔	✖	✖	✖	Query Resource: `label`
LANDING_PAGE_REPORT https://developers.google.com/google-ads/api/fields/v19/expanded_landing_page_view	✔	✔	✖	✖	Query Resource: `expanded_landing_page_view`
PAID_ORGANIC_QUERY_REPORT https://developers.google.com/google-ads/api/fields/v12/paid_organic_search_term_view	✔	✔	✖	✖	Query Resource: `paid_organic_search_term_view`
PARENTAL_STATUS_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/parental_status_view	✔	✔	✖	✖	Query Resource: `parental_status_view`
PLACEMENT_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/managed_placement_view	✔	✔	✖	✖	Query Resource: `managed_placement_view`
PRODUCT_PARTITION_REPORT https://developers.google.com/google-ads/api/fields/v19/product_group_view	✔	✔	✖	✖	Query Resource: `product_group_view`
SEARCH_QUERY_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/search_term_view	✔	✔	✖	✖	Query Resource: `search_term_view`
SHARED_SET_CRITERIA_REPORT https://developers.google.com/google-ads/api/fields/v19/shared_criterion	✔	✖	✖	✖	Query Resource: `shared_criterion`
SHARED_SET_REPORT https://developers.google.com/google-ads/api/fields/v19/shared_set	✔	✖	✖	✖	Query Resource: `shared_set`
SHOPPING_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/shopping_performance_view	✔	✔	✖	✖	Query Resource: `shopping_performance_view`
URL_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/detail_placement_view	✔	✔	✖	✖	Query Resource: `detail_placement_view`
USER_AD_DISTANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/distance_view	✔	✔	✖	✖	Query Resource: `distance_view`
VIDEO_PERFORMANCE_REPORT https://developers.google.com/google-ads/api/fields/v19/video	✔	✔	✖	✖	Query Resource: `video`

Changelog

v19 → v23 Google Ads API

Data Lookback

Lookback Window
30 days

Setting up Google Ads for ELT & CDC

Overview

ELT & CDC uses the API provided by Google Ads to sync the data. Google Ads API Reference

Requirements

You need to authenticate via OAuth2.

Set customer ID

Google Ads OAuth sign-in and authentication prompt

Getting Started

Pipelines

Sources

Destinations

Monitoring

Security

Transforms

Data Observability

Google Ads source for ELT & CDC

Collections

Reports

Changelog

Data Lookback

Setting up Google Ads for ELT & CDC

Overview

Requirements

Set customer ID

​Collections

​Reports

​Changelog

​Data Lookback

​Setting up Google Ads for ELT & CDC

​Overview

​Requirements

​Set customer ID

Collections

Reports

Changelog

Data Lookback

Setting up Google Ads for ELT & CDC

Overview

Requirements

Set customer ID