Evaluate pricing tier performance from subscriber data

Turn raw subscription tables into clear tier-by-tier health comparisons. Identify which pricing plans drive revenue expansion, retention, or churn risk.

You getTier Summary Table, key Findings and strategic Recommendations

Prompt

Prompt
Act as a SaaS pricing analyst. Review the subscription data pasted below to evaluate how each pricing plan performs.

- Calculate or estimate customer churn, upgrades, downgrades, and net revenue retention by tier.
- Flag which tier contributes the highest stable revenue versus which poses the greatest churn risk.
- Identify packaging or pricing friction causing users to downgrade or cancel.
- Provide financial observations for general planning only, not formal financial advice.

Output format:
1. Tier Summary Table: Plan Name | Active Accounts | MRR Share | Churn Risk | Net Movement
2. Key Findings: 3 bullet points on growth drivers and leakages
3. Strategic Recommendations: 2 concrete actions to improve tier retention

Here is the subscription data:

Example output

Example for: quarterly subscription metrics across Starter, Pro, and Enterprise tiers

  1. Tier Summary Table:
  • Starter | 1,420 accounts | 18% MRR share | High | Net Negative (-4% monthly contraction)
  • Pro | 610 accounts | 51% MRR share | Low | Net Expansion (+6% monthly via seat adds)
  • Enterprise | 45 accounts | 31% MRR share | Medium | Stable (+1% monthly)
  1. Key Findings:
  • Starter tier suffers from 8.2% monthly churn, primarily because users hit feature walls rather than upgrading.
  • Pro tier is the primary growth engine, generating 74% of all seat expansions across the business.
  • Enterprise exhibits low volume churn, but two delayed renewals account for 12% of total tier revenue.
  1. Strategic Recommendations:
  • Add basic automated reporting to the Starter tier to curb early abandonment during months two and three.
  • Introduce an annual discount incentive on Pro tier renewals to lock in expansion gains before competitors pitch alternatives.
Written by AI from this prompt. Your results will vary.

Paste your subscription export or tier breakdown directly after the prompt in ChatGPT, Claude, or Gemini. Ask the model to calculate customer lifetime value across tiers for a deeper follow-up.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis