AnalyticsMedium⏱ Pre-campaign planning
What It Is
Model the revenue potential of an SEO campaign before starting it — translating keyword search volume into estimated traffic, leads, and revenue using CTR curves, your site’s conversion rate, and deal values. This transforms SEO from a “trust us, it works” pitch into a quantified business case that executives and clients can evaluate like any other investment.
How It Works
- Pull the target keyword list and assign monthly search volume from Ahrefs, Semrush, or Google Search Console — segment by intent tier (bottom-funnel, mid-funnel, top-funnel) since these convert at very different rates
- Apply a position-based CTR curve to each keyword: position 1 ≈ 27–30%, position 3 ≈ 10%, position 5 ≈ 6%, position 10 ≈ 2.5% — use Ahrefs’ SERP feature adjustments for queries with featured snippets or local packs that suppress CTR
- Multiply projected traffic by your site’s current conversion rate from GA4 — use segment-specific rates (organic traffic converts differently than paid) for accuracy
- Multiply projected conversions by average deal value to get forecast revenue — use actual CRM data for deal value, not list prices
- Present forecast as a range with three scenarios (conservative/moderate/aggressive) and explicitly state all assumptions so stakeholders can stress-test the model rather than treat it as a guarantee
Who Recommends It
- Jeremy Rivera — SEO Arcade (SEO Forecasting 101)endorses
- Jeremy Rivera — SEO Arcade (Opportunity Sizing in SEO)endorses
- Ray Martinez — SEO Arcadeendorses
Difficulty
Medium
Medium
Time to Results
Pre-campaign planning
Pre-campaign planning
