Create Powerful Customer Segments for Marketing | Data Analysis for Beginners #4

Learn how to create a great marketing segmentation analysis and presentation to impress your managers with a RFM Model (Recency, Frequency and Monetary).

You will be to identify your most value customer and dormant customers to further customize your marketing campaigns for maximum effect.

Check me out on Linkedin

Video Contents:
0:14 Problem Statement
1:17 Dataset Exploration
2:46 Pivot Tables and Create Main Variable
5:57 Calcuating Recency
9:51 Using Percent Rank
14:49 Calculating RFM Scores
16:48 Creating Segments
20:00 Segment Analysis and Visualization
21:30 Presentation

You can find the dataset here for analysis:

#excel
#marketing
#dataanalysis
#segmentation
#clustering
#rfm

[MG-vkul]

Business + Technical, very Well done!!!

[minimumviablepizza]

This could by far be the most useful data tutorial I have watched and very applicable to all sorts of data sets if you think about your own customer base and what could be considered their recency, frequency and monetization measures. 🙏

[healyourstress]

Thank you so much sir I have been looking for this analysis from so long but none of the videos on you tube has given me that kind of insight..❤

[ErikS]

Hello, this video is really great and i want to thank you for doing it. A real time and effort saver.
I do have a question that makes me feel stupid, but in my dataset i have 639 customers, and i have done exactly like you do.

I dont understand why the percentrank make it so my scoring places like this: 30-27=10, 26-24=9, 23-21=8, 20-19=7, 18-17=6, 16-14=5, 13=4, 12-10=3, 9-8=2, 7-5=1, 4-1=0. Why is for example 14 alone with the score of 4? Is this correct?

Should it not be equal intervalls between the Scores 30-1, and the customers score individual score then places them in a interval that has equal amount of numbers in it?

I hope this makes sense, again great video, liked!

[jakobschwarz]

some dates are not recognized at dates and i get the value 0 for max invoice for all of them

[tracyewli-kwakutse]

What is happening when I change Invoice Date to max and all the numbers are 0 on excel and how do I fix this.

[careenevans]

How did you get the $7200 you concluded in the end and 10days average?

[buummip]

I used this method on our sales dataset but there's always blanks ("-") appearing in monetary and RFM score even though the scores for monetary, frequency, recency are complete. Could you tell me why?

[humanandlifefacts]

Throughout whole youtube I have seen most of the channels used similiar dataset . Can you pls do the same project using different dataset.

[opsdijz]

can some one help me while convering date to max in pivote im getting 0 insted of value and then changing to date give me date in 1900

[Juzz_RSA]

Thank you💯🔥❤️🇿🇦 can I please also ask for this done in python, would help me in my data analysis journey

[clintjakealfante]

Hello I got another question. How do you get the frequency? I downloaded the data set that is linked in the video but it doesn't have the frequency column. How do I get the frequency?

[clintjakealfante]

Where can I get the data that you used in the video?

[madhanbala]

Great content but please provide the dataset

[hildapurnamasari]

I just want to confirm, that RECENTCY is worse ---> if there are many ?