How do you handle combining params from several search queries for analysis?
When analyzing core web vitals across multiple city and service pages, search queries often come with overlapping parameters like location, service type, and intent. Has anyone found an efficient way to merge these parameters for reporting or spotting cannibalization? I keep ending up with tons of near-duplicate entries in Search Console exports and would love to hear what workflow folks use.
Asked by nadeemnawaz
1 Answer
Yeah, I run into this all the time with SaaS products that have tons of landing pages targeting similar keywords for different cities and features. The deduping gets messy fast if you just export from Search Console. What actually works for me is pulling the raw data into BigQuery, then using REGEXP_EXTRACT to parse out the parameters from the query string. I break them into columns: city, intent, service. Then I group by those columns and sum impressions, clicks, etc to spot where two pages are splitting the same intent/location combo, which is usually cannibalization. If you don't have BigQuery, Excel works too, just way slower: use Text-To-Columns and filter/merge manually. Either way, having the params split into separate columns makes reporting and investigating issues so much easier than staring at a wall of URLs or raw queries.