Identifying Upselling Opportunities with Subscription Plan Data
what would be the best way to identify upsellings when I have a super property attached to the login event with the id of the subscription plan?
what would be the best way to identify upsellings when I have a super property attached to the login event with the id of the subscription plan?
Hi Juan I., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To identify upsellings with a subscription plan ID super property, you can use the following approach: First, ensure your super property is properly set up. Super properties are global event properties that are automatically included with all events tracked for a user. They're ideal for tracking persistent information like subscription plans.LBKS// Example of registering a subscription plan ID as a super property mixpanel.register({ "subscription_plan_id": "basic_plan" });LBKSWhen a user upgrades their subscription, you should: 1. Track a specific event for the upgrade (e.g., "Subscription Changed" or "Plan Upgraded")
2. Include both the old and new subscription plan IDs as properties
3. Update the super property to reflect the new subscription planLBKS// When user upgrades from basic to premium mixpanel.track("Subscription Changed", { "old_subscription_plan_id": "basic_plan", "new_subscription_plan_id": "premium_plan" });LBKS// Update the super property mixpanel.register({ "subscription_plan_id": "premium_plan" });LBKSThis approach allows you to:
- Analyze upgrade patterns in Mixpanel's Funnels or Flows
- Create cohorts of users who upgraded from specific plans
- Compare behavior before and after upgradesFor more detailed implementation, refer to Mixpanel's documentation on Setting Super Properties.Best practice: Also store the subscription plan ID as a user profile property to make it available for user-level analysis: LBKSmixpanel.people.set({ "subscription_plan_id": "premium_plan" });LBKSThis is recommended in Mixpanel's best practices for identifying users, which suggests tracking identifiers as both super properties and user properties to assist in troubleshooting.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Let me check the knowledge base for you again. One moment! 📚
I understand you want to compare current and previous subscription plan values using Mixpanel's UI rather than the API. Based on your super property setup for subscription plans, here's how you can identify upsells through the UI:
Using Profile History in Mixpanel
Mixpanel's Profile History feature is perfect for your use case as it captures changes in properties over time. This allows you to compare current subscription plans with previous ones.For subscription-based businesses, Mixpanel offers specific functionality to analyze recurring revenue changes: 1. Recurring revenue change type - This computed property tells you the type of change between values: - Upgrade: when a user moves from a lower to higher value plan - Downgrade: when a user moves from a higher to lower value plan - New: when a user starts a subscription - Churn: when a user cancels a subscription - Flat: when there's no change2. Time control - You can select which time period to compare against (1 month ago, 3 months ago, etc.)Building Revenue Metrics explains these features in detail.
Creating Reports to Identify Upsells
In the Mixpanel UI: 1. Go to the Insights report 2. Create a metric based on your login event 3. Use the Compare to past feature to see changes over time 4. Break down by your subscription plan ID property 5. Look for users who moved from lower-tier to higher-tier plansThe Insights documentation explains how to use time period comparisons: "Compare the current period of time to previous periods to track trends and growth in your product's use."For a more comprehensive view, you can use Mixpanel's SaaS KPIs template which includes pre-built metrics for analyzing subscription changes. There's a public dashboard available that shows the types of metrics you can build.Note that for the most robust historical property analysis, Mixpanel recommends using Historical Profile Values, which would require some setup but provides the most accurate way to track property changes over time.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Let me check the knowledge base for you again. One moment! 📚
I understand you don't have access to the Revenue Analytics features since they're part of Mixpanel's paid plans. Here are some alternatives you can use with the free plan to track subscription changes and identify upsells:
Alternatives for Tracking Subscription Changes
1. Custom Events Approach Create specific events to track subscription changes manually. When a user changes their subscription plan, track an event like "Subscription_Changed" with properties for both the old and new plan values.2. User Properties Store the current subscription plan as a user property. While you won't have automatic historical tracking, you can: - Set a property for "previous_plan" alongside "current_plan" - Update both properties when changes occur - Create cohorts based on these properties3. Event Properties Analysis Use the Insights report to analyze your login events with the subscription plan ID super property: - Group by user - Look at first and last values of the property - Create segments of users whose last value is higher than their first value4. Consider the Free Plan Limitations The Mixpanel free plan includes: - Up to 1 million events per month - All core reports (Insights, Flows, Funnels, Retention, and Explore) - Unlimited seats for team members - Up to 5 saved reports per userIf your needs grow beyond these capabilities, you might consider: - The Startup Program if you qualify (for companies less than 5 years old with under $8M in funding) Startup Program: Use Mixpanel for free for the first year - Upgrading to a paid plan that includes Revenue Analytics featuresRemember that while these workarounds can help track subscription changes, they won't provide the same level of automatic analysis as the dedicated Revenue Analytics features available in paid plans.Would you like more specific guidance on implementing any of these alternative approaches with your current setup?
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.