When a customer has more than one active subscription at the same time — a scenario known as concurrent subscriptions — it can create a challenge for accurate data analysis.
This complexity can make it difficult to build clean, reliable reports and gain a clear understanding of subscriber behavior. This guide explains how to use the Subscription Selector to cut through that ambiguity, ensuring your segments are always precise, consistent, and actionable.
Understanding Data Structure: Customer vs. Subscription
To provide greater clarity in your analysis, our system distinguishes between customer-level data (like total lifetime revenue) from subscription-specific data (like the revenue from a single plan). This distinction allows you to analyze both overall customer value and individual product performance.
This structured approach also allows for more granular insights, enabling you to identify subscribers in specific phases of their lifecycle, such as those in a free trial, a payment grace period, or those who have paused their subscription, enabling you to create highly targeted campaigns.
Focusing Your Analysis with the Subscription Selector
When customers have a history of multiple subscriptions, analyzing their behavior can be complex. The Subscription Selector gives clients full control over which subscription is used when analyzing or segmenting customers, eliminating ambiguity that arises from multiple active or historical subscriptions. Unlike rigid or automated approaches, this tool allows teams to define selection criteria, such as latest, longest, or highest-value subscriptions, ensuring that insights are accurate, consistent, and tailored to business needs.
You can choose to focus your entire segment on one of the following selectors:
| Selector Option | What it does | Relevant Column |
|---|---|---|
| Highest Revenue Subscription |
This option selects the subscription that has generated the most revenue over its entire lifetime. This is useful for identifying your most valuable products on a per-customer basis. |
It determines this by finding the highest value in the Subscription Lifetime Revenue column for that customer. |
| Last Updated Subscription | This option selects the subscription with the most recent activity, such as the last payment, a plan change, or a renewal. | It selects the latest event in the subscription history. This can be any type of event that can happen for a subscription: renewal, churn, start, cancellation, churn, upgrade or downgrade. |
| Latest Started Subscription | This option selects the subscription that the customer most recently signed up for. | It identifies this subscription by looking for the most recent date in the Subscription Start Date column for that customer. |
| Longest Subscription Lifetime |
This This option selects the subscription that has been active for the longest cumulative duration. This is great for identifying a customer's most-used or main product. |
It finds this subscription by looking for the highest value in the Subscription Lifetime Days column for that customer. |
By applying one of these selectors, you can ensure that your reports and segments are consistent and focused.
Unlocking Actionable Insights
This powerful segmentation structure empowers you to build more sophisticated and effective segments. For example, you can:
- Identify At-Risk Customers: Create segments of users whose subscriptions are paused or in a grace period to launch targeted retention campaigns.
- Reward Most Loyal Users: Isolate customers with the longest subscription lifetimes or highest lifetime value to offer them exclusive rewards.
- Understand Customer Lifecycles: Analyze the journey from a free trial to a long-term, high-revenue subscription to optimize your conversion funnels.
By leveraging these tools, you can move beyond simple analytics to gain a true understanding of your subscribers and unlock new opportunities for growth.