Monthly Traffic Economics Dashboard
Traffic volume means nothing without economic context. A channel driving 50,000 sessions monthly might be your best performer or your worst depending on acquisition cost, monetization rate, and visitor lifetime value. A monthly traffic economics dashboard consolidates these variables into a single view, answering: Which channels are profitable? Where should we invest more? Which channels are burning cash?
Most publishers track traffic volume (GA4 sessions) and maybe conversion rates, but rarely connect traffic to full economic reality—spend, revenue, margins, and ROI. This disconnect leads to over-investment in high-volume but unprofitable channels and under-investment in low-volume but high-margin channels.
A proper economics dashboard exposes unit economics per channel, surfaces concentration risks, and guides monthly budget reallocation decisions based on actual profitability, not vanity metrics.
Dashboard Core Metrics
Every traffic economics dashboard should track five metric clusters:
1. Volume Metrics
- Total sessions (current month vs. prior month)
- Sessions by channel (absolute counts)
- Channel distribution (% of total traffic)
2. Cost Metrics
- Total acquisition cost (sum of all channel spend)
- Cost per session (CPS) by channel (spend / sessions)
- Cost as % of revenue (spend / total revenue)
3. Revenue Metrics
- Total revenue (ads, affiliates, products, services)
- Revenue per session (RPS) by channel (revenue / sessions)
- Revenue by channel (absolute $ attributed)
4. Profitability Metrics
- Gross profit per session (RPS - CPS)
- ROI by channel ((Revenue - Cost) / Cost)
- Payback period (months to recover acquisition cost)
5. Portfolio Health Metrics
- Channel concentration (HHI index)
- Diversification score (number of channels exceeding 5% traffic share)
- Risk exposure (% of traffic from channels with negative ROI)
These five clusters provide complete visibility into traffic economics—volume without cost context is incomplete; cost without revenue context is blind.
Building the Dashboard (Google Sheets Template)
A functional traffic economics dashboard lives in Google Sheets (or Excel), updated monthly with data from GA4, ad platforms, and revenue systems.
Structure Overview
Sheet 1: Summary Dashboard (single-page executive view) Sheet 2: Channel Detail (row per channel, all metrics) Sheet 3: Trend Analysis (12-month rolling data for pattern detection) Sheet 4: Data Import (raw data dumps from GA4, ad platforms, revenue systems)
Sheet 1: Summary Dashboard
This is the at-a-glance view for monthly reviews. One page, scannable in 60 seconds.
Section A: Top-Line Metrics (scorecards)
| Metric | Current Month | Prior Month | % Change |
|---|---|---|---|
| Total Sessions | 125,000 | 118,000 | +5.9% |
| Total Cost | $8,500 | $7,800 | +9.0% |
| Total Revenue | $15,200 | $14,100 | +7.8% |
| Gross Profit | $6,700 | $6,300 | +6.3% |
| Blended CPS | $0.068 | $0.066 | +3.0% |
| Blended RPS | $0.122 | $0.119 | +2.5% |
| Blended ROI | 79% | 81% | -2.5% |
Conditional formatting: Green if improving (revenue up, costs down), red if deteriorating.
Section B: Channel Performance Grid
| Channel | Sessions | % of Total | Cost | CPS | Revenue | RPS | Profit | ROI |
|---|---|---|---|---|---|---|---|---|
| Organic Search | 45,000 | 36% | $2,000 | $0.044 | $6,300 | $0.140 | $4,300 | 215% |
| Paid Search | 25,000 | 20% | $3,500 | $0.140 | $4,500 | $0.180 | $1,000 | 29% |
| 20,000 | 16% | $500 | $0.025 | $2,400 | $0.120 | $1,900 | 380% | |
| Social Organic | 15,000 | 12% | $800 | $0.053 | $1,200 | $0.080 | $400 | 50% |
| Referral | 10,000 | 8% | $0 | $0.000 | $600 | $0.060 | $600 | ∞ |
| Paid Social | 10,000 | 8% | $1,700 | $0.170 | $200 | $0.020 | -$1,500 | -88% |
Color coding:
- Green ROI: >100% (profitable, scale candidate)
- Yellow ROI: 25-100% (break-even to modest profit, optimize)
- Red ROI: <25% or negative (unprofitable, cut or fix)
Insight: Paid Social is bleeding $1,500/month—immediate action required (cut spend, fix targeting, or pause entirely).
Section C: Portfolio Health
Diversification Score: 5 channels exceed 5% traffic share → Strong diversification
HHI (concentration index): 2,180 → Moderate concentration (acceptable but monitor; ideal <1,500)
Risk Exposure: 8% of traffic from negative-ROI channels → Low risk
Top 3 channels: Account for 72% of traffic → Moderate concentration (acceptable; ideally <70%)
Interpretation: Portfolio is reasonably diversified. One channel (Organic Search) dominates but not dangerously. Paid Social is a red flag but represents only 8% of traffic—manageable risk.
Section D: 12-Month Trend (Line Chart)
Plot total sessions, total cost, total revenue, and gross profit over 12 months. This surfaces seasonal patterns and long-term trajectory.
Look for:
- Widening gap between revenue and cost: Improving economics
- Converging revenue and cost: Deteriorating economics
- Seasonal spikes: Plan budget allocation around predictable seasonality
Sheet 2: Channel Detail
One row per channel, with columns for all metrics plus calculated fields.
Core columns:
| Column | Formula/Source |
|---|---|
| Channel | Manual entry (Organic Search, Paid Search, etc.) |
| Sessions | Import from GA4 → Traffic Acquisition report |
| Cost | Sum of ad spend (Google Ads, Facebook Ads, etc.) + estimated content production cost |
| CPS | =Cost / Sessions |
| Revenue | Import from GA4 → Ecommerce or custom revenue events |
| RPS | =Revenue / Sessions |
| Gross Profit | =Revenue - Cost |
| Profit per Session | =Gross Profit / Sessions |
| ROI | =(Revenue - Cost) / Cost |
| Payback Period (months) | =Cost / (Revenue / 30 days) (for channels with monthly recurring spend) |
Advanced columns:
| Column | Formula |
|---|---|
| Marginal CPS | Change in cost / Change in sessions (requires multi-month data) |
| Engagement Rate | Import from GA4 (engaged sessions / total sessions) |
| Conversion Rate | Conversions / Sessions (if tracking conversion events) |
| LTV-adjusted ROI | =(Revenue × LTV Multiplier - Cost) / Cost (if you've calculated visitor LTV) |
Conditional formatting:
Apply color scales to ROI, CPS, and RPS columns—visual scanning reveals outliers instantly.
Sheet 3: Trend Analysis
Each channel gets a row per month for the last 12 months. This enables month-over-month and year-over-year comparisons.
Structure:
| Month | Channel | Sessions | Cost | Revenue | ROI |
|---|---|---|---|---|---|
| Jan 2026 | Organic | 42,000 | $1,800 | $5,900 | 228% |
| Feb 2026 | Organic | 45,000 | $2,000 | $6,300 | 215% |
| Mar 2026 | Organic | ... | ... | ... | ... |
Trend analysis use cases:
1. Seasonality detection: Does Paid Search ROI drop every Q4? Budget accordingly.
2. Channel maturation: Is Email traffic plateauing? Time to invest in list growth.
3. Cost inflation: Is CPS rising for Paid Search? Competition is increasing—adjust bids or targeting.
4. Revenue decay: Is RPS declining for Referral traffic? Quality of referring sites may be dropping.
Build pivot charts from this data:
- ROI by channel over time (line chart, one line per channel)
- Sessions by channel over time (stacked area chart showing portfolio evolution)
- Cost vs. Revenue over time (dual-axis line chart)
Sheet 4: Data Import
This is your workspace for dumping raw data from source systems before transforming it into dashboard metrics.
Data sources:
Google Analytics 4:
- Export Traffic Acquisition report (Source/Medium → Sessions, Engagement Rate, Conversion Rate)
- Export Ecommerce report (Revenue by Source/Medium) if applicable
Ad Platforms:
- Google Ads: Export campaign performance (Spend, Clicks, Conversions)
- Facebook Ads: Export ad set performance (Spend, Link Clicks, Results)
- Microsoft Ads: Export campaign stats
Revenue Systems:
- Affiliate networks: Export commissions by traffic source
- E-commerce platform: Export orders by UTM source
- Email platform: Export revenue from email campaigns
Content production costs (estimated):
- Hours spent on content × hourly rate (or flat monthly content budget)
- Divide by traffic generated to get cost per session for owned channels
Import this data monthly, then reference it in Sheet 2 formulas.
Automated Data Connections
Manual data entry is time-consuming and error-prone. Automate where possible.
Google Sheets Add-Ons:
Supermetrics: Pulls data from GA4, Google Ads, Facebook Ads, LinkedIn Ads directly into Sheets. Paid ($99+/month) but worth it for multi-channel dashboards.
Google Analytics Add-On: Free, pulls GA4 data into Sheets. Limited to GA4 metrics.
Zapier + Webhooks: Connect non-standard platforms (affiliate networks, CRM, revenue tools) via Zapier automation.
Google Apps Script: Custom scripts to pull data via APIs (requires coding but free).
Setup:
- Install Supermetrics or GA4 add-on
- Configure data queries (dimensions: source/medium; metrics: sessions, revenue, etc.)
- Schedule auto-refresh (daily or weekly)
- Reference imported data in Sheet 2 formulas
Automation reduces monthly dashboard updates from 2 hours to 15 minutes.
Monthly Dashboard Review Process
Schedule a recurring monthly review (first Monday of each month) to analyze dashboard and make decisions.
Review checklist:
1. Top-line health check (5 min)
- Are total sessions growing or declining?
- Is blended ROI improving or deteriorating?
- Are costs growing faster than revenue (margin compression)?
2. Channel performance audit (10 min)
- Which channels have negative ROI? → Diagnose and fix or cut
- Which channels have >200% ROI? → Scale by increasing budget
- Which channels are declining month-over-month? → Investigate causes
3. Portfolio risk assessment (5 min)
- Is any single channel >50% of traffic? → Diversification risk
- Has HHI increased (concentration worsening)? → Need new channels
- What % of traffic is unprofitable? → Risk exposure increasing?
4. Budget reallocation (10 min)
- Cut $X from underperforming channels
- Redirect to high-ROI channels
- Test $Y on experimental channel
5. Goals and benchmarks (5 min)
- Are we on track to hit quarterly traffic/revenue goals?
- How does current performance compare to last quarter?
- What's one metric to improve next month?
Document decisions and assign action items. Without follow-through, dashboards are just pretty graphs.
Example Monthly Decision Flow
Scenario: February 2026 dashboard review
Findings:
- Paid Social ROI: -88% (losing $1,500/month)
- Organic Search ROI: 215% (strong performer)
- Email ROI: 380% (strongest performer, but only 16% traffic share)
- Total spend: $8,500; revenue: $15,200; profit: $6,700
Decisions:
1. Cut Paid Social spend by 80% ($1,700 → $340/month). Test minimal spend on best-performing audiences only. If still negative, pause entirely.
2. Reallocate $1,000/month ($1,360 saved from Paid Social, minus $340 retained for testing) to Email list growth:
- $500/month for lead magnet ads (Facebook targeting cold audiences)
- $500/month for content production (more gated guides)
Expected outcome: Email traffic grows 20% (20K → 24K sessions). At 380% ROI, $1,000 additional spend should generate $3,800 additional revenue.
3. Invest $500/month in Organic Search (content production, link building). Already strong ROI (215%); scaling should compound.
Net budget: Reduced spend from $8,500 → $7,840 (savings from Paid Social cut exceed new investments).
Projected results (March 2026):
- Total sessions: 129,000 (+3% from Email and Organic growth)
- Total cost: $7,840 (-8%)
- Total revenue: $17,500 (+15% from Email scaling)
- Gross profit: $9,660 (+44%)
This is the power of economics dashboards—data-driven reallocation compounds profitability.
Benchmarks and Targets
Set quarterly benchmarks to evaluate whether your traffic economics are healthy.
| Metric | Good | Acceptable | Needs Improvement |
|---|---|---|---|
| Blended ROI | >150% | 50-150% | <50% |
| Negative-ROI channel % | <5% | 5-15% | >15% |
| HHI (concentration) | <1,500 | 1,500-2,500 | >2,500 |
| Top channel % of traffic | <40% | 40-60% | >60% |
| Cost growth rate | <Revenue growth rate | Equal | >Revenue growth rate |
| Profitable channel count | 5+ | 3-5 | <3 |
If multiple metrics fall into "Needs Improvement," prioritize fixing concentration risk (over-dependence on one channel) and profitability (negative-ROI channels).
FAQ
How much time does monthly dashboard maintenance take? With automation: 15-30 minutes monthly (data import + review). Without automation: 1-2 hours monthly (manual data entry + analysis). Automate if you're spending >1 hour monthly.
What if I can't track revenue per channel accurately? Use modeled attribution (GA4's Data-Driven attribution) or approximations (allocate revenue proportionally to sessions if direct attribution isn't possible). Imperfect data beats no data—make decisions with best available information.
Should I track organic/owned channels (SEO, Email) that have minimal direct spend? Yes. Include estimated costs (content production, tools, labor). Even "free" channels have costs—ignoring them inflates perceived ROI and leads to underinvestment in genuinely profitable paid channels.
How do I account for visitor lifetime value in the dashboard? Add an "LTV-adjusted ROI" column multiplying revenue by your LTV multiplier (e.g., if average visitor returns 2.5× over their lifetime, multiply single-session revenue by 2.5). This adjusts ROI calculations for long-term value.
What if my ROI is negative for all channels? You have a monetization problem, not a traffic problem. Fix monetization first (improve conversion rates, pricing, or revenue per session) before scaling traffic. Scaling unprofitable traffic accelerates losses.