Free SERP Intent Analysis Template (CSV)

Should two keywords share one page or get two? This decision sheet settles it with evidence instead of gut feel: for each keyword pair you count the shared URLs in Google's top 10, judge whether the intent matches, and record a One page or Two pages decision with a note. It ships with 12 worked examples from a home coffee gear site, including the tricky Partial cases.

Download CSV Template Automate it with Optiwing

Free download. No email required.

What's Inside the Template

Keyword A and Keyword B

The pair you are testing. Pull pairs from within the same tentative cluster, or any two keywords you suspect might overlap.

Shared SERP URLs (0-10)

How many of the same URLs appear in Google's top 10 for both keywords. This single number is the strongest intent-match signal available.

Same Intent (Yes/No/Partial)

Your judgment call informed by the overlap count: Yes at roughly 4 or more shared URLs, No at 0-2, and Partial in between or when formats differ.

Decision (One page/Two pages)

The action: same intent means one page targets both keywords, different intent means each keyword needs its own page.

Notes

Why you decided that way: matching formats, a qualifier that changes the SERP, or a Partial case resolved by covering one keyword as an H2 inside the other's page.

Preview

Keyword A	Keyword B	Shared SERP URLs (0-10)	Same Intent	Decision	Notes
best french press	french press coffee maker	7	Yes	One page	Both SERPs are product roundups with nearly identical results
best french press	how to use a french press	1	No	Two pages	Roundup SERP vs tutorial SERP with different formats
french press ratio	how to use a french press	5	Partial	One page	Ratio results appear inside tutorial pages so cover ratio as an H2
best burr grinder	burr coffee grinder	8	Yes	One page	Same roundups rank for both so target with one page
best burr grinder	burr vs blade grinder	2	No	Two pages	Comparison intent is separate from buying intent
cold brew coffee maker	how to make cold brew	1	No	Two pages	Gear roundup vs recipe guide with zero format overlap
best espresso machine under 500	best espresso machine	3	Partial	Two pages	Unqualified term surfaces premium picks so keep pages separate
best gooseneck kettle	pour over kettle	7	Yes	One page	Same product set ranks for both terms

First 8 of 12 example rows. Note how both Partial cases resolve differently: one merges into a single page, the other stays split.

How to Use It

1
Download the CSV and open it in Google Sheets or Excel. List the keyword pairs you are unsure about, one pair per row.
2
Google Keyword A in an incognito window and copy the top 10 organic URLs. Do the same for Keyword B.
3
Count how many URLs appear in both lists and enter the number in Shared SERP URLs. Ignore ads, map packs, and shopping results.
4
Set Same Intent: 4 or more shared URLs usually means Yes, 0-2 means No, and 3 or mixed formats means Partial and deserves a closer look.
5
Record the Decision. For Partial cases, check whether one keyword's results appear as sections inside the other's ranking pages: if so, merge with an H2; if not, keep two pages.
6
Write the reason in Notes, then feed the decisions back into your keyword clustering sheet before briefing any content.

Check SERP Overlap Without 20 Incognito Tabs

Manually comparing top 10 results works, but at ten keyword pairs it is an hour of copy-pasting URLs. Optiwing's SERP tools pull live Google results and compare them for you, and its clustering tool applies the same shared-URL logic across an entire keyword list at once.

The SERP similarity tool compares two keywords' live top results side by side and scores the overlap
The SERP checker shows the full live top 10 for any keyword without leaving your desk browser fingerprint on the results
Scaling up? The keyword grouping tool runs this exact analysis across thousands of keywords at 1 credit each
Start with 100 free credits, no credit card required

Try the SERP Similarity Tool

Frequently Asked Questions

How many shared SERP URLs mean two keywords have the same intent?

A common rule of thumb: 4 or more shared URLs in the top 10 means the same intent and one page, 0-2 means different intent and two pages, and 3 is a judgment call. Optiwing's clustering uses a threshold of 3 or more shared results combined with intent checks, which maps closely to this sheet.

Why does SERP overlap matter for SEO?

Google's results reveal how it interprets a query. If two keywords return mostly the same pages, Google treats them as one intent and a single page can rank for both. If you build two pages anyway, they compete with each other and often both underperform, which is the keyword cannibalization problem this sheet prevents.

What does a Partial intent match mean in practice?

Usually one keyword's topic appears as a subsection inside pages ranking for the other keyword. In the example data, french press ratio results are mostly tutorial pages, so the ratio keyword gets covered as an H2 inside the how-to article instead of its own page. But Partial can also break the other way: best espresso machine under 500 stays separate from best espresso machine because the unqualified SERP favors premium picks.

Should I check SERPs in incognito mode?

Yes, or use a SERP checker tool. Personalized results skew the overlap count, and location can matter for anything with local intent. A tool that fetches clean, unpersonalized results makes the counts consistent across your whole sheet.

How is this different from a keyword clustering template?

Clustering organizes a whole keyword list into page groups; this sheet is the microscope you use on individual pairs where the right grouping is not obvious. Use clustering for the bulk pass and this template for the edge cases and cannibalization checks.

Do SERPs change often enough to redo this analysis?

For most keywords the intent signal is stable for months, but SERPs do shift, especially around Google core updates. Revisit rows where the decision was Partial or the overlap count was borderline whenever you refresh the content plan.