Workflow: Cannibalization audit
The overlap set is the whole subject of this workflow. Get it first, and get the column order right — comparing a domain against itself returns two position columns with identical headers, and only the argument order tells them apart.
Add your data
Adding details ensures a relevant result
Save time by automatically applying details and getting ready-to-use prompts.
Prompt
For {your-domain.com} in {country}, compare the domain's Google Ads keyword portfolio against its own organic keyword portfolio and return only keywords where it appears in both.
Pass {your-domain.com} as the paid entry first and as the organic entry second. The two position columns come back with identical headers, so read the first as paid_position and the second as organic_position — do not infer which is which from the values. A position of 0 means no presence on that side; drop such rows from this step.
Return these columns:
• keyword
• paid_position
• organic_position
• cpc
• search_volume
• keyword_difficulty
• competitive_density
• overlap_class
Set overlap_class as:
• own_both_top — organic_position is 3 or better and paid_position is 3 or better
• organic_strong — organic_position is 5 or better
• organic_mid — organic_position is 6 to 20
• organic_weak — organic_position is above 20
Sort by search_volume descending. Limit: 40 keywords. Where keyword_difficulty is unavailable, label it inferred.
Example Output (illustrative)
- A table of up to 40 rows — one overlapping keyword per row with your paid and organic position side by side, CPC, volume, difficulty, competitive density and a class describing how strong the organic side is