Traffic Portfolio Risk Calculator: Quantify Your Exposure in 5 Minutes

"Am I diversified enough?" isn't a feeling—it's a calculation.

This risk calculator provides quantified risk assessment using four weighted metrics: concentration risk, correlation exposure, volatility score, and owned audience strength. Input your traffic data, get a numerical risk score (0-100), and specific remediation priorities.

No spreadsheets required. Just follow the formulas, plug in your numbers, and interpret results using the benchmarks provided.

Calculator Input: Data You Need

Before starting, gather this data from Google Analytics (past 12 months):

1. Monthly traffic by source (Acquisition > All Traffic > Source/Medium, export 12 months)
2. Weekly traffic by source (same report, weekly view, export 52 weeks)
3. Email list metrics (subscribers, open rate, unsubscribe rate)
4. Revenue by source (if E-commerce tracking enabled)

Time to gather: 10-15 minutes

Metric 1: Concentration Risk Score (40% of total risk)

Formula: Herfindahl-Hirschman Index (HHI)

HHI = Σ(Traffic_Share_i)²

Where Traffic_Share_i = (Traffic from Source i / Total Traffic)

Step-by-Step Calculation

Example data:

HHI Calculation:

HHI = 0.3906 + 0.0279 + 0.0123 + 0.0094 = 0.4402

Convert HHI to Risk Score (0-100 scale, lower is better)

This example: HHI 0.44 → Risk Score: 70 (High concentration risk)

Weight: 40% of total risk score

Weighted contribution: 70 × 0.40 = 28 points

Metric 2: Correlation Risk Score (30% of total risk)

Formula: Average Pairwise Correlation

Avg_Correlation = Σ(Correlation_ij) / Number_of_Pairs

Where Correlation_ij = Pearson correlation between Channel i and Channel j

Step-by-Step Calculation

Data needed: 52 weeks of traffic for each source (weekly data points)

Use Excel/Google Sheets formula: =CORREL(Channel_1_Weekly, Channel_2_Weekly)

Example correlation matrix:

Count unique pairs: With 4 channels, there are (4 × 3) / 2 = 6 pairs

Sum correlations (excluding diagonal 1.00 values):

0.12 + 0.38 + 0.24 + 0.09 + 0.47 + 0.11 = 1.41

Calculate average:

Avg_Correlation = 1.41 / 6 = 0.235

Convert Correlation to Risk Score

This example: Avg correlation 0.24 → Risk Score: 20 (Low correlation risk)

Weight: 30% of total risk score

Weighted contribution: 20 × 0.30 = 6 points

Metric 3: Volatility Risk Score (15% of total risk)

Formula: Coefficient of Variation

CV = (StdDev of Monthly Traffic / Mean Monthly Traffic) × 100

Step-by-Step Calculation

Data: 12 months of total traffic (all sources combined)

Example:

Mean: (68 + 72 + 71 + 64 + 70 + 73 + 69 + 75 + 67 + 71 + 72 + 70) / 12 = 70,167

Standard Deviation (use =STDEV.S() in spreadsheet): 2,915

Coefficient of Variation:

CV = (2,915 / 70,167) × 100 = 4.15%

Convert CV to Risk Score

This example: CV 4.15% → Risk Score: 5 (Very low volatility)

Weight: 15% of total risk score

Weighted contribution: 5 × 0.15 = 0.75 points

Metric 4: Owned Audience Risk Score (15% of total risk)

Formula: Owned Traffic Percentage

Owned % = (Email + RSS + Direct + Community) / Total Traffic × 100

Step-by-Step Calculation

Example:

• Email traffic: 12,000
• Direct traffic: 8,000 (of which 4,000 are likely repeat visitors = owned)
• RSS traffic: 200
• Total owned: 16,200
• Total traffic: 72,000

Owned % = (16,200 / 72,000) × 100 = 22.5%

Convert Owned % to Risk Score (inverse—higher owned % = lower risk)

This example: 22.5% owned → Risk Score: 30 (Moderate risk)

Weight: 15% of total risk score

Weighted contribution: 30 × 0.15 = 4.5 points

Total Portfolio Risk Score

Sum weighted contributions:

Total Risk Score = 28 + 6 + 0.75 + 4.5 = 39.25

Round: 39 out of 100

Risk Score Interpretation

This example: Score 39 → Grade: C (Moderate risk with actionable improvements needed)

Risk Diagnosis and Remediation Plan

Based on individual metric scores, identify remediation priorities:

This Example's Diagnosis

Primary issue: Google concentration (62.5% of traffic)

Secondary issue: Owned audience could be stronger (22.5% is acceptable but not excellent)

Strengths: Low correlation between channels, very stable traffic

Recommended Action Plan

Priority 1 (Months 1-3): Reduce Google dependency

• Target: Bring Google down to 50% or lower
• Method: Scale email list (grow from 12K to 18-20K visits/month) and YouTube (grow from 8K to 12-15K visits/month)
• Expected HHI improvement: From 0.44 to 0.32 (Risk Score: 70 → 50)

Priority 2 (Months 4-6): Strengthen owned audience

• Target: Increase owned traffic from 22.5% to 28-30%
• Method: Aggressive email list growth (optimize forms, better lead magnets, more consistent sending)
• Expected improvement: Owned Audience Risk Score: 30 → 20

Priority 3 (Months 7-12): Maintain gains

• Target: Hold HHI below 0.35, owned audience above 28%
• Method: Rebalancing (if Google grows back above 55%, reallocate effort)

Expected outcome after 12 months:

• HHI: 0.32 (Risk Score: 50, -20 points)
• Correlation: 0.24 (Risk Score: 20, no change)
• Volatility: 4% (Risk Score: 5, no change)
• Owned: 30% (Risk Score: 15, -15 points)
• New Total Risk Score: 50 × 0.40 + 20 × 0.30 + 5 × 0.15 + 15 × 0.15 = 29 points
• Improvement: From 39 (Grade C) to 29 (Grade B)

Advanced Calculation: Monte Carlo Risk Simulation

For publishers who want deeper analysis, simulate portfolio behavior under stress scenarios.

Scenario 1: Primary Channel Drops 50%

Input: Google drops from 45K to 22.5K

Calculation:

• New Google traffic: 22,500
• Other channels unchanged: 27,000
• New total: 49,500
• Traffic decline: (72K - 49.5K) / 72K = 31.3% decline

Scenario 2: Primary + Correlated Secondary Drop Together

Input: Google drops 50%, YouTube drops 30% (correlation 0.38)

Calculation:

• New Google: 22,500
• New YouTube: 5,600 (8K × 0.70)
• Other channels unchanged: 19,000
• New total: 47,100
• Traffic decline: (72K - 47.1K) / 72K = 34.6% decline

Scenario 3: All Algorithmic Channels Drop 40%

Input: Google, YouTube, Pinterest all drop 40%

Calculation:

• New Google: 27,000
• New YouTube: 4,800
• New Pinterest: 4,200
• Email unchanged: 12,000
• New total: 48,000
• Traffic decline: (72K - 48K) / 72K = 33.3% decline

Survivability assessment: If 33% traffic decline would kill business, risk is unacceptable. If business survives, risk is manageable.

Quick Risk Calculator (5-Minute Version)

Don't have time for full calculation? Use this simplified version:

Question 1: What % of traffic comes from your largest source?

• <40% = 20 points
• 40-50% = 35 points
• 50-60% = 50 points
• 60-70% = 70 points

• 70% = 90 points

Question 2: What % of traffic do you own (email + direct)?

• 30% = 10 points

• 20-30% = 25 points
• 10-20% = 45 points
• <10% = 70 points

Question 3: If your top 2 sources dropped 40% tomorrow, would your business survive 6 months?

• Yes, easily = 10 points
• Yes, with cuts = 30 points
• Uncertain = 60 points
• No = 90 points

Total Risk Score: (Q1 + Q2 + Q3) / 3

Example: (50 + 25 + 30) / 3 = 35 points (Grade B, low-moderate risk)

FAQ: Traffic Portfolio Risk Calculator

How often should I recalculate risk score? Quarterly. Traffic distributions shift over time. Correlation coefficients change. Recalculate every 3 months to catch emerging risks.

My risk score is 65 (Grade D). How fast can I improve it? 6-12 months to drop to Grade C (50-point range). 12-18 months to reach Grade B (35-point range). Risk reduction is gradual, not immediate.

Do I need advanced math skills? No. If you can use Excel/Google Sheets functions (SUM, AVERAGE, STDEV, CORREL), you can calculate this. Formulas provided.

What if I have incomplete data (e.g., no correlation data)? Use simplified 5-minute calculator. Full calculator requires 52 weeks of weekly traffic data. If <12 months history, wait until you have it.

Can two sites with same traffic distribution have different risk scores? Yes. Correlation matters. Site A with 60% Google + 40% email has lower risk than Site B with 60% Google + 40% Bing (correlated).

Related guides: Traffic Portfolio Audit Template | Traffic Diversification Strategy Framework | Traffic Monitoring Alert System