Claude + Google Search Console CSV Paste
The most direct way to learn how to use Claude to find keyword cannibalization is also the simplest: export your Google Search Console Performance report grouped by query and page, paste it into Claude, and ask it to flag every query where more than one URL earns impressions or clicks. Claude groups the rows by query, calculates the click split, identifies which URL performs better on CTR and position, and recommends whether to consolidate via 301 redirect, add a canonical tag to the weaker page, or differentiate the two pages’ keyword targets.
To get the export right, open GSC and navigate to Search results in the Performance menu. Enable clicks, impressions, CTR, and position. Click the Pages tab, then export — this gives you a query-by-page grouped CSV where each row is a unique query-page combination. Paste the CSV rows into Claude with the prompt: “Find keyword cannibalization in this GSC data. Group by query, flag every query where two or more pages rank, identify the keeper URL, and give me one fix per conflict: consolidate, canonical, or differentiate.” Claude’s 200K-token context means even large exports clear in a single pass — no pagination, no sampling.


























