Rev Marketing Intelligence Cohort New Subs & CAC
Apr 26 complete  ·  May 3 in progress

1. All Paid Media - LTV/CAC

▶ Chart notes
Bars = new subs cohorted to originating week: Prepaid signups + Trial upgrades (trial start date) + Free upgrades (free start date) · Faded bars = projected using daily upgrade rate (7-day trailing) · Blended CAC = (Google SaaS + YouTube + Meta SaaS spend) ÷ all new subs · Paid CAC = (Google SaaS excl. YouTube + Meta SaaS spend) ÷ paid-attributed subs · Paid Media LTV = estimated lifetime value of paid media acquired customer by month

2. All Paid Media - Trial Inspector

▶ Projection math — Apr 26
Cutoff: May 7 (latest data) − 8 days = Apr 29 — days ≤ Apr 29 use actual conversions; days > Apr 29 use a fixed reference rate.
Fixed conv. rate window: Apr 23–Apr 29  →  45 conv / 197 starts = 22.8% (same rate applied to every projected day).

Week of Apr 26  |  actual starts: 193  |  projected upgrades: 42.7  |  upgrade rate: 22.8%
4 days settled (≤ Apr 29), 3 projected using 22.8% rate.
DayStartsUpgrades methodConv. rateUpgrades
Sun Apr 2622actual conv.9.0
Mon Apr 2752actual conv.8.0
Tue Apr 2828actual conv.5.0
Wed Apr 2931actual conv.7.0
Thu Apr 3022rate × starts22.8%5.0
Fri May 122rate × starts22.8%5.0
Sat May 216rate × starts22.8%3.6

Fixed rate window (Apr 23–Apr 29) is the last 7-day period where all conversions are fully matured. Using a sliding window for post-cutoff days artificially depresses the rate as it draws in recent starts with no conversions yet.

3. Brand PPC

Chart notes

Bars = Brand PPC SaaS subs cohorted to originating week: Prepaid signups + Trial upgrades (trial start date) + Free upgrades (free start date) · Current week bar shows WTD actuals · Brand PPC CAC = Brand PPC SaaS spend ÷ Brand PPC total new subs · Cost per Prepaid = Brand PPC SaaS spend ÷ Brand PPC prepaid subs

4. NB PPC

Chart notes

Bars = Non-Brand PPC SaaS subs cohorted to originating week: Prepaid signups + Trial upgrades (trial start date) + Free upgrades (free start date) · Current week bar shows WTD actuals · Non-Brand CAC = Non-Brand PPC SaaS spend ÷ Non-Brand PPC total new subs

5. NB PPC - Trial Inspector

Chart notes

Bars = NB PPC SaaS trial starts (indigo) and trial upgrades cohorted to trial start week (purple) · Upgrade Rate = NB PPC trial upgrades ÷ NB PPC trial starts · CPT = NB PPC SaaS spend ÷ NB PPC trial starts · Faded bars = projected using settled NB PPC CVR from reference window

6. Meta

Chart notes

Bars = Meta SaaS subs cohorted to originating week: Prepaid signups + Trial upgrades (trial start date) + Free upgrades (free start date) · Current week bar shows WTD actuals · Meta CAC = Meta SaaS spend ÷ Meta total new subs