Home Customer Analytics — RFM, Cohorts & LTV

Customer Analytics — RFM, Cohorts & LTV

Vikas Bansal
By Vikas Bansal
10 articles

Industry Benchmarks — compare to peers

What are Industry Benchmarks? The Industry Benchmarks dashboard compares your store's key retention and LTV metrics against anonymized, aggregated data from other Shopify merchants in your industry and currency. This helps you understand whether your performance is above average, on par, or below your peers. You will find this dashboard under Benchmarks in the sidebar. How Benchmarking Works Datadrew calculates benchmarks using anonymized data from all stores on the platform that share your industry category and currency. Your store is compared against three percentile groups: | | | | | --- | --- | --- | | Percentile | Label | What It Means | | P75 and above | Top 25% | Your metric is in the top quartile — you are outperforming most peers | | P25 to P75 | Average | Your metric is within the middle range — typical performance | | Below P25 | Bottom 25% | Your metric is in the lowest quartile — there is room for improvement | A minimum of 4 comparable stores is required to generate meaningful benchmarks. If your industry/currency combination has fewer stores, benchmarks may not be available yet. What Metrics Are Benchmarked The benchmarks dashboard covers five key areas: 1. Growth Benchmarks Revenue growth trends compared to your peers, showing month-over-month or quarter-over-quarter performance. 2. LTV Benchmarks Compare your AOV, 1-month LTV, 3-month LTV, 6-month LTV, and 1-year LTV against industry percentiles. The chart shows your values as a dark line, with colored bands representing the Top 25% (green), Average (yellow), and Bottom 25% (red) ranges. 3. Repeat Customer Benchmarks Compare your 1-month, 3-month, 6-month, and 1-year repeat customer percentages against the industry. This tells you if your retention is competitive. 4. Customer Frequency Benchmarks A radar chart comparing your distribution of 2-timers, 3-timers, 4-5 timers, and 5+ timers against the industry average. This shows whether your customer base is more or less loyal than typical. 5. RFM Segment Benchmarks Compare your RFM segment distribution (Champions, Loyal, Promising, New Customers, Need Attention, Should Not Lose, Sleepers, Lost) against industry averages. This helps you gauge the overall health of your customer base. How to Read the Dashboard Each benchmark section includes: - A chart — Line charts for LTV and retention, radar charts for frequency and RFM. Your data appears as a dark line; industry bands are color-coded. - A comparison table — Click "See Table" to view exact values for You, Top 25%, Average, and Bottom 25% side by side. Your values are color-coded: green (Top 25%), yellow (Average), or red (Bottom 25%). - A metric tip — A summary indicator at a glance telling you where your key metric falls relative to the industry. Key Insights to Look For - LTV vs Industry — If your 1-year LTV is in the Bottom 25%, focus heavily on retention strategies before scaling acquisition. - Repeat Rate Gap — A low repeat rate compared to peers means you are leaving revenue on the table. Invest in post-purchase email flows and loyalty programs. - Frequency Distribution — If your 2-timer percentage is below average but your 5+ timer percentage is above average, you have a strong loyal core but struggle with converting first-time buyers into repeat customers. - RFM Health Check — A Champions percentage above industry average is a strong signal. A growing "Lost" segment relative to peers is a red flag. Actions to Take - Use benchmarks to set realistic, data-driven targets for retention and LTV improvement. - If your LTV is below the 50th percentile, prioritize retention over acquisition — it is more cost-effective to grow value from existing customers. - Share benchmark data with your team to create alignment around retention goals. - Revisit benchmarks quarterly to track whether your improvement efforts are moving you up the rankings. Need help? Contact us at support@datadrew.io or use the in-app chat. Related articles - Industry benchmarks and competitive context - Location Cohorts — geographic analysis - LTV Cohort Analysis - Feature comparison across plans Need help? If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.

Last updated on Jul 07, 2026

Location Cohorts — geographic analysis

What are Location Cohorts? Location Cohorts segment your customers by their shipping address — country, province/state, or city — and then track their lifetime value, repeat purchase rates, and purchase frequency by geography. This helps you understand which markets produce your most valuable customers. Location Cohorts are available as a breakdown option within both the Cohort Analysis and Purchase Frequency dashboards. How to Use Location Cohorts 1. Navigate to Lifetime Value > Cohort Analysis or Lifetime Value > Purchase Frequency. 2. In the controls panel, change Breakdown By to one of: - Shipping Address Country — Groups customers by country - Shipping Address Province — Groups by state or province - Shipping Address City — Groups by city 3. The heatmap will now show each geographic region as a row, with columns showing how those customers behave over subsequent time periods. What You Will See - Cohort Size — How many customers are in each geographic region. - Revenue by Period — How much revenue each location cohort generates over time. - Cumulative LTV per Customer — The lifetime value of customers from each region. - Repeat Rate — What percentage of customers from each region make a second purchase. - Purchase Frequency — How orders distribute across 1-timer, 2-timer, 3-timer, etc., by location. Key Insights to Look For - High-LTV regions — Some countries or states consistently produce higher LTV customers. These are your best markets for scaling ad spend. - Retention by geography — Do customers in certain regions have notably higher repeat rates? This could indicate better product-market fit in those areas. - Expansion opportunities — Regions with small cohort sizes but high LTV per customer suggest untapped potential. Consider increasing marketing investment there. - Low-value markets — If certain regions have large cohort sizes but very low LTV and repeat rates, you may be overspending on acquisition in those areas. Actions to Take - Increase ad budget allocation to regions with the highest 6-month and 12-month LTV per customer. - Create region-specific marketing campaigns and landing pages for your top-performing markets. - Investigate why certain regions underperform — consider factors like shipping costs, delivery times, and currency differences. - Use city-level data to optimize local marketing efforts or identify potential locations for pop-up events. - Combine location cohorts with product breakdowns in the filters to find which products perform best in specific regions. Combining with Filters For even deeper analysis, combine location breakdowns with the Refine Cohorts filters. For example, you can view location cohorts while filtering by a specific product type or customer tag. This helps you find region-product combinations that drive the highest value. Need help? Contact us at support@datadrew.io or use the in-app chat. Related articles - LTV Cohort Analysis - Industry Benchmarks — compare to peers - Supported currencies and multi-currency stores - Purchase Frequency dashboard Need help? If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.

Last updated on Jul 07, 2026

Why cohort analysis is the best way to calculate LTV

Why Cohort Analysis is the Best Way to Calculate LTV Many Shopify merchants calculate customer lifetime value using simple averages — total revenue divided by total customers. While quick, this method is deeply misleading. Cohort-based LTV analysis is the gold standard because it accounts for how customer value evolves over time. The Problem with Simple LTV Averages A simple average LTV lumps all customers together — the customer who joined yesterday with the customer who has been buying for three years. This creates several problems: - Mixing maturity levels — New customers drag down the average because they have not had time to make repeat purchases. You end up undervaluing your customer base. - Hiding trends — If your retention is improving (or declining), a blended average will not show it. You cannot tell if recent customers are behaving differently from older ones. - Inaccurate acquisition budgets — If you base your Customer Acquisition Cost (CAC) target on a blended LTV, you might be overspending or underspending on acquisition. How Cohort-Based LTV Works Cohort analysis solves these problems by grouping customers by when they first purchased, then tracking each group separately over time: 1. Group customers by acquisition month — All customers who made their first purchase in January 2025 form the "Jan 2025" cohort. 2. Track cumulative revenue per customer — At the 1-month mark, 3-month mark, 6-month mark, and so on, calculate how much revenue per customer each cohort has generated. 3. Compare cohorts side by side — You can now see whether your January cohort is more valuable than your October cohort, and at what time horizon. What Cohort LTV Tells You That Averages Cannot - True payback period — You can see exactly when a cohort's cumulative LTV exceeds the CAC for that period. This is the real payback window for your ad spend. - Retention trajectory — Are customers making their second purchase faster? Are newer cohorts generating more revenue in their first 3 months? Cohort analysis shows the trend. - Seasonal effects — Holiday cohorts (Black Friday, Christmas) often have lower long-term LTV because many are one-time gift buyers. Cohort analysis reveals this clearly. - Campaign effectiveness — If you ran a major campaign in March, you can isolate the March cohort and see if those customers are retaining better or worse than other months. A Practical Example Suppose your blended average LTV is $85. That sounds good, but when you break it into cohorts: | | | | | | --- | --- | --- | --- | | Cohort | 3-Month LTV | 6-Month LTV | 12-Month LTV | | Jan 2025 | $52 | $71 | $95 | | Apr 2025 | $58 | $82 | $110 | | Jul 2025 | $45 | $60 | Still growing... | | Nov 2025 | $62 | Still growing... | Still growing... | Now you can see that the April cohort is significantly more valuable than January, and you can investigate what drove that improvement. The blended $85 average told you none of this. How Datadrew Makes This Easy In Datadrew, the LTV Cohort Analysis dashboard automatically: - Groups customers by acquisition period (week, month, quarter, or year) - Calculates cumulative LTV per customer for each cohort - Displays a color-coded heatmap so you can visually spot strong and weak cohorts - Shows a weighted average row at the bottom for overall benchmarking - Includes CAC data when you have Meta Ads or Google Ads connected - Lets you break down cohorts by product, location, or customer attributes to find even deeper insights The result: you get an accurate, actionable picture of customer lifetime value that evolves as your business grows. Need help? Contact us at support@datadrew.io or use the in-app chat. Related articles - LTV Cohort Analysis - LTV and cohort analysis with Drew AI - Purchase Frequency dashboard - Product Cohorts Need help? If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.

Last updated on Jul 07, 2026

Product Cohorts

What are Product Cohorts? Product Cohorts segment your customers by the first product they purchased, then track their lifetime value and repeat purchase behavior over time. Instead of grouping customers by when they bought (like the standard cohort analysis), product cohorts group them by what they bought first. This helps you answer critical questions like: Which products bring in the highest-LTV customers? Which product is the best "gateway" to repeat purchases? Product Cohorts are available as a breakdown option within both the Cohort Analysis and Purchase Frequency dashboards. How to Use Product Cohorts 1. Navigate to Lifetime Value > Cohort Analysis or Lifetime Value > Purchase Frequency. 2. In the controls panel, change Breakdown By from "Acquisition Period" to one of: Product Title, Product Type, Product Vendor, SKU, or Product Tags. 3. The heatmap will now show each product (or product type/vendor) as a row, with subsequent columns showing revenue or purchase behavior over time. What You Will See - Cohort Size — How many customers made their first purchase with each product. - Revenue per Period — How much revenue each product cohort generated in subsequent months. - Cumulative LTV — The total lifetime value per customer, broken down by which product they purchased first. - Repeat Rate — What percentage of each product cohort made a second purchase. Key Insights to Look For - Gateway Products — Products that lead to the highest 3-month or 6-month LTV are your best gateway products. Feature these prominently in acquisition campaigns. - High Volume but Low LTV — If a product attracts many first-time buyers but they rarely return, it may be a deal-driven or commodity product. Consider how to improve the post-purchase experience for these buyers. - Product Type Patterns — Use the product type breakdown to see if certain categories attract higher-value customers overall. - Single Product Orders — Enable the "Single Product Order" filter to isolate the impact of each product when it is the only item in the order. Actions to Take - Allocate more ad budget to products that generate the highest long-term LTV, not just the most first-time sales. - Create cross-sell email sequences for low-LTV product cohorts to encourage a second purchase. - Use high-LTV gateway products as lead magnets in acquisition campaigns. - If certain product types bring in one-and-done buyers, reconsider whether they belong in your paid advertising mix. Need help? Contact us at support@datadrew.io or use the in-app chat. Related articles - LTV Cohort Analysis - Product Performance dashboard - Purchase Frequency dashboard - Why cohort analysis is the best way to calculate LTV Need help? If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.

Last updated on Jul 07, 2026

Purchase Frequency dashboard

What is the Purchase Frequency Dashboard? The Purchase Frequency dashboard (also called Transaction Frequency) shows how your customers distribute across different order counts. For each cohort, it answers the question: what percentage of customers placed exactly 1 order, exactly 2 orders, exactly 3 orders, and so on? This dashboard is found under Lifetime Value > Purchase Frequency in the sidebar. How to Read the Dashboard The dashboard displays a frequency heatmap where: - Rows represent cohorts (grouped by acquisition period, product, vendor, or other breakdowns) - Columns represent transaction counts (1 txn, 2 txn, 3 txn, etc.) - Cells show either the number of customers or the percentage of the cohort that reached that purchase frequency Each row also shows the cohort size (number of new customers acquired in that period). Dashboard Controls - Acquisition Period — Set the date range for cohort creation. - Group By — Choose week, month, quarter, or year grouping. - Breakdown By — Segment by acquisition period, product title, product type, vendor, SKU, product tags, shipping country, province, city, order tags, or customer tags. - Frequency Range — Choose to display up to 5, 10, 15, or 20 transaction columns. - Single Product Order — When using product-based breakdowns, enable this to count only orders containing a single product. - Format — Toggle between absolute values and percentages. - Filters — Refine cohorts by product, location, tags, and more. Key Insights to Look For - 1-timer dominance — If 80%+ of customers are one-time buyers, you have a retention problem. Focus on post-purchase engagement. - 2nd purchase rate — The jump from 1 to 2 orders is the hardest. Track this closely — even a small improvement in your 2nd-purchase rate can dramatically increase overall LTV. - High-frequency tail — If a meaningful percentage of customers reach 5+ orders, you have a strong loyalty base. These are your most valuable customers. - Product-driven frequency — Use the product breakdown to find which products drive repeat purchases. Products that appear frequently in 2+ transaction cohorts are great for acquisition campaigns. Actions to Take - If most customers stop at 1 order, create a post-purchase email sequence timed to arrive before the average time to second order. - Identify which products have the highest 2nd-purchase conversion and feature them in acquisition campaigns. - Use location breakdowns to see if certain regions have naturally higher repeat rates — these may be better markets to invest in. - Export the data to combine with your email marketing segments for targeted reactivation campaigns. Exporting Data Click the Export CSV button to download the frequency heatmap data for offline analysis or reporting. Need help? Contact us at support@datadrew.io or use the in-app chat. Related articles - LTV Cohort Analysis - RFM Segmentation - Product Cohorts - Product Repurchase Rate analysis Need help? If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.

Last updated on Jul 07, 2026

RFM Segmentation

What is RFM Segmentation? RFM stands for Recency, Frequency, and Monetary — three dimensions that measure customer behavior: - Recency — How many days since the customer's last order - Frequency — How many total orders the customer has placed - Monetary — How much the customer has spent in total Each customer is scored 1 to 5 on each dimension (5 being the best), and these scores are combined to place every customer into one of 10 segments. This gives you a clear, actionable picture of your customer base. You will find the RFM Segmentation dashboard under Customers > RFM Analysis in the sidebar. The 10 RFM Segments | | | | | --- | --- | --- | | Segment | Description | Recommended Action | | Champions | Bought recently, buy often, and spend the most | Reward them with VIP perks, early access, and referral programs | | Loyal | Buy regularly with above-average frequency and spend | Upsell premium products, invite to loyalty programs | | Promising | Recent customers with moderate frequency — showing growth potential | Nurture with personalized recommendations to increase purchase frequency | | New Customers | Made their first purchase recently | Onboard with welcome sequences, educate about your product range | | Need Attention | Previously active customers whose recency and frequency are declining | Re-engage with targeted offers before they slip away | | Should Not Lose | Were high-value customers but have not purchased recently | Win them back with personalized outreach and exclusive deals | | Sleepers | Low recency and frequency — becoming disengaged | Send reactivation campaigns with strong incentives | | Lost | Have not purchased in a long time and had low engagement | Consider sunset campaigns; focus budget on higher-value segments | | Warm Leads | Moderate scores across all dimensions — could go either way | Increase touchpoints and provide social proof to encourage next purchase | | Cold Leads | Low scores across all dimensions | Low-cost reactivation attempts; reallocate marketing spend to better segments | How to Read the Dashboard The dashboard has two main views: 1. Summary View — Shows a treemap visualization of all 10 segments sized by customer count. Each segment displays the number of customers and their percentage of your total customer base. Below the treemap, you can connect Klaviyo to automatically sync segment tags. 2. Segment Details View — Click on any segment in the left sidebar to see a detailed customer table for that segment. Each row shows the customer's name, email, phone, RFM score, total spend, last order date, and total orders. Dashboard Controls - Period — Choose between "All Time" or "Last 1 Year" to adjust the time window used for RFM scoring. - Segment Selector — Click any segment in the sidebar to drill into its customer list. - Klaviyo Integration — Connect your Klaviyo account to automatically tag customers with their RFM segment. Enable weekly sync to keep tags updated. - Export — Export the customer list for any segment as CSV or XLSX. Key Insights to Look For - Champions + Loyal percentage — The combined percentage of Champions and Loyal customers tells you how strong your core customer base is. Aim for 15-25% or higher. - Need Attention + Should Not Lose — These are customers at risk of churning. A growing percentage here is a warning sign. - New Customers segment size — This reflects your acquisition velocity. If it is shrinking, you may need to invest more in top-of-funnel marketing. - Lost segment growth — If the Lost segment keeps growing, your retention strategy needs improvement. Klaviyo Sync When you connect Klaviyo, Datadrew can automatically tag each customer with their RFM segment in Klaviyo. This allows you to: - Build targeted email flows for each segment (e.g., win-back campaigns for "Should Not Lose") - Create segment-specific Klaviyo audiences - Schedule weekly automatic tag updates to keep segments current Benchmarks Navigate to the Benchmarks page to compare your RFM segment distribution against industry averages. This helps you understand if your Champions percentage is above or below similar Shopify stores. Need help? Contact us at support@datadrew.io or use the in-app chat. Related articles - Customer segmentation and RFM analysis - Syncing RFM segments to Klaviyo - Automating RFM segment sync to Klaviyo - LTV Cohort Analysis Need help? If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.

Last updated on Jul 07, 2026

LTV Cohort Analysis

What is LTV Cohort Analysis? LTV (Lifetime Value) Cohort Analysis groups your customers by the month (or week/quarter) they made their first purchase, then tracks how much cumulative revenue each cohort generates over time. This is the most accurate way to understand how valuable your customers truly are — not just on day one, but over their entire relationship with your brand. In Datadrew, you will find the LTV Cohort Analysis dashboard under Lifetime Value > Cohort Analysis in the sidebar. How to Read the Dashboard The cohort analysis dashboard has three main components: 1. Summary KPIs — At the top, you will see key metrics including AOV (Average Order Value), total customers, repeat rate, and LTV at 1-month, 3-month, 6-month, 1-year, 2-year, and 3-year windows. 2. Cohort Heatmap — The main table where each row is a cohort (e.g., "Jan 2025") and each column represents a time period after acquisition ("First Order", "Month 1", "Month 2", etc.). The cells show how much revenue (or orders, customers, or cumulative LTV per customer) that cohort generated in each subsequent period. Darker shading means higher values. 3. Retention Charts — Line and area charts that visualize cumulative LTV per customer across cohorts, making it easy to spot which cohorts are outperforming and which are underperforming. Dashboard Controls - Acquisition Period — Set the date range for cohort creation. - Group By — Choose to group cohorts by week, month, quarter, or year. - Metric Selector — Switch between viewing Revenue, Orders, Customers, AOV, Cumulative Orders per Customer, or Cumulative Revenue per Customer (LTV). - Format — Toggle between absolute values and percentages (relative to first-order period). - CAC Column — When you have Meta Ads and/or Google Ads connected, an ad spend column appears showing Customer Acquisition Cost (total ad spend divided by cohort size) for each cohort period. - Filters — Refine cohorts by product, product type, vendor, SKU, shipping country, tags, and more. Key Insights to Look For - LTV Growth Over Time — Compare cumulative LTV per customer at the 3-month, 6-month, and 12-month marks. Healthy businesses see steady growth, meaning customers return to buy again. - Cohort Improvement — Are newer cohorts generating more LTV than older ones? If so, your retention efforts are working. - Repeat Rate — The percentage of customers who placed more than one order. A higher repeat rate means more predictable revenue. - LTV vs CAC — When ad spend data is available, compare the cumulative LTV per customer against the CAC for each cohort. You want LTV to exceed CAC — ideally by 3x or more. - Seasonal Patterns — Holiday cohorts (e.g., November, December) often show lower LTV because many of those customers were one-time gift buyers. Actions to Take - If LTV is flat after the first order, focus on post-purchase email flows and loyalty programs to drive repeat purchases. - If certain cohorts have significantly higher LTV, investigate what marketing campaigns or product launches drove those acquisitions and replicate the approach. - If CAC exceeds 12-month LTV, your ad spend is not sustainable — consider tightening targeting or improving retention. - Use cohort data to set realistic customer acquisition budgets based on how quickly customers pay back their acquisition cost. Exporting Data You can export the cohort heatmap and retention charts as CSV files using the export button at the top of each section. Need help? Contact us at support@datadrew.io or use the in-app chat. Related articles - Why cohort analysis is the best way to calculate LTV - RFM Segmentation - Purchase Frequency dashboard - LTV and cohort analysis with Drew AI Need help? If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.

Last updated on Jul 07, 2026

Leveraging Product Cohorts in Your eCommerce Business

Introduction In the dynamic world of eCommerce, understanding customer behavior is key to successful business growth. Product-level cohort analysis is a vital tool that groups customers based on the first product they purchased, providing deep insights into purchasing patterns and customer preferences. This article delves into the benefits of utilizing this form of analysis and guides you on how to interpret and apply these insights effectively. What is Product-Level Cohort Analysis? Product-level cohort analysis segments customers into groups (cohorts) based on the first product they purchased from your store. This method allows you to track and analyze the behavior of these groups over time, offering valuable insights into how different products influence customer loyalty, repeat purchases, and overall engagement. How to Conduct Product-Level Cohort Analysis To start, you'll need data on customer purchases, specifically focusing on what each customer's first purchase was. Typical data points include: - Product Name/Type: Identifies the first product purchased. - Acquisition Date: When the customer made their first purchase. - Follow-up Purchases: Subsequent purchases made by the customer. This data can be visualized in a cohort analysis table, where the rows represent different products and columns represent time intervals (e.g., months or quarters after the first purchase). Continuously update your cohort analysis to reflect recent trends and changes in customer behavior DataDrew automatically creates these cohorts for you on your lifetime data. This analysis helps in understanding the lifecycle of customers in relation to specific products. - Acquisition Product: The product which customers purchased in their first order - Cohort Size: The number of customers who made their first purchase in that cohort. - First Order: The number of customers who placed their first order and the cumulative revenue they generated - Monthly Columns (e.g., 0, 1, 2, 3): These columns represent months post-acquisition and show customer engagement or purchase behavior over time. Install DataDrew Analytics on Shopify App Store Analyzing the Data 1. Product-Specific Trends: Understand which products are attracting more new customers and their subsequent purchase behavior. 2. Customer Lifecycle: Track how long customers continue to engage after their first purchase. 3. Product Performance Over Time: Compare different products to see which retain customer interest. The Value of Product-Level Cohort Analysis 1. Understanding Customer Lifecycle Track how long customers who first purchase a specific product continue to engage with your store. This can help in tailoring customer retention strategies. Lead By Example 🌟 Suppose you operate an online store that sells various electronics, like smartphones, laptops, and headphones. Observations from Product Type Cohorts: - Smartphone Cohort: You notice that customers who first bought a smartphone tend to make another purchase within 3 months, often for the accessories category. - Laptop Cohort: These customers have a longer purchase cycle, often returning around 6 to 12 months later, possibly for complementary products like software or bags. - Headphone Cohort: Engagement for this group is sporadic, but they show increased activity during sales or when new models are launched. Tailoring Customer Retention Strategies: - Smartphone Cohort: Since these customers are likely to make a follow-up purchase relatively soon, you might send them targeted promotions for smartphone accessories or extended warranty services shortly after their initial purchase. - Laptop Cohort: Knowing their longer purchase cycle, you can engage them with content related to laptop maintenance, software updates, and eventually introduce them to complementary products. Periodic newsletters featuring new releases or tips can keep them engaged. - Headphone Cohort: For this group, alerting them about upcoming sales, new model launches, and offering exclusive previews or discounts can re-engage them. 2. Identifying High-Value Products By observing which products consistently lead to more repeat purchases, you can identify your most valuable products - those that not only attract customers but also retain them. Lead By Example 🌟 Suppose you own "Brew & Bean," a gourmet coffee shop specializing in a variety of coffee beans. Observations from Product Level Cohorts: - Espresso Blend Cohort: Customers who purchased the Espresso blend as their first order tend to make repeat purchases within a month, often sticking with the same blend or trying other dark roasts. - Single-Origin Cohort: These customers, starting with Single-Origin beans, show interest in exploring different varieties, with repeat purchases typically occurring every 2-3 months. - Organic Blend Cohort: Customers who initially purchase Organic blends have a longer gap between purchases but usually buy in larger quantities. - Decaf Blend Cohort: Customers who first purchase Decaf blends show very low repeat purchase rates and overall lower lifetime value (LTV). Identifying Valuable Products & Tailoring Strategies: - Espresso Blend Cohort: Introduce loyalty programs and promotions focusing on espresso recipes, and encourage cross-selling with related products like French Roast to promote exploration within the category. - Single-Origin Cohort: Launch a monthly Single-Origin showcase, encouraging customers to try new varieties and engage with the brand through taste experiences and feedback. - Organic Blend Cohort: Offer discounts on large purchases and emphasize the health and sustainability aspects of Organic blends in marketing to reinforce their buying decision. - Decaf Blend Cohort: To address the low engagement, consider diversifying the Decaf range with unique flavors or blends, and create educational content highlighting the benefits and quality of decaf coffee. Implement targeted marketing campaigns to re-engage this cohort, possibly pairing Decaf blends with evening relaxation themes or health-conscious messaging. 3. Customizing Marketing Strategies Understand the products that serve as effective entry points for long-term customer relationships. Tailor your marketing strategies to promote these products to new customers. 4. Product Development Insights Gain insights into which types of products are successful in attracting customers. This can inform your product development and inventory management strategies. 5. Customer Segmentation Segment your customers based on their first purchase, allowing for more targeted and personalized marketing campaigns. Conclusion Product-level cohort analysis is a potent tool for eCommerce merchants, offering deep insights into how initial purchases influence long-term customer behavior. By effectively analyzing and acting on these insights, businesses can enhance their marketing strategies, product offerings, and overall customer engagement, leading to sustained growth and success in the competitive eCommerce landscape. Remember, the key to making the most of this analysis is in the application of its insights to drive strategic decision-making and personalized customer experiences. Bonus - Other Breakdowns By Product Type - Analysis: Segment customers into cohorts based on specific product types or categories they initially purchase from. This can range from broad categories (like clothing, electronics, etc.) to more specific ones (such as winter wear, smartphones, gaming accessories). - Value: This breakdown helps in understanding which product types are the most effective in attracting and retaining customers. For instance, you might find that customers who first buy luxury items have a higher lifetime value (LTV), or that those who purchase basic necessities tend to return more frequently. This insight is crucial for inventory management, marketing strategy, and product development. By Country and Other Location Parameters - Analysis: Organize customers into cohorts based on their geographic location at the time of their first purchase. This can be as broad as country-level segmentation or as specific as city or region-based cohorts. - Value: Analyzing customer behavior based on location allows you to identify regional trends and preferences. You might discover that certain products are more popular in specific areas or that some regions have a higher customer retention rate. This information can guide localized marketing strategies, regional stock allocation, and even influence decisions on physical store locations or localized online experiences. By Custom Parameters (Order tags / Customer tags etc) - Analysis: Utilize more nuanced customer data such as order tags (e.g., first-time buyer, bulk order) or customer tags (e.g., VIP customers, newsletter subscribers) to create specialized cohorts. - Value: Custom parameters allow for a deeper and more personalized analysis of customer behavior. For instance, tracking VIP customers might reveal that they have a higher average order value but require more personalized engagement strategies. Similarly, understanding the behavior of newsletter subscribers can help in optimizing email marketing campaigns. This level of detailed analysis supports highly tailored marketing approaches and customer service strategies, enhancing overall customer satisfaction and loyalty.

Last updated on Jul 07, 2026

RFM Analysis

What is RFM Analysis? RFM Analysis is a powerful tool that helps you segment your customers based on their purchasing behavior. By evaluating Recency, Frequency, and Monetary value (RFM), you can identify different customer groups, understand their behavior, and tailor your marketing strategies accordingly. This method gives you insights into your most loyal customers, those at risk of leaving, and everyone in between. The Components of RFM - Recency (R): How recently did the customer make a purchase? - Frequency (F): How often does the customer make a purchase? - Monetary (M): How much money does the customer spend on purchases? Each customer is scored on these three metrics, usually on a scale of 1 to 5, with 5 being the highest. RFM Segments and Their Definitions Here are the key RFM segments and what they mean for your business: Champions - Definition: Buy often, spend a lot, and made a purchase recently. - Actions: Reward them. Ask them for reviews. They can be early adopters for new products and collections. Loyal Customers - Definition: Spend often and in good amounts. They are also engaged with relevant promotions. - Actions: Upsell higher-value products. Ask for reviews. Ask for referrals and engage with them; send free gift cards, pizzas, handwritten notes, etc. Promising - Definition: Recent customers who spend decent money and have bought more than once. - Actions: Offer subscription and loyalty programs. Provide recommendations. Ask for reviews. Send gifts, handwritten cards, etc. Make one-on-one personalized phone calls. New Customers - Definition: Recent buyers but most likely just one-time buyers. - Actions: Provide post-sale support. Give them “early success,” offer free gift cards. Start a one-on-one relationship. Need Attention - Definition: Customers who have average to below-average RFM scores. - Actions: Make limited-time offers. Recommend new products or services based on their passion/problem. Should Not Lose - Definition: Made large and frequent purchases but have not purchased in a long time. - Actions: Win back through special offers. Talk to them, survey them, don’t lose them to competition. Sleepers - Definition: Spent good money but have not purchased in a long time. - Actions: Send emails and messages to reconnect. Provide helpful resources. Lost - Definition: Lowest RFM scores, bought a small amount a long time ago. - Actions: Try to revive interest with reach-out campaigns, otherwise ignore. Warm Leads - Definition: Bought once or twice fairly recently but have not spent much. - Actions: Reach out personally and provide proactive support. Learn about them and build relationships. Cold Leads - Definition: Customer at risk of being lost, with below-average RFM scores. - Actions: Reach out through SMS or email to revive interest. Get feedback. RFM Score Breakdown Each customer is assigned an RFM score based on their purchase behavior. FM score is the mean of F-score and M-score. | | | | | --- | --- | --- | | Segment | R-score | FM-score | | Champion | 5 | 5 | | Loyal | 3,4,5 | 4,5 | | Promising | 4,5 | 2,3 | | New Customers | 5 | 1 | | Warm Leads | 4 | 1 | | Cold Leads | 3 | 1 | | Need Attention | 2,3 | 2,3 | | Shouldn’t Lose | 1,2 | 5 | | Sleepers | 1,2 | 3,4 | | Lost | 1,2 | 1,2 | How to Conduct RFM Analysis Manually 1. Data Collection: Gather data on your customers' purchase history. 2. Calculate Scores: Assign scores for Recency, Frequency, and Monetary values for each customer. 3. Segmentation: Group customers based on their RFM scores into the predefined segments. 4. Action Plan: Develop marketing strategies tailored to each segment. Automatically with DataDrew Analytics Datadrew simplifies this process by automatically calculating RFM scores and segmenting your customers. With DataDrew Analytics, you can: - Visualize RFM Segments: View your customer segments in an intuitive grid format. - Create Audiences: Build customer audiences based on their RFM scores for targeted marketing campaigns. - Take Action: Push these audiences to marketing platforms like Klaviyo and Facebook to execute your campaigns.

Last updated on Jul 07, 2026

Cohort analysis

Cohort analysis is one of the most powerful methods to analyse how a particular group of customers engage with your business. While you can unlock many other insights, a few primary objectives could be - - Estimate the lifetime value of your customers - Analyse the impact of your marketing strategy on your customer cohorts. Understanding the Cohort analysis We have grouped all acquired customers into cohorts by when they made their first purchase. 👉 Decoding the cohort analysis of a test store below Definitions - Acquisition period - When new customers were acquired. This is how the cohorts are created. In the above screenshot, we have Nov and Dec cohort. - New customers - How many new customers are there in the cohort. - Repeat % - The percentage of new customers who have made at least 1 additional order after their first order. - Orders - Total number of orders from a particular cohort in the selected timeframe - Revenue - Total revenue from a particular cohort in the selected timeframe - First-order - This variable shows the value of the selected metric. In the given screenshot, by default, it takes the Cumulative revenue per customer which is the total revenue from all acquired customers in their first order divided by the total number of new customers. - Period after 1st order - This could be months/quarter/year after the first order and can be flexibly selected to analyze the shorter or longer time periods. For Example - This screenshot shows that there are 2320 new customers acquired in the month of Dec 2020 out of which 28% of customers made repeat purchases over the subsequent months. Also, The cumulative revenue per customer is $38 in the first order which increased to $39 within the same month(0 months after 1st order) and increased to $43 one month after the first order. 👉 Comparing different customer cohorts Imagine you're increasing ad spends to increase your new customer's acquisition or let's say, you're launching new products to see if these products are helping you retain more of your new customers and helping you increase the repeat rate, you can do all this and much more by comparing the customer cohorts. For example - In the above screenshot, When you compare Dec 2020 and Jan 2021 cohorts, you see Jan 2021 cohort has a higher number of new customers and also has a higher repeat rate. 👉 Additional Tools 1. Duration - You can analyse your cohorts at a monthly, quarterly, or yearly level. The shorter time durations help when the customer behaviour is changing considerably faster. This is generally used when your marketing team does rapid testing and experimentation. Whereas, the longer time durations help in quickly giving you a birds-eye view of how the business has progressed. Remember to keep a longer timeframe like 2+years if you're choosing quarterly or yearly durations. ​ 2. Filters - You can choose to analyse the customers from a specific sales channel, countries, order tags, or customer tags. You can include or exclude these values using filters to filter out relevant first-orders. Have any further questions? You can book a call here.

Last updated on Jul 07, 2026