Use Data Functions in Mixpanel reports to perform more complex calculations on your queries.
Select Data Functions
Data Functions compute aggregate values of your event and property data, including totals, uniques, and averages.
In Insights, you can change the data function by selecting the drop-down that displays Total beside the event selector. When you first create an Insights report, the query will default to total.
In the Funnels report, you can toggle between totals, uniques, or sessions, while Retention queries can only be calculated using unique values.
Insights Data Functions
Functions calculated per user in Insights have additional aggregation options following the initial calculation. The initial per user calculation is aggregated as average by default, but you can also choose to calculate the distribution, median, 25/75/90th percentiles, minimum, and maximum.
Here's a quick walkthrough of the newest changes:
Events
Function Name |
Events & Cohorts Calculation |
Profiles Calculation |
Total |
Total count of [event] performed. Example: How many times did my users watch a video? |
N/A |
Total per user |
The number of events performed per user. Example: How many videos were watched per user? Aggregation options: Average, distribution, median, percentiles, minimum, maximum |
N/A |
Users
Function Name |
Events & Cohorts Calculation |
Profiles Calculation |
Total |
N/A |
Total count of user profiles. Example: What's my total number of users? |
Unique |
The number of users who performed [event]. Example: What's the count of users who watched a video? |
N/A |
Daily Active Users (DAU) |
The number of users who performed [event] within the last 24 hours. Example: What's the count of users who watched a video in the last day? |
N/A |
Weekly Active Users (WAU) |
The number of users who performed [event] within the last 7 days. Example: What's the count of users who watched a video in the week? |
N/A |
Monthly Active Users (MAU) |
The number of users who performed [event] within the last 30 days. Example: What's the count of users who watched a video in the last month? |
N/A |
Aggregate Property values
Function Name |
Events & Cohorts Calculation |
Profiles Calculation |
Sum |
The total of a numeric property value across all instances of [event]. Example: What's the total number of minutes of videos watched? |
The total of a numeric property value across all user profiles. Example: What's the total revenue across all users? |
Average |
Average of a numeric property value across all instances of [event]. Example: What's the average number of minutes per video watched? |
Average of a numeric property value across all user profiles. Example: What's the average revenue across all users? |
Distinct count |
Calculates the unique count of property values across all instances of [event]. Example: How many unique songs were played in the last 30 days? |
Calculates the unique count of property values across all profiles. Example: How many unique countries were our video watchers from? |
Median |
Median of a numeric property value across all instances of [event]. Example: What's the median number of minutes per video watched? |
Median of a numeric property value across all user profiles. Example: What's the median revenue across all users? |
Percentiles (25/75/90/99) |
The 25/75/90/99th percentile of a numeric property value across all instances of [event]. Example: What's the 25th percentile number of minutes of videos watched? |
The 25/75/90/99th percentile of a numeric property value across all user profiles. Example: What's the 25th percentile revenue across all users? |
Minimum |
Minimum of a numeric property value across all instances of [event]. Example: What's the minimum number of minutes per video watched? |
Minimum of a numeric property value across all user profiles. Example: What's the minimum revenue across all users? |
Maximum |
Maximum of a numeric property value across all instances of [event]. Example: What's the maximum number of minutes per video watched? |
Maximum of a numeric property value across all user profiles. Example: What's the maximum revenue across all users? |
Aggregate property values per user
Function Name |
Events & Cohorts Calculation |
Profiles Calculation |
Sum |
The total of a numeric property value across all instances of [event] per user. Example: What's the total number of hours of videos watched per user? Aggregation options: Average, distribution, median, percentiles, minimum, maximum |
N/A |
Average |
Average of a numeric property value across all instances of [event] per user. Example: What's the average number of hours of videos watched per user? Aggregation options: Average, distribution, median, percentiles, minimum, maximum |
N/A |
Distinct count |
The number of distinct property values per user. Example: How many different videos did each user watch? Aggregation options: Average, distribution, median, percentiles, minimum, maximum |
N/A |
Minimum |
Minimum of a numeric property value across all instances of [event] per user. Example: What's the minimum number of hours of videos watched per user? Aggregation options: Average, distribution, median, percentiles, minimum, maximum |
N/A |
Maximum |
Maximum of a numeric property value across all instances of [event] per user. Example: What's the maximum number of hours of videos watched per user? Aggregation options: Average, distribution, median, percentiles, minimum, maximum |
N/A |
Count Sessions
Function Name |
Events & Cohorts Calculation |
Profiles Calculation |
Sessions with event |
The number of sessions that contain [event]. Example: What's the total number of sessions in which users watched a video? |
N/A |
Additional Aggregation Option Examples
Data Function | Average | Distribution | Median | Percentiles (25/75/90) | Minimum/ Maximum |
Total per user | What's the average number of songs played per user? | What is the distribution of my users by the number of songs played? | What's the median number of songs played per user? | How many songs did the 90th percentile user listen to? | How many songs did my least/most active user listen to? |
Sum of property value count per user | What's the average cumulative watch time per user? | What's the distribution of my users by the cumulative minutes of content watched? | What's the median of the cumulative watch time per user? | How many cumulative minutes has the 90th percentile user watched? | How much has the lowest/highest spender spent? |
Average of property value count per user | What's the average of the average cart value for each rider? | What's the distribution of my users by the average cart value per user? | What's the median of the average cart value per user? | What's the average cart value for the 90th percentile user? | What's the minimum/maximum average cart value? |
Distinct property value count per user | What's the average number of unique song titles heard by my users? | What's the distribution of my users by the number of unique song titles listened to? | How many unique songs does the median user listen to? | How many unique songs does the 90th percentile user listen to? |
What's the minimum/maximum number of unique songs my users listen to? |
Minimum property value count per user | What's the average of the minimum ratings provided per user? | What's the distribution of my users by the minimum rating provided? | What's the median of the minimum ratings provided by users? | What's the minimum rating provided by the 90th percentile user? | What's the minimum rating across all ratings?? |
Maximum property value count per user | What's the average of the maximum gaming session length per user? | What's the distribution of my users by the maximum gaming session length? | What's the median of the maximum gaming session length per user? | What's the maximum gaming session length provided by the 90th percentile user? | How long has the longest gaming session lasted across our users? |
Here's a quick overview on "Distinct count" of property values, and how that differs from "Distinct count" of property values per-user:
Here are some use-cases that are now possible with "Distinct count" of property values:
- How many unique items were added to cart yesterday?
- How many unique songs / videos were played in the last 30 days?
- How many unique files were worked on in the last week?
Funnels Data Functions
Only the following data functions are available in Funnels.
Function Name |
Calculation |
Uniques |
Count of unique users performing [event]. |
Totals |
Total count of [event] performed. |
Sessions |
Count of sessions in which [event] was performed. |
Daily, Weekly, and Monthly Active Users
Daily Active Users (DAU)
Select DAU to calculate the number of unique users in the previous day (24-hour) period that have performed the selected event.
Weekly Active Users (WAU)
Select WAU to calculate the number of unique users in the previous week (7-day) period that have performed the selected event.
Monthly Active Users (MAU)
Select MAU to calculate the number of unique users in the previous month (30-day) period that have performed the selected event.
Note on DAU, WAU, and MAU calculations
If you select the DAU, WAU, or MAU function for a date range that includes the current day, the query will take the end of the current day as the end of the query’s time segment (even though it’s in the future). For example, today is April 25th, and it’s 4:22 PM. If you make a query to show WAU and you select “current day” as your date range, the query will return the count of unique users between April 19 at 12:00:00 AM and April 25 at 11:59:59.
Comments
Article is closed for comments.