Verkkokurssikassa
Sales

Order Reports

Order Reports let you track sales over different time periods, view product, country and refund breakdowns, and export orders as a CSV file.

Date Range

Reports are filtered by the selected date range. You can choose from preset ranges (today, yesterday, last 7, 30 or 90 days, last 6 months, current or previous month, current year, all orders) or enter a custom range. The last 7, 30 and 90 days include today. You can also select the time zone used to calculate day boundaries.

On the Lifetime Value tab the range means something different: it selects which customers belong to the report by when they were acquired, not which orders are counted. That tab therefore opens on a 6 month range by default.

Currency Mode

Reports can be shown either in the original currencies the orders were paid in or converted to a single currency. Conversion uses the average European Central Bank exchange rate over the selected date range. If a rate is missing for one of the currencies, converted figures are unavailable for that range, and the original currencies still show.

Sales Figures

Sales figures across the reports are net of refunds. A partially refunded order counts at what the customer paid minus what was refunded, and a fully refunded order is left out of sales and order counts. Refunds themselves are reported on the Refunds tab.

Metrics

The Sales Tracking tab shows four key metrics for the selected date range:

MetricDescription
RevenueSales incl. VAT for the selected date range, net of refunds.
OrdersNumber of paid orders, not counting fully refunded ones.
Average Order ValueRevenue divided by number of orders.
Conversion RateShare of opened checkouts that ended in a paid order, including orders refunded later.

Tabs

Sales Tracking

Compares the performance of sources, checkout links, and offers. Each section has a table and a time-series chart. The table shows revenue, order count, average order value, conversion rate, and view value (revenue divided by all opened checkouts).

Products & Add-ons

Product-level sales figures: revenue, order count, average order value, add-on sales share, and the top offer and source. A separate section shows the attachment rate for Order Bumps and Pre-upsells (the share of orders that included the add-on sale).

Discount Codes

Sales by the discount code customers used, for example to settle a revenue share with whoever promotes a code. The key metrics at the top cover every order that used a code: how many there were, their sales incl. VAT, their share of all sales, and the total discount.

The table has one row per code, with the code's description below it. When abandoned checkout emails include a discount code, each customer gets their own single-use code, so those codes are added up in one row.

ColumnDescription
OrdersPaid orders that used the code, not counting fully refunded ones.
Sales incl. VATWhat customers paid, minus refunds.
Sales excl. VATSales incl. VAT minus VAT.
Total discountWhat the code took off the price at purchase, VAT included. Refunds don't reduce it.

An order counts in the date range it was placed in, at its current figures. A refund made later lowers the sales of that range, so the figures for a range you have already settled with someone can still change. The transactions export records each payment and refund on its own date instead.

International

Sales broken down by the currency customers paid in and by the country in their billing details. Both tables show three sales figures, all net of refunds:

FigureDescription
Sales excl. VATSales incl. VAT minus VAT.
VATThe VAT charged on the sales, minus the VAT share of refunds.
Sales incl. VATWhat customers paid, minus refunds.

Sales by Currency has one row per currency, with the sales figures and order count. Its amounts are always in the currency itself, whichever currency mode is selected.

Sales by Country has one row per country. Expand a country to see its regions. When the report is converted to a single currency, the sales figures are shown in that currency and the table also shows the average order value. When the report shows original currencies, each cell lists a separate amount for every currency the country's customers paid in, and the average order value is not shown.

A chart below the tables shows orders by country over time.

Analytics

Three separate sections:

  • Analytics Consent: consent acceptance rate over time, and the number of accepted and rejected consents
  • Device Breakdown: share of mobile, desktop, and tablet devices across orders over time
  • Payment Methods: breakdown of payment providers and methods as a table and pie chart, and trends over time

The consent section shows data only when the checkout has an analytics integration set up, such as a Meta pixel or a Google Tag Manager container.

Abandoned Checkout

Emails sent, emails clicked, click rate, orders recovered, recovery rate, revenue recovered, unsubscribes, and unsubscribe rate. A per-email breakdown shows how many of each email in the sequence were sent, clicked and recovered, with the click rate, recovery rate and conversion rate after a click. Populated once Abandoned Checkout Emails are enabled and the recovery flow has begun sending.

The figures describe the emails sent in the selected date range. A click and the recovery that follows it count toward the email that was clicked, and an unsubscribe toward the emails sent to that order, so the figures for recent periods can still grow as customers respond.

Refunds

Shows how much has been refunded from orders placed in the selected date range, regardless of when the refund was made.

FigureDescription
Lost revenueTotal amount refunded.
Refund rate by amountLost revenue as a share of what customers originally paid.
Refund countNumber of orders with a partial or full refund.
Refund rate by countRefund count as a share of paid orders.

The Top refunded products table lists each refunded product with the number of orders in which it was refunded, the refunded amount, and its refund rate (of the orders that contained the product, the share in which it was refunded).

Amounts on this tab are always in a single currency. When the report shows original currencies, they are converted to euros.

A refund counts toward the period of the original order, so the figures for recent periods can still grow as refunds come in. To see refunds by the date they were made, use the Transactions export.

Lifetime Value

Shows what the customers you acquired are worth over time, rather than what you sold in a period. A customer belongs to the report when their first successful order falls inside the selected date range; their value then includes all of their orders, including ones placed after the range ends.

Value is net of refunds. Because it sums orders across currencies, this tab requires a single display currency and is unavailable when the report shows original currencies.

Four views are available. The first three group customers by what acquired them, and the last lists them individually:

ViewGrouped by
By ProductThe main products on the customer's first order. An "Upgrade product" add-on sale takes the place of the product it replaces, so the upgrade owns the row; add-ons bought alongside a main product get no row of their own. A customer therefore usually appears on a single row. When a first order does contain several main products, the customer counts fully toward each of them, so column totals can exceed actual revenue.
By OfferThe offer the customer's first order came through.
By Checkout LinkThe checkout link the customer's first order came through.
By CustomerOne row per customer, with email, first and latest purchase, and acquisition offer.

Each grouped row reports the average value per customer at three points measured from each customer's own first order: the first 30 days, the first 90 days, and their whole lifetime. The short windows let you compare a product launched last month against one launched two years ago, which lifetime figures alone cannot do.

A window only counts customers who have existed long enough to have it, so a customer acquired ten days ago is left out of the 30 day average. When no customer in a row qualifies, the cell shows a dash. Rows whose product, offer or link has since been deleted are still included and marked as removed, so the totals continue to reconcile with real revenue.

CSV Export

The CSV export offers two separate reports as tabs. Column headers and enum values (such as order and payment statuses) are localized to the user's selected language.

Transactions (Accounting)

A cash-basis view of money-movement events for the selected period, with one row per successful payment, refund, or refund reversal. Failed and unfinished payment attempts are not listed. Intended for bookkeepers as the basis for monthly accounting and VAT reporting.

Rows are sorted by event time (Event time) in descending order. Refund Amount and VAT amount are negative (and refund reversals positive), so in Excel SUM(Amount) gives net cash flow and SUM(VAT amount) gives net output VAT directly.

Columns: Order ID, Order created at, Event time, Event (Payment / Refund / Refund reversal), Email, Country, Currency, Amount (incl. VAT), VAT amount, Payment provider, Payment method, Transaction ID.

The Transactions report is stable for any given date range. New refunds do not retroactively change previously reported months; they appear in their own period as a negative row.

Orders

One row per order in the selected period. Intended as a general overview of orders: who bought, what, from which source, and how much they paid.

Columns cover order basics (ID, created at, status), money (amount incl. VAT and VAT separately, both net of refunds), customer and billing details (name, email, phone, full address, company, VAT ID), order source and offer, payment details, and products and add-ons as separate columns.

Order status filter: you can choose which order statuses are included (Completed, Paid, Partially refunded, Refunded, In payment, Pending, Checkout initiated). By default only real, paid orders are selected (Completed, Paid, Partially refunded, Refunded). You can add unfinished ones if you need them.

A single CSV file can contain up to 50,000 rows. If there are more rows, the export automatically splits them into multiple files. The filename is of the form YYYY-MM-DD_YYYY-MM-DD.csv.

On this page