Data Functions

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. 

mceclip0.png

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

The following data functions are only available in Insights, and are separated into groups based on what is being calculated: Total, Unique, Count users, aggregate property values, aggregate property values per user, and count sessions.

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?

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?

 

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.

Did this answer your question?

Comments

0 comments

Article is closed for comments.