Sales analysis
Master the key metrics to monitor the growth of your WooCommerce online store and identify performance levers.
In this chapter :
Key statistic - Shops that analyze their data weekly grow 2.3 times faster than those that don't. 78% of successful e-commerce stores base their decisions on data.
Native WooCommerce reports
WooCommerce integrates powerful reports that can be accessed without additional extensions.
Access reports
Go to WooCommerce > Reports. The interface is divided into several tabs: Orders, Customers, Stock.
Orders tab - This is the most frequently consulted tab. It displays sales by period, products sold, coupons used and downloads (for digital products).
Custom Period - Filter by day, week, month, year or custom range. Compare periods (this month vs. last month, this year vs. last year).
Export - The "Export CSV" button at top right lets you export data for external analysis in Excel or Google Sheets.
These reports are in real time. Each sale instantly updates the graphs and tables.
Sales report by date
This is the main report displaying daily sales trends.
The curve graph shows sales day by day. A peak indicates a strong day, a trough a weak day. Identify patterns: weekends, marketing events and seasonality.
The detailed table below the graph lists each day with the number of orders, items sold, gross amount, shipping costs, discounts and net amount.
Gross represents the total before discounts. The net amount** is what you actually receive in cash (gross amount minus discounts).
Sales ratio by product
This report lists all products sold during the period, with quantities and amounts.
Columns include: Product, Quantity sold and Total amount. The table is sortable by each column to quickly identify your bestsellers.
The top product is your star. Make sure it's always in stock, highlight it on the homepage and create similar variants.
Products not on the list have recorded zero sales. Analyze why: visibility problem? Price too high? Poor-quality photos? Unconvincing description? Obsolete product?
Coupon report
This report shows the performance of each coupon code: uses and total amount of discounts granted.
Calculate ROI: if code PROMO20 generated 50 orders (€5,000) with €1,000 in discounts, the net gain is €4,000. If the advertising cost to promote this code was 500€, the real profit is 3500€.
Identify over-used codes that drain your margins. Codes that are never used indicate insufficient communication or an unattractive offer.
Essential metrics 🔺
Certain metrics are universally critical for any e-commerce store.
Sales (ca)
Total sales over a given period. It's the number 1 metric, but alone it's insufficient.
Average daily sales = monthly sales divided by 30. Follow the trend: an increase means growth, stagnation means a plateau, a drop means a problem.
Sales by channel - Identify sales by source: organic (SEO), paid (Google Ads), social, email or direct. Find out which channel generates the most revenue, and invest more in profitable channels.
Forecast sales - Extrapolate trends. If the average is €10,000/month with 10%/month growth, the forecast in 6 months will be €10,000 × 1.1^6 = €17,716.
Please note: sales do not equal profit. A €100,000 turnover with a 5% net margin generates €5,000 profit. A €50,000 turnover with a 20% margin generates a €10,000 profit. Margin is more important than gross volume.
Average basket
The average amount spent per order. Calculation: sales divided by number of orders.
Example: €10,000 sales for 100 orders = an average basket of €100.
Optimize the basket :
- Cross-sell: "Complete with...".
- Upsell: "Upgrade to the premium version for €20 more".
- Conditional free delivery: "Add 15€ for free delivery".
- Bundles: "Complete pack -15%".
Increasing the average shopping basket by 10% generates 10% more sales without additional traffic. This is often easier than acquiring 10% more customers.
Number of orders
This is the volume of transactions. More orders means a growing customer base.
If orders are increasing but the average basket is decreasing, this means you're attracting lower-budget buyers. Is this a deliberate low-cost strategy or a problem?
If orders are falling but the average basket is rising, this means you're losing customers, but those who remain are spending more. Is it a high-end niche strategy or a loss of acquisition?
Optimal: orders AND basket increase simultaneously. This is healthy growth on all fronts.
Growth rate
This is the comparison between the current period and the previous period.
Month-on-month (MoM) - Compare this month with last month. Formula: (Sales this month - Sales last month) / Sales last month × 100.
Example: €12,000 this month, €10,000 last month = (12000 - 10000) / 10000 × 100 = +20% MoM. That's excellent growth.
Year-on-year (YoY) - Compare this month with the same month last year. This eliminates seasonality bias.
Comparing December 2024 with December 2023 reveals true growth (Christmas on both sides). Comparing December with November would be biased (Christmas vs. non-Christmas).
Aim for growth of +10-20% MoM in the launch phase, +50-100% YoY in the first year, then stabilization at 10-20% YoY thereafter.
Sales analysis 🔺
Break down sales to understand where the money really comes from.
Breakdown by category
Which product category generates the most sales?
If 70% of sales come from a single category, it's your cash cow. Protect it, optimize it and expand it.
For weaker categories (less than 5% of sales): assess whether they're worth the inventory space and mental attention. Sometimes it's better to do away with dead categories and concentrate on the strong ones.
80/20 rule (Pareto) - Often, 20% of products generate 80% of sales. Identify these 20% and promote them everywhere.
Time distribution
Seasonality - Fashion sales peak in September (back-to-school) and December (Christmas), with a dip in July-August. Plan accordingly: inventories, marketing campaigns and cash flow.
Day of the week - B2C sells more on weekends. B2B sells more from Tuesday to Thursday. Schedule your emails and ads for high-conversion days.
Time of day - Many B2C stores sell between 8pm and 10pm (after dinner). Launch your flash sales at these times.
Create a monthly chart over 12 to 24 months to clearly visualize seasonality and plan accordingly.
Geographical distribution
Where do your customers come from?
The WooCommerce > Reports > Customers by location menu displays countries and regions. Identify your growth markets.
If 40% of your customers come from region X, but you don't advertise locally, that's a massive opportunity. Launch geo-targeted ads, create local partnerships and organize events.
Are areas with zero sales a barrier? A language problem, overpriced delivery or fierce local competition? Decide whether to invest in these markets or ignore them.
New vs. regular customers
New customers - This is their first order. Costly to acquire (advertising). Margins are often low or even negative on the first purchase.
Recurring customers - They're making their 2nd or more purchase. The cost of acquisition is zero (they're already in the base), the margin is full and the basket is often larger (trust is established).
If 90% of sales come from new customers, you have a retention problem. Customers buy once, then disappear. Concentrate on building loyalty: email marketing, loyalty programs and exceptional service.
If 70% of your sales come from repeat customers, you're in excellent health. Your loyal base generates predictable revenues. Continue moderate acquisition to compensate for natural churn.
The optimal ratio: 60-70% repeat business, 30-40% new business. It's the balance between growth and stability.
Conversion rate 🔺
The conversion rate represents the percentage of visitors who complete a purchase on your store. It's a critical metric for measuring the return on investment of your traffic.
Conversion rate calculation
Conversion rate = (Number of orders / Number of unique visitors) × 100
Example: 10,000 visitors, 200 orders = 200/10000 × 100 = 2% conversion rate.
E-commerce benchmark: 1-3%. Less than 1% = serious problem (site, price, trust). Over 3% = excellent work.
WooCommerce does not track visitors natively. Install Google Analytics via Site Kit by Google or MonsterInsights to get these figures.
Factors impacting conversion
Design and user experience play a decisive role. A modern, fast, mobile-optimized site converts 2 to 3 times better than a slow, dated one. Visitors judge the credibility of your store in a matter of seconds, and a professional design inspires confidence.
Price is a critical factor. If it's too high compared with the competition, conversions will be low. Conversely, too low a price can raise doubts about quality. It's essential to test different pricing strategies to find the optimum balance point.
Professional product photos with multiple angles and zoom functions improve conversion by 40% compared to amateur photos. Customers buy with their eyes: high-quality visuals reassure and trigger purchase.
Detailed descriptions that highlight concrete benefits and reassure the customer generate 25% more conversion than vague or purely technical descriptions. Tell a story, explain uses, answer objections.
Customer reviews are one of the most powerful levers: more than 50 positive reviews increase conversion by 270% compared to a product sheet without reviews. Authentic testimonials create the social proof essential for building trust.
Trust signals such as security badges, money-back guarantees and customer testimonials reassure hesitant visitors and turn them into buyers.
Simplified checkout is decisive: every step removed from the purchasing process improves conversion by 10%. Aim for a maximum of 3 steps between the shopping cart and order confirmation.
Conversion funnel
Visualize where visitors abandon their purchase journey. Let's take a concrete example with 10,000 visitors on the home page. Of these, only 4,000 access a product page (60% have already abandoned). Of these 4,000, only 1,200 add an item to the shopping cart (70% leave without adding). Of these 1,200, only 400 reach checkout (67% abandon). Finally, of these 400, only 200 finalize their order (50% abandon at checkout).
Every step of the way is losing customers. The challenge is to identify the weakest link in this chain and optimize it as a priority. If checkout loses 50% of visitors, simplify it radically: offer guest purchasing without creating an account, reduce the number of mandatory fields, integrate express payment solutions like Apple Pay or Google Pay.
If the product page loses 70% of visitors without them adding the item to the shopping cart, improve the photos, enrich the descriptions, adjust the price or make the add-to-cart button more visible and attractive.
Continuous optimization
Test systematically to improve conversion on an ongoing basis.
A/B testing involves creating two versions of the same page (version A vs. version B), dividing the traffic equally between the two, then retaining the version that performs best. You can test calls to action, colors, titles, prices or layouts. This method eliminates guesswork and is based on real data.
Heatmaps reveal your visitors' actual behavior. Tools like Hotjar (€99/month) show precisely where people click, how far they scroll and which areas they ignore completely. This information reveals user experience problems that would otherwise be invisible.
Session recordings let you watch videos of real user sessions. You see exactly where they hesitate, when they give up and where they go wrong in their navigation. This direct empathy with the user experience generates insights that would otherwise be impossible to obtain.
Direct customer feedback is a goldmine of information. A simple post-purchase survey asking "What almost stopped you from buying?" produces brutally honest answers that reveal concrete opportunities for improvement.
A conversion rate improvement of just 1% can generate thousands of euros in additional revenue every year. It's an investment that always generates a positive return.
Promotional performance 🔺
Measure the real impact of your marketing campaigns and promotions.
Campaign ROI
ROI** (return on investment) is calculated as follows: (Revenue generated - Cost of campaign) / Cost of campaign × 100
Let's take three concrete examples to illustrate this calculation.
A Facebook Ads campaign costs €500 and generates 30 orders for total sales of €3,000. The ROI is therefore: (3000 - 500) / 500 × 100 = +500% ROI. Every euro invested yields €6. This is an excellent campaign for which we need to increase the budget.
A Google Ads campaign costs €1,000 and generates 15 orders for sales of €1,200. The ROI is: (1200 - 1000) / 1000 × 100 = +20% ROI. Each euro earns €1.20. The campaign is profitable, but the return remains marginal: it needs to be optimized or the budget reallocated to more effective channels.
An Instagram campaign costs €300 and generates just 5 orders for sales of €200. The ROI is: (200 - 300) / 300 × 100 = -33% ROI. This is a net loss. We need to stop this campaign immediately or radically change our strategy.
Multi-touch attribution
Let's imagine that a customer sees your Facebook ad (first point of contact), then visits your site via Google 2 days later (second point of contact), then receives a promotional email (third point of contact) and finalizes his purchase.
Which campaign actually "caused" the sale? In reality, all three channels contributed to the result. Multi-touch attribution distributes the credit evenly between the different contact points.
Google Analytics (free) offers several attribution models: last click, first click, linear or time-degressive. It's essential to install this tool to understand the true contributions of each marketing channel.
Without an attribution system, you risk over-investing in the channels that receive the last click (often email or direct search) and under-investing in the channels that initiate discovery (usually social networks or display advertising).
Coupon performance
The WooCommerce > Reports > Coupons menu lists each promotional code with the number of uses and the total amount of discounts granted.
Let's take the code WELCOME10 as an example: it was used 200 times, granted €2,000 in discounts and generated 300 orders (some customers placed several orders), for total sales of €30,000.
Net revenues amounted to 30,000 - 2,000 = 28,000€. If the cost of communicating the code (emails, advertising) is €500, the final net profit is €27,500.
The strategic question remains: without the promotional code, how many of those 300 orders would still have taken place? It's difficult to know for sure. The most reliable method is to test a period without a code against a period with a code. The difference reveals the real impact of the coupon.
Codes that are never used represent a waste of communication. We need to analyze the reasons for this failure: are the conditions of use too strict? Discount too low to be attractive? Target audience not interested in this type of offer?
Customer acquisition cost (cac)
Customer acquisition cost measures how much you have to invest to acquire a new customer.
The CAC is calculated as follows: Total marketing expenditure / Number of new customers acquired
Let's take an example: if you spend €5,000 on advertising this month and acquire 100 new customers, your CAC is €50.
Is this metric profitable? It all depends on the customer lifetime value (CLV). If the CLV is €200, it's profitable with a ratio of 1:4 (excellent). If the CLV is €60, you have a problem with a ratio of 1:1.2 (too tight, little margin for error).
To reduce the CAC, you need to optimize ad targeting, improve the conversion rate (the same traffic generates more customers) or develop organic marketing (SEO, free social networks).
To increase CLV, focus on loyalty, increasing the average basket and recurring sales. A high CLV allows you to adopt a more aggressive CAC to accelerate growth.
Dashboards 🔺
Centralize your key performance indicators (KPIs) for effective daily and weekly management.
Daily Dashboard
Consult the following metrics every morning for 5 minutes: the previous day's sales compared with the average and targets, the previous day's order volume, the evolution of the average basket, the conversion rate (which may reveal a technical problem) and out-of-stock products requiring urgent action.
These figures reveal immediate problems such as a bug on the site, a critical stock shortage or abnormal traffic requiring rapid intervention.
Weekly Dashboard
Devote 15 to 30 minutes every Monday morning to an in-depth weekly review. Analyze the week's sales figures and compare them with previous weeks to identify trends. Evaluate the weekly conversion rate to see if your optimizations are bearing fruit. Examine the top 5 products to see if your bestsellers are evolving. Review the performance of each marketing channel to calculate ROI by source. Finally, analyze cart abandonment rates and the effectiveness of your recovery strategy.
This review enables you to identify emerging trends and adjust your tactics in real time: boost advertising on the best-performing channel, launch a promotion on slow-selling products, or modify your abandoned basket recovery strategy.
Monthly dashboard
Schedule an in-depth 1-2 hour review at the beginning of each month. Start by analyzing your monthly sales figures: have you reached your target? If a gap exists, analyze the causes. Examine month-on-month (MoM) and year-on-year (YoY) growth to understand your trajectory. Evaluate the ratio of new customers to repeat customers to measure the health of your customer loyalty. Observe the evolution of the average basket to check whether your upsell strategies are working. Calculate the performance of your promotions and the ROI of each campaign. Finally, identify your star products and those that are failing, so you can make informed decisions about your catalog.
This monthly analysis enables you to define objectives and actions for the following month. It's the continuous improvement loop that drives your store forward, month after month.
Dashboarding tools
Google Data Studio is a free solution that connects WooCommerce (via an extension), Google Analytics and Google Ads. You can create customized visual reports and share them easily with your team. It's the ideal tool for getting started without investment.
Metorik costs $50/month and features a real-time WooCommerce dashboard. It offers pre-configured reports and automatic email alerts that warn you in the event of a 20% drop in sales, low stock or other critical anomalies.
Putler costs $20/month and combines WooCommerce data with your payment processors. It offers sales forecasts, RFM analysis (recency, frequency, amount) and cohort analysis to understand purchasing behavior.
Klipfolio costs $49/month and can connect to over 100 different data sources. It's the right solution for stores that use multiple platforms and have complex analysis needs.
Start simply with native WooCommerce reports and free Google Analytics. Invest in paid tools only when your sales exceed €10,000 per month and the complexity of your business justifies the investment.
In a nutshell
Master native WooCommerce reports to analyze your sales by date, product and coupon usage. Track key metrics: sales, average cart, number of orders and growth. Analyze your data by comparing periods (month N vs N-1, year N vs N-1) and identify seasonal trends to anticipate peaks in activity. Optimize your strategy by focusing on increasing the average basket through cross-selling and upselling. Use Google Analytics or Matomo to go further in analyzing shopping tunnels and user behavior.
Next steps 🔺
Navigation: ← Reports and Analytics | Sales Reports | Next: Customer Reports →