Attribution ROI Analysis (90-Day Period)

Funnel Overview

10,500 Visitors (6,000 organic + 2,500 Twitter + 1,200 newsletter + 800 Product Hunt)
    ↓ 2.67% conversion
280 Signups
    ↓ 16.1% paid conversion
45 Paying Customers
    ↓ $100 average
$4,500 Revenue

Channel Attribution (Proportional Model)

Since Stripe lacks source data, using traffic proportions as conversion proxy:

Time Investment ROI

Critical Insights

Newsletter is Massively Underutilized

• 5.58% conversion rate (3x other channels)
• $45.83 revenue per hour invested
• Currently only 16% of your time (2 hrs/week)
• Generating 24% of revenue with 11% of traffic

The math:

• Each newsletter subscriber worth: $100 LTV × 5.58% = $5.58
• If you can add 10 subscribers per hour of work: $55.80/hour value created
• Compare to Twitter: $12.50/hour
• You’re leaving 3.7x returns on the table

SEO is Your Compounding Asset

• $18.75/hour ROI but compounds over time
• 57% of traffic, 40% of revenue
• Today’s content drives traffic for months/years
• 8 hrs/week is substantial but justified by volume

Key point: Don’t kill this to chase short-term wins. SEO takes time to build and pays dividends later.

Twitter is Your Lowest-Efficiency Channel

• $12.50/hour return
• 24% of traffic but needs 40% of your time (5 hrs/week)
• 2,500 visitors → ~47 signups = 1.88% conversion

Question: What is Twitter actually doing for you?

• If brand awareness: Track differently (impressions, engagement)
• If conversion driver: It’s underperforming by 3.7x vs newsletter

Recommended Time Reallocation

Current (15 hrs/week total):

• SEO: 8 hrs (53%)
• Twitter: 5 hrs (33%)
• Newsletter: 2 hrs (13%)

Optimized (same 15 hrs/week):

• SEO: 7 hrs (47%) - Slight reduction but maintain momentum
• Newsletter: 5 hrs (33%) - 2.5x increase (from 2 to 5 hrs)
• Twitter: 2 hrs (13%) - 60% reduction (from 5 to 2 hrs)
• Attribution tracking: 1 hr (7%) - Fix data gaps

Expected Impact:

• Newsletter: +150 monthly visitors → +8 signups → +1-2 paid → +$150/mo
• Twitter reduction: -1,500 monthly visitors → -28 signups → -4-5 paid → -$450/mo
• Net short-term: -$300/month
• BUT: Newsletter compounds (list grows), Twitter doesn’t (ephemeral)
• Month 6: Newsletter at 2,500 readers = +$1,000/mo vs Twitter baseline

Action Plan

Week 1: Fix Attribution (Critical)

1. Add source tracking to Stripe (metadata field)
2. Implement post-signup survey
3. UTM everything (newsletter, Twitter, all shared links)
4. Set up tracking sheet for time logging

Weeks 2-4: Grow Newsletter Aggressively

Invest 5 hrs/week into:

1. Lead magnet creation (Week 2, 3 hrs)
2. Opt-in optimization (Week 2, 2 hrs)
3. Content upgrades (Weeks 3-4, 3 hrs/week)
4. Distribution (Weeks 3-4, 2 hrs/week)

Target: Grow from 1,200 to 2,000 monthly newsletter visitors (67% growth)
Expected: +800 visitors × 5.58% = +45 signups → +7 paid → +$700/month

Twitter Reduction Strategy

Cut from 5 hrs/week to 2 hrs/week by:

• Stop: Real-time engagement scrolling, reactionary threads
• Keep: One high-quality thread per week, respond to mentions, share newsletter content
• Measure: Track weekly Twitter traffic; if drops >60%, reconsider

Month 2: Validate and Adjust

1. Rerun this analysis with 30 days of new data
2. Compare actuals to expectations
3. Make data-driven adjustments

Expected Outcomes

After 30 days:

• Attribution completeness: 35% → 85%
• Newsletter visitors: 1,200 → 1,600
• Twitter reduction validated or reversed

After 90 days:

• Newsletter visitors: 1,200 → 2,000+
• Revenue: $4,500 → $5,500/quarter (+22%)
• Time ROI: $15.67/hr → $19.50/hr average

Bottom Line

You’re spending 33% of your time on a channel delivering 12.5% returns.

The math is clear:

• Newsletter: $45.83/hour
• Twitter: $12.50/hour
• You’re leaving $33.33/hour on the table

Action: Shift 3 hours from Twitter to newsletter this week. Measure results. Adjust based on data, not hunches.