How to Build a Content Calendar From Keyword Research

Most business blogs are written on instinct: whatever the owner thought of that week. The result is a pile of unrelated posts that rank for nothing. A content calendar built from keyword research flips that — every article targets something your buyers already search for, and each one supports the others.

Step 1: Start with seed topics

Seed topics are the broad themes your business is about. List your services or product categories, the problems your customers describe in sales calls, and the questions they ask before buying. For a bookkeeping firm, seeds might be “bookkeeping”, “small business taxes”, “payroll” and “cash flow”.

Your own data is gold here. In Google Search Console, open the Performance report and look at the queries you already appear for. These show what Google already associates with your site.

Step 2: Expand into keywords

Put each seed into a keyword tool — Ahrefs, Semrush or Google Keyword Planner — and collect related keywords and questions. For each keyword, note:

• Search volume — roughly how many searches a month.
• Keyword difficulty — how hard it is to rank, based on the strength of pages already ranking.
• Search intent — what the searcher wants (see next step).

Don’t dismiss low-volume keywords. A specific phrase with 50 searches a month from ready-to-buy customers can be worth more than a broad one with 5,000.

Step 3: Sort by search intent

Search intent is the most important thing to get right. Google ranks pages that match what searchers want. Look at the current top results for each keyword to confirm the intent.

If the top 10 results for a keyword are all service pages, a blog post won’t rank there — and vice versa.

Step 4: Group keywords into topic clusters

A topic cluster is one pillar page covering a broad topic, supported by several cluster articles that each cover one sub-topic in depth. Every cluster article links to the pillar, and the pillar links back.

For example, a pillar on “small business payroll” might be supported by articles on payroll taxes, paying contractors, payroll software and common payroll mistakes. This structure helps Google understand that your site covers the topic thoroughly — and it keeps readers moving through your site.

Also group keywords that mean the same thing (“payroll software for small business” and “small business payroll software”) into one article. Writing separate pages for near-identical keywords makes them compete with each other.

Step 5: Prioritise

You can’t write everything at once. Score each topic on three things:

1. Business value — how close is the reader to buying what you sell? This matters most.
2. Difficulty — can your site realistically rank in the next six months?
3. Volume — how much traffic could it bring?

Start with high-value, lower-difficulty topics. They win early rankings and build the authority you need to compete for harder terms later.

Step 6: Build the calendar

A spreadsheet is enough. For each piece, add: target keyword, secondary keywords, search intent, content type, cluster, internal links to add, writer, due date and publish date.

Pick a pace you can sustain. Two strong articles a month, published consistently for a year, will beat ten rushed posts followed by silence. Leave room in the calendar to update old content — refreshing an article that ranks on page two is often the fastest win available.

Step 7: Measure and adjust

Check Search Console every month. Look for articles gaining impressions but few clicks (improve the title and meta description), articles ranking in positions 8–20 (update and expand them), and new queries you appear for but haven’t targeted (add them to the calendar).

Content only works if your site is technically sound. If pages aren’t getting indexed, start with the technical SEO audit checklist.