A yearly marketing projections template that models traffic, leads, and revenue by channel with best/base/worst case scenarios. Built for marketing leaders who need to forecast with defensible assumptions and present projections that finance teams take seriously.
Last updated: March 2026 · Reading time: 14 min
A marketing projections template is a spreadsheet model that forecasts traffic, leads, and revenue across marketing channels for the coming 12 months. It turns your marketing plan into numbers that finance teams, CEOs, and board members can evaluate. Without projections, you’re asking for budget based on hope. With them, you’re asking based on a model with stated assumptions that can be tested and adjusted.
A marketing projections template is a channel-by-channel forecast model that converts planned marketing activities into expected traffic, leads, and revenue, with adjustable assumptions for scenario planning.
Gartner’s 2024 CMO Spend Survey found that 71% of CMOs were asked to “do more with less” in the past year. The CMOs who kept their budgets intact were the ones who could show a direct line from marketing spend to projected revenue. This template builds that line. It’s the same forecasting framework we use at ScaleGrowth.Digital to set expectations with clients before the first campaign launches.
This template is built for marketing directors, VPs, and CMOs who need to present annual projections in planning meetings. It’s also used by growth-stage startups raising funding (investors want to see your customer acquisition cost model and payback period, both of which require traffic and lead projections).
Six interconnected tabs where data flows from traffic through leads into revenue.
| Channel | Jan | Feb | Mar | Q1 Total | … | Dec | Annual Total | MoM Growth % |
|---|---|---|---|---|---|---|---|---|
| Organic Search | 12,000 | 12,600 | 13,200 | 37,800 | … | 19,200 | 186,000 | 5% |
| Paid Search (Google Ads) | 8,000 | 8,200 | 8,400 | 24,600 | … | 10,400 | 110,000 | 2.5% |
| Paid Social | 5,000 | 5,200 | 5,500 | 15,700 | … | 7,800 | 76,000 | 4% |
| 3,500 | 3,600 | 3,700 | 10,800 | … | 4,600 | 48,000 | 2% | |
| Referral | 1,500 | 1,550 | 1,600 | 4,650 | … | 2,000 | 21,000 | 2% |
| Direct | 4,000 | 4,100 | 4,200 | 12,300 | … | 5,200 | 55,000 | 2% |
| Total | 34,000 | 35,250 | 36,600 | 105,850 | … | 49,200 | 496,000 | – |
| Channel | Monthly Traffic (Avg) | Conv. Rate | Monthly Leads | Annual Leads |
|---|---|---|---|---|
| Organic Search | 15,500 | 2.8% | 434 | 5,208 |
| Paid Search | 9,200 | 3.5% | 322 | 3,864 |
| Paid Social | 6,300 | 1.2% | 76 | 907 |
| 4,000 | 4.5% | 180 | 2,160 | |
| Referral | 1,750 | 5.2% | 91 | 1,092 |
| Direct | 4,600 | 3.0% | 138 | 1,656 |
| Total | 41,350 | 3.0% (blended) | 1,241 | 14,887 |
| Channel | Annual Leads | SQL Rate | SQLs | Close Rate | Customers | Avg Deal Size | Revenue |
|---|---|---|---|---|---|---|---|
| Organic Search | 5,208 | 30% | 1,562 | 15% | 234 | $8,000 | $1,874,000 |
| Paid Search | 3,864 | 35% | 1,352 | 18% | 243 | $7,500 | $1,825,000 |
| Paid Social | 907 | 20% | 181 | 10% | 18 | $6,000 | $109,000 |
| 2,160 | 40% | 864 | 20% | 173 | $8,500 | $1,469,000 | |
| Referral | 1,092 | 50% | 546 | 25% | 137 | $9,000 | $1,229,000 |
| Direct | 1,656 | 25% | 414 | 12% | 50 | $7,000 | $348,000 |
| Total | 14,887 | 33% (blended) | 4,919 | 17% (blended) | 855 | $8,000 (avg) | $6,854,000 |
The template has six tabs that connect into a single projection model. Change one assumption and the downstream impact flows automatically. Here’s what each tab covers:
Traffic projections start with your current baseline (last 3 months of actual data from Google Analytics 4) and apply a channel-specific month-over-month growth rate. Don’t use the same growth rate for every channel. Each channel grows differently based on how it works.
Organic search grows through content publishing and backlink acquisition. Typical growth rates for a company investing in SEO: 3-8% MoM for the first 6 months, accelerating to 5-12% MoM in months 7-12 as older content compounds. If you’re starting from near zero organic traffic, expect 3-6 months of minimal growth before the curve bends upward. Ahrefs (2024) found that only 5.7% of pages rank in the top 10 within a year of publication.
Paid search growth depends on budget increases and quality score improvements. A well-managed account grows traffic 2-5% MoM at constant budget (through better quality scores and ad relevance). With budget increases, growth maps roughly 1:1 to additional spend, with diminishing returns above $50,000/month. WordStream’s 2024 benchmark data shows average paid search CTR of 3.17% across industries.
Paid social growth ranges from 3-6% MoM with consistent creative refresh. Fatigue hits paid social faster than paid search. You need new creative every 2-3 weeks. Meta’s 2024 performance data shows creative refresh extends campaign effectiveness by 35% on average.
Email traffic grows with list size. If your list grows 2-3% per month and your click-to-open rate holds steady around 10-15% (Mailchimp’s 2024 benchmarks), you can model email traffic growth at 1.5-3% MoM.
Referral traffic grows through partnerships, PR, and guest content. Model at 1-3% MoM unless you’re launching a new partnership or integration that will create a step change.
Direct traffic is a proxy for brand awareness. It grows slowly: 1-3% MoM for established brands, 3-5% for brands investing in above-the-line marketing (TV, podcast ads, events).
The template has each of these growth rates as editable inputs. Change the assumption and the 12-month projection recalculates automatically.
Lead projections use a simple formula: Traffic x Conversion Rate = Leads. But the conversion rate varies by channel, and that variance is where most projections go wrong. Teams often use a single blended conversion rate across all traffic. That hides the reality that referral traffic converts at 5x the rate of paid social traffic.
Use channel-specific conversion rates. Here are the benchmarks from Unbounce’s 2024 Conversion Benchmark Report across 44,000 landing pages:
| Channel | Median Conversion Rate | Top 25% Conversion Rate | Why It Differs |
|---|---|---|---|
| Organic Search | 2.4% | 5.3% | Higher intent but broader audience mix |
| Paid Search | 3.2% | 6.1% | Keyword targeting matches intent directly |
| Paid Social | 1.1% | 2.8% | Interruption-based, lower immediate intent |
| 4.2% | 8.5% | Warm audience, already opted in | |
| Referral | 4.8% | 9.2% | Pre-qualified by the referring source |
| Direct | 2.8% | 5.7% | Brand-aware visitors, mixed intent |
Start with your actual conversion rates from the last 90 days (GA4 > Reports > Acquisition > Traffic Acquisition, filtered by conversion events). If you don’t have 90 days of data, use the median benchmarks above as starting assumptions, then calibrate monthly.
A critical detail: conversion rates aren’t static across the year. B2B companies see higher conversion rates in Q1 (new budget cycles) and Q4 (use-it-or-lose-it budget). Ecommerce sees spikes during promotional periods. The template includes seasonal adjustment multipliers for each quarter.
Revenue projections add three layers to your lead projections: SQL qualification rate, close rate, and average deal size. The formula: Leads x SQL Rate x Close Rate x Avg Deal Size = Revenue.
Each layer has its own channel variance:
SQL rate (lead-to-sales-qualified). Not every lead is worth a sales conversation. Referral leads qualify at 40-55% because they come pre-vetted. Paid social leads qualify at 15-25% because they’re earlier in the buying journey. Forrester (2024) found that the average B2B SQL rate across all channels is 29%.
Close rate (SQL-to-customer). This varies by channel because lead quality and intent differ. Referral SQLs close at 20-30%. Paid social SQLs close at 8-15%. Your sales team’s overall win rate is a blend of these channel-specific rates. Salesforce’s 2024 State of Sales report shows the average B2B close rate at 22%, but top-performing teams hit 30%+.
Average deal size. This can also vary by channel. Enterprise leads from organic search (who found you while researching) may have larger initial deals than those from paid social (who were reached through audience targeting and may be smaller companies). If your deal size is relatively consistent, use a single number. If it varies by more than 20% across channels, break it out.
The revenue attribution tab in the template multiplies all three layers per channel and sums to total projected revenue. You can also add a Customer Acquisition Cost (CAC) column using your channel spend to calculate per-channel ROI and blended CAC.
Every projection needs three scenarios. Presenting a single number implies certainty that doesn’t exist. Three scenarios show your leadership team the range of outcomes and the assumptions driving each one. Finance teams respect range-based forecasting because it acknowledges uncertainty while still providing actionable targets.
| Assumption | Worst Case | Base Case | Best Case |
|---|---|---|---|
| Organic traffic MoM growth | 2% | 5% | 8% |
| Paid search traffic MoM growth | 1% | 2.5% | 5% |
| Paid social traffic MoM growth | 1% | 4% | 7% |
| Blended conversion rate | 2.0% | 3.0% | 4.0% |
| SQL qualification rate | 22% | 33% | 40% |
| Close rate | 12% | 17% | 22% |
| Average deal size | $6,500 | $8,000 | $9,500 |
| Projected annual revenue | $3.2M | $6.8M | $11.4M |
How to define each scenario:
Base case assumes your current trajectory continues with planned improvements. Use your actual last-90-day performance as the starting point and apply growth rates that match your planned investment level. This is the projection you budget against.
Best case assumes everything works: SEO content ranks faster than average, paid campaigns exceed CTR benchmarks, conversion rate optimization efforts succeed. Typically 40-60% above base case. This is not fantasy. It’s the upside if your team executes well and market conditions are favorable.
Worst case assumes headwinds: a Google algorithm update reduces organic traffic, paid CPCs increase 15-20% (which has happened year-over-year for 8 consecutive years per WordStream), a key channel underperforms. Typically 40-55% below base case. This is the number your CFO will hold you to. Make sure you can defend it.
The template’s scenario planner tab lets you toggle between scenarios with a single dropdown. All downstream numbers (leads, revenue, pipeline) update instantly.
The single biggest mistake in marketing projections is using optimistic growth rates without data backing them. Here’s how to set defensible assumptions for each channel:
Step 1: Start with historical data. Pull 6-12 months of actual MoM growth from GA4 for each channel. Calculate the average, median, and standard deviation. Your base case should use the median (less skewed by outliers). Your best case uses the 75th percentile. Your worst case uses the 25th percentile.
Step 2: Adjust for planned investments. If you’re doubling your content team from 2 to 4 writers, it’s reasonable to model organic growth 50-80% above the historical rate (not 200%). If you’re increasing paid search budget by 30%, model traffic growth at 25-30% (accounting for some diminishing returns). Every assumption should map to a specific action or investment.
Step 3: Account for diminishing returns. No channel grows linearly forever. Organic traffic growth compounds for 12-18 months, then slows as you saturate your addressable keyword space. Paid search CPCs increase 15-20% year-over-year on average (WordStream, 2024), which means constant-budget campaigns lose traffic over time. Build these curves into your model.
Step 4: Validate with industry benchmarks. If your model projects 15% MoM organic growth for 12 months, that’s 5.4x annual growth. Unless you’re a brand-new site with massive content investment, that’s unrealistic. Check your assumption against what established companies in your industry achieved. HubSpot’s annual benchmark reports, Databox’s community benchmarks, and Animalz’s SaaS content marketing data are good reference points.
Step 5: Document every assumption. The assumptions dashboard tab in this template has a row for every variable. Write a one-line justification next to each number. When your CEO asks “why did you project 5% MoM organic growth?” you need an answer better than “it seemed reasonable.”
Projections are useless if you don’t compare them to reality every month. The MoM tracker tab has three columns per month: Projected, Actual, and Variance (%). When variance exceeds +/- 15%, that’s a signal to investigate and potentially recalibrate your model.
| Metric | Jan Projected | Jan Actual | Variance | Feb Projected | Feb Actual | Variance |
|---|---|---|---|---|---|---|
| Total Traffic | 34,000 | 32,800 | -3.5% | 35,250 | 36,100 | +2.4% |
| Organic Traffic | 12,000 | 11,200 | -6.7% | 12,600 | 12,900 | +2.4% |
| Total Leads | 1,020 | 985 | -3.4% | 1,058 | 1,102 | +4.2% |
| MQLs | 337 | 310 | -8.0% | 349 | 362 | +3.7% |
| Revenue | $571,000 | $548,000 | -4.0% | $592,000 | $610,000 | +3.0% |
Run this review monthly. At ScaleGrowth.Digital, we do it in the first week of each month when the previous month’s data is finalized. The review takes 30 minutes and answers three questions:
The template includes conditional formatting: green for actuals within 5% of projection, yellow for 5-15% variance, red for over 15%. After Q1, you’ll have enough data to decide whether your base case assumptions need updating. After Q2, recalibrate the remaining 6 months with updated assumptions if variance is consistently above or below 10%.
A pipeline waterfall shows how volume drops at each stage of your funnel. It’s the visual that makes executives immediately understand where marketing’s contribution meets sales’ responsibility. The waterfall answers: “If marketing generates 1,000 leads, how many become customers?”
| Stage | Monthly Volume | Stage Conv. Rate | Cumulative Rate |
|---|---|---|---|
| Website Visitors | 41,350 | – | – |
| Leads (form fills, signups) | 1,241 | 3.0% of visitors | 3.0% |
| MQLs (marketing qualified) | 410 | 33% of leads | 1.0% |
| SQLs (sales qualified) | 205 | 50% of MQLs | 0.5% |
| Opportunities (in pipeline) | 123 | 60% of SQLs | 0.3% |
| Closed Won | 71 | 58% of opportunities | 0.17% |
The waterfall data tab in the template pre-calculates these stage-to-stage conversion rates and shows both monthly and quarterly volumes. You enter three inputs: total visitors, lead conversion rate, and stage-to-stage conversion rates. The template calculates the volume at each stage and shows the cumulative drop-off.
This data feeds directly into a waterfall chart. If you’re building a board deck or investor presentation, the waterfall visual makes the marketing-to-revenue story clear in 10 seconds. Pair this with your marketing budget template to show spend-to-revenue efficiency by stage.
Block 2 hours. You’ll need access to GA4, your CRM (for conversion and close rate data), and your marketing budget. Here’s the process:
Step 1 (15 min): Open the Assumptions Dashboard tab. Enter your current monthly traffic per channel (pull from GA4 > Reports > Acquisition > Traffic Acquisition). Enter your current conversion rates per channel. Enter your average deal size and close rate from your CRM.
Step 2 (20 min): Set growth rate assumptions for each channel. Use your historical data as the starting point. Adjust based on planned investments (new content hires, budget increases, new channels). Document the justification for each assumption.
Step 3 (10 min): Review the Traffic Projection tab. The 12-month forecast auto-calculates from your baseline and growth rates. Sanity check: does the December number look achievable? If organic traffic projects to 3x by December but you’re only adding 2 blog posts per month, your growth rate is too aggressive.
Step 4 (10 min): Review the Lead Projection tab. Check blended conversion rate against your actual CRM data. Are there channels where you’re above or below the benchmark? Adjust inputs.
Step 5 (15 min): Review the Revenue Attribution tab. Verify deal size, SQL rate, and close rate against your last 12 months of sales data. If you don’t have 12 months, use the last available quarter.
Step 6 (20 min): Build your scenarios. Toggle to the Scenario Planner tab. Set worst case (conservative assumptions), base case (your primary projection), and best case (upside scenario). Make sure worst case is something you can still justify to your CFO.
Step 7 (ongoing): Each month, update the MoM Tracker with actuals. Compare. Adjust. Present the updated projection at your monthly marketing review.
For budget planning that pairs with these projections, use our marketing budget template. For annual strategic planning, see the AOP template.
Marketing projections fail for three reasons, and none of them are about math. The math is simple multiplication. The failures are about assumptions, accountability, and updates.
“I’ve reviewed projections from over 50 marketing teams. The projections that hold up share one trait: they’re backed by documented assumptions that the team revisits monthly. The ones that miss badly are always the ones where someone plugged in a 10% MoM growth rate because it made the annual number look good, without checking whether their channel strategy could actually deliver that growth. The spreadsheet doesn’t lie. But the assumptions you feed it can.”
Hardik Shah, Founder of ScaleGrowth.Digital
Three projection mistakes that cost marketing teams credibility:
Mistake 1: Using a single blended conversion rate. If your blended conversion rate is 3%, but organic converts at 2.4% and email converts at 4.5%, a channel mix shift completely changes your lead projection. A month where paid social (1.1% conversion) takes a larger share of traffic will produce fewer leads than projected, even if total traffic hits target. Always model by channel.
Mistake 2: Projecting linear growth for every month. Marketing doesn’t grow linearly. Organic search has a hockey stick curve (flat for months, then sharp growth as content compounds). Paid channels have seasonal variation (Q4 CPCs rise 30-50% in ecommerce due to holiday competition). Event-driven channels spike and drop. Model the shape of growth, not just the rate.
Mistake 3: Never recalibrating. A projection created in January with December targets is useless by April if you’ve never compared actuals to plan. The companies that hit projections recalibrate quarterly: update assumptions, acknowledge what’s working and what isn’t, and adjust the remaining months. This isn’t admitting failure. It’s managing with data.
Get the complete 6-tab Google Sheets template with traffic projections, lead modeling, revenue attribution, scenario planner, MoM tracker, and pipeline waterfall. All formulas pre-built and auto-calculating.
Google Sheets format. No spam. Instant access.
Plan your marketing budget by channel with monthly allocation, budget vs. actual tracking, and ROI calculation per channel.
The strategic planning framework that your projections feed into. Includes OKRs, quarterly milestones, and team planning.
ScaleGrowth.Digital builds data models and projection frameworks tailored to your business. From channel modeling to board-ready reporting.
Well-built marketing projections typically land within 15-20% of actual results in the first year. After one quarter of calibration with real data, accuracy improves to within 10%. The key driver of accuracy isn’t the model complexity but the quality of the assumptions. Teams that document and revisit assumptions monthly achieve significantly tighter projections than those that set-and-forget.
12 months is the standard for annual planning and budget allocation. Some companies project 18-24 months for strategic planning or investor decks. Beyond 12 months, use wider ranges in your best/worst case scenarios because uncertainty compounds. Monthly granularity for the first 6 months, quarterly for months 7-12, and annual for anything beyond 12 months.
Use industry benchmarks as starting assumptions and plan to recalibrate aggressively. Unbounce, HubSpot, Mailchimp, and WordStream all publish annual benchmarks by industry and channel. Start with these, run for 60-90 days, then replace benchmarks with your actual performance data. Flag your projections as “benchmark-based” until you have 90 days of real data.
Include them separately, not in the revenue projection model. Brand awareness metrics (direct traffic growth, branded search volume, social mentions) are leading indicators but don’t convert directly to revenue in a projectable way. Track them in a separate dashboard. Your CFO wants to see traffic to leads to revenue. They don’t want to see impression counts in a revenue model.
Lead with three numbers: projected annual revenue (base case), the investment required to achieve it, and the implied ROI. Then show the range (worst to best case). Then show the waterfall: visitors to leads to SQLs to revenue. Keep the assumptions on a backup slide. Leadership wants the outcome first, the methodology second, and the details only if they ask. A 10-minute presentation with 3 slides beats a 30-minute walkthrough of 6 tabs.
ScaleGrowth.Digital builds data-backed marketing projection models calibrated to your business. We set the assumptions, build the model, and run monthly calibration so your projections stay accurate.