Free Affiliate Keyword Research Templates to Stop Guessing
This page offers free templates to help affiliates choose keywords based on buyer intent, competition, and fit, not just search volume. It explains common mistakes beginners make and shows free ways to find and sort keywords before writing.
Most new affiliates pick keywords the same way they pick lottery numbers: a gut feeling, a glance at search volume, and a quick prayer. If you’ve ever published a post and then watched it sit at zero traffic for six months, the problem usually started before you wrote a single word. It started with the keyword you chose.
Key Takeaways
- Search volume alone tells you almost nothing about whether a keyword will make money, because volume and buyer intent are two separate things you have to check separately.
- A free keyword template works best when it forces you to log intent, competition, and commercial fit side by side instead of trusting your memory.
- Ranking for the wrong keyword wastes the same amount of writing time as ranking for the right one, so the sorting step has to happen before the content brief, not after.
- Your existing site traffic and your competitors’ published posts are both free keyword research tools you’re probably not using correctly.
Why keyword research breaks down for new affiliates
Here’s a scenario you’ll recognize. You open a free keyword tool, type in your niche, and get handed a list of two hundred phrases sorted by search volume. The top one gets 40,000 searches a month, so you write about it. Three months later you’re ranked on page four, you’ve made no sales, and you’re not sure why. The volume was real. The problem is that volume tells you how many people search a phrase, not what they want when they search it or whether they’re close to buying anything.
A keyword like “best running shoes” might get searched by someone who wants to buy today, someone writing a school report, and someone who already owns three pairs and is just browsing. You can’t tell the difference from the search volume number. You can only tell by looking at what’s already ranking for that phrase and asking what kind of page Google thinks satisfies that search.
What a keyword research template actually needs to track
A spreadsheet with one column for “keyword” and one for “volume” isn’t a research template. It’s a wish list. A template that actually helps you decide what to write needs at least five columns:
- The keyword phrase itself, written the way a real person would type it, not the way a tool normalizes it.
- Search intent, labeled as informational, comparison, or transactional. A phrase with “vs” or “review” or “best” in it usually signals someone closer to a decision than a phrase starting with “what is” or “how does.”
- Who’s currently ranking, meaning the actual domains on page one. If nine of the top ten results are massive sites you can’t outrank for a year, that’s useful information before you write, not after.
- Commission fit, meaning does this keyword connect naturally to a product you’re already promoting, or would you be bending the topic to fit an affiliate link.
- Content gap, a short note on what the current top results are missing, since that gap is usually the actual reason you’d rank at all.
Once you’ve sorted a list this way, the keywords that looked exciting in a tool often drop to the bottom, and ones you’d have skipped move to the top. That’s the whole point of the exercise.
Where to find keywords without paying for a tool
You don’t need a paid subscription to build a working list. Three free sources cover most of what beginners need:
- Autocomplete and “people also ask.” Type your main topic into a search bar and read what it suggests before you finish typing. Those are real queries real people typed recently.
- Your own site search and analytics. If you’ve published anything at all, check what phrases are already sending you a trickle of traffic. Those are keywords you’re half-ranking for already, which makes them far easier to push further than starting cold.
- Competitor posts. Look at what the affiliates ahead of you are covering and how they structure it. This is exactly the kind of digging covered in the competitor research templates for spying on rival affiliates, which pairs well with a keyword sheet because it shows you which topics are already proven to hold traffic.
Turning a keyword list into something you’ll actually write
A sorted keyword list is only step one. The next mistake people make is jumping straight from the spreadsheet into a blank document, which is how you end up rewriting the intro four times because you never nailed down the angle. Once you’ve picked a keyword, lock in the verdict, the format, and the internal link before you write a sentence. That’s the whole idea behind the content brief templates built to stop rewriting drafts, and it saves more time than any keyword tool will.
If the keyword you picked is clearly a comparison search, like “X vs Y,” don’t write a general review. Build an actual comparison page using the structure in the product comparison templates that sell better, because that format matches what the searcher actually wants to see.
Checking that the keyword still fits your niche
It’s easy to chase a keyword that gets volume but doesn’t belong anywhere near your site. If you write skincare content and a shiny keyword about kitchen gadgets shows up in your research, ignore it, even if the number looks good. Keyword choices should trace back to the niche decisions you made early on. If you haven’t formalized that yet, the niche research templates for picking a lane will help you set boundaries so your keyword list doesn’t drift into topics that confuse your readers and dilute your authority on the ones that matter.
It also helps to check that the product tied to the keyword is one you can actually promote cleanly. A great keyword attached to a program with a 24-hour cookie window or a long list of excluded categories isn’t worth building a page around. That’s a five-minute check against the program terms templates for reading the fine print before you commit a week of writing to it.
Frequently Asked Questions
How many keywords should a beginner research before writing anything?
Start with 20 to 30 candidate keywords in your sheet, then narrow that down to your top 5 after checking intent and competition. Trying to research hundreds at once just delays the point where you actually start writing.
Is search volume useless then?
No, it’s one input, not the whole decision. A keyword with low volume but strong buying intent and weak competition will often outperform a high-volume keyword that’s dominated by sites you can’t beat yet.
Should I target keywords my competitors already rank for?
Yes, but only the ones where you can spot a clear gap, like outdated information, a missing comparison, or a weaker format than what the topic deserves. Copying a competitor’s keyword without improving on their page rarely moves you past them.
How often should I revisit my keyword list?
Check it every few months, since search behavior shifts and your own rankings change what’s realistic to target. It’s also worth pairing this with an audit of posts you’ve already published, since a keyword that was too competitive a year ago might be winnable now.
Once you’ve got a short list of keywords worth targeting, the next step is making sure the posts you’ve already published aren’t quietly losing ground while you write new ones. The site audit checklist for before you add new traffic walks through exactly what to check first.
