← ClaudeAtlas

paid-organic-overlaplisted

Compares Google Ads search terms with Search Console rankings to find keywords you pay for but already rank first for, pricing each by incremental CPA. Use when asked am I paying for clicks I already get organically, which keywords to bid down, or how to split search budget between SEO and ads.
Insightful-Pipe/agency-reporting-skills · ★ 0 · AI & Automation · score 72
Install: claude install-skill Insightful-Pipe/agency-reporting-skills
# Paid vs Organic Search Overlap "Stop paying for keywords you already rank #1 for" sounds obvious, and it is often wrong. Google's own pause studies (a 2012 meta-analysis of 390 of them) found that when the advertiser held the top organic result, about half of its ad clicks still would not have happened without the ad. Below the top spot, almost all of them were new. So this skill never cuts an ad because of rank alone. It finds where paid and organic overlap, prices each overlapping term by what its ad really adds, checks the live results page, and turns the few real candidates into a test you can measure. ## Before you start You need the InsightfulPipe MCP connected with a Google Ads account. Search Console for the same site makes the answer better; without it the skill uses DataForSEO. 1. Call `query_contexts` with `request="accounts"` and `platform="google-ads"`. Note `workspace_id`, `brand_id` and the `account_id` (customer id); use them in place of the `1` placeholders in the bodies below. If there are several, ask which one. Never use a manager account directly; pick a client account under it. 2. Find the ad's landing domain with query 1 below (the domain most final URLs point to). 3. Call `query_contexts` with `request="accounts"` and `platform="google-search-console"`. Use the property whose `site_url` is that domain (`https://www.example.com/`, `https://example.com/` or `sc-domain:example.com`). If none matches, say so and use the DataForSEO path. Never compare