Paid/Organic Overlap Quadrant
Free, no signup. Find terms that are strong in both channels, paid-only content gaps, and organic-only paid-test candidates. Dollar impact is modeled from current paid cost.
Paste Ads search terms first, then GSC Queries. Separate data sets with a line containing ---. Files never leave your browser.
Site passport Local context for this saved site
Local data
Saved targets, named lists, and recent check summaries remain only in this browser.
Runs entirely in your browser — nothing you paste is uploaded or stored. Anonymous run-level outcome counters may be used for aggregate research; URLs, domains, IPs, and identifiers are never included, and no statistic is released below 100 runs.
Rate this tool
How to use it
- Paste a Google Ads search-terms table containing Search term, Clicks, and Cost.
- Add a line containing only
---, then paste a GSC query table containing Query, Clicks, Impressions, and Position. - Select Analyze, then sort the JSON rows by quadrant or dollar impact in your downstream workflow.
- Turn strong-both and organic-only findings into measured experiments, not immediate budget changes.
Example result Illustrative data
The figures below are invented solely to explain the calculation; they are not benchmarks or observed account results.
How to read the result
- Strong both: at least one paid click and an organic position of 10 or better. Consider an incrementality test; dollar impact equals current cost.
- Paid only: paid activity exists without a matched top-10 organic query. The suggested action is to create or improve organic coverage.
- Organic only: the query ranks in the top 10 with no matched Ads row. It may be suitable for a paid test when economics support it.
- Weak: neither threshold is met. The model recommends deprioritizing it until demand or coverage changes.
Data sources & freshness
The engine normalizes capitalization, spacing, and common query variation, then pairs each Ads row with at most one exact or near-duplicate GSC row. Paid strength means at least one paid click. Organic strength means average position 10 or better. Unmatched GSC queries are added as organic-only or weak rows.
Features
- Four transparent quadrants with plain-language next actions.
- Paid clicks, organic clicks, paid cost, and organic position retained in every joined row.
- Local processing with explicit required-column validation.
Limitations
- Average position is not a rank guarantee, and the default thresholds are simple heuristics.
- Near-duplicate matching is lexical, not semantic; synonyms may remain separate.
- Cost is not incremental savings. Use a geo, audience, or time holdout before changing spend.
- GSC and Ads rows should cover comparable dates, countries, devices, and search types.
Frequently asked questions
What data does the paid and organic overlap tool need?
It needs a Google Ads search-terms export with Search term, Clicks, and Cost columns, followed by a GSC Queries export with Query, Clicks, Impressions, and Position columns.
How are paid and organic terms matched?
The tool normalizes query text and joins exact or near-duplicate terms. It does not infer semantic similarity between differently worded searches.
Does strong performance in both channels mean I should pause paid search?
No. The result identifies a candidate for a controlled test. Brand defense, conversion value, geography, device mix, and true incrementality still need to be considered.
What does dollar impact mean?
For strong-both rows, dollar impact is the current paid cost associated with that search term. It is spend exposed to a test, not a savings forecast.
Is my Ads or GSC data uploaded?
No. Both CSV tables are parsed and joined locally in your browser.
Feature requests for Paid Organic Overlap
Upvote what you want most. New ideas can be submitted from the floating Feedback menu; requests appear here once approved, and the most-wanted rise to the top.
You won't be emailed about that request anymore.
Loading…
➕ Request a feature
New requests are reviewed before they appear here.
ツールについて
AdsとGSCのデータを結合し、有料のみ、オーガニックのみ、両方が強い、両方が弱いというアクションへ分類します。
クエリごとの重なりと欠落を確認し、予算・SEO・計測の次の調査対象を見つけます。
機能
- AdsとGSCクエリの正規化結合
- 有料のみ/オーガニックのみの分類
- 両方が強い・弱い行の抽出
- アクション候補付きのCSV出力
仕組み
AdsとGSCの行を正規化したクエリキーで結合し、提供されたクリック・表示・費用・順位などの指標を並べます。しきい値に基づき四象限へ分類し、各行に確認すべきアクションを付けます。
制限事項
- 異なる期間、地域、デバイス、帰属モデルのデータを結合すると誤解を招くことがあります。分類は優先順位の補助であり、入札やコンテンツ変更の自動判断ではありません。
- 検索語の表記揺れやプライバシー集計により、一部のクエリが一致しない場合があります。
よくある質問
有料とオーガニックの両方が強い行はどう扱いますか?
防御的なブランド表示か、重複を活かせる高意図クエリかを確認し、増分テストと利益を見て判断してください。
入力データの期間はそろえる必要がありますか?
はい。同じ期間、地域、デバイス、帰属条件でそろえると、四象限の比較が解釈しやすくなります。
この分類は自動で予算を変更しますか?
いいえ。分類は調査の優先順位を示すだけで、入札やSEO施策を自動変更しません。