Video

Just want to say thank you ❤ BTW you deliver a high value content, So don't get bother by The number of subscribers or watch count, wish All the Best ❤❤

Hey man loved your explanation ❤❤ Need a further reading or anything that goes in depth Any suggestions??😅

wow!! you just made a great job thatnk you for your amazing efforts i was trying to find any information about how to make comprehensive dashboard by using mixpanel reflecting the ad spend and you really made easy to understand how to do it so i tried to implement it but found new issue which is the UTM source gives me not set on mixpanel any trying to see solution for this issue thank you again for your efforts and truly appreciate it

Hello! Thanks for sharing. What were the main services you offered to get your first clients? Is there a specific niche you would recommend?

Hey Timo great video! Had a doubt or wanted a confirmation actually for User Properties Let's say I don't connect to DW Question : For a product, let's say I want to get amount spend in SF in last 1 year by users. There is a User123 who spent some time in SF (6 months) and in California in the next 6 months. Now, the location variable will be updated. Ideally if I take 1 year time duration, this will lead to all amount being allocated to California. Or if i calculated number of user X city, then this User123 should be counted in both but as per Mixpanel's implementation this would be counted in California right? (Want to confirm on this understanding :) ) I know I can pass location as event property with amount as a solution. The reason I said no DW. Cause this requires good data at the source or at my end and we have identified some issues with it which will take some sweet time to resolve : (. Also good edits, zooming etc on a couple of elements + great explanation with the diagrams!

What tools did you use to record this video?

Hi, Timo. If you don't mind, could you increase the volume of the next videos a little? :)❣

Amazing video Timo! would love to see more content like this

Thank you very much for your explanation of the difference between the star schema and the event schema. As a BI practitioner, I use the star schema almost all the time, and I wasn't so sure about the second one. Is there a resource you can recommend to learn more about the Event Schema and Event analytics in general?

Thanks for the video! It's useful 👍

Good video! Could you please complete the video though? I am able to initiate all the required instances but not able to move forward from there sadly.

Excellent! I will recommend to my friends!! Thank you.

Great video as always!

😜 Promo>SM

What tools did you use as you provided data consultancy or management service? How did you get your first customers? Thank you for the video

I can't believe we have already reached our final episode :( . I am learning a lot from this series Timo. Thank you very much for your content!

Awesome! Thx! ❤

Community hero <3

Great overview. I think a common confusion is how is this different than just using Google Analytics. Why would a team want to add this to their toolset.

Great video Timo! but please use light mode in the MP UI next time since it is a bit hard to see clearly with the dark mode

The video we were all waiting for!!

Can you share the link to the previous video?

Amazing video Timo. Very insightful! I can't wait to see the next one. Whenever you are in Mixpanel, are you doing the subscription analytics and the product analytics on the same platform (MixPanel)? Seeing the SQL code for dbt opened my mind. This is the kind of learning resource analysts should be seeking for, instead of more SQL tutorials. Thanks for your content!

Mate! Such a good video! Thanks for all the insights. Would love to see a video about the constructed/virtual events / cohorts you mentioned!

Thank you for sharing, Timo. This is so crisp, clear, and relatable - for anyone who is venturing into the world of data consulting. The explore and refine process is the one which I feel would help one to specialize and creates his own niche over time.

This is extremely helpful, Timo. I'm really looking forward to the next videos in the series because I'm going through a very similar process in my current company. We just implemented Mixpanel for the first time there and working on getting the subscription data in sync with product events. Thanks for sharing this knowledge.

what do you think about using a dashboard tool like Plotly and Dash or Poer BI? and replacing the use of mixpanel by doing all the back and front by myself?

I can't wait for the next video in this series. Thanks for sharing your wisdom with us Timo! There is a huge gap between knowledge that helps you take action and what is taught in online courses and I firmly believe your channel helps us (especially me) close that gap.

The outcome is the same but there is more resources thrown at data. Biggest difference.

Very informative video, thank you

Very insightful, thanks abhi. Especially these 4 ways metrics can drop (components, influences, seasonality and dimensional segments) was a new framing for me. Would be interesting to learn how the latter two could be included in the framework. Would this be part of building and testing hypotheses for influences?

🎯 Key Takeaways for quick navigation: 00:00 📊 *Ownership en verantwoordelijkheid voor Mixpanel* - Het is essentieel om minstens één persoon verantwoordelijk te maken voor het beheer van Mixpanel. - Deze persoon is verantwoordelijk voor het nemen van beslissingen over gegevensinzameling, toegangsbeheer en configuratie van het account. - De Lexicon, ofwel gegevensbeheer, is een cruciale tool voor het beheren van gebeurtenissen, eigenschappen en formules in Mixpanel. 02:59 🔄 *Aanpassing van standaardrapporten in Mixpanel* - Mixpanel biedt geen kant-en-klare standaardrapporten zoals bij Google Analytics. - Het definiëren van rapporten begint altijd met de specifieke bedrijfsfuncties die worden ondersteund en de gewenste bedrijfsresultaten. - Het is belangrijk om te begrijpen welke gebeurtenissen relevant zijn voor het bereiken van de bedrijfsdoelstellingen voordat analyses worden uitgevoerd. 05:16 🚀 *Begrip van gebeurtenisinzameling en tracking in Mixpanel* - Het gebruik van SDK's (Software Development Kits) is essentieel voor het verzenden van gebeurtenissen naar Mixpanel vanuit verschillende bronnen. - De "track" en "identify" functies binnen de SDK's worden gebruikt voor het traceren van gebeurtenissen en het identificeren van gebruikers. - Het begrijpen van gebeurtenisinzameling en tracking is cruciaal voor het effectief gebruik van Mixpanel voor analyse. 07:07 📈 *Gebruik van geconstrueerde gebeurtenissen en cohorten in Mixpanel* - Geconstrueerde gebeurtenissen zijn gebaseerd op bestaande gebeurtenissen en kunnen worden gebruikt om specifieke gebruikersgedragingen te identificeren. - Cohorten zijn groepen gebruikers gebaseerd op gedefinieerde criteria, waardoor diepgaande analyses mogelijk zijn. - Het begrip en gebruik van geconstrueerde gebeurtenissen en cohorten voegen een krachtige dimensie toe aan de analysecapaciteiten van Mixpanel. 08:42 🛑 *Beheer van gegevensgebruikerservaring in Mixpanel* - Het beperken van het aantal gebeurtenissen tot maximaal 50 om de gebruikerservaring van gegevens te behouden. - Een overvloed aan gebeurtenissen kan leiden tot moeilijkheden bij het vinden van relevante gebeurtenissen voor analyse en het handhaven van de gegevenskwaliteit. - Monitoring en onderhoud van gebeurtenissen zijn essentieel om ervoor te zorgen dat de verzamelde gegevens nauwkeurig en consistent blijven. 10:08 🎓 *Training en promotie van Mixpanel binnen het bedrijf* - Het trainen van medewerkers en het promoten van het gebruik van Mixpanel binnen het bedrijf zijn cruciaal voor een succesvolle implementatie. - Het begrip van de behoeften en uitdagingen van verschillende teams helpt bij het creëren van relevante en effectieve gebruiksscenario's voor Mixpanel. - Een cultuur van training en acceptatie bevordert het gebruik van Mixpanel en maximaliseert de waarde voor het bedrijf. 11:18 🔍 *Gebruik van de gebruikerstab in Mixpanel* - De gebruikerstab biedt gedetailleerde inzichten in individuele gebruikersgedragingen en kan worden gebruikt voor foutopsporing en analyse. - Door individuele gebruikersprofielen te bekijken, kunnen micro-patronen worden geïdentificeerd en technische problemen worden opgelost. - Regelmatige controle van de gebruikerstab is essentieel voor het waarborgen van de nauwkeurigheid en consistentie van de gegevensverzameling in Mixpanel. Made with HARPA AI

Great video Timo!

Really good! This applies to every analytics tool! I invested poorly on training and ended up with 300 events.

thank you for sharing these details also it would've much more helpful if I had gotten some kind of blueprint or sample of tracking plan.

Just started learning Mixpanel, super helpful tips, thanks!

Thanks for sharing, Timo! It is essential to have these principles in our ADN.

What is the best analytics tool? I hate GA4

no =D

Thank you for sharing your process. I've recently finished a masters in big data management and analytics, with ~10 years of professional experience in project management and emergency response before hand. My struggle is feeling like I don't REALLY have skills that someone would want to pay for as a consultant. I also think I'm lacking the network as I haven't worked professionally in data science before trying to be a consultant... I like the idea of knowing my secret weapon. It aligns well with everything I know about personal branding. Just the "how" of finding out what the secret weapon is is fantastic!

Thank you for sharing this, really saved the time for research!

Do I spy Designing Data Intensive Applications book in the background 👀

Really interesting stuff. Looks like you do pretty much everything data wise for companies? Defining metrics, setting up tracking, bringing everything into a datawarehouse, visualizations etc. So you're really handling everything- data analytics, data engineering, business intelligence etc. Really cool. If you wrote a book or made a course outlining your processes from start to finish I would buy in a heartbeat.

'Promo sm'

Hi timo I hope you are doing well. I recently graduated computer science engineering with concentration of data analytics can you please refer me or hire me for the job so that I can gain knowledge in data field

Very helpful! Thanks for your clear and detailed breakdown of the options.

Having my first real exposure to GA4 tonight, and this is bewilderingly frustrating. The list of WTF moments I've had over the last few hours is so long and varied I wouldn't even know where to begin.

Thanks for this. Really helpful!

Hi, Timo. I have a question that has been bothering me for some time now, about how a tool like Census manages to create audiences and export it to other platforms. What data is normally exported? Email I understand, since the user tends to use the same email on different sites and apps. But is there any other identifier that can be used for user-matching besides email? Thanks.

Just wanted to add: With Snowplow, you can put GTM Server-side after Snowbridge and use it to stream data to 3rd party destinations like GA, Conversion APIs and Braze. Snowbridge is designed for streaming to Kafka, GTM SS, Events Hub, etc. Thanks Timo, this was really insightful