Connect Google Ads to clariBI
Sync campaign, keyword, and conversion data from your Google Ads account. Ask questions about ROAS, CPC, and spend in plain English instead of building custom reports.
Powered by the Google Ads API with GAQL queries, OAuth incremental authorization, and 440+ ready-to-use analysis templates. Manager (MCC) accounts supported.
What is Google Ads?
Google Ads is Google's advertising platform for search, display, video, and shopping campaigns. It is the world's largest digital advertising platform, powering paid traffic for millions of businesses across search results, YouTube, the Display Network, and partner sites.
Advertisers use Google Ads to target users by keywords, demographics, locations, audiences, and placements. The platform tracks impressions, clicks, costs, conversions, and return on ad spend (ROAS) across every campaign, ad group, and individual ad. However, extracting actionable insights often requires navigating a complex interface or building custom reports.
clariBI connects to the Google Ads API using the adwords OAuth scope and runs GAQL (Google Ads Query Language) queries to sync 13 report types. These cover everything from campaign-level spend to individual keyword quality scores, search term reports, demographic breakdowns, and conversion tracking by action type.
Once synced, any team member can type a question like "What was my CPC for brand campaigns last week?" or "Which keywords have the lowest cost per conversion?" and get an instant, chart-ready answer without building reports in the Google Ads interface.
Learn more about Google Ads at ads.google.com →How to connect Google Ads to clariBI
The entire setup takes under two minutes. You need a Google account with access to the Ads account you want to analyze.
Authorize your Google account
In clariBI, go to Data Sources and connect your Google account. clariBI uses incremental OAuth and requests the adwords scope only when you add a Google Ads source. If you already connected Google for GA4, the additional scope is added without replacing existing permissions.
Select your Ads account
Pick the Google Ads customer ID you want to analyze. Provide it in the format 123-456-7890 or without dashes. Manager (MCC) accounts are supported for agencies managing multiple client accounts.
Choose date range and reports
Select how far back to sync: 30 days, 90 days, 6 months, 1 year, 2 years, or all-time. By default, all 13 report types are synced.
Data syncs automatically
clariBI runs GAQL queries against the Google Ads API and creates datasets for each report type. Auto-generated dashboards give you immediate visibility into spend, performance, and conversions.
Ask questions in plain English
"What was my CPC for brand campaigns last week?", "Show ROAS by campaign for the last 90 days", "Which keywords have the lowest cost per conversion?" clariBI's AI engine answers directly from your synced Ads data.
What you can analyze
clariBI pulls 13 report types from the Google Ads API using GAQL. Each report includes daily breakdowns with the real metrics listed below.
-
Campaign Performance
impressions, clicks, cost_micros, conversions, conversions_value, ctr, average_cpc, average_cpm, cost_per_conversion by campaign.
-
Ad Group Performance
All core metrics broken down by ad group with status and type.
-
Ad Performance
Individual ad metrics with creative type and final URLs.
-
Keyword Performance
Keyword text, match type, quality_score, and all core metrics (impressions, clicks, cost, conversions, CPC).
-
Search Terms
Actual search queries that triggered your ads, with match type and performance metrics.
-
Geographic
Performance by country, region, and city with spend and conversion data.
-
Device Performance
Metrics broken down by device type (mobile, desktop, tablet).
-
Age Demographics
Performance by user age group with impressions, clicks, cost, and conversions.
-
Gender Demographics
Performance by user gender with spend and conversion breakdowns.
-
Audience Segments
Performance by audience segment applied to campaigns.
-
Placements (Display Network)
Display Network placement performance with site URLs and metrics.
-
Hourly Performance
Metrics by hour of day for bid scheduling and dayparting optimization.
-
Conversion Actions
Detailed conversion tracking by action type, category, and attribution model.
Connection details
Reference these parameters when connecting your Google Ads account in clariBI.
| Parameter | Value / Notes |
|---|---|
| OAuth scope | adwords (incremental authorization; requested only when adding a Google Ads source) |
| API | Google Ads API with GAQL (Google Ads Query Language) queries |
| Token management | OAuth tokens stored with Fernet encryption and refreshed automatically. Revoke access from Google account settings or clariBI at any time. |
| Account types | Standard accounts and Manager (MCC) accounts supported. Provide customer ID as 123-456-7890 or without dashes. |
| Report types | 13 report types synced by default: Campaign, Ad Group, Ad, Keyword, Search Terms, Geographic, Device, Age, Gender, Audience, Placements, Hourly, Conversion Actions |
| Date range options | 30 days, 90 days, 6 months, 1 year, 2 years, or all-time. Choose during setup; adjustable later. |
| Access model | Read-only. clariBI never creates, modifies, or pauses campaigns, ads, or keywords. |
| Sync frequency | Automatic daily sync with on-demand refresh available |
Use cases
Google Ads generates massive amounts of performance data. clariBI makes it instantly accessible to every team member, from PPC specialists to executives.
Spend Optimization
Identify high-CPC keywords that are not converting and shift budget to campaigns with the best ROAS. Ask "Which campaigns have the highest cost per conversion?" and act on the answer immediately.
Search Term Mining
Discover actual search queries driving clicks. Find negative keyword opportunities and new keyword ideas from the search terms report without manual CSV exports.
Quality Score Analysis
Track keyword quality scores over time to improve ad relevance, landing page experience, and expected CTR. Ask "Which keywords have quality score below 5?" for a targeted fix list.
Cross-Channel Reporting
Combine Google Ads with GA4 and Meta Ads in a single dashboard to compare channels side by side. See the full picture from ad click to website visit to conversion.
Dayparting Analysis
Use hourly performance data to identify peak conversion hours and optimize bid schedules. Ask "Which hours have the best conversion rate on weekdays?" for data-driven scheduling.
Conversion Attribution
Analyze conversions by action type, campaign, and audience to understand what drives results. Track conversion value and cost per conversion across every dimension.
Security & requirements
Your advertising data is handled with care. Here is how clariBI protects your Google Ads connection and what you need to get started.
Security measures
-
Read-only access
clariBI never creates, modifies, pauses, or deletes campaigns, ads, keywords, or any other Google Ads resources. It only reads performance data.
-
Encrypted token storage
OAuth access and refresh tokens are encrypted at rest using Fernet symmetric encryption. The encryption key is managed separately from the data store.
-
Automatic token refresh
clariBI refreshes your OAuth tokens automatically before they expire. You do not need to re-authorize unless you revoke access.
-
Revoke access at any time
Disconnect from clariBI's data sources page or revoke from your Google account security settings. All synced data can be deleted on request.
-
Audit logging
All data syncs and queries against your Google Ads source are logged in clariBI's audit trail, visible to workspace administrators.
Prerequisites
-
Google Ads account
You need an active Google Ads account with at least read access. Both standard accounts and Manager (MCC) accounts are supported.
-
Google account with access
The Google account you authorize must have access to the Ads customer ID you want to connect. For MCC accounts, the authorized user needs access to the manager account.
-
No additional software needed
The connection is entirely cloud-to-cloud via Google's API. There is nothing to install, no firewall rules to configure, and no credentials to manage beyond OAuth.
-
Incremental authorization
If you already connected Google for GA4, clariBI will request the additional
adwordsscope incrementally without replacing existing permissions. -
clariBI paid plan or trial
Google Ads integration is available on all paid plans and during the free 14-day trial (50 AI credits included).
Pricing & availability
Google Ads integration is included on all paid clariBI plans and the free 14-day trial. No extra fees, no per-query charges.
Annual billing saves up to 17% • All plans include unlimited dashboards, reports, and data source connections within your plan's limits • See full pricing details
Connect Google Ads in one click
Start your free 14-day trial and have your first Google Ads dashboard live today. No credit card required.
13 report types via GAQL • MCC accounts supported • Automatic token refresh • All paid plans from $99/month