Is the distinct count correct? You first count the distinct numer for each month an then use the window sum function. If a customer bought in two month would you not count him twice?
How can I calculate the churn if a customer is paying a flat fee for my service and, depending on the service, they could be an active customer for 2+ years?
Can we have a negative retention value? I think with this formula, if there are new users acquired, will might get a negative retention. I can be wrong!
Hey Andy, since, I am beginner It's hard to interpret what's going on, on that viz. Little bit of explanation would have add so much value to it. Waiting for another video on customer churn. Thank you
With all due respect, this is just a nice example of calculating the moving ratio of the number of customers in the first half of the period to the whole period. This example does not calculate the number of customers who have left the company, gone into full churn, and no longer plan to do business. The real customer churn rate is calculated using a different method.
What method is that? I'd like to know what I did wrong. As for those that no longer plan to do business, that's impossible to know for any business. A customer can always come back.
@@vizwiz Andy, thank you for your quick response. I fully share your opinion that it is impossible to know if a client is lost or not. Even the client himself does not know whether he will continue working with the company next year or not. - The method that I want to give as an example requires that company managers are not afraid to admit the fact that the company loses customers regularly. - This method is suitable for companies that operate in the transactional b2b market, without obligatory contracts with clients. - To get a more accurate result, you need to have information on orders for a period of two years or more. Step 1: Define clearly Who the company's Active (Operating) customer is. For example, we recognize a client as active (operating) if No More Than 6 Months have passed from the date of his last transaction to the date of the report. Step 2. Calculating number of active (operating) customers - We calculate the number of active (operating) clients at the beginning of the reporting period (for instance, a quarter). Let's call it "AC-Start". - Similarly, count the number of active (operating) clients as of the last date of the quarter and subtract the number of new clients acquired during that quarter. Let's call this metric "AC-End-Net". Step 3. Calculate the customer churn rate (CCR) CCR = ( [AC-End-Net] - [AC-Start] ) / [AC-Start] Note: For these numbers to make business sense, it is highly recommended to segment the CCR number. For example, calculate the CCR for each region separately. Or pre-segment the customer base by the average duration of the interval between purchases.
Does the 60-day Churn rate represent: 1) The percentage of customers who left during the last 60 days relative to the total number of customers 60 days ago. 2) The percentage of customers who were active within the first 60 days and left during the last 60 days, relative to the total number of customers 60 days ago. This clarifies whether the churn rate is based on the total customers who left in the last 60 days or specifically those who were active in the initial 60 days of their contract.
Love this thank you for this and all of your videos. Question, for me I would have to do something more complex ie looking at guest ids in the 6 month but not in the 3 month and vice versa (ie new customers). Any suggestions on how to approach that in Tableau?
Please correct me if I am wrong but it seems there are 2 mistakes in the video: - recurring customers aren't taken into account - percentages aren't calculated correctly
Hey Andy, awesome video!! Thank you! I have a small doubt about this chart. If I acquire 200 customers in a 3 month window and if I am losing 100 customers in that same window, my churn will be negative. Is there some way we can prepare a chart that factors in the new acquisitions when calculating churn?
This video is great. Could you explain why you in 2:07 when calculating the churn rate are taking customers from the last 6 month - customers from the 3 months? 3:50 how is the 3 month churn rate and number of customers from the last 6 month related? 4:00 where does the 12 months come from? Why 12 months when you said let's calculate the 6 months churn rate?
Also I once I put a fillter for country when I choose only one country its fillter the presentage lower then 100% . only when I choose all countries it show 100%. How should I approach this?
Thanks Andy, amazing to the point illustration. what if I want to calculate churn rate for a month over month, what I need to put in windows function instead of -2, is it -1?
Hi.. I have a question. In filters (wildcard search) , we have to give certain constraints 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.
Hi Andy, thanks this is really good. Can you please create for the SaaS products? I think the way we can do SaaS products is different. Due to the active and canceled products, we cannot get a churn rate.
How about this? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-opfVV1maNVw.html You can also search the channel for "parameters" and you'll find lots more. Does that help?
I’m trying to understand the L3M and L6M calculations… it seems like if you have the same 100 customers over the entire history the calcs would give you 300 and 600 respectively. This would give you a 50% churn rate, which isn’t correct. You would want to know how many distinct customers exist over the 3 and 6 month periods (100 and 100 in my example), not the sum of the count in each month, right?
@@vizwiz but the COUNTD will only count it per month. The WIND_SUM will then only count the COUNTD per month. What if a customer bought two times? Then he will be counted twice?
@@vizwiz I'm finding the same as @JensGrafe if you have a customer with multiple purchases it's summing the count by month and over stating the number of customers.
A question for seasoned Tableau practitioners, what are the tips you could give to those who are new to Tableau? Also, what keeps you motivated or how do you keep motivated to learn more about tableau?
Simple, practice. That’s the only way to get better. Other than that, find people who’s work you like and follow them. Download workbooks you find interesting and see how they were created. Participate in community projects like Makeover Monday; this will give you practice every week. Check out the Tableau Starter Kit too. It has a really useful guide.
For some things yes, for others no. I can think of tons of things that are painstakingly difficult in PBI. No tool is perfect. They each have benefits, which is great for all of us.