How would I set up a report which gives me the number of active subscribers? We have subscriptions running with revenuecat (and those events are coming through) and we have both annual and monthly subscribers - so I don't know if Revenuecat sends an event say on month 3 of an annual subscription
Hi Antonio, 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
There isn’t anything in the provided docs that mentions RevenueCat specifically or how/when it sends renewal events, so I can’t say for sure what events you’ll see in month 3 of an annual subscription. I’ll focus on how to define “active subscribers” in Mixpanel once you know which events represent an active subscription.
1. Decide what “active subscriber” means in your data
You need to pick one or more events that reliably indicate a user currently has an active subscription. For example:
- A “Subscription Renewed” / “Subscription Active” event from RevenueCat, or - A periodic “Subscription Status = active” event you send yourself.
Once you know that event (or set of events), you can treat it as your “active usage” signal and count unique users over a period, similar to how MAU/WAU are defined. [MAU guide]
2. Build an “active subscribers” metric in Insights
1. Create a new Insights report. [Insights quick start] 2. Click Select Metrics → choose Events and select the event(s) that represent an active subscription (e.g. your RevenueCat “subscription active/renewed” event). 3. For Measurement, change from “Total Events” to Unique Users. [Insights users] 4. Set the date range to the period you care about (e.g. “Last 30 days” or a custom month). [Date range] 5. (Optional) Use filters to restrict to subscription events only (e.g. plan type = monthly/annual) or to a specific platform. [Insights quick start] 6. (Optional) Use breakdowns by plan type (monthly vs annual) to see active subscribers per plan. [Insights quick start]
This gives you “number of users who triggered the subscription-active event in the chosen period,” which is your active subscriber count for that period.
3. Use DAU/WAU/MAU-style views if helpful
If you want to see active subscribers as DAU/WAU/MAU:
- In the metric’s advanced settings for Unique Users, choose DAU, WAU, or MAU. [Insights users] - This will count users who did the “subscription active” event within the last 1/7/30 days, respectively. [MAU guide]
4. If RevenueCat doesn’t emit periodic events
The docs don’t say how to handle “silent” periods where no event is sent but the subscription is still active, and there’s no built‑in “subscription state” feature described in the sources. If RevenueCat only sends events on purchase/renewal/cancel, you may need to:
- Confirm with your data team or RevenueCat docs what events you get and when. - Potentially derive an “active” flag in your warehouse and use Mixpanel’s Revenue Analytics / warehouse connector to bring in a time‑series of MRR/ARR or active status, then analyze that in Mixpanel. [Revenue analytics overview; Subscription use cases]
Because the provided docs don’t include the exact RevenueCat event schema, I can’t give a more precise event name or confirm month‑3 behavior; you’ll need to map your actual RevenueCat events to the “active” definition, then follow the steps above.
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.
so there wouldn't be a way within mixpanel to grab the number of users for whom either there had been a monthly renewal event this month OR an annual renewal event in the last 12 months
Let me check the knowledge base for you again. One moment! 📚
It looks like your last message (** ** i) might have been sent by mistake or got cut off.
I can help you set up Mixpanel to report on active subscribers, but I’ll need a clear question or a bit more detail (for example: “I want a monthly count of active paying users by plan” or “I’m not sure which RevenueCat events to use in Mixpanel”).
Please resend or clarify what you’d like to know about Mixpanel, and I’ll answer based on the docs provided.
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! 📚
You can get very close to that definition in Mixpanel using an Insights report with filters and/or cohorts, but it depends on how your renewal events are modeled. The docs don’t mention RevenueCat specifically, so I’ll describe the Mixpanel side and where the limitation is.
1. Basic idea in Insights
If you have two distinct events, e.g.:
- Monthly Subscription Renewed
- Annual Subscription Renewed
you can:
1. Create an Insights report. 2. Metric: select Events → choose both renewal events. 3. Measurement: set to Unique Users. [Insights quick start; Measurements] 4. Date range: set to Last 12 months. 5. Add inline filters on each event: - For the monthly renewal event: filter to time in this month (e.g. “on or after start of this month”). - For the annual renewal event: filter to time in last 12 months. 6. Because the metric is “Unique Users” across the selected events, a user who matches either event+time condition will be counted once. [Reports filters]
This gives you “number of unique users who did a monthly renewal this month OR an annual renewal in the last 12 months,” assuming you can distinguish those events or plans via properties.
2. Using cohorts (optional, more explicit)
You can also define cohorts and then combine them:
1. Cohort A: users who did the monthly renewal event in this month. 2. Cohort B: users who did the annual renewal event in the last 12 months. [Cohorts] 3. Create a third cohort C = A OR B using the cohort builder’s AND/OR logic. [Define cohorts] 4. In Insights, select Profiles → Users, measurement = Total to count user profiles in cohort C, or use cohort C as a filter and count unique users of any event. [Insights users; Reports filters]
3. Where the limitation is
The docs do not show a built‑in “subscription state” or a special operator that automatically interprets billing periods; everything is based on events, properties, and time filters. If:
- You don’t have separate monthly vs annual events or properties, or - RevenueCat doesn’t emit any renewal/active event within the period you care about,
then Mixpanel alone cannot infer “still active” beyond what your events/properties say. In that case, you’d typically model subscription state in your warehouse and bring it into Mixpanel via Warehouse Connectors / Revenue Analytics, then build metrics on top of that state. [Revenue analytics overview; Grow revenue guide]
So: yes, Mixpanel can count “users who did event X in window A OR event Y in window B” using filters or cohorts; what it can’t do (per the docs) is infer subscription activity if the underlying events don’t exist or don’t distinguish monthly vs annual.
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.
If I want to show how a step in a funnel has changed for users that have signed up during different time periods, how do I do that? The funnel generally shows one snapshot over a period.
Let me check the knowledge base for you again. One moment! 📚
You can compare how a funnel step performs across different signup periods by using Comparisons and/or Breakdowns in Funnels, instead of looking at a single snapshot.
Option 1: Compare the same funnel across time
Use Compare to Past on your funnel metric:
1. Build your funnel as usual (steps, conversion window, filters). [Funnels quickstart] 2. In the funnel report, use Comparisons → Compare to Past. 3. Choose the period you want to compare against (previous week/month/quarter, or a custom window). [Comparisons]
This shows how each step’s conversion has changed between two time periods (e.g., users who entered the funnel this month vs last month).
Option 2: Break down by signup cohort
If you track a signup date or have signup-based cohorts:
1. Create cohorts like “Signed up in Jan”, “Signed up in Feb”, etc., using the Cohort Builder (e.g., users who did Sign Up in that month). [Cohorts]
2. In your funnel, click Breakdown and select those cohorts. [Breakdowns]
3. The funnel will show separate conversion for each signup cohort, so you can see how a given step differs for users who signed up in different periods.
You can also use Find Interesting Segments in Funnels to automatically surface cohorts or properties whose conversion differs significantly from overall, which can highlight time-based segments if you’ve defined them as cohorts. [Find segments]
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! 📚
