Breakdown Reports


Breakdown Reports let you segment your metrics by different dimensions to uncover trends and patterns that aren't visible in aggregate data. Instead of seeing just your overall churn rate, you can see churn rate by plan, by market, or by any other dimension - revealing which segments are performing well and which need attention.


Overview

Breakdown report showing MRR by plan

The Breakdown Reports section provides segmented views of your key metrics:

  1. Segmented charts - Each dimension value gets its own line or bar in the chart
  2. Comparison table - Side-by-side comparison of all segments
  3. Trend analysis - See how segments perform over time relative to each other

Available metrics

You can create breakdowns for most of GrowPanel's core metrics:

MetricWhat the breakdown shows
MRRRevenue distribution and growth by segment
ARRAnnualized revenue by segment
SubscribersCustomer count by segment
Logo ChurnCustomer churn rate by segment
MRR ChurnRevenue churn rate by segment
Net MRR ChurnNet churn (including expansion) by segment
ARPAAverage revenue per account by segment
ASPAverage selling price by segment
LTVCustomer lifetime value by segment
NRRNet revenue retention by segment
GRRGross revenue retention by segment

Breakdown dimensions

Select a dimension to segment your data:

DimensionDescriptionExample insights
PlanSubscription plan or product tierWhich plans have the highest churn?
Plan GroupGroups of related plansHow do product lines compare?
CurrencyBilling currencyHow does revenue distribute across currencies?
Billing IntervalMonthly, quarterly, annualDo annual customers churn less?
MarketCountry or regionWhich markets are growing fastest?
Payment MethodCard, ACH, PayPal, etc.Does payment method affect retention?
Data SourceStripe, Chargebee, etc.Compare metrics across billing platforms
Customer AgeTime since first revenueHow does behavior change over customer lifetime?
Pricing ModelLicensed or meteredHow do pricing models affect LTV?
Custom VariablesYour metadata fieldsSegment by any custom attribute

Using breakdown reports

Step 1: Select a metric

Navigate to the Breakdowns section and choose the metric you want to analyze:

Step 2: Choose a dimension

Select how you want to segment the data:

Step 3: Analyze the results

The report shows:

  • Chart - Each segment as a separate line (for trends) or bar (for comparisons)
  • Table - Detailed values for each segment across the selected time period
  • Summary - Key statistics like highest/lowest performing segments

Charts

Line chart (trends)

The line chart shows how each segment performs over time. Use this to:

  • Spot segments trending upward or downward
  • Identify seasonal patterns in specific segments
  • See when segments diverged in performance

Each segment is shown as a separate line with its own color. Hover over the chart to see exact values for each segment at any point in time.

Stacked area chart

For metrics like MRR, you can switch to a stacked view to see:

  • How segments contribute to the total
  • Relative proportion of each segment
  • Changes in segment mix over time

Table

The table below the chart shows:

ColumnDescription
SegmentThe dimension value (e.g., plan name, country)
Current ValueThe metric value for the most recent period
ChangeAbsolute change from the previous period
% ChangePercentage change from the previous period
% of TotalThis segment's share of the total
SparklineMini trend chart for quick visual reference

Click column headers to sort by different columns. Click a segment row to drill down into that specific segment.


Filters

Breakdown reports support the same filters as standard reports:

  • Date range - Analyze a specific time period
  • Interval - Daily, weekly, monthly, quarterly, or yearly
  • Currency - Normalize to a reporting currency
  • Additional filters - Plan, market, payment method, etc.

Filters apply to the entire breakdown. For example, filtering by "United States" while breaking down by "Plan" shows how different plans perform specifically in the US market.


Common use cases

Churn rate by plan

Question: Which plans have the highest customer churn?

  1. Select Logo Churn as the metric
  2. Break down by Plan
  3. Look for plans with consistently higher churn lines

High churn on specific plans may indicate:

  • Poor product-market fit for that tier
  • Pricing issues
  • Missing features that customers expect

MRR growth by market

Question: Which geographic markets are growing fastest?

  1. Select MRR as the metric
  2. Break down by Market
  3. Compare the slope of each line

Fast-growing markets may deserve:

  • Additional sales resources
  • Localization investment
  • Dedicated support coverage

Retention by billing interval

Question: Do annual customers retain better than monthly?

  1. Select NRR (Net Revenue Retention) as the metric
  2. Break down by Billing Interval
  3. Compare annual vs. monthly retention curves

If annual customers retain significantly better:

  • Consider incentives for annual upgrades
  • Analyze what makes annual customers more committed
  • Adjust pricing to encourage annual billing

ASP by payment method

Question: Do payment methods correlate with deal size?

  1. Select ASP (Average Selling Price) as the metric
  2. Break down by Payment Method
  3. Compare average values across methods

Card vs. ACH vs. invoice may show:

  • Enterprise customers prefer invoicing
  • Higher-value deals use bank transfers
  • Self-serve customers use cards

LTV by custom variable

Question: How does industry affect customer lifetime value?

  1. Select LTV as the metric
  2. Break down by your Industry custom variable
  3. Compare lifetime values across industries

If certain industries have higher LTV:

  • Focus acquisition efforts there
  • Develop industry-specific features
  • Create targeted case studies

Export

Click the Export icon to download the breakdown data as a CSV file. The export includes:

  • All segments
  • Values for each period in the date range
  • Summary statistics

Tips

  • Start broad, then filter - Begin with an overall breakdown, then apply filters to investigate specific segments
  • Compare like with like - When comparing segments, ensure you have enough data in each segment for meaningful comparison
  • Watch for small sample sizes - A segment with few customers may show volatile metrics that aren't statistically significant
  • Combine dimensions - Use filters and breakdowns together (e.g., break down by plan, filter by US market)
  • Track over time - Check breakdowns regularly to spot emerging trends before they become problems

  • Filters - Learn about all available filter options
  • World Map - Geographic visualization of metrics
  • Cohorts - Analyze customer behavior by signup date
  • MRR - Core MRR report with movement breakdown