kapa.ai

Please stand by Paras as I search the knowledge base. I normally take about 15 seconds or so. 👋

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!

ℹ️ 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:

1. Ensure $created is Populated: Make sure your user profiles have the $created property set. If you are not already setting this property, you will need to update your implementation to include it when creating user profiles.

2. Create an Insights Report: - Go to the Insights report in Mixpanel. - Select “Profile” as the metric type. - Set the measurement to “Total” or “Unique Users” (depending on whether you want total profiles or unique registrations). - Use the $created property as a filter or breakdown. For a day-wise report, break down by the date part of $created.

3. Breakdown by Day: - In the breakdown options, select the $created property and group by “Day.” This will show you how many user profiles were created (registered) on each day.

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!

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.