GAQL <> GSC
Compare your Google Ads paid data against Google Search Console organic data side by side — for every search term. Identify where you're paying for traffic you could get organically, and where organic gaps mean paid ads are essential.
How to open
- From the left sidebar, go to Google Ads → GAQL <> GSC.
- Select your Campaign (Google Ads account).
- Select your Domain (GSC property).
- Choose a Region (e.g., Global, United States, India).
- Set your date range (default: Last 30 days).
Results table
Each row represents a search term with both paid and organic data side by side:
| Column | Description |
|---|---|
| CAM ID | Google Ads campaign ID |
| CAM NAME | Campaign name |
| SEA TERM | The search term |
| GADS IMPR. | Google Ads impressions for this term |
| GADS CLK | Google Ads clicks |
| GADS CTR | Google Ads click-through rate |
| GADS AVG CPC | Average cost per click (paid) |
| GADS COST | Total paid spend for this search term |
| GADS CONV. | Google Ads conversions |
| GSC IMPR. | Organic impressions from GSC |
| GSC CLK | Organic clicks from GSC |
| GSC POS. | Average organic ranking position |
| VOL (GL) | Search volume (Global) |
| DIF | Difficulty score |
Views
| Tab | Description |
|---|---|
| All Data | Full row-level data per campaign + search term combination |
| Aggregated | Aggregated totals per search term across all campaigns |
Filters
Filter by:
- Search Term — find a specific keyword
- GAds Cost — filter by paid spend
- GSC Position — filter by organic ranking
- + Add filter — additional filters
Use Presets to save filter combinations. Click Export to download as CSV.
How to use the insights
| Insight | Action |
|---|---|
| High GADS COST + good GSC POS (rank 1–5) | You may be paying for traffic you already get organically — consider reducing bids |
| High GADS COST + poor GSC POS (rank 10+) | Organic is weak — paid ads are justified until organic improves |
| Low GADS COST + high GSC CLK | Organic is doing well — low paid investment needed |
| Zero GSC data + high GADS COST | No organic presence — focus on content/SEO for this term |
ヒント
Use GAQL ↔ GSC to find keyword cannibalization — terms where you're paying for clicks that your own organic results could capture for free.
Requirements
- Google Ads account connected (via Campaign Insights)
- Google Search Console connected (via Project Settings)