#Tableau

Подписаться 64 тыс.

Просмотров 15 тыс.

50% 1

In this tip, I’m show you how to calculate the 3-month and 6-month churn rate in Tableau. To calculate churn rate, all you need to do is:
1. Create 4 calculations
2. Follow the 8 simple steps to build the view
Customer churn rate is the % of customers that you’re losing in a predetermined time period.
Churn rate is bad because if you don’t know how many customers are leaving, then you won’t know the impact on your revenue and you would be able to make changes to reduce churn.
Download the workbook here - www.vizwiz.com/2022/12/churn-...
===============
ABOUT THIS CHANNEL
This channel is dedicated to making you great at Tableau and introducing you to careers and influential people in data.
SUBSCRIBE
/ andykriebel
MORE TIPS & INTERVIEWS
www.vizwiz.com/
www.dualaxispodcast.com/
FOLLOW ME ON SOCIAL
Get updates or reach out to get updates on my social media profiles!
Twitter: / vizwizbi
LinkedIn: / andykriebel
Facebook: / vizwiz
Spotify: spoti.fi/3Sw5i5D
Apple Podcasts: apple.co/3yj7y89
Google Podcasts: bit.ly/3yiz0mq
Amazon Music: amzn.to/3yk27Wy
===============
MY EQUIPMENT
** Blue Yeti Microphone
amzn.to/3SjnjCX
** Endurax 66" Video Camera Tripod
amzn.to/3F4ogMy
** iPhone 13 (camera)
amzn.to/3VP01YA
** Neewer® 700W Professional Photography 24"x24"/60x60cm Softbox for Lighting
amzn.to/3VJLoGa
===============
CREATE GREAT RU-vid CONTENT
🎬 Part-Time RU-vidr Academy - Ali Abdall's 6-week live online course on becoming a part-time RU-vidr
ptya.samcart.com/referral/IKj...
📚 More great courses from Ali
ptya.samcart.com/referral/7he...
===============
DISCLAIMER
This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. Proceeds go to producing content for this channel.

Наука

Опубликовано:

2 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 67

@MrLauroRibeiro Год назад

You are a STAR!! Thank you so much! Yes, Please, teach us as much as you can!!

@vizwiz Год назад

More to come!

@michaelfajemilehin1793 Год назад

Thank you Andy

@scott_strool Год назад

awesome, so helpful

@yusufismail3239 2 месяца назад

Wow this is so useful, thanks appreacite it!

@Beny123 Год назад

Appreciate how efficiently you've done this.

@vizwiz Год назад

Thanks!

@leonardocerliani3479 Год назад

Fantastic video as always. And thanks especially for the final tip about parametrization!

@vizwiz Год назад

You’re welcome

@rohanrasquinha7514 8 месяцев назад

great dashboarding skills. simple and concise. Hats off from data analytics guy

@shailendrakumar08 Год назад

Amazing 💯

@vizwiz Год назад

Thanks for watching

@moxie1189 Год назад

Great Job, Andy. Can we please see the parameterised version?

@jboyd3737 Год назад

Thanks so much for these! parameter video would be great!

@vizwiz Год назад

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?

@nagan3110 Год назад

hi andy, please do custom churn rate with paramaters

@louisadibe3189 4 месяца назад

Cool

@melindagroffman9991 5 месяцев назад

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?

@newbs825 11 месяцев назад

OMG Excellent Video and it was so easy to follow along. Do you by any chance have a video for Rentention Rate similar to this?

@vizwiz 11 месяцев назад

I do indeed. #Tableau - Calculate Customer Retention & Cohort Analysis ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PwL8EySm8Yo.html

@diannegillam8788 Год назад

Hi Andy, this is awesome. 1 question thou. How would I do this if I had a parameter showing the financial year and calendar year?

@mazharshaikh7965 Год назад

Please create the video for custom churn rate, Thanks

@gauravdeore931 Год назад

Hey Andy, Always Inspire by your new learning videos. Thanks you so much :) Can we use "FIRST()>= -2 " to hide First 3 Data points.

@vizwiz Год назад

Yes you can! Great job! You would exclude TRUE in that case.

@aayushironside3506 Год назад

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

@vizwiz Год назад

Are you able to give more detail about the part that wasn't clear? Also, what would you have said differently? That would be helpful to me.

@viyer22 Год назад

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?

@statistikochspss-hjalpen8335 Год назад

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?

@JensGrafe-rc4fw Год назад

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?

@nanjunchen2857 4 месяца назад

Agree! That’s exactly what my concern is about this calculation.

@jeromevanbeek9070 Месяц назад

Agree. This is my concern as well. Churn rate doesn't seem to be right this way.

@igorstanisic5380 4 месяца назад

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.

@islamelkhateeb6524 Год назад

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?

@vizwiz Год назад

Correct!

@RonBenZeev Год назад

Hey ! Can you create a video calculate Customer life time value? this would be amazing!

@vizwiz Год назад

Great suggestion! I'll add it to my list.

@abchowdhury9152 8 месяцев назад

I dont have any data for the date or time period!

@zenmode216 2 месяца назад

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!

@simonsoltanian4035 Год назад

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.

@vizwiz Год назад

I don't have data for that.

@simonsoltanian4035 Год назад

@@vizwiz I can share with the data set. Please have a look at it. drive.google.com/file/d/10AG35cHs-BG8wajwBgsIIVYPBcvpP-Qc/view?usp=share_link

@mdhruv1 Год назад

Could we also get something similar for support cases . New cases ,case being worked ,cases closed, cases rejected

@vizwiz Год назад

Of course! It should be a similar method. Swap out your dimensions for what I demo.

@kbystryakov Год назад

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.

@vizwiz Год назад

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.

@kbystryakov Год назад

@@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.

@JP_-oq3xn Год назад

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?

@vizwiz Год назад

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.

@JP_-oq3xn Год назад

@@vizwiz You’re simply amazing! Thank you so much for the advice!

@vizwiz Год назад

@@JP_-oq3xn my pleasure!

@Andrerival13 Год назад

Is there dynamic date parameter churn rate with score card

@vizwiz Год назад

I don't understand.

@josephubbarapu8885 Год назад

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.

@vizwiz Год назад

I believe this has been answered on the forums. Have a look there.

@josephubbarapu8885 Год назад

@@vizwiz Thanks for reply Andy.. I checked the forums also but did not get the right answer. Please help me out on this. My work has been stuck.

@RonBenZeev Год назад

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?

@vizwiz Год назад

Try making the country filter a context filter.

@sergejlust9334 11 месяцев назад

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

@TheJohnwadebaker Год назад

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?

@viyer22 Год назад

He is using a distinct count (COUNTD) of customer names.

@vizwiz Год назад

The COUNTD will only count each customer once.

@JensGrafe-rc4fw Год назад

@@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?

@RobinFay-pi8vu Год назад

@@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.

@mcavazosp Год назад

@@JensGrafe-rc4fw I found the same issue, were you able to find a way to only count one customer per month?

@lanvinsgivenchy5421 Год назад

No wonders powerbi is far , far , far in front of tableau , what takes 20 secondes on powerbi takes 10 minutes on tableau !

@vizwiz Год назад

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.