Bright Analytics

File:Google Ads logo.svg - Wikimedia Commons

The Google Ads connector imports search &amp; display performance at the Campaign and Keyword levels and refreshes three dimension tables (Account, Campaign, AdGroup). Data is pulled via the Google Ads API using MCC (manager) or account‑level IDs.

Fact tables: <code>googleads_data_campaign</code>, <code>googleads_data_keyword</code>

Lookup tables: <code>googleads_meta_account</code>, <code>googleads_meta_campaign</code>, <code>googleads_meta_adgroup</code>

Look‑back: 3 days for facts, 1 day for meta

- Fact tables: <code>googleads_data_campaign</code>, <code>googleads_data_keyword</code>
- Lookup tables: <code>googleads_meta_account</code>, <code>googleads_meta_campaign</code>, <code>googleads_meta_adgroup</code>
- Granularity: Daily (per entity)
- Look‑back: 3 days for facts, 1 day for meta

For more information on this integration and use cases please follow the link <a href="https://brightanalytics.com/connectors/google-ads-reporting-api/" rel="nofollow noopener noreferrer" target="_blank">here</a>.

___________________________________________________________

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

Hidden option <code>googleads_report_type</code> set to <code>campaign</code> or <code>keyword_view</code> per target.

The Google Ads connector captures daily performance for campaigns and keywords across specified accounts, applies currency conversion from micros, refreshes account/campaign/adgroup metadata daily, and provides built‑in metrics and joins for full‑funnel PPC analytics.

Google Ads API Connector

brightanalytics.com

Find answers and get help from Intercom Support and Community Experts

This site employs cookies and other technologies that we and our third party vendors use to monitor and record personal information about you and your interactions with the site (including content viewed, cursor movements, screen recordings, and chat contents) for the purposes described in our Cookie Policy. By continuing to visit our site, you agree to our {websiteTermsLink}, {privacyPolicyLink} and {cookiePolicyLink}.

This site uses cookies and similar technologies ("cookies") as strictly necessary for site operation. We and our partners also would like to set additional cookies to enable site performance analytics, functionality, advertising and social media features. See our {cookiePolicyLink} for details. You can change your cookie preferences in our Cookie Settings.

We use cookies to make our site work and also for analytics and advertising purposes. You can enable or disable optional cookies as desired. See our {cookiePolicyLink} for more details.

Advertising cookies are set by our advertising partners to collect information about your use of the site, our communications, and other online services over time and with different browsers and devices. They use this information to show you ads online that they think will interest you and measure the ads' performance. Social media cookies are set by social media platforms to enable you to share content on those platforms, and are capable of tracking information about your activity across other online services for use as described in their privacy policies.

These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

These cookies are necessary for the website to function and cannot be switched off in our systems.

These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site.

You have the right to opt out of the sale of your personal information. See our {cookiePolicyLink} for more details about how we use your data.

Your Privacy Choices

We use cookies to enhance your experience. You can customize your cookie preferences below. See our {cookiePolicyLink} for more details.

Cookie Settings

Link, Press control-option-right-arrow to exit

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Thinking...

Searching through sources...

Analyzing...

Tickets submitted through the messenger or by a support agent in your conversation will appear here.

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`	✅

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

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.

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

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`

Google Ads API Connector

1. Overview

2. Connection Setup

3. Jobs & Scheduling

4. Table Schemas (all columns)

4.1 googleads_data_campaign

4.2 googleads_data_keyword

4.3 Lookup Tables

5. Dimensions

6. Base Metrics

7. Composite Metrics

8. Joins

9. Summary

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)

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

Name	Formula	Round	Format
CTR [GAds]	`(Clicks / Impressions) * 100`	2	%
CPC [GAds]	`Spend / Clicks`	2	£
CPM [GAds]	`(Spend / Impressions) * 1000`	2	£

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`