SEO attribution is one of the hardest challenges in digital marketing. Learn how to properly measure the revenue impact of organic search beyond last-click models.
The SEO Attribution Problem
Why Last-Click Fails for SEO
Last-click attribution gives SEO minimal credit because:
- Users discover through organic search but convert later
- Multiple organic visits precede a conversion
- Organic research influences other channel conversions
- Brand awareness from SEO drives direct traffic
The Organic Search Influence
Organic search influences other channels:
Organic search → Direct traffic (brand recall)
Organic search → Email signups (future conversions)
Organic search → Social sharing (amplification)
Organic search → Referral traffic (cited by others)
Organic search → Paid search (branded query uplift)
Attribution Models for SEO
Model Comparison
| Model | SEO Credit | Best For |
|---|---|---|
| Last-click | Minimal | Direct response |
| First-click | Maximum | Awareness campaigns |
| Linear | Equal | Multi-touch analysis |
| Time-decay | Moderate | Recent-focused analysis |
| Data-driven | Accurate | Full-funnel analysis |
Recommended: Multi-Touch Attribution
For SEO, use multi-touch attribution:
WITH user_journeys AS (
SELECT
user_pseudo_id,
ARRAY_AGG(
STRUCT(
traffic_source.medium,
traffic_source.source,
event_timestamp,
event_name
)
ORDER BY event_timestamp
) as touchpoints
FROM `analytics.events_*`
GROUP BY user_pseudo_id
)
SELECT
touchpoint.medium,
COUNT(DISTINCT user_pseudo_id) as attributed_conversions
FROM user_journeys,
UNNEST(touchpoints) as touchpoint
WHERE user_pseudo_id IN (
SELECT user_pseudo_id
FROM user_journeys
WHERE EXISTS (
SELECT 1 FROM UNNEST(touchpoints) t
WHERE t.event_name = 'purchase'
)
)
GROUP BY touchpoint.medium;
Measuring SEO ROI
Direct Revenue from SEO
Track conversions directly from organic:
- E-commerce transactions
- Lead form submissions
- Phone calls from organic
- Demo requests from organic
- Subscription signups from organic
Indirect Revenue from SEO
Measure SEO's indirect impact:
- Brand search uplift: Track branded search volume growth
- Assisted conversions: Organic assisted other channel conversions
- Customer lifetime value: Compare LTV of organic vs. paid customers
- Reduced acquisition cost: Organic reduces dependence on paid
SEO ROI Formula
SEO ROI = (Total SEO Revenue - Total SEO Cost) / Total SEO Cost × 100
Where Total SEO Revenue =
Direct Revenue +
(Assisted Revenue × Attribution Weight) +
(Brand Uplift Revenue × Weight) +
(Paid Search Savings × Weight)
Example:
- Direct Revenue: $500,000
- Assisted Revenue: $200,000 (weighted 50% = $100,000)
- Brand Uplift: $150,000 (weighted 30% = $45,000)
- Paid Search Savings: $100,000
- Total Revenue: $745,000
- SEO Cost: $200,000
- ROI: ($745,000 - $200,000) / $200,000 × 100 = 272.5%
Proving SEO Value to Stakeholders
Executive Dashboard Metrics
Focus on metrics executives care about:
| Metric | Why It Matters |
|---|---|
| Organic revenue | Direct bottom-line impact |
| Revenue growth rate | Trend and momentum |
| Cost per acquisition | Efficiency vs. paid |
| Customer LTV | Quality of organic traffic |
| Market share | Competitive position |
Monthly SEO Business Report
SEO Business Impact - [Month]
REVENUE IMPACT
- Direct organic revenue: $125,000 (+15% MoM)
- Assisted revenue: $45,000 (+10% MoM)
- Total SEO revenue: $170,000
EFFICIENCY
- Organic CPA: $12 (vs. Paid: $45)
- Organic LTV: $350 (vs. Paid: $280)
- SEO ROI: 285%
GROWTH INDICATORS
- Organic traffic: +18% YoY
- Ranking improvements: 45 keywords up
- New keywords ranking: 120
- Content published: 25 articles
INVESTMENT
- SEO team cost: $35,000
- Tool subscriptions: $5,000
- Content production: $15,000
- Total investment: $55,000