kapa.ai Could you help me prepare a day-wise user sign up report ?
Certainly! To prepare a day-wise user sign up report in Mixpanel, you should use the Insights report. Here’s how you can do it: 1. Select the “Sign Up” Event: In the Insights report, choose the “Sign Up” event as the metric you want to analyze. This event should be tracked in your implementation (e.g., via mixpanel.track('Sign Up', {...})
) Track Events.2. Set the Measurement to Unique Users: To count the number of unique users signing up each day, set the measurement to “Unique Users.” This will show you how many distinct users performed the “Sign Up” event per day Insights: Users.3. Choose the Time Interval as “Day”: In the date/time selector, set the interval to “Day.” This will break down your report to show daily sign up counts.4. (Optional) Apply Filters or Breakdowns: You can further filter or break down the report by properties such as “Source,” “Country,” or “OS” to get more granular insights What to Track.Summary of Steps in Mixpanel UI:
- Go to Insights report.
- Select the “Sign Up” event.
- Set measurement to “Unique Users.”
- Set interval to “Day.”
- (Optional) Add filters or breakdowns as needed.This will give you a chart or table showing the number of users who signed up each day.If you want to see the actual users who signed up on a specific day, you can click on a data point in the chart and use the “View Users” feature to explore or export the list View Users.Let me know if you need help with a specific step or want to export the data!
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! 📚
To create a report based on the date a user profile was registered with Mixpanel (i.e., when the profile was created), you should use the reserved profile property $created
. This property represents the time that the profile was created, but note that it is not auto-populated—it must be set when the profile is created or imported (Reserved Properties).How to create a day-wise user registration report using $created:Note:
If you have not set the $created
property on your user profiles, Mixpanel will not be able to report on registration date using this method. In that case, you may need to use another property you control, or update your data going forward to include $created
 (Reserved Properties).Summary:
- Use the $created
property for user registration date.
- Create an Insights report, break down by $created
(day).
- Ensure $created
is set on your profiles.If you need to query this programmatically (e.g., via JQL or API), you can filter user profiles by the $created
property as well (Querying Profiles).Let me know if you need step-by-step UI instructions or code examples!
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.