Комментарии:
Wow, this is incredibly intuitive! ❤
Ответитьдядя ты крутой! спасибо!
ОтветитьVery helpful video on Cohort analysis
ОтветитьIn terms of an employee retention cohort chart. I would like to do difference between hire date and termination date for the elapsed months. It does the calc correct for the ones who have termination dates but doesn’t display the months that don’t have any terminations. I’d like to show all months across the top regardless of if they have a termination. Any thoughts?
Ответитьthank you. super useful
ОтветитьHow to change the date format of data update time... I don't want time with data refreshed date.?
ОтветитьHey Andy, I understand the Retention Rate graph but I am getting lost on the point of the Elapsed Quarters Graph. What exactly is the graph is trying to relay? it seems the exact same as the retnetion graph except now the triangle is angled another way with the same results. the top header shows 1,2,3 etc instead of the Quarter names. Is that the only point of showing the retention graph as an elapsed graph?
ОтветитьThanks a lot
One question: how to rename "Field Labels for Rows"? I can only hide them
Hi Andy,if I want to highlight the quarters when the customer make use the product by using another graph when I can select the single customer how should I implement that? I tried to add the customer as attribute but doesn't work
Ответитьthank you so muchhh!
ОтветитьHi how fill empty cells to 0 or relevant data using lookup
ОтветитьPerfect video, i loved
ОтветитьVery good lesson. Just one question: The line chart you created at the last, is it telling the cumulative retention rate or the average retention rate?
ОтветитьHow can I do this using a running total retention? Meaning the number can only increase every elapsed quarter
ОтветитьDear Andy. Thank you very much. But you have exact order date as information. How to do if I have several purchase by one customer in a different dates. How could I sort it as a first purchase date ?
Ответитьhow to show quarter labels instead of 0,1,2 ?
Ответитьsuper helful
ОтветитьThanks Andy, do you have a way of analyzing the cohort from the first day they started? In my instance, I'm using term (Education), so date difference wouldn't work here. The cohort's first term is their cohort name like 202008 which I'm trying to compare against 202108's first term. I'm thinking a partition might be necessary but wanted to reach out first.
ОтветитьIs there a resource somewhere that explains the why and what more for these types of calculations?
ОтветитьHey Andy, I want to thank you for this super helpful video! Your instructions were very clear. I have an enhancement to the retention rate line graph that makes it more accurate by taking the average of the retention rates for each cohort at the given length of time from when they first purchased.
AVG(
{ FIXED [Customers First Purchase Quarter],[Elapsed Quarters]:
COUNTD([Email])
/
sum([Customers per First Quarter])}
)
Can we do this in looker studio
Ответитьcan you share the sample data to follow up
ОтветитьThanks Andy. Really great easy to follow tutorial. So useful for marketing teams as well.
Ответитьthakyou very helpful!
ОтветитьCan we change customer id if we dont have customer name?
ОтветитьShort, Clear, and Straight to the Point. Excellent.
ОтветитьThankyou Andy, what if I want to add a new table at last of cohort table that explain the average of retention rate through out the year? Is it possible? If yes then how to make it? Thankyouuu
ОтветитьAndy, It help a lot. But why the screen zoom in and zoom out while recording those session. it put extra pressure while watching those videos
ОтветитьThis is a masterpiece. Thanks!
ОтветитьAndy! You are very helpful for me i have learnt lots of things to watching your videos. Now please give me some advice for the interview and tell me about the best company were i can join as an experience Data Analyst, Thanks
ОтветитьThank you, Andy! You are a legend.
ОтветитьAmazing Sir
ОтветитьThis one is great, thank you
ОтветитьHI... I have a question.
In filters (wildcard search) , we have to give certain constraint that the user needs to select a minimum of 3 to 4 chars/nums in the wildcard search. then only the related info needs to display in the dashboard.
Issue:- if the user enters 1 char also then the data is displaying and there will be large info.... starts with and ends with will not work out here because there will be multiple id's which starts with different numbers.
Great! Thank you Andy, Is there a tutorial on how to rename column, for example the Quarter of.... column.
ОтветитьWow Andy, another magnificient lesson, so happy to learn with you. i am going to share this video on LinkedIn. Kind Regards from Costa Rica.
ОтветитьHey Andy, thanks. Can you please create an example of churn rate per month for customers?
ОтветитьExcellent 👌 Like usual ... Very actionable. Many Thanks Andy !
ОтветитьAndy, can I PM you through our Tri team. I run a data and analytics function as part of my remit and I’d like to chat?
ОтветитьVery innovative. Thank you for this tip as always.
Happy Christmas.
This was great some nifty features I could leverage in my next build. Thanks, Andy!
ОтветитьStill remember how excited when I first learned how to do Cohort analysis in Tableau using LOD back then... It's insanely HELPFUL!
As someone who oversees several EC stores' BI analytics, Cohort & Retention analysis is one of the essential I run regularly... at the end of the day, it all comes down to RETENTION, RETENTION, RETENTION!