Statistics

Statistics shows how the shop is doing: revenue, orders, basket value, cancellations, vouchers, assortment, customers and more. You choose a period, compare it with an earlier one and download the tables as CSV. plinth collects the figures from Shopware every night, so the pages open quickly.

Where to find it

Open Reports > Statistics. The sub-pages are in the menu below it and as tabs at the top of every statistics page:

Two more tabs appear only at the top of the statistics pages: Compare shops (when you have access to several shops with statistics) and Mail (the scheduled statistics mail).

What you need

• The permission View statistics for the overview, orders, season, payments, times and sales analysis.
• View assortment statistics for the Assortment page.
• View customer numbers and regions for the Customers page and the regions on the Orders page.
• Export statistics for the CSV downloads.
• Set up statistics mail for the Mail tab, Change statistics settings for Settings.
• A connected shop with its access keys, see Onboarding wizard.
• A finished first statistics import, see "How do I check the statistics import?" further down on this page.
• For the statistics mail: a mail server set up in the reports area, see Reports.

Permissions are assigned in Access.

Note: Statistics shows figures only. It contains no customer names, addresses or e-mail addresses. Regions appear only from 5 orders.

How do I choose a period?

1. Open any statistics page.
2. Click one of the buttons 7 days, 30 days, This month, Last month, 90 days, 12 months, This year or Last year.
3. For your own period, fill in the two date fields and click Apply. A period can be about two years at most.
4. The line below the buttons shows the selected period, the number of days and the previous period.

The period stays selected when you switch between the tabs.

How do I compare two periods?

1. Open Overview, Orders or one of the Sales analysis views.
2. Next to Comparison, choose what the period is compared with:
   • Previous period: the same number of days directly before. A calendar month is compared with the month before.
   • Previous year: the same dates one year earlier.
   • Avg. same weekday (4 weeks): the average of the same weekdays in the last four weeks.
   • None: no comparison.
3. The change in the tiles and the second line in the chart follow this choice.

On Overview and Orders you can also click Show previous year. It adds the same period of last year to the charts and the change to last year to the tiles.

Note: If days are missing in the comparison period, plinth shows a note and leaves the change values out instead of showing wrong numbers.

How do I read the overview?

1. Open Reports > Statistics.
2. The tiles show Revenue, Orders, Avg. basket, Cancellation rate, Voucher share and New customer share. Hover over a tile for the exact definition; click it to open the details.
3. Below are the charts Revenue and Orders, the tables Best-selling products and Vouchers, and Anomalies and tips.
4. Open More reports for Weekday and time of day, Payment methods, Customers and the Forecast for the running month.

Revenue is the sum of the order totals (gross, including shipping) of all orders that were not canceled.

How do I analyse orders?

1. Open Reports > Statistics > Orders.
2. Under Trend, set Group by to Day, Week or Month. Chart and table follow.
3. Notable days lists Best days, Weakest days and Unusual days (far from the usual value for that weekday).
4. Further down you find Payment methods, Cancellations, Sale share, Order value bands, Free-shipping threshold, Vouchers and, with the customer permission, Customers and Regions.
5. A click on a voucher code opens its report under Vouchers for the same period.

The block Free-shipping threshold appears only when a threshold is set in the settings.

How do I find products that need attention?

1. Open Reports > Statistics > Assortment.
2. Click one of the tiles Reorder, Sold out, Dead stock or New to show only this group in the product list. Click again to show all.
3. Use Search products, brands or categories to narrow the list.
4. Read the columns Stock, Sell-through and Stock cover (days). Sell-through is items sold divided by items sold plus today's stock.
5. A click on a product opens it in the shop admin in a new tab.

The page also shows Brands, Categories, Sizes and Price bands.

How do I compare seasons?

1. Open Reports > Statistics > Season.
2. Orders per season shows Spring/Summer and Autumn/Winter by order date, with the change against the same season last year.
3. Assortment by release season groups the products by the season of their release date: sales in the selected period against today's stock.

How do I analyse customers, payments and order times?

Customers

1. Open Reports > Statistics > Customers.
2. If the page says No customer analysis yet, click Calculate now. Progress is shown on the Jobs page. Otherwise the analysis runs at night.
3. Read New and returning per month, Days until the second order and Cohorts by first order month. In the cohorts, switch Measure between Share ordering, Revenue and Revenue per customer.

Payments

1. Open Reports > Statistics > Payments.
2. The tiles show Payment attempts, Failed, Canceled and Amount in failures. Click a tile to filter the table of payment methods.

Times

1. Open Reports > Statistics > Times.
2. The map Orders by weekday and hour shows when people order. Darker means more.
3. Click the tile Orders in the period or Revenue in the period to colour the map by orders or by revenue.

How do I use the sales analysis?

1. Open Reports > Statistics > Sales analysis.
2. Choose a view in the second tab row:

3. Use Group by and the filters of the view, then click Apply.

Note: Stock is always today's stock. There is no stock history, so the comparison column sets earlier sales against today's stock.

How do I export a table as CSV?

1. Choose the period first. The export uses the selected period.
2. Scroll to the end of the page. Next to Export there is one button per table, for example Revenue per day, Payment methods, Vouchers, Products, Brands, Categories or Seasons.
3. Click the button. The CSV file is downloaded.

The buttons appear only with the permission Export statistics. Every export is logged, see Audit log.

How do I get the statistics by mail?

1. Open the tab Mail on a statistics page.
2. Tick Statistics mail active.
3. Under When, choose the Frequency (Weekly (the last 7 days) or Monthly (the previous month)), the weekday or day of month and the Time.
4. Under Sections, tick what the PDF should contain.
5. Under Recipients, tick plinth users or enter More addresses, one per line.
6. Click Save. To try it, enter a Test address and click Send as test now.

The mail contains one sentence and a PDF with totals only. Without a mail server nothing is sent.

How do I change the statistics settings?

1. Open Reports > Statistics > Settings.
2. Under Free-shipping threshold, fill in Free shipping from (goods value in euros). Empty or 0 switches the view on the orders page off.
3. Under Sales analysis, adjust the thresholds, for example Slow movers: sell-through below (percent) or Pairs: minimum orders together. An empty field means the default.
4. Click Save. The settings apply to this shop.

How do I check the statistics import?

The statistics need the order history of the shop. plinth loads it in the background:

• In the Onboarding wizard, the step First import loads the shop data. The statistics load last, in the background. The first load covers about the last 13 months and can take a while.
• After that, plinth updates the statistics every night. It also re-reads the last weeks, so later cancellations reach the numbers.

To see the status:

1. Open the Jobs page.
2. Look for the jobs Update statistics and Sync orders. A later reload of older days is called Backfill statistics.
3. Running shows the progress in days. Done means the days are stored. For Failed, expand the row for the reason.

While the import runs, the statistics pages already work. A banner Data incomplete names the days that are still missing; they show up once loaded.

What does "as of" mean?

Not every number on a page belongs to the selected period:

• Period figures (revenue, orders, items sold) cover the selected period. Complete days come from the nightly update. Today is read live and marked with Today's data is not complete yet.
• Stock figures (Stock value, Stock today, Sell-through) are as of today. The tile tooltip says so: the chosen period does not apply here. On the assortment page, the line Assortment data from ... shows when the product data was read.
• Customers and payments show Analysis as of ...: the time of the last calculation, normally last night.

Common errors and fixes

See also

• Markers: mark events in the charts and check their impact
• Reports: PDF and CSV reports on a schedule
• Vouchers: voucher report per code and campaign
• Returns: return rates, reasons and costs
• Jobs: status of the statistics import
• Glossary