I understand the challenge you're facing. Since the subscription_price is only available in the upgraded_paid event, we need to adjust our approach. Mixpanel offers a feature called Borrowed Properties that can help us solve this issue. Here's an alternative approach:
1. Use Borrowed Properties:
Mixpanel's Borrowed Properties feature allows you to "borrow" a property from one event and use it in the analysis of another event. In this case, we can borrow the subscription_price from the upgraded_paid event and apply it to the trial_started event.
As described in the Borrowed Properties blog post, "Borrowed Properties unlocks more analysis with the data you already have, without any lift from your engineering team."
2. Set up the Borrowed Property:
In the Mixpanel UI, you can set up the borrowed property. The trial_started event will "borrow" the subscription_price property from the upgraded_paid event.
3. Create a funnel:
Create a funnel with two steps:
- Step 1: "trial_started"
- Step 2: "upgraded_paid"
Set the conversion window to 30 days to match your trial period.
4. Apply cohort filter:
Create and apply a cohort filter for users who started their trial 30 days ago, as suggested in the previous answer.
5. Break down by borrowed property:
Now, you can break down the funnel by the borrowed subscription_price property. This will show you the conversion rates for different price points, even though the property is only set in the second event.
6. Compare cohorts:
You can still create multiple cohorts for different time periods and compare them in your analysis.
This approach allows you to analyze the impact of different price points on conversion rates, even when the price is only set at the time of upgrade. The Borrowed Properties feature essentially backfills the subscription_price to the trial_started event, allowing for more comprehensive analysis.
Remember, as mentioned in the Mixpanel documentation, "Borrowed Properties aren't a shortcut for implementations (you should still create thoughtful tracking plans). They are meant to open up a new world of analysis by merging data that was previously difficult or impossible to plan ahead of time for your engineers."
By using this method, you should be able to effectively analyze your trial-to-paid conversion rates for different price points and cohorts, helping you determine the optimal pricing strategy for your subscription.
