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.
À propos de l’outil
Joignez les termes Google Ads et GSC dans quatre quadrants transparents pour repérer les recouvrements solides, les lacunes payantes et les candidats à tester.
Fonctionnalités
- Jointure exacte ou quasi-dupliquée après normalisation du texte.
- Quadrants payant/organique avec actions en langage clair.
- Impact monétaire modélisé à partir du coût Ads actuel.
- Traitement local et validation explicite des colonnes requises.
Fonctionnement
Le moteur associe chaque ligne Ads à au plus une ligne GSC exacte ou quasi-dupliquée. La force payante exige au moins un clic et la force organique une position moyenne de 10 ou meilleure ; les lignes non associées deviennent organiques uniquement ou faibles.
Limites
- La position moyenne n’est pas une garantie de classement et les seuils sont heuristiques.
- La correspondance est lexicale, pas sémantique ; des synonymes peuvent rester séparés.
- Le coût n’est pas une économie incrémentale : utilisez un holdout avant de modifier les dépenses.
Questions fréquentes
Quelles données faut-il fournir ?
Un export Ads avec Search term, Clicks et Cost, puis un export GSC avec Query, Clicks, Impressions et Position.
Comment les termes sont-ils associés ?
Le texte est normalisé puis rapproché par égalité ou quasi-duplication ; aucune similarité sémantique n’est déduite.
Un bon résultat dans les deux canaux signifie-t-il qu’il faut suspendre le payant ?
Non. Il identifie un candidat à un test contrôlé ; la défense de marque, la valeur de conversion et l’incrémentalité restent à mesurer.
Mes données sont-elles téléversées ?
Non. Les deux tableaux sont analysés et joints localement dans votre navigateur.