SOP - Build a monthly keyword and content opportunity pipeline
A role-specific operating procedure for SEO VA, tailored to Ahrefs, Google Search Console, Google Analytics 4, and Screaming Frog.
Purpose and business outcome
This SOP enables a SEO Operations Specialist to own "Build a monthly keyword and content opportunity pipeline" across Ahrefs, Google Search Console, Google Analytics 4, and Screaming Frog with clear decision rights, measurable quality controls, and minimal founder chasing.
Operating contract
| Control | Definition |
|---|---|
| Workflow trigger | A keyword brief, page optimization request, technical issue, content launch, or reporting cycle enters the SEO queue. |
| Primary owner | SEO Operations Specialist |
| Selected stack | Ahrefs, Google Search Console, Google Analytics 4, and Screaming Frog |
| Definition of done | The opportunity is researched, prioritized, implemented or handed off with exact instructions, quality-checked, and tracked against a documented baseline without implying guaranteed rankings. |
Selected stack operating map
Only tools relevant to SEO VA are offered in the selector. These are the exact responsibilities assigned to the selected stack.
| Tool | Function | How it is used in this workflow |
|---|---|---|
| Ahrefs | Research | Use for keyword discovery, competitor gaps, backlink analysis, and rank tracking. |
| Google Search Console | Measurement | Use for query, page, indexing, coverage, and search-performance diagnostics. |
| Google Analytics 4 | Measurement | Use for organic traffic, engagement, conversions, and landing-page analysis. |
| Screaming Frog | Technical SEO | Use for crawls, metadata checks, redirect mapping, canonicals, and technical QA. |
Scope of ownership
The specialist owns the following execution areas and escalates only according to the boundary rules later in this document.
- Translate business priorities into keyword, page, and technical SEO work queues.
- Research search intent, competitors, content gaps, internal-link opportunities, and SERP patterns.
- Prepare implementation-ready on-page recommendations for titles, headings, copy, schema, links, and media.
- Run technical crawls, prioritize issues by impact, and coordinate fixes with clear acceptance criteria.
- Maintain content inventories, keyword maps, rank tracking, and change logs across the selected stack.
- Report organic performance, completed work, risks, and next recommendations in plain business language.
Step-by-step operating procedure
Complete the sequence in order unless a documented exception requires a different path.
Confirm the business priority
Document the target audience, service or product priority, market, conversion action, current baseline, and deadline before beginning research.
Research demand and search intent
Use Ahrefs plus the approved research stack to identify viable topics, intent patterns, competitor gaps, and realistic page opportunities.
Map keywords to pages
Assign one primary intent cluster to each target page, flag cannibalization, and document whether the correct action is create, consolidate, refresh, redirect, or leave unchanged.
Prepare implementation instructions
Write exact recommendations for metadata, headings, copy sections, internal links, schema, media, and calls to action using the selected publishing and optimization tools.
Run technical and on-page QA
Crawl the affected URLs, inspect indexing and canonical signals, validate links and redirects, and confirm the live page matches the approved brief.
Record the change and baseline
Log the publication date, changed elements, target query cluster, owner, and pre-change metrics in the reporting source of truth.
Monitor and recommend the next action
Review indexing, clicks, impressions, engagement, conversions, rankings, and technical health at the agreed cadence; then recommend one prioritized next action.
Your exact-stack specialist is already trained for this.
Enter your email to unlock the full custom SOP, download the Markdown, and view two matching redacted specialist profiles available this week.