3. Create a user Data & RFM Scores spreadsheet and plug in the customer data to get their RFM scores.

Take the data you got in the previous step and compile it in a single spreadsheet. Your customer’s RFM score will be a sequence of three numbers, representing Recency, Frequency, and Monetary respectively, and between 1 and 3. For example, 2-2-1, 3-1-2, 1-1-3. To get the first score (R), order your customers by Recency. Now divide them into three equally sized cohorts: one of the cohorts will contain 1/3 of customers who bought most recently (top cohort). Another cohort will contain 1/3 of customers who bought least recently (bottom cohort). The remaining 1/3 will be your middle cohort. Give each cohort a Recency score between 1 and 3, where 1 is the best score given to all customers in your top cohort, 2 is the middle score given to all in the middle cohort, and 3 is the worst score given to all in the bottom cohort. To get the second score (F), order your customers by Frequency. Divide them into three equally sized cohorts as you did for Recency. Give them a score between 1 and 3. After that, do the same to find the third score: Monetary (M). After calculating all three scores each customer had on Recency, Frequency, and Monetary, concatenate the three numbers to get the RFM score of each customer.

5. Analyze the RFM cohorts of the top 10% LTV customers to identify general practices you can apply to your marketing and sales strategies.

Recency: Check how much time on average has passed since the top 10% of customers made their last purchase. This is your window of time from a user’s last purchase in which you can re-engage them and get them to purchase again. Frequency: Check how often the top 10% of customers buy. Use this information to assess how often you should impact customers with marketing and sales initiatives. Monetary: Check how much revenue the top 10% of customers made. Investigate the types of product that these customers most commonly purchased. Use those products to create campaigns and offers. Increase customer LTV by analyzing your customers’ buying behavior and offering promotions that match their existing behavior.

6. Order your customer list by LTV, then create a segment from the top 10% of customers in Google Analytics and analyze the most profitable customer behavior patterns.

Use the User IDs from the customers who belong in the top 10% in terms of LTV to create a segment in Google Analytics that will enable you to track the user journeys and purchasing behavior of your most profitable customers. Apply the segment. Check the following aspects: How they navigate – Behavior Flow and Goal Flow reports. The amount of time they spend on each funnel page. The products they buy. Which device they use to access. Their screen resolution.

7. Conduct an internal examination of your business goals and decide on short term vs. long term profitability.

To optimize for short term profit, focus on initiatives to improve the Recency and Frequency of customers who have scores of 2 or 3 in these parameters. To optimize for long term profit, focus on initiatives that improve the scores of parameters similar to the ones you found on the top 10% LTV customers.

8. Create test campaigns and optimize your sales funnel using RFM data.

To optimize for Recency: target customers with a Recency score of 2 or 3 by creating activation campaigns with limited timeframes, using elements of scarcity and urgency in your offers. Create landing pages with pop-ups and other micro-conversion elements that highlight the importance of purchasing now. To optimize for Frequency: offer benefits for customers who purchase often (e.g. customer loyalty programs). Push campaigns for customers with a Frequency score of 2 or 3 offering items that complement the ones bought before, accessories, small add-ons, replacement parts, “customers who bought this also bought…”. Optimization of the Monetary parameter is an indirect consequence of optimizing Recency and Frequency.