Store sales analysis means examining your sales data (revenue, number of transactions, quantities, products, periods or customers) to understand what is changing and why. A revenue drop of 8% this week is an observation, not yet an explanation.
A good analysis goes beyond tracking a few metrics: it looks for the factors that actually explain why they change.
Which dimensions should you use to analyze sales?
The same data can be viewed from different angles depending on the question you're asking.
By day or by hour
This view shows when business is busiest or slowest and lets you compare time slots that are truly comparable.
By week or by month
This view tracks change over time and helps you tell a one-off fluctuation from a longer-lasting trend.
By item or product category
This breakdown shows which items or categories contribute most to revenue, and which ones are growing or declining.
By customer
When sales are linked to known customers, you can study their purchase frequency, average basket or share of revenue.
By location
If you run several stores, comparing them helps you spot performance gaps and look for their causes.
By payment method
You can also track the split between card, cash and other payment methods when it matters for your business.
These dimensions can be combined. For example, you can analyze one product category in one location over a given period. The goal isn't to stack up filters, but to choose the ones that answer a specific question.
Which sales metrics should you track?
A few metrics make a good foundation.
Revenue
Revenue measures the total value of sales over a period. But on its own, a change in revenue doesn't explain what happened.
Number of transactions
This tells you how many sales were rung up. A drop in revenue can come from fewer transactions, even if the amount spent per customer stays the same.
Average basket (average transaction value)
It's calculated as follows:
Average basket = revenue ÷ number of transactions
It measures the average value of a transaction. Any change in revenue can therefore be broken down into a change in the number of transactions and a change in the average basket (see how to increase your average basket).
Quantities sold
Units sold help you tell a change driven by volume from one driven by price or by the mix of products sold.
Sales by product and by category
This view pinpoints the items or categories that are really driving an increase or a decline.
Compare the right periods
A figure on its own lacks context. Revenue of €20,000 can be excellent or disappointing depending on the store, the period and your usual results. That's why you need to compare.
You can compare against:
- the previous period
- the same period last year
- a target
- a historical average
- another comparable location
But not every comparison is meaningful. A Saturday shouldn't necessarily be compared with a Monday. A week with a public holiday isn't directly comparable to a normal week. A promotion can also skew the picture. The quality of the comparison matters as much as the metric itself. This look back at past sales is also the basis for revenue forecasting.
Tell a one-off dip from a real trend
A drop on a single day may not matter at all. The same drop repeated over several weeks deserves more attention. That's why it helps to look at a long enough period to distinguish between:
- a one-off incident
- a seasonal variation
- an anomaly
- a lasting trend
A series of small drops, for example, can be more important to analyze than one dramatic fall on a single day. This distinction keeps you from reacting to every normal fluctuation in business. See also how to detect sales anomalies to spot these signals automatically.
Find what's behind the change
Once you've identified a gap, the next step is to find its cause.
The number of transactions has changed
If revenue drops while the average basket stays stable, the problem may simply be fewer transactions.
The average basket has changed
With similar foot traffic, a change in the average basket can have a big impact on revenue. Then you need to look at what customers are buying: fewer items, cheaper products or a different basket mix.
One category or a few items explain the gap
An overall change is sometimes concentrated in a handful of products. Identifying those items is often more useful than analyzing the whole catalog.
A promotion is skewing the comparison
If the previous period included a major promotion, a direct comparison can look like a decline when sales have simply returned to normal.
A stockout held back sales
An item may sell less not because demand is falling, but because it was out of stock. This is a crucial distinction: recorded sales don't always reflect total demand.
Look at the product mix
Two periods can show the same revenue and still be very different. Imagine customers buy more low-margin products and fewer high-margin items. Revenue can stay flat while profitability changes.
That's why sales analysis should look not only at how much the store sells, but also at what it sells. The product mix shows the share of total sales that each category or product line accounts for.
Don't confuse revenue with profitability
This is an important limitation of sales analysis. Higher revenue doesn't necessarily mean better financial results.
A promotion can generate a lot of sales while sharply cutting into your margin. Conversely, a slight drop in revenue can come with a better product mix. When the data is available, you should round out the analysis with margin metrics. Revenue measures sales. On its own, it doesn't measure their profitability.
How to analyze a drop in revenue
A simple method is to work from the big picture down to the details.
- Has revenue really dropped?Compare it with a relevant period.
- Has the number of transactions changed?This tells you whether foot traffic or transaction volume is a factor.
- Has the average basket changed?If so, look at the composition of purchases.
- Which categories account for most of the gap?No need to analyze every item if two categories explain most of the change.
- Which products explain the change in those categories?Then drill down to the specific items involved.
- Is there a known cause?A promotion, stockout, price change, seasonality, a special event or another change in your business.
Step by step, this method turns a top-line metric into an explanation you can act on.
How can AI help analyze sales?
A dashboard works best for tracking metrics you've defined in advance. AI offers a complementary approach: you query the data directly whenever a question comes up.
For example:
“Compare my September sales with August.”
Then:
“Which categories explain the drop in revenue?”
And next:
“In this category, which items declined the most?”
The value lies in this progression. Instead of digging through several reports and filters to find the source of a change, the store owner can go deeper, one question at a time. So a dashboard and AI don't serve quite the same purpose: one makes routine tracking easier, the other helps you explore and explain. See also building a store dashboard.
From analysis to action
Understanding a change is only worthwhile if it then helps you make a decision.
An item whose sales are picking up sharply may call for a check on stock levels and restocking. A category that has been declining for several weeks may warrant a closer look at the items involved. A product that barely sells anymore while stock stays high can turn into dead stock. A decline concentrated in one customer segment may prompt you to study that segment's behavior or plan a loyalty campaign.
The right action depends on the cause. That's why analysis should come before the decision, not the other way around.
How does Gillia help with sales analysis?
Gillia is an AI agent that lets you query your business data in natural language. You can start with a general question:
“How have my sales changed this week?”
Then dig deeper:
“Which categories explain the drop?”
And keep going:
“Which products account for most of this gap?”
This approach takes you step by step from a top-line metric to the data that explains it. An analysis you check often can be pinned to the dashboard. A check you need to repeat regularly can become a routine, so you no longer have to run it by hand. That's the whole idea behind an AI agent for retail. The goal isn't to pile up statistics, but to surface the information you need to make a decision. You'll find more sales use cases in our full catalog of Gillia use cases: read revenue by category or by item or get a chart on demand.
To go further, explore the Gillia POS: every sale updates your inventory, customer records and online store.