Build a product-led growth finance lens: PQLs, freemium economics, and monetization tests.
- User
Build a product-led growth finance lens: PQLs, freemium economics, and monetization tests.
- Assistant
Product-Led Growth (PLG) Finance Lens
As Sherlock, I've dissected countless growth strategies, and PLG stands out for its flywheel potential: the product itself acquires, converts, and monetizes users. But without a finance lens, it's just vibes—high growth with leaky economics. This lens is a plug-and-play framework to quantify, forecast, and optimize PLG via PQLs (Product Qualified Leads), freemium economics, and monetization tests.
Think of it as your financial detective toolkit: input metrics → unit economics engine → output forecasts → test flywheel. Built for founders, CFOs, and growth leads. I'll include templates, formulas, and a Notion/Google Sheets-ready dashboard.
1. PQLs: From Product Signals to Financial Value
PQLs are users whose in-product behavior predicts paid conversion (e.g., "created 10 dashboards" in a BI tool). Unlike MQLs/SQLs (marketing/sales-qualified), PQLs are cheaper and self-qualify.
PQL Framework
Stage Definition Key Behaviors Financial Scoring PQL Candidate Free user hits activation threshold 3+ logins, feature X used Score = (Sessions * 0.1) + (Features * 0.2) PQL High-intent signal Power user: 10+ actions, retention >7 days LTV Proxy = ARPU * Conversion Rate * (1 / Churn) Hot PQL Nudge-ready (e.g., upgrade prompt) Trial limit hit + high engagement Priority Score = Engagement Score * (1 - Days to Upgrade) Formulas:
- PQL Conversion Rate = Paid Customers from PQLs / Total PQLs
- PQL CAC = (Marketing Spend + Product Costs) / PQLs Generated (often 50-80% lower than SQL CAC)
- PQL LTV = ARPU × Gross Margin × (1 / Monthly Churn) × Lifetime Multiplier (e.g., 3x for expansions)
Actionable Template (Google Sheets):
Column A: User ID | B: Days Since Signup | C: Sessions | D: Features Used | E: PQL Score (formula: =IF(C10>10,0.8,0)+...) | F: PQL Status | G: Projected LTVPro Tip: Segment PQLs by cohort (e.g., viral vs. paid acquisition). Target: 10-20% PQL-to-paid conversion. If <5%, refine signals.
2. Freemium Economics: The Unit Economics Engine
Freemium = Free tier as top-of-funnel → Paid upsell. Success = LTV >> CAC with viral coefficients >1.0.
Core Model (Cohort-Based)
Free Users Acquired (Month 0) ↓ (Activation Rate: 40-60%) Active Free Users ↓ (Retention: 20-40% MoM) Engaged Free Users → PQLs (10-30%) ↓ (Free-to-Paid: 3-10%) Paid Users → RevenueKey Metrics Dashboard (Track weekly cohorts):
Metric Formula Benchmark Red Flag Free-to-Paid Rate Paid / Active Free Users 5-15% <3% Viral Coefficient (Invites Sent * Conversion) / Users >1.0 <0.7 CAC Payback CAC / (ARPU × Margin) <12 months >18 LTV:CAC Ratio LTV / CAC >3:1 <2:1 Expansion Revenue (Net Expansion Rate - 100%) * ARR 20-50% YoY <10% Freemium Burn Rate Free User Cost / Total Users <20% of Revenue >30% Full Economics Formula:
LTV = ∑[ARPU_t × Retention_t × Margin] for t=1 to ∞ Freemium Efficiency = (Paid ARR + Expansion) / (Free User Acquisition Cost × Free Users)Forecast Template (Excel Model Link: Hypothetical Google Sheet):
- Row 1: Cohorts (Jan, Feb...)
- Inputs: Acquisition (10k/mo), Free-to-Paid (5%), ARPU ($20/mo), Churn (5%/mo)
- Outputs: Cumulative ARR, Break-even Month 8.
Sherlock Insight: Freemium "costs" scale with users—cap free tier compute (e.g., Notion's block limits). Aim for 70% margins post-scale.
3. Monetization Tests: Experiment Flywheel
Test iteratively: Price tiers, paywalls, feature gates. Financial goal: +1% conversion = 20-50% ARR lift.
Test Design Matrix
Test Type Hypothesis Variant A (Control) Variant B (Test) Success Metric Min Sample Projected Impact Pricing Tier 15/mo $15 Pro $10 Pro + limits Conv. Rate ↑5% 1k PQLs/group +$50k MRR Paywall Timing Gate at Day 7 vs. Day 14 Day 14 prompt Day 7 + value prop Free-to-Paid ↑3% 5k users LTV +12% Feature Unlock Tease AI vs. Unlimited Storage Storage gate AI trial gate ARPU ↑10% 2k PQLs Expansion +15% Discount Cadence Annual 20% off at EOY No discount Personalized 20% Churn ↓2% 500 payers Retention +8% Statistical Rigor:
- Power Calculation: Use
pwr.t.testin R/Python for 80% power, α=0.05. - Success KPI: Primary (e.g., Conv. Rate), Secondary (LTV), Guardrail (Engagement Drop <5%).
- Formula for Impact: ΔRevenue = (Test Conv - Control) × PQL Volume × ARPU × Margin.
Rollout Cadence:
- Week 1: Launch A/B (tools: Amplitude, PostHog).
- Week 2-4: Monitor cohorts.
- Week 5: If p<0.05 and LTV↑, 100% rollout.
- Log: Test ID, Cost ($), ROI (e.g., 5x from pricing tweak).
Pro Tip: Sequential testing (e.g., Multi-Armed Bandit) accelerates. Always test on PQLs first—10x signal vs. all users.
Integrated PLG Finance Dashboard (Build in Google Sheets/Looker)
Sheet 1: PQL Tracker Sheet 2: Freemium Cohorts (waterfall viz) Sheet 3: Test Results (ROI table) Sheet 4: Forecast (Monte Carlo sim: ±20% inputs → ARR range) KPIs at Top: LTV:CAC | Rule of 40 Score | Burn MultipleQuick Wins to Implement Today
- Audit PQLs: Query your analytics for top 3 behaviors correlating to paid (SQL:
SELECT user_id, COUNT(*) FROM events WHERE event='dashboard_create' GROUP BY user_id HAVING COUNT>10). - Model Freemium: Plug your numbers into the cohort sheet—aim for LTV:CAC >3x.
- Launch Test: A/B price anchor (19) on 1k PQLs next week.
This lens turns PLG from art to science: predictable revenue at 10x efficiency. Questions? Drop your metrics—I'll Sherlock the gaps. 🔍
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.