Ай бұрын
Ай бұрын
3 ай бұрын
6 ай бұрын
6 ай бұрын
7 ай бұрын
7 ай бұрын
8 ай бұрын
8 ай бұрын
9 ай бұрын
9 ай бұрын
10 ай бұрын
Пікірлер
@vidalongacomsaude1 5 күн бұрын
Awsome class, thank you for sharing it!
@MO3az-hw9qy 5 күн бұрын
Very informative! Thank you for this valuable content. By the way, do you have any courses (paid or free) that bridge the gap between analytics engineering and product analytics?
@timodechau 2 күн бұрын
Unfortunately not. But I was thinking about it since some more people have asked. The best resource I can recommend is Olga's Substack: dataanalysis.substack.com
@FaijaAkterSetu 8 күн бұрын
You know what? I am a regular viewer of your KZbin Channel. I have seen all your videos and your content qualities are very good. I learned lots of things from you. Your channel has great quality contents but still it is not delivering its right audiences due to SEO problems. You should focus on your SEO so that You can get a big fanbase, Thanks.
16 күн бұрын
Is Amplitude also event based as GA4?
@timodechau 16 күн бұрын
Yes, you can also get pageviews out of the box, but Amplitude's foundation is events.
@mattytwoshoes 16 күн бұрын
@@timodechau Isn't a pageview a type of event? 🙃
@timodechau 16 күн бұрын
It is, but when you come from GA, it feels different.
@martinwrightuk 22 күн бұрын
4 minutes in and my mind is blown!
@elzoomzoom 22 күн бұрын
Hi Timo, it would be great to have a link to the pdf from the presentation! Thank you for the conference- it’s awesome blast!
@PA20243 Ай бұрын
Hi Timo, thanks for the update. I'm wondering why Mixpanel hasn't released this as an additional type of user property, which could be updated directly from the app. Something like mixpanel.getPeople().set(name, value) but with a default option for collecting historical data, so that the user property wouldn't be overwritten during an update. In this case, the update date would also define the period from when a given value applies in the historical data. It seems that user properties in Amplitude aren't overwritten by default, but rather their changes are reflected in the graphs.
@raouf87 Ай бұрын
Real meat! Thanks a lot Timo for sharing this ❤ one question, we already send our product analytics data to mixapnel through segment CDP, would mixpanel correctly merge identities? for new and existing users? if yes, curious to know, how will that happen?
@timodechau Ай бұрын
It depends how you use Segment. If you use the identify call it should correctly stitch identities. But you can check the user informations in the user sections to see if users can have different ids and are still merged.
@zwei_meter_jason Ай бұрын
Oh no, I just missed the live event by a hair.
@timodechau Ай бұрын
I hope the replay is still ok. I try to stick to the same time every week.
@fred8169 2 ай бұрын
Just explain it buddy
@timodechau Ай бұрын
😁 - sorry. It needs the build up.
@AgnishwarBanerjee-d1k 2 ай бұрын
great points and love the honesty of your presentation
@timodechau Ай бұрын
Thanks!
@TheGladiator123 2 ай бұрын
Hey Timo, do you have any suggestions for Dataset to practice product analytics regarding the users engagement and behaviors in app or product!?
@timodechau 2 ай бұрын
That is a good question. There is the Amplitude Demo Account: analytics.amplitude.com/demo That's all I know. But maybe it would be a good idea if I could create some demo setups. I have an event data simulator, so I can build any dataset.
@TheGladiator123 2 ай бұрын
@@timodechau thank you for your response. I'm a Data Analyst eager to transition into a Product Analytics and Customer Journey focused Analytics Engineer role. I've noticed your extensive use of dbt in your video, which is impressive. I've already started taking courses on it. Could you please share your recommendations for my next steps? Any advice would be greatly appreciated
@timodechau 2 ай бұрын
It's not that easy to answer. Tooling and data model/prep are two parts of the job. The more essential part is understanding how to help a product team. This includes more knowledge about how product and product teams work. Maybe it is a good idea for a post that I should write.
@TheGladiator123 2 ай бұрын
@@timodechau Really appreciate that you replied also can't wait for that ♥️, BTW I built a simulator to practice the product analytics it simulate a streaming service ( Netflix) with All it's compents ut generate users Data, videos Wich is a part of a series, also i made marketing campaigns budget and social Media interaction to practice CLTV and CAC and of course users traffic Data on the platform to monitor users behavioral patterns I don't know why KZbin doesn't allow me to post the GitHub repository link here Is there any way to send the link for you!?
@TheGladiator123 2 ай бұрын
Brilliant ❤
@OronM 2 ай бұрын
Excellent video! if you are able to train the product team to use these tools properly and on their own that is amazing. usually they want the data team to build them the whole thing from A-Z.
@timodechau 2 ай бұрын
And this never can scale. And truth be told, they are the experts in their domain. They have so much background knowledge and will unlock much better insights.
@TheGladiator123 2 ай бұрын
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 ❤❤
@timodechau 2 ай бұрын
Thank you so much. Yes, you won't be famous with this kind of content. But that's what I like and I am so glad it helped you.
@TheGladiator123 2 ай бұрын
Hey man loved your explanation ❤❤ Need a further reading or anything that goes in depth Any suggestions??😅
@timodechau 2 ай бұрын
Unfortunately, not really. This is a good post: substack.com/home/post/p-143579364 and this one too: www.leverslabs.com/article/introducing-metric-trees But I am planning to run a weekly live format where I create metric trees - so keep your eyes out for it. Potentially I will start in August
@ahmedtaha917 2 ай бұрын
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
@timodechau 2 ай бұрын
Excellent. The docs are a bit vague, and I had to talk to Mixpanel directly to check out some things.
@abackhoff 3 ай бұрын
Hello! Thanks for sharing. What were the main services you offered to get your first clients? Is there a specific niche you would recommend?
@timodechau 2 ай бұрын
I basically did everything as a first project. This was helpful to also get an idea of how these different projects work, which ones are more risky, and which I like to do. I will keep this experimentation until today.
@abackhoff 2 ай бұрын
@@timodechau I already do some consulting, but I have trouble finding the types of clients that will generate enough value through analytics for them to pay what I'd like. Currently I offer building a simple but complete data infrastructure ELT with data pipelines, a data warehouse, dbt and any BI tool. What would you recommend me to reach more companies that could benefit from that? I'm in Mexico by the way, but I could sell remotely in the US or Europe if need be.
@rankaujjwal 3 ай бұрын
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!
@timodechau 3 ай бұрын
When I got your scenario right, I would solve it with events only, like a purchase event with the amount and the state providing the properties. This should get you the right calculation. It could also been done with user properties, but it would be not really efficient to do so.
@noel_g 3 ай бұрын
What tools did you use to record this video?
@timodechau 3 ай бұрын
Screen Studio does most of the magic!
@leonardolourencocrespilhoh511 3 ай бұрын
Hi, Timo. If you don't mind, could you increase the volume of the next videos a little? :)❣
@timodechau 3 ай бұрын
Thanks for the feedback - I need to check why it was like this.
@OronM 3 ай бұрын
Amazing video Timo! would love to see more content like this
@timodechau 3 ай бұрын
What kind of topics would you like to watch?
@TheGladiator123 2 ай бұрын
How about making a customer journey report for a more complex Data @@timodechau
@mabenba 4 ай бұрын
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?
@timodechau 3 ай бұрын
There are not many. www.activityschema.com is a good start. I have some other videos that touch on these topics as well.
@kovalerya 4 ай бұрын
Thanks for the video! It's useful 👍
@timodechau 4 ай бұрын
Glad to hear that!
@ashwinmahendran3518 4 ай бұрын
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.
@timodechau 4 ай бұрын
I published longer versions here: www.deepskydata.com/courses/snowplow-on-google-cloud-iglu-server www.deepskydata.com/courses/snowplow-on-google-cloud-2-the-pipeline
@harrykekgmail 4 ай бұрын
Excellent! I will recommend to my friends!! Thank you.
@timodechau 4 ай бұрын
Awesome, thank you!
@OronM 5 ай бұрын
Great video as always!
@timodechau 4 ай бұрын
Thanks! Let me know if you have any whishes for future videos.
@benniejacobs9246 5 ай бұрын
😜 Promo>SM
@ThatGuy_Nick 5 ай бұрын
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
@timodechau 4 ай бұрын
Concerning tools - it always depends on the project. Usually from a long list of data tools. First clients - Network. I told friends about my new services and asked them to look out for potential clients. By that, I got my first two projects.
@mabenba 6 ай бұрын
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!
@timodechau 6 ай бұрын
Thanks! Let me know what you would like to see in the next video.
@mabenba 6 ай бұрын
@@timodechau Your welcome! I am starting to use Mixpanel for a new project and your videos helped me a lot. I come from the BI world, mostly using Power BI. How would you face a project like the one you just showed using a BI tool instead of a tool like Mixpanel or Amplitude? Does it make sense to use another tool for reporting and visualization? It is not that I don't like Mixpanel, but it lacks in the board side.
@timodechau 6 ай бұрын
Any BI tool would do if you only want to report on the metrics and how they change over time. But if you want to understand the correlation between specific user behavior and subscription revenue you need a tool like Mixpanel.
@mabenba 6 ай бұрын
@@timodechau I am starting to get that feeling! Have you ever experimented with tree-based machine learning models to predict metrics, like MRR, only to find that the most significant connections are in the lower branches of the metric tree? For example, by using Shap values and models like Random Forest or XGBoost to uncover deeper insights.
@timodechau 6 ай бұрын
No - but this sounds extremely interesting. Did you do something like this?
@헬로월드-u1u 6 ай бұрын
Awesome! Thx! ❤
@avo-stefaniabje 6 ай бұрын
Community hero <3
@timodechau 6 ай бұрын
Thanks!
@noel_g 6 ай бұрын
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.
@OronM 6 ай бұрын
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
@timodechau 6 ай бұрын
You are absolutely right - I have one more video with the dark mode - but will make sure to use the white background in the new ones.
@mabenba 6 ай бұрын
The video we were all waiting for!!
@timodechau 6 ай бұрын
Let me know if you have any questions.
@mabenba 6 ай бұрын
@@timodechau I have millions of questions, but in part because I am new to Mixpanel and event-based analysis. Is there a resource you would recommend to learn more about all of this? Thanks for your amazing content Timo. I am already reading "Guide to product Analytics" from the Mixpanel team as well.
@arijit_ad 6 ай бұрын
Can you share the link to the previous video?
@timodechau 6 ай бұрын
Sure - here it is: kzbin.info/www/bejne/rJ25oXusgcermck
@mabenba 6 ай бұрын
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!
@keyspacemedia 6 ай бұрын
Mate! Such a good video! Thanks for all the insights. Would love to see a video about the constructed/virtual events / cohorts you mentioned!
@timodechau 6 ай бұрын
Thanks - let me think about it. This video got quite popular, so I should do more videos about it.
@pankajsaikia100 7 ай бұрын
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.
@timodechau 7 ай бұрын
Excellent. Great that it helped a little bit.
@erickfogtman 7 ай бұрын
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.
@timodechau 7 ай бұрын
Thanks - that is a lucky coincidence. Let me know if you can set it up at the end of the video.
@mabenba 7 ай бұрын
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?
@timodechau 7 ай бұрын
I would not recommend it. When you use something like Mixpanel, you want analyse sequences. Like customer journeys. This is not really possible with these tools. You can create a funnel viz, but you need to slice and dice it to find interesting segments and that is too much work in these tools.
@mabenba 7 ай бұрын
@@timodechau this totally makes sense. What about when you have product data from one platform (such a mixpanel to name an example) and marketing data from another platform (such as HubSpot)… should I make a unified report then or how can I join the data from different areas like in a metric tree? Sorry for all the questions!
@mabenba 7 ай бұрын
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.
@timodechau 7 ай бұрын
Thanks! This gap is my motivation - so please let me know if there are still some gaps after the next episodes.
@mabenba 7 ай бұрын
@@timodechau I am loving the idea of metric trees and all the related topics like this one. How do you make a data product out of these? I come from BI, and I can't imagine how a tree and it's relationships should be presented besides a static report.
@timodechau 7 ай бұрын
I will cover this in the next videos.
@TheR0yalBeast 7 ай бұрын
The outcome is the same but there is more resources thrown at data. Biggest difference.
@timodechau 7 ай бұрын
Yeah - this is still a significant issue.
@tkjekf 7 ай бұрын
Very informative video, thank you
@timodechau 7 ай бұрын
Thanks!
@niels_1608 7 ай бұрын
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?
@timodechau 7 ай бұрын
Thanks for your comment Niels. You can check out the board that Abhi was using here: miro.com/app/board/uXjVNq48sQI=/ There are some references for dimensions. But I am also thinking about the same thing. On a metric level, you can always define the dimensions, but sometimes you need them potentially across a set of metrics, which is more complicated.
@MickPerez-g2f 8 ай бұрын
🎯 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
@OronM 8 ай бұрын
Great video Timo!
@timodechau 8 ай бұрын
Thanks!
@FedericoNahmad-sy5qk 8 ай бұрын
Really good! This applies to every analytics tool! I invested poorly on training and ended up with 300 events.
@timodechau 8 ай бұрын
This is part of the process. I did so as well in the past. But in Mixpanel, you have good ways to manage it - merge or rename events, or just hide them.
@dilipkumarg9680 9 ай бұрын
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.
@timodechau 8 ай бұрын
A blueprint is a tricky business since a tracking plan always depends on a business. But I did this extensive free course here: www.deepskydata.com/courses/create-a-tracking-plan-for-airbnb
@justinmcclain6120 9 ай бұрын
Just started learning Mixpanel, super helpful tips, thanks!
@timodechau 8 ай бұрын
Awesome. Glad it helped.