🛡️WHITEWIZ.IO — SAFE PAGES BUILT FOR CLOAKINGSECUREUndetectable white pages · instant review-mode load · 100% policy-clean · pass any manual reviewfrom $49Get Safe Pages
🛡️CLOAKSHIELD.IO — ADVANCED AD CLOAKINGPROSmart filtering · bot & reviewer protection · works with Meta/Google/TikTokfrom $29/moStart Free
📊ADSCALEHUB.NET — SCALE YOUR AD ACCOUNTSVERIFIEDAged accounts · high limits · dedicated manager · same-day setupfrom $89Scale Now

Built a free keyword clustering sheet — grouping by SERP overlap, not by string match

Started by ScriptKitty · Oct 12, 2026 at 9:46 AM 5 replies 2,310 viewsTags:Keyword ResearchToolsFree
Oct 12, 2026 at 9:46 AM#1
ScriptKitty
Regular Member

Joined Dec 2025 · 60 posts · 27 rep

Every cheap clustering tool groups keywords by how similar the words are. That is wrong. "best running shoes" and "top running shoes" are the same page; "running shoes" and "running shoe size chart" are not, despite sharing more characters.

Proper way is SERP overlap: if two queries share 4+ of the top 10 results, they belong on one page.

Sheet is linked in the Downloads section. Paste in your keywords, paste in your SERP data, it clusters them. No signup, no email, I do not want your email.

while(true) { automate(); }

Oct 12, 2026 at 12:06 PM#2
RankOrDie
Senior Member

Joined Apr 2022 · 80 posts · 39 rep

SERP overlap clustering is the only method that has ever matched reality for me. Nice of you to give it away.

Building boring sites that print money. Case studies in my journey thread.

Oct 12, 2026 at 2:26 PM#3
NewbieNate
Newbie

Joined Oct 2026 · 73 posts · 30 rep

Downloaded. Do I need a paid API for the SERP data part or is there a free way in?

Day 9 of learning. Journey thread incoming once I have something to show.

Oct 12, 2026 at 4:46 PM#4
ScriptKitty
Regular Member

Joined Dec 2025 · 60 posts · 27 rep

You need SERP data from somewhere. Free tier of most tools will cover a few hundred queries a month, which is plenty for one site.

while(true) { automate(); }

Oct 12, 2026 at 7:06 PM#5
NicheNinja
Regular Member

Joined Aug 2025 · 75 posts · 58 rep

Used this on a 900 keyword list yesterday. It collapsed to 180 pages, which is about 200 fewer articles than my old method told me to write.

Currently: 14 sites, 11 of them bad.

Oct 12, 2026 at 9:26 PM#6
FreelanceFiona
Jr. VIPPremium Seller

Joined Sep 2024 · 43 posts · 21 rep

That last comment is the real ROI. Clustering properly mostly saves you from writing things.

Conversion copy for affiliate offers. Portfolio in my marketplace thread.

Checking your session…

⭐UPGRADE TO JR. VIPMEMBERSNo ads, bigger uploads, marketplace priority and a gold username.$9.99/moUpgrade Account