Customer analysis
Segment and analyze your WooCommerce customer base to maximize retention and customer lifetime value.
In this chapter :
Key statistic - Increasing customer retention by 5% increases profits by 25 to 95%. A loyal customer is worth 10 times more than a new customer over its lifetime.
WooCommerce customer reports
WooCommerce offers basic customer reports, extensible with third-party tools.
Customer list
The menu Users > All users filtered by "Customer" role displays all your buyers.
Columns include: Name, Email, Role and Number of orders (via a custom extension column). Click on a customer to see details: addresses, orders and administrative notes.
It's limited but quick to consult a specific customer or check his purchases.
Customer report by purchase
The WooCommerce > Reports > Customers > Customers by Orders menu lists customers sorted by number of purchases.
The top of the list represents your loyal recurring customers. These are your VIPs. Treat them like gold: priority service, exclusive offers and surprise gifts.
The bottom of the list shows your one-time buyers. These are the silent majority. Converting 10% of them into bi-annual buyers transforms your business.
Customer ratio by spend
The WooCommerce > Reports > Customers > Customers by Spend menu sorts customers by total amount spent.
The top 10% probably represent 40 to 60% of your sales (Pareto rule). Identify them, mark them "VIP" in the notes and offer them special treatment.
Analyze the patterns: what do they buy? How often? What's their average shopping basket? Replicate this profile in your acquisition campaigns to attract more similar customers.
Advanced extensions
The Customer Data Export extension (free) lets you export all your customers in CSV format, with customized columns including total amount spent, number of orders, date of last order and other relevant data.
Metorik ($50/month) offers ultra-powerful segmentation with automatic calculation of customer lifetime value, churn prediction and automatic emailing based on purchasing behavior.
Putler ($20/month) offers native RFM analysis, cohort analysis and prediction of your customers' future buying behavior.
These tools justify their cost if you manage more than 1,000 customers and wish to finely segment your base for targeted marketing actions.
Customer segmentation 🔺
Not all customers are created equal. It's essential to segment them to adapt your marketing actions to each group.
By value
VIP** customers (top 10% of your base) have spent more than 50% of your total sales. They deserve absolute premium treatment, including permanent free delivery, priority support, early access to new products and invitations to exclusive events.
Regular customers** (the next 30%) buy regularly and spend moderately. Build loyalty with a points program, cumulative discounts and reserved private sales.
Occasional customers** (the remaining 60%) have only made one or two small purchases. Your aim is to get them to buy a third time, which is the psychological threshold for loyalty. Send them reactivation emails and personalized offers based on their first purchases.
Each segment should receive communication tailored to its expectations. VIP customers don't want aggressive promotions that look cheap, while occasional customers need strong incentives to take the plunge.
By frequency of purchase
Weekly shoppers** mainly consume consumable products such as food or cosmetics. Automate their experience with subscriptions, restocking reminders and VIP programs that reward their regularity.
Monthly buyers** follow a regular, predictable rhythm. Anticipate their needs with personalized emails like "Is your regular order arriving soon?" and offer recommendations based on their purchase history.
Quarterly or annual buyers** buy durable products that don't require frequent replacement. Maintain the relationship between purchases with value-added content: tips for use, presentation of new products or invitations to events.
One-time buyers** are at high risk of churn. Launch an aggressive reactivation sequence from the 30th day after their first purchase to turn them into repeat customers.
Always adapt communication frequency to the natural buying rhythm of each segment. Bombarding annual buyers with weekly emails generates massive churn.
By category purchased
Customers who have purchased category X become natural prospects for complementary category Y.
If a customer has bought a camera, suggest lenses, carrying bags, tripods or photography courses. If they've bought sportswear, recommend sports nutrition or fitness accessories.
Create segments in your email marketing tool (Klaviyo, Mailchimp) based on previously purchased categories. Ultra-targeted campaigns generate conversions 5 times higher than generic emails sent to the whole base.
By lifecycle status
Prospects** have signed up for your newsletter but never purchased. Move them forward with a nurturing sequence that combines product education, social proof with customer testimonials and an attractive offer for their first order.
New customers** made their first purchase less than 30 days ago. Accompany them with careful onboarding: a personalized thank-you, advice on how to use the product purchased, an invitation to leave a review and an incentive to make a second purchase.
Active customers** buy regularly and are the heart of your business. Keep them with a rewarding loyalty program, exclusive offers and sincere recognition of their loyalty.
At-risk customers** have been inactive for 90 to 180 days, an unusually long period compared with their usual frequency. Launch an urgent reactivation with a message like "We miss you! Here's a 20% discount for your return".
Churned" customers have been inactive for more than 180 days. Try one last approach: "Last chance before you're removed from our list. Take advantage of a 30% discount if you come back". After this attempt, remove them from your database to reduce platform costs and improve the deliverability of your emails.
Customer lifetime value (clv) 🔺
The ultimate metric: how much a customer earns over their entire relationship with you.
CLV calculation
CLV = Average basket × Annual purchase frequency × Customer lifetime (years)
Example:
- Average basket = €80
- Frequency = 4 purchases/year
- Lifespan = 3 years
CLV = 80 × 4 × 3 = 960€
This customer is worth €960 over his lifetime. You can invest up to €960 to acquire him and break even (in reality, aim for CAC < 20% CLV for profitability).
CLV by segment
Calculate the lifetime value for each customer segment. This reveals exactly where to focus your marketing and sales efforts.
Let's imagine that the LCV of VIPs is €2500, that of regular customers is €600 and that of occasional customers is €150.
In this context, investing €200 in cost of acquisition (CAC) to acquire a potential VIP customer generates a ratio of 1:12, which is excellent and fully justifies the investment.
On the other hand, investing €100 in CAC to acquire an occasional customer generates a ratio of only 1:1.5, which is marginal. In this case, it's better to prioritize improving the conversion rate of occasional customers to regular customers rather than investing heavily in acquisition.
Increase CLV
To increase the average basket, deploy cross-selling and upselling strategies, create attractive bundles and introduce free delivery thresholds to encourage additional purchases.
To increase purchase frequency, rely on regular email marketing, set up rewarding loyalty programs, offer subscription packages and send personalized reminders at the right time.
To increase customer longevity, offer exceptional service, sell products of impeccable quality, create strong community involvement and generate memorable experiences that leave a lasting impression on your customers.
A 10% increase in CLV enables you either to generate the same sales with 10% fewer customers (savings on acquisition), or to generate 10% more sales with the same number of customers. It's a massive lever for profitability.
CLV vs CAC
The ratio CLV:CAC measures the health of your customer acquisition strategy.
A ratio of 3:1 is the minimum viable. With a CLV of €300, your CAC should not exceed €100. It's profitable, but margins remain tight.
A ratio of 5:1 to 10:1 is excellent. With a CLV of €500 and a CAC between €50 and €100, you have a comfortable margin that allows for growth and absorbs unforeseen events.
A ratio of less than 3:1 indicates a serious problem. You're spending too much on acquisition in relation to what your customers bring in. Urgently reduce the CAC or increase the CLV.
A ratio greater than 10:1 indicates under-investment. If your CLV is €1,000 and your CAC is only €50, you could acquire much more aggressively. This is a missed growth opportunity.
Retention rate 🔺
The retention rate measures the percentage of customers who come back to buy over a given period.
Retention rate calculation
Retention rate = (Customers end period - New customers period) / Customers start period × 100
Example:
- 1000 customers beginning of month
- 1100 end-of-month customers
- 200 new customers acquired
Retention = (1100 - 200) / 1000 × 100 = 900 / 1000 × 100 = 90%
You've kept 90% of your existing customers. Excellent (benchmark 80-85%).
Churn rate
Inverse of retention. Percentage of customers lost.
Churn = 100% - Retention rate = 100% - 90% = 10%
You're losing 10% of your customer base every month. If nothing changes, in 10 months you will have lost all your current customers (without acquisition).
Reducing churn from 10% to 5% = doubling average customer lifetime = doubling CLV.
Improve retention
Exceptional onboarding is crucial, as 70% of churn occurs after the first purchase. A personalized welcome email, detailed user guide and proactive support can improve retention by 40%.
Loyalty programs** based on points, VIP levels and rewards create gamification. This generates an emotional attachment to your brand and establishes a psychological exit cost that deters customers from leaving for a competitor.
Regular communication** must add value, not just promotions. Share practical advice, tell inspiring stories, create an engaged community. The aim is to remain present in your customers' minds (top-of-mind).
The quality of products and service is the foundation of everything. Poor products lead to inevitable churn. No marketing tactic, no matter how brilliant, can compensate for poor quality.
Positive surprises** make a lasting impression: an unexpected free sample in the parcel, a free delivery upgrade, a personalized handwritten card. Exceeding expectations creates deep emotional loyalty.
Responsive customer service** makes all the difference. A problem solved quickly and pleasantly turns a critical customer into an enthusiastic ambassador. Conversely, a problem ignored turns the customer into a public detractor who will leave devastating negative reviews.
Cohort analysis
Cohort analysis involves tracking the retention of a group of customers acquired during the same period.
Let's take the example of the January cohort made up of 100 customers acquired in January. How many are still buying in February (month +1)? In March (month +2)? In June (month +5)? This analysis reveals some valuable patterns.
The retention graph by cohort normally shows a sharp drop in the first month (50-70% of customers lost), followed by a gradual stabilization.
If a recent cohort shows better retention than older cohorts, it means that your product and service improvements are bearing fruit.
If all cohorts show the same retention pattern, this indicates that your retention is structural, whether the pattern is good or bad.
Recommended tools for this analysis are Google Analytics (Audience > Cohort Analysis), Metorik or Putler.
RFM Analysis 🔺
RFM analysis is a classic and powerful segmentation method based on three dimensions: Recency, Frequency and Amount.
RFM components
The Recency (R) indicates when the last purchase took place. A purchase yesterday means a very recent, hot customer. A purchase 6 months ago indicates an old, cold customer who needs to be reactivated.
Frequency (F)** measures the total number of purchases made. A single purchase indicates a new or one-off customer. More than 10 purchases indicates a loyal and faithful customer.
The Amount (M) represents the total spent by the customer. 50€ spent indicates a small customer. 5000€ spent characterizes a large, high-value customer.
Each customer receives a score from 1 to 5 on each of these three dimensions. A customer rated 555 is perfect: recently purchased, buys often and spends a lot. A customer with a score of 111 is problematic: a former customer, with a single purchase and a low amount spent.
Key RFM segments
The Champions (RFM: 555, 554, 544) represent your best customers. They buy recently, frequently and spend large amounts. They're your absolute VIPs. Reward them generously, pamper them and solicit their opinions and testimonials.
The Fidèles (RFM: 545, 535, 455) buy regularly and spend well. Offer them upsells on premium products and include them in exclusive programs.
Potential customers** (RFM: 551, 541, 451) are good spenders, but their frequency and recency of purchase varies. Set up nurturing programs to regularize their purchases.
Customers at risk (RFM: 244, 254, 344) were good customers, but their recency is dropping dangerously. Initiate urgent reactivation before they're lost forever.
Customers in hibernation (RFM: 151, 152, 153) haven't been buying for a long time, even if their past frequency and amount were correct. Deploy an aggressive reactivation campaign with an offer such as "30% off for your exclusive return".
Lost** customers (RFM: 111, 112, 121) are old, have only made one or two purchases, have spent small amounts and are inactive. Try one last approach, then remove them from your list.
Actions by RFM segment
Each segment requires a different, tailored strategy.
For Champions, create an ambassador program, offer them early access to new products, send them exclusive gifts and solicit their testimonials.
For Loyalists, ensure their retention via a loyalty program and offer cross-selling of complementary products.
For at-risk customers, send "We miss you" emails accompanied by a return incentive such as a discount or free delivery.
For lost customers, send a final "Last chance" email, then remove them from your list. This saves platform costs and improves the deliverability of future emails.
Automate all these actions via your email marketing platform (Klaviyo, Omnisend) by creating workflows based on RFM scores.
Geography and demographics 🔺
Understanding where your customers are and who they really are is a major strategic lever.
Geographic analysis
The WooCommerce > Reports > Customers > By country menu displays the breakdown of your customers by country.
For a more detailed analysis by region, use extensions such as Metorik or manually export the data to Excel for further processing.
Identifying geographic patterns reveals strategic opportunities. If 80% of your customers come from region X, focus your local marketing, develop regional partnerships and organize physical events in this area. If you have zero sales in region Y despite a large population, this may indicate either an untapped growth opportunity, or a barrier to be identified (language problem, fierce local competition). If your sales are spread evenly over the territory, you're operating in a national market, and broad-spectrum advertising is still relevant.
Logistics optimization** follows naturally from this analysis. Concentrate your warehouses near high-sales areas to ensure fast, cost-effective delivery.
Regional seasonality varies greatly according to climate. The South buys swimwear as early as April, while the North waits until July. Geo-target your marketing campaigns according to local weather and seasons.
Demographic analysis
WooCommerce doesn't natively collect customer age or gender. You have several options for obtaining this valuable data.
The post-purchase survey consists of politely asking: "Help us serve you better (optional): Age? Gender? Profession?". Between 30% and 40% of customers usually respond, generating invaluable data.
The Facebook Pixel combined with Audience Insights provides free insights into the demographics of your engaged audience if you're advertising on Facebook.
Google Analytics offers approximate demographic data based on browsing behavior. Enable this feature in your Google Analytics settings.
Identifying demographic patterns guides your strategy. If 70% of your customers are women aged 25 to 34, adapt your products, communication, visuals and choice of influencers to this precise segment. If the majority are over 50, opt for a more readable design with larger texts, favor customer service by phone rather than chat, and adopt a reassuring communication style. If you find a balanced mix, offer a variety of products to appeal to everyone, and maintain neutral communication that reaches a wide audience.
Never make hasty assumptions. Test and measure systematically. The idea that "baby products are bought by women" is often true, but 30% of buyers may be fathers, grandparents, uncles or aunts.
Using demographic data
The personalization of communication becomes possible when you have demographic data at your disposal. Segment your emails by age and gender. Adapt the language, visuals and products promoted to each segment.
Product development** is based on your dominant demographic. If your core segment is urbanites aged 25 to 34, launch modern, eco-friendly and tech-friendly lifestyle products that appeal to their values.
Targeted advertising** on Facebook and Instagram becomes ultra-precise: women aged 28 to 35, Paris region, yoga and organic interests. Cost-per-click drops and conversion rates rise thanks to this precision.
Partnerships** must be consistent with your demographic. Collaborate with brands and influencers that resonate with your audience. If your segment is young, work with TikTok influencers. If your segment is mature, focus on traditional press and radio.
In a nutshell
Use WooCommerce customer reports to identify your best customers by number of purchases and amount spent. Segment them by value (VIP, regular, occasional), purchase frequency and recency of last order. Calculate customer lifetime value (LTV) to prioritize your loyalty efforts on the most profitable segments. Create targeted campaigns tailored to each segment (VIP rewards, reactivation of inactive customers, cross-sell offers for regulars). Automate follow-up with alerts to detect customers at risk of leaving.
Next steps 🔺
Navigation: ← Sales Reports | Customer Reports | Next: Product Reports →