top of page
Arun Profile Pic.jpeg
Arun Profile Pic.jpeg

Written By

I am Arun Kothapally. I help ambitious companies scale their organic growth. Over the last 11 years, I have helped companies like Practo, Flipkart, JioCinema, Edureka, Noon, and Treebo acquire millions of users by building organic growth engines.

Throughout my career in growth, I have had the privilege of working directly with some of the best product and marketing teams. Working with companies of different sizes and various marketing channels and platforms has opened my mind to understanding "how things work".

When I'm away from work, I'm usually outdoors, trekking, practicing yoga, traveling, or reading. I drop by Bangalore and Hyderabad at times, but I usually work remotely.

  • LinkedIn

Predicting SEO Traffic & Revenue For Leadership Buy-In

  • Jul 13, 2025
  • 4 min read

Updated: Jul 21, 2025

Forecasting SEO isn’t about being 100% right. It’s about being 80% credible and 100% accountable. You need to be reasonable and responsible in your predictions while driving results.

Why Forecasting SEO Matters

If you can’t connect SEO effort to business outcomes, no CMO or CFO will take you seriously.

Here’s why forecasting is non-negotiable for me:

  • Buy-in: Leadership won’t fund SEO if they can’t visualize what they’ll get.

  • Planning: Forecasting provides the team with a Clear Direction and informs product/content/dev what to prioritize.

  • Budget: If I want ₹15L for link-building and content, I need to show the revenue upside, not just traffic.

  • Expectation Management: SEO takes 4–12 months to show results. Forecasts help pace those conversations.

  • Focus: When you put numbers to impact, people stop arguing about “tactics” and start asking “what moves the needle.”

My Forecasting Philosophy

Forget perfect predictions. I build revenue-informed traffic scenarios — base, conservative, and optimistic.

Each scenario includes:

  • How much traffic could we unlock

  • What % of it can we realistically win

  • What revenue would that generate

This turns vague aspirations into testable hypotheses.


My Step-by-Step Forecasting Workflow

1. Define Target Clusters

Choose keyword clusters tied to business value (BOFU > MOFU > TOFU).

Example: If I’m running SEO for an edtech platform → target “data science certification”, not just “what is data science.”


2. Estimate Traffic Potential

Use a bottom-up formula:

Estimated Traffic = Search Volume × CTR by Rank × % of Keywords Ranked
  • Use Ahrefs/Semrush for volume

  • Use SERP layout analysis to adjust CTR (i.e., 15% instead of 30% if SERP is packed with PAA, video, ads)

  • Apply the expected win rate based on domain strength


3. Estimate Conversions & Revenue

Layer in CVR and LTV:

Leads = Traffic × CVR  
Revenue = Leads × LTV

Example:

  • Cluster: “best Python certification”

  • Total search volume: 50K/mo

  • We rank in the top 5 for 40% = 20K visitors

  • CVR = 2%, LTV = ₹7,000

Revenue = 400 leads × ₹7,000 = ₹28L

Tools I Use

  • Google Search Console: Real CTR, impression baselines

  • Google Analytics / GA4: Conversion rates, bounce data

  • Ahrefs/Semrush: Keyword-level forecasting, gap analysis

  • Looker Studio (ex-Data Studio): Automated dashboards

  • Screaming Frog: For audit-based traffic recovery forecasts

  • Prophet (optional): If I want to model seasonality from historical GSC data


SEO Performance vs SEO Results

SEO Performance (Leading indicators)

  • Impressions and CTRs from GSC

  • Keyword rank shifts (especially into the top 10)

  • Page indexation and crawl stats

  • Share of voice vs competitors


SEO Results (Business outcomes)

  • Non-branded organic sessions

  • Conversions from organic search

  • Semrush “traffic cost” → what paid ads would charge

  • CAC and revenue per visit

I always separate organic revenue overall from revenue from deliberate SEO activity to avoid confusion.

How I Present Forecasts to Stakeholders

What I Show

  • Clear base/conservative/optimistic traffic scenarios

  • Revenue models tied to funnel math (CVR × LTV)

  • SEO cost breakdown: content, tools, link building

  • Forecasted ROI over 6–12 months

How I Talk About It

I don’t say:

“We’ll grow traffic by 50%.”

I say:

“If we invest ₹10L in these 3 SEO levers, we could drive ₹25L–₹35L in LTV over 9 months. Here's how that compares to paid CAC.”

That’s the difference between noise and influence.


Common Mistakes I See (and Avoid)

  • Assuming 30% CTR across all top 3 positions (without checking SERP clutter)

  • Ignoring keyword cannibalization

  • Overestimating content velocity (teams can’t publish 30 blogs/month if you don’t have writers)

  • Confusing branded traffic growth with SEO impact

  • Forecasting before cleaning up tech debt


Real-World Examples of Traffic and Revenue Prediction

Here’s a breakdown of real-world examples where I’ve used forecasting to prove the ROI of SEO and secure budgets — whether with skeptical CEOs, lean startups, or multi-layered orgs.

EdTech SEO ROI Model: 9x Return

At one edtech client, we spent ₹40,000/month on content (8 articles at ₹5,000 each) and allocated an additional budget to link building and tools such as Ahrefs and OnCrawl. Over time, this increased traffic by 2x, and with a 1% conversion rate and an average order value of ₹2,000, we could attribute ~4,000 incremental sales.

Revenue math:₹2,000 × 4,000 sales = ₹80 lakhs

Total cost:₹8 lakhs across content, tools, and links

ROI:10x return on SEO investment compared to ~3x from paid ads — a no-brainer for management.


Negative ROI? Know When to Stop

In another case (also EdTech), after ~3-4 months of SEO work, I realized we were in a brutally competitive SERP environment. Even with proper investments, the SEO ROI was negative. Rather than chasing sunk costs, I recommended we pause SEO entirely. That clarity helped reallocate funds more efficiently and built long-term trust with leadership.


Ecommerce Traffic-to-Revenue Projection

For an e-commerce brand, we ran a 12-month ROI model. Assuming 100K monthly visits at 2% conversion and ₹500 AOV:

  • Sales = 2,000

  • Revenue = ₹10 lakhs/month

  • Annual SEO revenue = ₹1.2 crore

Even after factoring in ₹43 lakhs spent on content + links over two quarters, we showed a 1.5x ROI over 12 months. Management saw it clearly: SEO may take longer than PPC to deliver, but it compounds over time.


JioCinema Tech SEO Prioritization with Limited Dev Bandwidth

One sports media client required only one engineering change every six months. I selected the most impactful SEO fix from a 20-item backlog — and it unlocked a 3x increase in traffic. This wasn't about volume. It was about prioritization and conviction in the change.


SaaS and Consumer Startups: Forecast Sheets That Close Deals

I built detailed forecast sheets outlining:

  • Number of pieces needed

  • Estimated cost per article/link

  • Predicted traffic gain from each keyword cluster

  • Projected sales at a 1-2% conversion rate

For SaaS, I used actual pipeline data (such as LTV, CAC, and close rate) to map organic sessions to revenue. One startup in video editing saw a 5.6x ROI, which helped secure long-term SEO budgets.

1weather.com: Ad Revenue and Traffic Forecasts

For a weather-based app, I forecasted SEO traffic over 18 months, modeled ad impressions per page view, and estimated CPMs ($2–$5 per thousand). Based on 5.5 million sessions, I projected approximately $ 55,000 per month in ad revenue, without even counting affiliate integrations. This gave us leverage to justify content ops and scaling the CMS.


Lesson Across All Forecasts

  • Never promise revenue. Just show potential.

  • Use 12-month projections, not one-off monthly snapshots.

  • Distinguish organic traffic vs true SEO-acquired traffic (non-branded).

  • Include content costs, backlink costs, and technical bandwidth. That’s your full accounting.

 
 
Learn SEO and Content Marketing

What the F*** is SEO? SEO isn’t just keywords, backlinks, or quick fixes — it’s a long-game, cross-functional system that cuts across...

 
 
bottom of page