top of page

Create a Natural Usage Frequency Histogram in Mixpanel

Updated: Nov 25, 2023


If you want to create this natural frequency identification graph in Mixpanel, I have step-by-step instructions below.


1- If you want to group core actions together, you will need to create a custom event to group those events together. Example: For our product, both copy and download an asset are inter-changeable. If you only have 1 event, you can skip this step.



2- Then create a cohort of users older than 28 days who performed the core event at least once, which you can do using the following query.



3- Then plotting the Frequency report by creating a retention report and select frequency from the top left.



4- That will result in a frequency curve, which isn't a histogram but still pretty much gets the same data. Use breakdowns to slice and dice the data.



5- You can convert this frequency curve to a histogram using any free online tool or Google sheets. I used Google sheets, and spent 15ish minutes converting it. You plot: days used, active users. Calculate active users from the cumulative users exported from Mixpanel. It's better to google if you aren't sure how to do this. Tons of articles on how to convert.



I hope this helps!


Btw, I'm trying to better understand who my audience is. If you've got ten minutes, I would love to do a user research call: toption.org/10-minute




2 comments

Related Posts

2 Comments


Guest
Aug 14, 2023

Hello, thank you so much for this! It worked!

Like
Khushi Lunkad
Khushi Lunkad
Aug 15, 2023
Replying to

Thank you for letting me know that it worked for you!


(Posted on 15th August, 2023)

Like
bottom of page