Product Analytics Academy
Product Analytics Academy
  • 11
  • 34 031
Mixpanel: Users Active On Multiple Days
How to use Mixpanel to count users who took an action on multiple distinct days.
Full product analytics course available at: bit.ly/46ccb1Q
Переглядів: 687

Відео

Mixpanel: Renaming Events and Properties
Переглядів 1,6 тис.11 місяців тому
How to easily rename events and properties in Mixpanel. Learn how to become a data-driven product manager with our self-paced and comprehensive online course: bit.ly/45OXEc1
Product Success Metrics | A Complete Tutorial
Переглядів 7 тис.Рік тому
Learn how to set success metrics and KPI's for any product. Ultimate Product Analytics Course: bit.ly/3EnzD0v
Mixpanel: Exclude Internal Users From Reports
Переглядів 1,2 тис.Рік тому
How to leave out internal and test users from your Mixpanel reports. Ultimate Product Analytics Course: bit.ly/3OV6HBO
Mixpanel: Daily/Weekly/Monthly Active Users
Переглядів 2,7 тис.Рік тому
Learn how to calculate your DAU’s, WAU’s, MAU’s whether your activation action is one event or several. Free course on product success metrics: bit.ly/3PnsyTU
Mixpanel: Retention Report Complete Tutorial
Переглядів 4,7 тис.Рік тому
Understand user retention using Mixpanel’s Retention report Free course on product success metrics: bit.ly/3L8T1lN
Mixpanel: How to make a Power User Curve
Переглядів 1,3 тис.Рік тому
Guide to how you can create a Power User Curve in Mixpanel. You can view the original Andrew Chen article on the Power User Curve ( as shown in the video) here: andrewchen.com/power-user-curve/ Free course on product success metrics: bit.ly/44kehvU
Mixpanel: Three Ways To Define User Sessions
Переглядів 2,3 тис.Рік тому
Guide to the three different ways you can define sessions in Mixpanel. Timeout-based - 2:10 Event-based - 6:16 Property-based - 8:42 Recap - 10:10 Free course on product success metrics: bit.ly/44iZce9 Measure average session length: ua-cam.com/video/8qveAvsnJsc/v-deo.html Time spent in app per user: ua-cam.com/video/gnTpblnTeHw/v-deo.html
Mixpanel: Average Session Length
Переглядів 3,3 тис.Рік тому
The easiest way to find the length of an average session using Mixpanel Free course on product success metrics: bit.ly/3JwQjpz How to define sessions in Mixpanel: ua-cam.com/video/urCcXyYHzBs/v-deo.html
Mixpanel: Time Spent In App Per User
Переглядів 4,5 тис.Рік тому
The easiest way to find how much time a user spends in the app. Free course on product success metrics: bit.ly/3Jvos90 How to define sessions in Mixpanel: ua-cam.com/video/urCcXyYHzBs/v-deo.html
Mixpanel: Finding The Time Between Events
Переглядів 5 тис.Рік тому
Best ways to find the average time between two events in Mixpanel. Free course on product success metrics: bit.ly/44jikJa

КОМЕНТАРІ

  • @chrisbrenden2828
    @chrisbrenden2828 11 днів тому

    Instead of plotting just the Average Retention, is there a way to plot each cohort (each week) as its own retention line?

    • @productanalyticsacademy
      @productanalyticsacademy 8 днів тому

      Unfortunately I don’t believe that’s currently possible. If your cohosting event is something like a signup, you could track signup date as a user property, then break down the retention chart by that user property

  • @MayumiHamaoka
    @MayumiHamaoka 13 днів тому

    hey, thanks for the content :) Do you know if it is possible to extract session_start and session_end timestamp from mixpanel to create reports outside mixpanel? Does mixpanel assign a session_id? Thank you!

    • @productanalyticsacademy
      @productanalyticsacademy 8 днів тому

      Hi there! Unfortunately that’s not currently possible since those are virtual events that are calculated by Mixpanel based on the session settings you choose for the project

  • @Artouple
    @Artouple 2 місяці тому

    Great video, thank you!

  • @NakamotoPlays
    @NakamotoPlays 2 місяці тому

    How can I make it look at minutes opposed to seconds?

  • @waranya.h
    @waranya.h 2 місяці тому

    This is awesome! Clearly explained and so easy to understand. Thank you so much.

  • @JuanHerreraMarin
    @JuanHerreraMarin 3 місяці тому

    Thank youuuuuuu

  • @wimbo_learn_music
    @wimbo_learn_music 3 місяці тому

    Thanks! This should be a super basic analysis but it's not straightforward at all in Mixpanel.

  • @Chefrondon
    @Chefrondon 3 місяці тому

    This is so great. Do you have classes or courses or more videos for Mixpanel following the sequence of AARRR funnel ? Thank you

    • @productanalyticsacademy
      @productanalyticsacademy 2 місяці тому

      Glad you liked it! I do have the class that’s linked in the video description. It had multiple other Mixpanel videos, as well as a whole section dedicated to metrics. It doesn’t follow AARRR exactly, but it’s similar. It’s my own framework. Other sections of the course include split testing, tracking plan development, and SQL for PM’s.

    • @Chefrondon
      @Chefrondon 2 місяці тому

      @@productanalyticsacademy wow I should get this, do you have any student discount 👀

    • @productanalyticsacademy
      @productanalyticsacademy 2 місяці тому

      @@Chefrondon Sorry for the delayed response, I was on vacation. The course is already heavily discounted due to a summer sale (down to $175 from $299) but since you enjoyed the video so much, I made a new student discount code that brings it down even further to $99. Can't go any lower than this haha. Just type in "youtubestudent" as your coupon code when signing up. Lmk if you have any issues. Hope you enjoy the course!

    • @Chefrondon
      @Chefrondon 2 місяці тому

      @@productanalyticsacademy thank you

  • @smaira2024
    @smaira2024 3 місяці тому

    I am trying to apply this to a project where my goal is to measure reduction in time by automating a manual workflow. Would that be a focus metric? I'm not sure how to map my goal into this framework. Feels like that kind of KPI may not fall under this. eg. Today it takes a business user X hours to perform a manual task. After I launch my feature I expect it will reduct it by 90%. My feature can still have these metrics but I'm not sure how to use them to track this goal. Could you please help?

    • @productanalyticsacademy
      @productanalyticsacademy 3 місяці тому

      If you already have a metric in mind as your KPI, there’s no need to try and force it into this framework. This framework helps you put KPI’s in place when you don’t have any. Sounds like you already have a key KPI that you need to manage to: average (or median) time to conversion. Just set that as your goal and don’t worry about trying to use this framework. It will probably be helpful to track the overall conversion rate of the workflow as well, alongside the time to conversion

    • @smaira2024
      @smaira2024 3 місяці тому

      @@productanalyticsacademy thank you for your reply. I don't think I fully understand. When you say conversion rate and time to conversion for the automated workflow (new feature) are you referring to : conversion rate = #of activated users/ #of users exposed to feature? time to conversion = amount of time it takes an activated user to complete one or more key actions? Would the focus metric in this case still be DAU/MAU?

  • @michaandruszkiewicz7571
    @michaandruszkiewicz7571 4 місяці тому

    This is gold, keep up the good work!

  • @MO3az-hw9qy
    @MO3az-hw9qy 5 місяців тому

    Bro You are awesome BTW loved Your Course although Recommended to other Coworkers

  • @MaksymSkurativskyi
    @MaksymSkurativskyi 5 місяців тому

    It seems there is some inconsistency at 10:59 with Retention metric. On the video it was said that we calculate users, but based on the formula on a slide we calculate animations.

    • @absg1234
      @absg1234 2 місяці тому

      It’s bad wording on my part cause I was trying to fit everything in one line. “Created animations” is shorthand for “user that created animations”. That’s why I’m the previous line I phrase it differently (“number of animations created”). In hindsight, this was a poor way of phrasing it in my part, you’re right to think what you thought

  • @drama.sreerama
    @drama.sreerama 5 місяців тому

    Thank you so much, I wasn't able to find this anywhere else!

  • @esmaeillrastipour4324
    @esmaeillrastipour4324 6 місяців тому

    great Thanks a lot bro

  • @AN-lr6xk
    @AN-lr6xk 6 місяців тому

    Can you also add a video for LTV CAC and also what is the key for determining success - For eg for new company, growth stage company and scale - what are the key results for the metrics we are looking for- for eg there should be a 70 perc retention rate for new companies - similar to this

    • @absg1234
      @absg1234 2 місяці тому

      Those are more so finance and marketing metrics, why is why they’re not as much the focus of this channel

  • @RahulChhabra007
    @RahulChhabra007 6 місяців тому

    why arent there text based guides easily available??

  • @shahfamily1469
    @shahfamily1469 7 місяців тому

    For Engagement metric I would disagree with # of times a watcher has watched a video for instance. Instead I feel it should be x# of videos watched / watcher. Reason being that # of times could also be 1 time but that doesn't make for an Engaged user. What makes an 'Engaged' user is based on data analysis coming down to that magic # that beyond which we know the user doesn't quit our product

    • @productanalyticsacademy
      @productanalyticsacademy 7 місяців тому

      Yes that’s exactly what is said in the video as well. Listen to 14:30

  • @hendrickmanenga9213
    @hendrickmanenga9213 8 місяців тому

    Thank you for such a good video.I dont see emai category in the list.

    • @productanalyticsacademy
      @productanalyticsacademy 8 місяців тому

      Glad you enjoyed it! It’s possible that your team isn’t tracking email as a user property. In that case you can use another identifier or work with your engineering team to start tracking email

  • @alexistuil4938
    @alexistuil4938 8 місяців тому

    Very good video ! Do you have a video on how implement these metrics in Mixpanel ?

    • @productanalyticsacademy
      @productanalyticsacademy 8 місяців тому

      Not yet but I’m working on it!

    • @Funmilayo_Oyeniyi
      @Funmilayo_Oyeniyi 7 місяців тому

      I will be waiting,Just subcribed to youtr channel.This video was really helpful@@productanalyticsacademy

  • @parksangwoo6398
    @parksangwoo6398 9 місяців тому

    Thank you so much! This helped me a lot:)

  • @marjanz3777
    @marjanz3777 9 місяців тому

    Such a great video! ❤

  • @joshuagraham6731
    @joshuagraham6731 9 місяців тому

    Love love this video. Simple explanations with great and practical examples. Subscribed!

  • @andrea_tag
    @andrea_tag 9 місяців тому

    Hi, for some reason I was following the steps to set up the en session , but I dont see the same options. In my case under 'Aggregate property per user'. I dont see the properties lists you see. I only see sessions in seconds when I select ''Aggregate property per user'.'

    • @productanalyticsacademy
      @productanalyticsacademy 9 місяців тому

      Hi Andrea, my apologies for the delayed response, I've been on vacation for a bit. Are you referring to the properties you see in the image like "Country", "Browser", etc? Those properties aren't numeric values so you wouldn't be able to aggregate them anyway. It's possible that Mixpanel is testing an update that prevents them from being shown. It's also possible that your implementation doesn't track any of those default properties (either because they've been disabled, or you're tracking everything on the server side)

  • @JamesGrom
    @JamesGrom 9 місяців тому

    incredibly helpful, thank you!

  • @atishab05
    @atishab05 10 місяців тому

    Such a great video 👍!

  • @doutimiebibote
    @doutimiebibote 10 місяців тому

    This is the best video I have watched so far about product analytics

    • @productanalyticsacademy
      @productanalyticsacademy 10 місяців тому

      Wow this is very high praise, thank you! So happy to hear you’ve found it this helpful

  • @evrimdemir1327
    @evrimdemir1327 10 місяців тому

    great video, thanks.

  • @exploreyourdreamlife
    @exploreyourdreamlife 11 місяців тому

    I've learned so much about leaving users from Mixpanel report from this video. Thanks to the creator for their exceptional content! Liked and Subbed!

  • @userprod2
    @userprod2 11 місяців тому

    Hi, Can you create a video addressing "How to set Channel attribution in Mixpanel?" I want see my daily Organic Session, Direct Sessions and Paid Sessions. Thanks in Advance.

    • @productanalyticsacademy
      @productanalyticsacademy 11 місяців тому

      Thanks for the idea! I’ll look into it. Mixpanel isn’t gonna categorize your sources automatically like Google Analytics does, but it does automatically process UTM parameters

  • @userprod2
    @userprod2 11 місяців тому

    Great Video, Quite Insighful and loved the way you described every step. Thanks !

  • @valeriamedved2014
    @valeriamedved2014 11 місяців тому

    hi) can we save the table in excel or csv? thank you in advance for your answer

    • @productanalyticsacademy
      @productanalyticsacademy 11 місяців тому

      Yes you can! If you click on the three-dots button ("...") on the top right of the chart (next to the "Save") button, there's an "Export" option and you can choose to export as a CSV. You just can't do it when you're using the sample datasets that are shown in this video, I'm guessing because they're made by Mixpanel and we don't have the right access level. If you try it on one of your own projects, you'll be able to do a CSV export too. Let me know if this helps!

  • @smaira2024
    @smaira2024 11 місяців тому

    Very clear explanation of the framework and helpful application in B2B and B2C. Glad I came across your channel. Thank you!

    • @productanalyticsacademy
      @productanalyticsacademy 11 місяців тому

      So great to hear that you found it helpful! Let me know if there are any other product analytics topics you would like me to cover

    • @smaira2024
      @smaira2024 11 місяців тому

      @@productanalyticsacademy It would be great to see content around picking metrics, establishing goals and reviewing them for experiments at different stages of the product.

    • @productanalyticsacademy
      @productanalyticsacademy 11 місяців тому

      @@smaira2024 Thanks for the tips! I do have more videos on metrics selection and experiments in the main course that I offer on my site, but I'll think through which aspects of those I can summarize and publish as a separate video here

    • @smaira2024
      @smaira2024 11 місяців тому

      @@productanalyticsacademy Thank you!

  • @mediesjef
    @mediesjef Рік тому

    Wonderful, thank you!

  • @techviking23
    @techviking23 Рік тому

    great video, thank you!

  • @KirkNank
    @KirkNank Рік тому

    Great and helpful video! At 0:45 seconds when you begin to create the cohort, your version shows "where". On my end, instead of "where" it says "who" and then you have the option of "did" or "did not". I then selected "email" > First value > email > Is > added in our company domain for the email address > set the date range since the beginning of the year > and then this worked pretty well.

    • @productanalyticsacademy
      @productanalyticsacademy Рік тому

      Hi Kirk! Based on your description, what you did is a little bit different from what's in the video, but should still give you good results. I selected the "Email" user property, which is why it said "Where". In your case, you may have had an event called "Email" or an event property (as opposed to user property) called "Email", and you selected that. This is why you then had to select the "First Value" option, because events have many different instances with different property values. Your method should work as long as the selected "Email" property is that of the user who triggered the event, and also their email doesn't change over time. Btw you can tell if what your selecting is a user property or an event property by looking at the icon next to it in the dropdown. The person icon indicates a user property.

  • @productanalyticsacademy
    @productanalyticsacademy Рік тому

    Hope you all enjoyed the video! If you want to learn more about product metrics, split testing, and analyzing product data, check out the Ultimate Product Analytics Course, offered on our site. bit.ly/3EnzD0v

    • @atishab05
      @atishab05 10 місяців тому

      Great video @productanalyticsacademy !👌

  • @kartiknegi2618
    @kartiknegi2618 Рік тому

    Loved it ! Thanks for the video man.

  • @amirkatoozian3996
    @amirkatoozian3996 Рік тому

    Great tutorial! Does this method work for subscription products as well?

    • @productanalyticsacademy
      @productanalyticsacademy Рік тому

      Yes, definitely! The Saas example given in the video matches what many subscription products look like, especially B2B ones. Remember that healthy product usage is what contributes to people converting to a paid subscription, as well as keeping their subscription for longer. If they onboard easily, activate well, and have high engagement, then that will lead to them keeping their subscription.

    • @atishab05
      @atishab05 10 місяців тому

      Great insight!

  • @ashleycuster1829
    @ashleycuster1829 Рік тому

    Thanks for the video! The examples were really helpful.

  • @productanalyticsacademy
    @productanalyticsacademy Рік тому

    Sorry for the lower audio quality on this one! Didn't have my usual recording setup

  • @JoniLindgren-u4i
    @JoniLindgren-u4i Рік тому

    came here to find the answer to why I cant see 1 day active in the frequency non-cumulative report...I mean, WHYY

    • @productanalyticsacademy
      @productanalyticsacademy Рік тому

      Yeah I'm annoyed by it too :/ You essentially have to calculate that number separately through an Insights report

    • @marcocerulli
      @marcocerulli 8 місяців тому

      @@productanalyticsacademy I've just seen this video (ua-cam.com/video/xJX9V1QRhKo/v-deo.html) to put on the dashboard the number of users who are "1 day active". The problem is that the cohort preview number of users for 2 days active is different compared to the number that I extrapolated from the Power User Curve. The same for the 3 days active and so on. Obviously I've changed the "greater than" in "equals" during the cohort creation, so I don't know why all this happens. Could you please help me?

    • @marcocerulli
      @marcocerulli 8 місяців тому

      @@productanalyticsacademy Hi! I've made a Power User Curve following this video. After then, I decided to calculate the number of 1-day active users with an insight report, following this other your video (ua-cam.com/video/xJX9V1QRhKo/v-deo.html). The problem is that the cohort preview number of users for 2-days active differs from the number I extrapolated from the Power User Curve. The same goes for the 3-days active and so on. Obviously, I've changed the "greater than" in "equals" during the cohort creation, so I don't know why all this happens. Could you please help me?

    • @productanalyticsacademy
      @productanalyticsacademy 8 місяців тому

      Unfortunately it's not really possible for me to help you without having access to your data and doing a deep dive. However, what I do know is that the cohort preview count shown in Mixpanel is often incorrect. You'll get a more accurate count if you make the cohort, then count the users in it a different way. For example checking the "View Users" option.

    • @JoniLindgren-u4i
      @JoniLindgren-u4i 8 місяців тому

      Got confirmation from Mixpanel support a few months back in October taht this is in fact not supported (yet?) @@productanalyticsacademy

  • @jackbaker1436
    @jackbaker1436 Рік тому

    love these videos, thank you so much

    • @productanalyticsacademy
      @productanalyticsacademy Рік тому

      That's awesome, glad you're enjoying them! I have a lot more coming so stay tuned, and please let me know if there are any other topics like this that you want to see covered

  • @productanalyticsacademy
    @productanalyticsacademy Рік тому

    Learn how Mixpanel's Retention report works with this complete tutorial. This video is taken from The Ultimate Product Analytics Course, which is available on our site: productanalytics.academy

  • @kevinhughes2714
    @kevinhughes2714 Рік тому

    This is what I was missing in my life. Thank you kind sir

    • @productanalyticsacademy
      @productanalyticsacademy Рік тому

      Glad I could help, and thank you for the kind comment! lmk if there's other Mixpanel topics that you want tutorials on, would love some viewer feedback on that

  • @CarstenHagemann1
    @CarstenHagemann1 Рік тому

    Thanks, that was really helpful!

    • @productanalyticsacademy
      @productanalyticsacademy Рік тому

      Glad it helped! If you have requests for any other videos, please comment to let me know

  • @productanalyticsacademy
    @productanalyticsacademy Рік тому

    Learn how to find the time between events. You can find our other Mixpanel tutorials in this playlist: ua-cam.com/play/PLmtZpkc1VS1d3aQvs4HU8PcDPhM7PoHTj.html

  • @productanalyticsacademy
    @productanalyticsacademy Рік тому

    Learn how to measure time spent in app per user in Mixpanel. You can find our other Mixpanel tutorials in this playlist: ua-cam.com/play/PLmtZpkc1VS1d3aQvs4HU8PcDPhM7PoHTj.html

  • @productanalyticsacademy
    @productanalyticsacademy Рік тому

    Learn how to measure average session length in Mixpanel. You can find our other Mixpanel tutorials in this playlist: ua-cam.com/play/PLmtZpkc1VS1d3aQvs4HU8PcDPhM7PoHTj.html

  • @productanalyticsacademy
    @productanalyticsacademy Рік тому

    Learn how to define sessions in Mixpanel. You can find our other Mixpanel tutorials in this playlist: ua-cam.com/play/PLmtZpkc1VS1d3aQvs4HU8PcDPhM7PoHTj.html

  • @productanalyticsacademy
    @productanalyticsacademy Рік тому

    Learn how to create a Power User Curve in Mixpanel. You can find our other Mixpanel tutorials in this playlist: ua-cam.com/play/PLmtZpkc1VS1d3aQvs4HU8PcDPhM7PoHTj.html