seo-sea-keyword-gap-analyzer

SEO vs SEA Keyword Gap Analyzer

Purpose

Help agencies and advertisers identify where organic and paid search overlap, where gaps exist, and how to optimize budget allocation between SEO and SEA. This analysis typically saves 10-30% of wasted ad spend by identifying keywords where organic rankings make paid ads unnecessary.

When to Use This Skill

Invoke when user mentions:

• Gap analysis: "Compare my organic and paid keywords"
• Cannibalization: "Am I paying for clicks I'd get for free?"
• Budget optimization: "Where can I save on Google Ads?"
• Content opportunities: "What keywords convert via ads but have no content?"
• SEO vs SEA: "Should I bid on keywords where I rank #1?"
• Organic/paid overlap: "Which keywords appear in both GSC and Google Ads?"

Required Tools

Tool	Purpose
gsc_search_analytics	Organic keyword data (queries, clicks, impressions, CTR, position)
google_ads_run_gaql	Paid keyword data via GAQL query (clicks, impressions, cost, conversions)

---

Part 1: Data Collection Framework

Step 1: Organic Data (GSC)

gsc_search_analytics(
    site_url="<property>",
    dimensions=["query"],
    days=28,
    row_limit=5000
)

Key fields: query, clicks, impressions, ctr, position

Step 2: Paid Data (Google Ads)

google_ads_run_gaql(
    customer_id="<account>",
    query="SELECT campaign.name, ad_group.name,
        ad_group_criterion.keyword.text,
        ad_group_criterion.keyword.match_type,
        metrics.impressions, metrics.clicks, metrics.ctr,
        metrics.average_cpc, metrics.cost_micros,
        metrics.conversions
    FROM keyword_view
    WHERE segments.date DURING LAST_30_DAYS
    ORDER BY metrics.impressions DESC LIMIT 500"
)

Key fields: keyword.text, clicks, impressions, cost_micros (÷ 1,000,000), conversions

---

Part 2: Four-Quadrant Gap Classification

The SEO-SEA Matrix

                        ORGANIC STRONG              ORGANIC WEAK
                     (Position ≤ 5)              (Position > 10 or absent)
                 ┌─────────────────────────┬──────────────────────────┐
  PAID ACTIVE    │  Q1: CANNIBALIZATION     │  Q2: PAID-ONLY           │
  (Running ads)  │  → Test pausing ads      │  → Content opportunity   │
                 │  → Potential savings      │  → Build organic content │
                 │  Priority: HIGH           │  Priority: MEDIUM        │
                 ├─────────────────────────┼──────────────────────────┤
  PAID INACTIVE  │  Q3: ORGANIC WINNERS     │  Q4: BLIND SPOTS         │
  (No ads)       │  → No action needed      │  → Assess search volume  │
                 │  → Monitor rankings      │  → Decide: SEO or SEA?   │
                 │  Priority: LOW            │  Priority: VARIES        │
                 └─────────────────────────┴──────────────────────────┘