Google Ads

Google Ads connections give you access to your company’s campaign and advertisement data.

Source Setup

We use OAuth to authenticate with Google Ads. When creating a connection, you will be redirected to your Google Ads account to authorize Etleap to extract data. Before setting up a new connection, please perform the following steps to verify that you have the required information.

Log in to your Google Ads account.
Navigate to the top right corner and locate your 10-digit Customer ID.
Copy the Customer ID. When copying it over to Etleap at the connection setup screen, please remove the hyphens.
If you have a manager Customer ID, you’ll be able to extract data from all the other IDs associated with it.

Note

Prefer using an API? Go here and select Google Ads under the Body header to start creating a connection via API.

What Data is Available?

Note

Update-Mode Deletes Support

Deletes are not applicable for this connector as pipelines handle reporting rather than entity data.

Google Ads connections provide reports and entities to start building pipelines with. Reports contain selectable fields, metrics, segments, and attributed resources. Entities return all the available fields, without metrics and additional segmentation options.

You can create Google Ads pipelines with the following reports:

Entity	Pipeline Mode	Iceberg Support
Report: Ad Group	Update	Batch
Report: Ad Group Ad	Update	Batch
Report: Ad Group Ad Asset Combination View	Update	Batch
Report: Ad Group Ad Asset View	Update	Batch
Report: Ad Group Asset	Update	Batch
Report: Ad Group Audience View	Update	Batch
Report: Ad Schedule View	Update	Batch
Report: Age Range View	Update	Batch
Report: Asset Field Type View	Update	Batch
Report: Asset Group Product Group View	Update	Batch
Report: Bidding Strategy	Update	Batch
Report: Campaign	Update	Batch
Report: Campaign Asset	Update	Batch
Report: Campaign Audience View	Update	Batch
Report: Campaign Budget	Update	Batch
Report: Campaign Group	Update	Batch
Report: Click View	Update	Batch
Report: Conversion Action	Update	Batch
Report: Customer	Update	Batch
Report: Customer Asset	Update	Batch
Report: Detail Placement View	Update	Batch
Report: Display Keyword View	Update	Batch
Report: Distance View	Update	Batch
Report: Dynamic Search Ads Search Term View	Update	Batch
Report: Expanded Landing Page View	Update	Batch
Report: Extension Feed Item	Update	Batch
Report: Feed Item	Update	Batch
Report: Feed Placeholder View	Update	Batch
Report: Gender View	Update	Batch
Report: Geographic View	Update	Batch
Report: Group Placement View	Update	Batch
Report: Hotel Group View	Update	Batch
Report: Hotel Performance View	Update	Batch
Report: Hotel Reconciliation	Update	Batch
Report: Income Range View	Update	Batch
Report: Keyword View	Update	Batch
Report: Landing Page View	Update	Batch
Report: Location View	Update	Batch
Report: Managed Placement View	Update	Batch
Report: Paid Organic Search Term View	Update	Batch
Report: Parental Status View	Update	Batch
Report: Product Group View	Update	Batch
Report: Search Term View	Update	Batch
Report: Shopping Performance View	Update	Batch
Report: Smart Campaign Search Term View	Update	Batch
Report: Topic View	Update	Batch
Report: User Location View	Update	Batch
Report: Video	Update	Batch
Report: Webpage View	Update	Batch

You can create Google Ads pipelines with the following entites:

Entity	Pipeline Mode	Iceberg Support
ACCESSIBLE BIDDING STRATEGY	Replace	Batch
ACCOUNT BUDGET	Replace	Batch
ACCOUNT BUDGET PROPOSAL	Replace	Batch
ACCOUNT LINK	Replace	Batch
AD GROUP AD LABEL	Replace	Batch
AD GROUP BID MODIFIER	Replace	Batch
AD GROUP CRITERION	Replace	Batch
AD GROUP CRITERION CUSTOMIZER	Replace	Batch
AD GROUP CRITERION LABEL	Replace	Batch
AD GROUP CRITERION SIMULATION	Replace	Batch
AD GROUP CUSTOMIZER	Replace	Batch
AD GROUP EXTENSION SETTING	Replace	Batch
AD GROUP FEED	Replace	Batch
AD GROUP LABEL	Replace	Batch
AD GROUP SIMULATION	Replace	Batch
AD PARAMETER	Replace	Batch
ASSET	Update	Batch
ASSET GROUP	Replace	Batch
ASSET GROUP ASSET	Replace	Batch
ASSET GROUP LISTING GROUP FILTER	Replace	Batch
ASSET SET	Replace	Batch
ASSET SET ASSET	Replace	Batch
BATCH JOB	Replace	Batch
BIDDING DATA EXCLUSION	Replace	Batch
BIDDING SEASONALITY ADJUSTMENT	Replace	Batch
BIDDING STRATEGY SIMULATION	Replace	Batch
BILLING SETUP	Replace	Batch
CALL VIEW	Replace	Batch
CAMPAIGN ASSET SET	Replace	Batch
CAMPAIGN BID MODIFIER	Replace	Batch
CAMPAIGN CONVERSION GOAL	Replace	Batch
CAMPAIGN CRITERION SIMULATION	Replace	Batch
CAMPAIGN CUSTOMIZER	Replace	Batch
CAMPAIGN DRAFT	Replace	Batch
CAMPAIGN EXPERIMENT	Replace	Batch
CAMPAIGN EXTENSION SETTING	Replace	Batch
CAMPAIGN FEED	Replace	Batch
CAMPAIGN LABEL	Replace	Batch
CAMPAIGN SHARED SET	Replace	Batch
CAMPAIGN SIMULATION	Replace	Batch
CARRIER CONSTANT	Replace	Batch
COMBINED AUDIENCE	Replace	Batch
CONVERSION CUSTOM VARIABLE	Replace	Batch
CONVERSION GOAL CAMPAIGN CONFIG	Replace	Batch
CONVERSION VALUE RULE	Replace	Batch
CONVERSION VALUE RULE SET	Replace	Batch
CURRENCY CONSTANT	Replace	Batch
CUSTOMER ASSET	Replace	Batch
CUSTOMER CLIENT	Replace	Batch
CUSTOMER CLIENT LINK	Replace	Batch
CUSTOMER CONVERSION GOAL	Replace	Batch
CUSTOMER CUSTOMIZER	Replace	Batch
CUSTOMER EXTENSION SETTING	Replace	Batch
CUSTOMER FEED	Replace	Batch
CUSTOMER LABEL	Replace	Batch
CUSTOMER MANAGER LINK	Replace	Batch
CUSTOMER NEGATIVE CRITERION	Replace	Batch
CUSTOMER USER ACCESS	Replace	Batch
CUSTOMER USER ACCESS INVITATION	Replace	Batch
CUSTOMIZER ATTRIBUTE	Replace	Batch
CUSTOM AUDIENCE	Replace	Batch
CUSTOM CONVERSION GOAL	Replace	Batch
CUSTOM INTEREST	Replace	Batch
DETAILED DEMOGRAPHIC	Replace	Batch
DOMAIN CATEGORY	Replace	Batch
FEED	Update	Batch
FEED ITEM SET	Replace	Batch
FEED ITEM SET LINK	Replace	Batch
FEED MAPPING	Replace	Batch
GEO TARGET CONSTANT	Replace	Batch
KEYWORD PLAN	Replace	Batch
KEYWORD PLAN AD GROUP	Replace	Batch
KEYWORD PLAN AD GROUP KEYWORD	Replace	Batch
KEYWORD PLAN CAMPAIGN	Replace	Batch
KEYWORD PLAN CAMPAIGN KEYWORD	Replace	Batch
LABEL	Replace	Batch
LANGUAGE CONSTANT	Replace	Batch
LIFE EVENT	Replace	Batch
MEDIA FILE	Replace	Batch
MOBILE APP CATEGORY CONSTANT	Replace	Batch
MOBILE DEVICE CONSTANT	Replace	Batch
OFFLINE USER DATA JOB	Replace	Batch
OPERATING SYSTEM VERSION CONSTANT	Replace	Batch
PRODUCT BIDDING CATEGORY CONSTANT	Replace	Batch
RECOMMENDATION	Replace	Batch
REMARKETING ACTION	Replace	Batch
SHARED CRITERION	Replace	Batch
SHARED SET	Update	Batch
SMART CAMPAIGN SETTING	Replace	Batch
TOPIC CONSTANT	Replace	Batch
USER INTEREST	Replace	Batch
USER LIST	Replace	Batch

Key Considerations

The Report: Click View resource only returns data from a single day and only stores data from the last 90 days.
Google Ads can refresh your data from the last 30 days, which means that in delta-mode we always fetch data from 30 days ago.
During the initial catch-up, Etleap starts extracting data from your Google Ads account from the early 2000s. This is to make sure the pipeline extracts all the data available in your account. The initial extractions might be empty, as most Google Ads accounts do not have data populated from that time period. Once the pipeline reaches a time period with data in your Google Ads account, it will successfully start to extract it.