Match demand to the reader
A keyword had to fit the audience and the article’s purpose. Search volume alone could not determine the plan.
Content strategy · Anonymised client case
Keyword research and content planning
I evaluated 59 keywords and developed eight article briefs for a four-week editorial plan, connecting company content with founder thought leadership.
English content · US keyword database · Semrush and Excel
The editorial challenge
New topics without content overlap
A B2B technology business and its founder needed useful content for business readers. The plan had to support two distinct publishing channels while avoiding repeated coverage.
Give each article a new question
I checked the archive to establish how each proposal would add to existing coverage, rather than repeat it under another keyword.
Keep expert context credible
The brief called for third-person, non-promotional journalism, with research, labelled examples and client-confirmation questions kept distinct.
My contribution
From research to editorial briefs
I connected keyword screening, existing-content review, topic selection and brief development in a structured handoff for editorial production.
Research and screening
Assess the keyword evidence
I organised Semrush US search volume, keyword difficulty, intent and CPC alongside qualitative search-result observations, recording each term’s source and editorial role.
Content history
Find a distinct editorial angle
I checked proposed topics against supplied content history and separated company content from founder thought leadership, retaining useful supporting and reserve terms.
Brief development
Give the writer a clear direction
I developed the reader, central question, title, outline, supporting keywords, meta description, internal-link suggestions, research sources and client-confirmation questions.
Planning and handoff
Connect the plan to its evidence
I scheduled eight proposals across four weeks, with one article for each publishing channel per week. Article references linked the calendar, briefs and keyword research.
Tools and materials: Semrush keyword data, Excel, qualitative search review, supplied content-history records and source research.
Selection logic
How I prioritised the keywords
I balanced demand and difficulty with search intent, audience fit, existing coverage and the strength of a differentiated story. All 59 terms received a documented role.
- 8
- Primary targets
- 22
- Supporting or branded terms
- 22
- Reserve candidates
- 7
- Held for content overlap
| Research signal | My decision | Editorial consequence |
|---|---|---|
| Related measurement terms Two phrases addressed the same measurement problem. The more specific phrase had stronger measured demand and lower difficulty in the research snapshot. | Choose one primary target and retain the related phrase as support. | Develop one article about the evidence needed to judge marketing impact, with a distinct purpose for the supporting term. |
| Intent over breadth A broad educational phrase suggested learning or course intent. A narrower oversight concept matched the proposed reader question more closely. | Prioritise the closer intent match and keep the wider concept secondary. | Focus the brief on judgement and questioning AI outputs, with any personal claims subject to client confirmation. |
| Existing content overlap Distributed-team themes already appeared in the archive. Another general treatment of remote operations would repeat prior coverage. | Reframe the topic around whose expertise influences decisions and flag the overlap for review. | Ask for a confirmed participation example before attributing a leadership practice to the subject. |
Related measurement terms
- Research signal
- Two phrases addressed the same measurement problem. The more specific phrase had stronger measured demand and lower difficulty in the research snapshot.
- My decision
- Choose one primary target and retain the related phrase as support.
- Editorial consequence
- Develop one article about the evidence needed to judge marketing impact, with a distinct purpose for the supporting term.
Intent over breadth
- Research signal
- A broad educational phrase suggested learning or course intent. A narrower oversight concept matched the proposed reader question more closely.
- My decision
- Prioritise the closer intent match and keep the wider concept secondary.
- Editorial consequence
- Focus the brief on judgement and questioning AI outputs, with any personal claims subject to client confirmation.
Existing content overlap
- Research signal
- Distributed-team themes already appeared in the archive. Another general treatment of remote operations would repeat prior coverage.
- My decision
- Reframe the topic around whose expertise influences decisions and flag the overlap for review.
- Editorial consequence
- Ask for a confirmed participation example before attributing a leadership practice to the subject.
Keyword metrics reflect the US tool snapshot used for the research. Unavailable volume remained distinct from a measured zero; qualitative search observations informed editorial fit.
The handoff
One workbook, three connected views
The calendar, article briefs and keyword research were linked through article references. Explore the anonymised examples and record structure below.
Editorial planning workbookResearch ↔ briefs ↔ calendar
Anonymised brief example
Data quality and market coverage
Can records be complete and accurate while important parts of the target market remain unobserved?
- Primary keyword
- Data quality metrics
- Reader
- B2B decision-makers assessing whether a dataset represents their target market.
- Distinct angle
- Population coverage, rather than another broad definition of data quality or a guide to record cleaning.
Explore the outline and production guidance
- Outline direction
- Distinguish a complete record from a representative dataset.
- Define the population the business needs to understand.
- Inspect the channels, regions and business types the evidence covers.
- Identify missing groups and the limits of the resulting conclusions.
- Evidence controls
- Use documented research and clearly labelled examples. Confirm actual organisational practices before attributing them to the business.
- Production guidance
- The shared brief specified 800–1,200 words, third-person journalism, a meta description of up to 155 characters and two or three relevant internal links.
- Brief components
- Reader, purpose, selection rationale, differentiation from prior coverage, outline, supporting keywords, proposed metadata, research references and confirmation questions.
Adapted from the brief structure. Original titles, identities, client links and internal references are withheld.
Four-week editorial plan
Two publishing channels, one connected schedule
One company article and one founder article were planned for each week. Every slot connected to a brief and its research.
| Week | Company content | Founder thought leadership |
|---|---|---|
| Week 1 | Company article 01 | Founder article 01 |
| Week 2 | Company article 02 | Founder article 02 |
| Week 3 | Company article 03 | Founder article 03 |
| Week 4 | Company article 04 | Founder article 04 |
Anonymised reconstruction of the schedule structure. Labels replace original titles and internal references.
Research record structure
Evidence that travels with the editorial choice
The research view retained all 59 terms, not only the primary targets, so selected, supporting, reserve and overlap decisions could be reviewed together.
- Keyword and source
- Term, source reference and keyword tier
- Search evidence
- US volume, difficulty, intent and CPC
- Editorial judgement
- Rationale, content overlap and qualitative search review
- Production connection
- Keyword status, editorial role and linked article reference
This view shows the workbook’s field structure. Client records and the original workbook are not published.
Outcome and demonstrated skills
An approved plan for editorial production
The client approved the research and content plan: eight article directions with differentiated angles, actionable briefs and a four-week schedule.
A clear basis for production
The handoff defined what to write, who it was for, why each topic was selected and which claims needed confirmation. Supporting and reserve terms remained available for later planning.
Search evidence and editorial judgement
Keyword prioritisation, intent analysis, content-history review, topic differentiation, brief writing, source evaluation and planning across two publishing channels.
Continue exploring
The research behind useful content
I connect search evidence, source evaluation and editorial judgement to build content plans that writers and stakeholders can use.