What This Template Is For
A freemium product with 100,000 free users and a 1% conversion rate generates the same revenue as one with 10,000 free users and a 10% conversion rate. Yet the second product is healthier: it delivers enough value on the free tier to attract users and enough premium value to convert them.
Most teams treat free-to-paid conversion as a pricing problem or a marketing problem. It is neither. It is a product problem. The conversion rate is determined by three things: how well the free tier demonstrates value, how clearly the paid tier delivers incremental value, and how seamlessly the upgrade experience works. Fix all three, and conversion improves. Fix only one, and it rarely moves.
This template helps you analyze your current free-to-paid funnel, identify the highest-leverage conversion blockers, design upgrade experiments, and track results. It pairs directly with the Product-Led Growth Handbook for freemium strategy and the pricing tier template for structuring plans that convert.
The activation rate glossary entry covers the upstream metric that most affects conversion: users who never activate on free rarely convert to paid. Use the cohort retention template to ensure you are not losing free users before they have a chance to convert.
When to Use This Template
- When free-to-paid conversion is below 3%. Most B2B freemium products should convert 3-7% of activated free users within 90 days. Below 3% signals a structural problem.
- When you have a large free base but slow revenue growth. The free tier is working for acquisition but failing at monetization.
- After launching a freemium tier. Measure the conversion funnel from day one so you can iterate quickly.
- When redesigning pricing. Changing what is free versus paid directly affects conversion. Model the impact before shipping.
- During growth team planning. Conversion rate improvements compound. A 1 pp improvement on a base of 50,000 free users is 500 new paid customers.
How to Use This Template
Step 1: Map the Conversion Funnel
Document every step from "free user exists" to "paid subscription active." Include discovery of paid features, upgrade prompt encounters, pricing page visits, checkout starts, and payment completions. Most teams assume the funnel is simple. It rarely is.
Step 2: Measure Each Stage
Pull conversion rates for each funnel stage. The biggest gap between two adjacent stages is your primary blocker. Do not guess where users drop off. Measure it.
Step 3: Identify Conversion Triggers
Analyze which actions or events precede conversion. What do converting users do in the 7 days before upgrading? This reveals the "trigger moment" that tips users toward paid. Build product experiences that accelerate users toward that moment.
Step 4: Audit Upgrade Prompts
Catalog every in-product moment where a free user encounters a paid feature or limit. Each is a conversion opportunity. Are these moments well-designed, or do they dead-end with a generic "Upgrade to Pro" message?
Step 5: Design Experiments
Based on the data, design 3-5 experiments targeting the biggest conversion blockers. Prioritize with the RICE framework and run them sequentially.
The Template
Free-to-Paid Funnel Definition
| Stage | Definition | Event | Current Rate | Target |
|---|---|---|---|---|
| Free user base | Total free accounts, active in last 30 days | active_free_user | [N] | N/A |
| Activated free user | Completed activation milestone on free plan | free_activated | [%] of free users | [%] |
| Encountered paid feature | Hit a limit, saw a premium feature, or viewed upgrade prompt | upgrade_prompt_seen | [%] of activated | [%] |
| Visited pricing page | Viewed pricing or upgrade comparison page | pricing_page_viewed | [%] of encountered | [%] |
| Started checkout | Entered payment information or started trial | checkout_started | [%] of pricing visitors | [%] |
| Completed payment | Subscription active, first payment processed | payment_completed | [%] of checkout starts | [%] |
| End-to-end conversion | Free user base to paid | - | [%] | [%] |
Conversion Trigger Analysis
| Trigger Event | Frequency | Conversion Rate Within 7 Days | Lift vs. Baseline | Priority |
|---|---|---|---|---|
| Hit storage / usage limit | [N]/month | [%] | [+X pp] | [High / Med / Low] |
| Tried to use premium feature (blocked) | [N]/month | [%] | [+X pp] | [High / Med / Low] |
| Invited team members (hit seat limit) | [N]/month | [%] | [+X pp] | [High / Med / Low] |
| Viewed competitor comparison page | [N]/month | [%] | [+X pp] | [High / Med / Low] |
| Reached N days of active use | [N]/month | [%] | [+X pp] | [High / Med / Low] |
| Received in-app upgrade prompt | [N]/month | [%] | [+X pp] | [High / Med / Low] |
Highest-converting trigger: [Trigger] at [%] conversion within 7 days
Most frequent trigger: [Trigger] at [N] occurrences per month
Upgrade Prompt Audit
| Location | Trigger | Current Message | Conversion Rate | Quality Score (1-5) | Improvement Idea |
|---|---|---|---|---|---|
| [Feature X locked screen] | Free user clicks premium feature | [Current copy] | [%] | [1-5] | [Idea] |
| [Usage limit banner] | Free user hits plan limit | [Current copy] | [%] | [1-5] | [Idea] |
| [Settings page] | Free user views plan details | [Current copy] | [%] | [1-5] | [Idea] |
| [In-app notification] | Time-based (Day 7, Day 14) | [Current copy] | [%] | [1-5] | [Idea] |
| [Email drip] | Post-activation sequence | [Current copy] | [%] | [1-5] | [Idea] |
Quality scoring:
- 5: Shows specific value the user would gain, personalized to their usage
- 4: Shows specific feature with clear benefit
- 3: Generic upgrade message with feature list
- 2: "Upgrade to Pro" with no context
- 1: Hidden or missing upgrade prompt
Pricing Friction Analysis
| Friction Point | Description | Impact | Fix Complexity | Priority |
|---|---|---|---|---|
| [Unclear value difference] | Free and paid plans look too similar | [High / Med / Low] | [Low / Med / High] | [1-5] |
| [Price shock] | Jump from $0 to $[X]/mo feels steep | [High / Med / Low] | [Low / Med / High] | [1-5] |
| [Payment method friction] | Checkout requires credit card before trial | [High / Med / Low] | [Low / Med / High] | [1-5] |
| [No trial option] | Users must commit to paid without trying premium features | [High / Med / Low] | [Low / Med / High] | [1-5] |
| [Annual-only pricing] | No monthly option increases commitment barrier | [High / Med / Low] | [Low / Med / High] | [1-5] |
| [Unclear billing] | Users unsure what they will be charged and when | [High / Med / Low] | [Low / Med / High] | [1-5] |
Experiment Backlog
| Experiment | Target Stage | Hypothesis | Expected Impact | Effort | RICE Score | Status |
|---|---|---|---|---|---|---|
| [Experiment 1] | [Stage] | [If we X, then Y because Z] | [+X pp conversion] | [T-shirt] | [Score] | [Planned] |
| [Experiment 2] | [Stage] | [If we X, then Y because Z] | [+X pp conversion] | [T-shirt] | [Score] | [Planned] |
| [Experiment 3] | [Stage] | [If we X, then Y because Z] | [+X pp conversion] | [T-shirt] | [Score] | [Planned] |
| [Experiment 4] | [Stage] | [If we X, then Y because Z] | [+X pp conversion] | [T-shirt] | [Score] | [Planned] |
Conversion Tracking by Cohort
| Signup Cohort | Free Users | Converted (30d) | Rate (30d) | Converted (60d) | Rate (60d) | Converted (90d) | Rate (90d) |
|---|---|---|---|---|---|---|---|
| [Month 1] | [N] | [N] | [%] | [N] | [%] | [N] | [%] |
| [Month 2] | [N] | [N] | [%] | [N] | [%] | [N] | [%] |
| [Month 3] | [N] | [N] | [%] | [N] | [%] | [N] | [%] |
| [Month 4] | [N] | [N] | [%] | [N] | [%] | ||
| [Month 5] | [N] | [N] | [%] | ||||
| [Month 6] | [N] | [N] | [%] |
Optimization Checklist
- ☐ Mapped the full free-to-paid funnel with specific events
- ☐ Measured conversion rate at each funnel stage
- ☐ Identified the primary conversion blocker (biggest stage-to-stage drop-off)
- ☐ Analyzed conversion triggers (what do converting users do before upgrading?)
- ☐ Audited all upgrade prompts for quality and conversion rate
- ☐ Identified pricing friction points
- ☐ Designed 3-5 experiments prioritized by RICE
- ☐ Set up cohort tracking for conversion at 30, 60, and 90 days
- ☐ Established A/B testing infrastructure for upgrade prompt experiments
- ☐ Scheduled monthly conversion review meeting
Filled Example: B2B Note-Taking SaaS
Funnel Metrics (January 2026)
| Stage | Users | Conversion to Next | Cumulative |
|---|---|---|---|
| Active free users (30d) | 84,200 | - | 100% |
| Activated (created 10+ notes) | 52,100 | 61.9% | 61.9% |
| Encountered paid feature | 31,800 | 61.0% | 37.8% |
| Visited pricing page | 8,400 | 26.4% | 10.0% |
| Started checkout | 3,200 | 38.1% | 3.8% |
| Completed payment | 2,640 | 82.5% | 3.1% |
End-to-end conversion (active free to paid): 3.1%
Primary blocker: Encountered paid feature to Visited pricing page (26.4%). Users hit premium features but do not investigate pricing. The upgrade prompt is a dead-end modal with "Upgrade to Pro" text and no explanation of what Pro includes.
Top Conversion Triggers
| Trigger | 7-Day Conversion Rate | vs. Baseline (3.1%) |
|---|---|---|
| Hit 5 GB storage limit | 14.2% | +11.1 pp |
| Tried to share with 4th collaborator (limit: 3) | 11.8% | +8.7 pp |
| Searched for a note and saw "Advanced Search is Pro" | 8.3% | +5.2 pp |
| Used product for 14+ consecutive days | 6.1% | +3.0 pp |
Experiment Results (Q1 2026)
| Experiment | Impact | Status |
|---|---|---|
| Replaced generic "Upgrade" modal with feature-specific value prop and pricing | +2.4 pp (pricing page visits from 26.4% to 28.8%) | Shipped |
| Added 7-day Pro trial triggered at storage limit (no credit card) | +3.8 pp (end-to-end conversion from 3.1% to 6.9% for this segment) | Shipped |
| Added "shared with you" preview for 4th collaborator (see content, cannot edit) | +1.1 pp (collaborator limit conversion from 11.8% to 12.9%) | Shipped |
Net impact: End-to-end conversion rose from 3.1% to 4.6% (+1.5 pp). At 84,200 active free users, this adds ~1,260 new paid customers per month.
Key Takeaways
- Free-to-paid conversion is a product problem, not a pricing or marketing problem. The funnel has specific, measurable stages
- Analyze conversion triggers. What do users do in the 7 days before upgrading? Build product experiences that accelerate users toward those moments
- Upgrade prompts are conversion surfaces. Treat them with the same design care as your onboarding flow
- Measure conversion by cohort, not in aggregate. Aggregate rates blend mature cohorts (who already converted or never will) with fresh cohorts
- A 1 pp conversion improvement on a large free base is worth more than most new features on the roadmap
About This Template
Created by: Tim Adair
Last Updated: 3/5/2026
Version: 1.0.0
License: Free for personal and commercial use