Skip to main content

Google Ads API Connector

Updated this week
File:Google Ads logo.svg - Wikimedia Commons

Overview

The Google Ads API provides programmatic access to all core campaign management, configuration, and performance reporting data within Google Ads. It is used for retrieving account structure, campaign settings, budget information, keyword and ad performance, audience and asset details, and real-time delivery metrics.

This connector supports search, display, shopping, video (YouTube), Performance Max, app campaigns, local campaigns, and other Google Ads formats.

Data handled by the integration:

Account & Structural Data

  • Accounts & sub-accounts (MCC hierarchy)

  • Campaigns

  • Ad groups

  • Ad group criteria (keywords, audiences, placements, topics, etc.)

  • Labels and shared sets

  • Bidding strategies

  • Budgets

  • Negative keywords & lists

  • Assets and asset groups (Performance Max)

Creative & Ad Data

  • Search text ads

  • Responsive search ads

  • Display ads and asset combinations

  • Video ads (YouTube)

  • Shopping ads (Product Ads, Showcase Ads)

  • Image assets, text assets, URL data

  • Policy approval & disapproval reasons

Performance & Measurement

  • Impressions, clicks, cost, CPC, CPM

  • Conversions & conversion value

  • View-through conversions

  • Search terms

  • Quality score metrics

  • Video metrics (views, view rate)

  • Shopping metrics (product view, cart actions)

  • Asset-level and audience-level performance

Audience & Targeting

  • User lists (first-party audiences)

  • Affinity & in-market audiences

  • Custom audiences & custom segments

  • Geo targeting

  • Devices, networks, placements

  • Demographics (age, gender, household income, parental status)

Metadata & Reference Tables

  • Geo location tables

  • Device types

  • Campaign types

  • Ad types

  • Conversion action definitions

  • Performance Max asset groups

  • Network & channel constants

Granularity:

The Google Ads connector retrieves data at multiple levels: Customer, Campaign, Ad Group, Keyword, Audience, Asset and Creative level.

Purpose:

  • Power campaign performance dashboards (search, display, video, shopping, PMax)

  • Analyse and optimise campaign structure and bidding

  • Retrieve full account configuration for auditing and QA

  • Monitor creative performance and testing

  • Combine Google Ads performance with DV360, Meta, or other channels in unified reporting

  • Provide keyword, search term, and asset group insights

  • Support automated workflows that rely on campaign structure visibility

Refresh Cadence:

Data is refreshed daily.

Update Modes:

Append (for data table), Refresh (for metadata)

For more information on this integration and use cases please follow the link here.

Connection Setup

Key

Description

Req.

googleads_login-customer-id

Login Customer ID (MCC)

✅

googleads_account_ids (targets)

Comma‑delimited list of Account or MCC IDs

✅

googleads_developer_token

Google Ads Dev Token (hidden)

✅

google_client_id / secret

OAuth2 client (hidden)

✅

google_client_scopes

Scope https://www.googleapis.com/auth/adwords

✅

OAuth installed‑app flow stores a refresh token after first user consent.

Jobs & Scheduling

Job Label

Feed

Look

back

Poll

Targets (Tables)

Update

Google Ads – Data Import

google_ads

3 days

24h

googleads_data_campaign googleads_data_keyword

Append

Google Ads – Meta Refresh

google_ads

1 day

24h

3 lookup tables

Refresh

Hidden option googleads_report_type set to campaign or keyword_view per target.

Table Schemas (all columns)

googleads_data_campaign

Column

Description

Date

Report date

ExternalCustomerId

Account ID

CampaignId

Campaign ID

CampaignName

Campaign name

AdNetworkType1

Primary ad network (SEARCH, DISPLAY)

Device

Device category (DESKTOP, MOBILE, etc.)

Metrics:

— (numeric columns below)

Impressions

Impressions

Clicks

Clicks

Cost

Cost micros (divide by 1e6 for currency)

Conversions

Conversions

ConversionValue

Conv. value

AverageCpc

Avg. CPC micros

AverageCpm

Avg. CPM micros

Interactions

Interactions

InteractionRate

% interactions

VideoViews

Video views (if video campaign)

SearchImpressionShare

Search IS %

plus all additional Google Ads fields returned by the API.

googleads_data_keyword

Column

Description

Date

Report date

ExternalCustomerId

Account ID

CampaignId

Campaign FK

AdGroupId

AdGroup FK

AdGroupName

AdGroup name

KeywordText

Keyword text

MatchType

Keyword match type (EXACT/PHRASE/BROAD)

CriterionId

Keyword ID

AdNetworkType1

Network

Device

Device

Metrics:

—

Impressions

Impressions

Clicks

Clicks

Cost

Cost micros

Conversions

Conversions

ConversionValue

Conv. value

QualityScore

Keyword QS

AveragePosition

Avg. position (legacy)

Additional performance & attribution columns generated by Google Ads

Lookup Tables

Table

Key

Example Fields

googleads_meta_account

Id

Name, CurrencyCode, CanManageClients

googleads_meta_campaign

Id

Name, Status, AdvertisingChannelType

googleads_meta_adgroup

Id

Name, Status, CampaignId

Dimensions

Dimension Name

Mapping

Account [GAds]

googleads_meta_account.Name

Campaign [GAds]

googleads_meta_campaign.Name

AdGroup [GAds]

googleads_meta_adgroup.Name

Ad Network Type [GAds]

AdNetworkType1 (fact tables)

Device [GAds]

Device (fact tables)

Base Metrics

Metric

Formula (campaign+keyword)

Round

Prefix

Impressions [GAds]

SUM(Impressions)

0

Clicks [GAds]

SUM(Clicks)

0

Spend [GAds]

SUM(Cost) / 1,000,000

2

£

Conversions [GAds]

SUM(Conversions)

0

Conversion Value [GAds]

SUM(ConversionValue)

2

Composite Metrics

Name

Formula

Round

Format

CTR [GAds]

(Clicks / Impressions) * 100

2

%

CPC [GAds]

Spend / Clicks

2

£

CPM [GAds]

(Spend / Impressions) * 1000

2

£

Joins

Fact Table

FK

Lookup Table

Key

Campaign & Keyword

ExternalCustomerId

googleads_meta_account

Id

CampaignId

googleads_meta_campaign

Id

Keyword only

AdGroupId

googleads_meta_adgroup

Id

Did this answer your question?