Use Case: SaaS – Async Communication Tool for Remote Teams

🧭 Instructions

Use this template to evaluate and rank keywords across SEO and paid search efforts. It will help you:

Spreadsheet Table (Sample View)

Keyword Search Volume Keyword Difficulty CPC ($) Intent Relevance (1–5) Current Rank Opportunity Score (1–5) Notes / Content Ideas Priority
async video updates 1,500 38 3.10 Transactional 5 Not ranked 5 Landing page + explainer video High
remote team communication 4,200 52 2.60 Commercial 5 #19 4 Comparison blog + gated checklist High
team status updates 1,000 33 1.90 Informational 4 Not ranked 4 Blog + short-form video series Medium
standup alternatives 850 25 2.20 Commercial 5 Not ranked 5 “Skip the daily standup” blog High
best tools for remote teams 3,800 59 4.40 Commercial 4 #28 3 Listicle with partner mentions Medium
video messaging app 2,000 46 3.80 Transactional 3 Not ranked 3 Competitive positioning page Low

Column Definitions

Column Purpose
Search Volume Average monthly searches (from Ahrefs, SEMrush, or Google Keyword Planner)
Keyword Difficulty SEO competition rating — varies by tool (lower = easier to rank)
CPC Cost-per-click for paid ads (optional, for PPC targeting insights)
Intent Informational / Commercial / Transactional
Relevance Alignment with product & audience (1 = low, 5 = perfect match)
Current Rank Your current Google ranking, if applicable
Opportunity Score 1–5 subjective score balancing volume, intent, difficulty, and relevance
Notes Use case ideas, gaps, or page suggestions
Priority High / Medium / Low (based on strategic opportunity)

✅ Pro Tips