Resources/SOPs/SOP 009
SOP 009SEO

How to Do Keyword Research for SEO

Time2–8 hours
📊 LevelIntermediate
📅 UpdatedMarch 2024
👤 WhoSEO specialist, digital marketer,…

🚀 Goal

Find high-value keywords that people search for in your niche, group them by intent, and create a keyword map that drives your entire SEO and content strategy.

🎯 Ideal Outcome

A comprehensive keyword spreadsheet with buckets organised by search intent, each bucket mapped to a specific page on your site — ready to guide 6–12 months of content creation.

🤔 Why This Matters

Keyword research is the foundation of SEO. Without it, you are creating content nobody is searching for. A strong keyword strategy tells you exactly what pages to build, what content to write, and in what order — giving you a competitive advantage over businesses and institutes that are guessing.

RE

Reshma

SEO & GEO Manager, Unlearn Academy

Mentor Insight

The biggest SEO mistake I see from Kerala businesses is skipping keyword research entirely and just writing content they think is good. I audited one local digital agency's blog — 24 articles, zero keyword research. Total organic traffic: 18 visits per month. We did a proper keyword map for their niche, identified 6 high-value, low-competition clusters, and built one page per cluster. Three months later, those 6 pages were generating 1,200 organic visits per month combined. The existing 24 articles were irrelevant. Six well-researched pages beat 24 random ones every time.

Result: 6 keyword-mapped pages → 1,200 organic visits/month vs 24 random articles getting 18.

⚠️ Before You Start

Access to Ahrefs, Semrush, or KWFinder (at minimum, a free trial)

A Google Sheet or Excel file set up to organise findings

A clear understanding of your target audience and what problems your business solves

Set aside dedicated time — this process is not difficult but it is time-consuming

Phase 1 — Understand Your Keywords Before You Search
1

Define your seed keywords

Before opening any tool, write down 5–10 phrases that describe your business or content from your customer's perspective. For Unlearn Academy, seed keywords would include: • digital marketing course Kerala • graphic design training Trivandrum • Meta Ads course Malayalam • UI UX design course Kochi • digital marketing salary Kerala Think like your target audience — not like your business. Customers search for their problem, not your solution. They search 'how to get a digital marketing job' not 'L2 Agency Training Programme'.
💡

Pro tip: Also check what keywords you already rank for: Google Search Console → Performance → Queries. These are real searches bringing you traffic — start here before expanding.

Phase 2 — Research & Expand Your Keyword List
2

Run keyword research in Ahrefs or Semrush

Open Ahrefs → Keyword Explorer → Enter your first seed keyword → Set country to India. For each keyword, note: • Search Volume — average monthly searches • Keyword Difficulty (KD) — 0–100 scale. Under 20 = relatively easy to rank. Above 50 = very competitive. • Traffic Potential — estimated clicks if you rank #1 • SERP overview — who currently ranks on page 1 Work through these tabs: • Matching terms — all keywords containing your seed word • Related terms — semantically related keywords • Questions — question-format searches (excellent for blog topics) • Also rank for — keywords your competitors rank for that you don't Target keywords with: Volume > 200/month AND KD < 30 for new sites. Volume > 500/month AND KD < 50 for established sites.
3

Use Google autocomplete and 'People also ask'

Open Chrome in Incognito → Type each seed keyword into Google. Note: • Autocomplete suggestions (appearing as you type) — real searches • 'People also ask' boxes on the results page — question-format opportunities • 'Related searches' at the bottom of results page These are free and show exactly what Google considers related to your topic — valuable signal for content strategy. For Kerala-specific research: search from an Indian IP (do not use VPN). You want to see what results Kerala users actually see.
📌

Note: If you search 'digital marketing course' and see results dominated by global platforms (Coursera, Udemy, IIDE) — the keyword is competitive. Try 'digital marketing course Trivandrum' or 'digital marketing course Kazhakootam' — much easier to rank for, much higher buyer intent.

4

Build your comprehensive keyword list

In Google Sheets, create a table with these columns: • Keyword • Monthly Search Volume • Keyword Difficulty (KD) • Search Intent (Informational / Navigational / Transactional / Commercial) • Current Ranking Position (check Search Console) • Priority (High / Medium / Low) • Notes Aim for 50–200 keywords minimum before moving to mapping. The more thorough the research, the better the strategy. Search intent classification: • Informational: 'what is digital marketing' — wants to learn • Commercial: 'best digital marketing course Kerala' — comparing options before buying • Transactional: 'digital marketing course fees Trivandrum' — ready to buy • Navigational: 'Unlearn Academy contact' — looking for a specific brand Commercial and Transactional keywords = highest priority for business pages.
Phase 3 — Map Keywords to Pages
5

Group keywords into topic buckets

Sort your keyword list by search intent, then group similar keywords together. A 'bucket' is a group of keywords that share the same search intent and should be targeted by one page. Example buckets for a digital marketing school: Bucket 1: /digital-marketing-course-kerala → 'digital marketing course Kerala', 'digital marketing training Kerala', 'best digital marketing course Kerala' Bucket 2: /digital-marketing-salary-kerala → 'digital marketing salary Kerala', 'digital marketing job salary Trivandrum', 'digital marketer income India' Bucket 3: /meta-ads-course → 'Meta Ads course', 'Facebook ads training Malayalam', 'Meta Ads certification Kerala' One bucket = one page. Never target the same keyword with two pages (keyword cannibalisation).
💡

Pro tip: If two keywords have the same intent and similar search results, they belong in the same bucket. If the Google results page looks completely different for two keywords, they need separate pages.

6

Prioritise buckets and create your content roadmap

Not all keywords should be targeted at the same time. Prioritise based on: 1. Business value — Commercial + Transactional keywords that directly lead to enrolments 2. Competition — Start with lower-KD keywords while building domain authority 3. Traffic potential — Higher volume keywords for awareness content Create a content calendar from your keyword map: • Month 1: Target 2–3 highest-priority transactional keywords (course pages, fee structure) • Month 2–3: Target commercial comparison keywords (best institutes, vs competitors) • Month 4–6: Target informational keywords (salary guides, career guides, how-to articles) This roadmap can drive 6–12 months of SEO content.
7

Calculate keyword opportunity per bucket (optional)

For each bucket, you can estimate the business potential: 1. Total Monthly Volume = sum of search volumes in the bucket 2. Expected CTR at #1 = multiply by 0.35 (35% average for top result) 3. Total Addressable Monthly Traffic = Total Volume × 0.35 4. Expected Conversion Rate = your average enquiry-to-visit rate (estimate: 0.5–2%) 5. Monthly Leads = TAM × Conversion Rate Example: Bucket: 'digital marketing course Kerala' Total Volume: 1,200/month TAM: 1,200 × 0.35 = 420 potential visitors At 1% conversion = ~4 leads/month from this keyword cluster alone This shows which keyword buckets are worth investing in first.
📌

Note: These are estimates. Real results depend on your actual conversion rate, competition, and how well the page is optimised. Use this for prioritisation — not guaranteed revenue projections.

Keyword research completion checklist

5–10 seed keywords defined from your target audience's perspective
Keyword research run in Ahrefs / Semrush covering Matching Terms, Related Terms, and Questions
Google Autocomplete and People Also Ask checked for each seed keyword
Minimum 50 keywords collected with Volume, KD, and Intent noted
Keywords grouped into topic buckets by search intent
Each bucket mapped to a specific URL / page on the site
Content calendar created: Transactional → Commercial → Informational priority order
Keyword map saved with a backup copy (Canonical List tab)
Scheduled for refresh in 12 months or before next content campaign

SOP Complete

You've completed all steps. Document your before/after results and add this to your portfolio as a case study.

Quick Reference

🧐 Where

Ahrefs (ahrefs.com), Semrush, or KWFinder for keyword data. Google Sheets for mapping and organisation.

🗓 When

Before building or redesigning a website. Before launching a new content marketing campaign. Refreshed at least once a year as search trends change.

👤 Who

SEO specialist, digital marketer, or content strategist. Can be delegated to a trained assistant once the process is understood.

Want to learn this live?

Join a cohort — real mentors, client briefs, and structured progression from L1 to L4.

Enquire Now

Save This SOP

Related SOPs

← All SOPs