Old: Statistics

Total revenue development

Shows the number of orders and the revenue for the selected period.
Returns and credit notes are not included in the number of orders. The number of returned items from item bundles will be analysed. However, the corresponding revenue will not. This statistic shows when a few orders generated a large amount of revenue or many orders generated only a small amount of revenue.

Returns/credit notes/cancellations

Shows the monetary amounts of returns, credit notes and cancellations for the selected period. This analysis helps you to monitor returned items. Use the Reasons for return statistic to correlate reasons for return statistic e.g. to referrers.

Revenue by item group

Shows the revenue by item groups of orders for the selected period and order statuses. Different filters allow you analysing based on specific item groups, e.g. by filtering by flags.

Revenue by referrer per item

Shows the revenue by item groups of orders for the selected period and order statuses. The statistic shows which order referrers were profitable and which referrers generated little or no revenue.

Revenue by referrer per order

Shows the revenue by order referrer of orders for the selected period and order statuses. The statistic shows which order referrers were profitable and which referrers generated little or no revenue.

Revenue by sales representative

Shows the gross revenue and the number of orders per sales representative for the selected period.

Revenue by manufacturer

Shows the gross revenue and the number of items sold per manufacturer for the selected period. The statistic shows revenue by manufacturer and the ratio of item quantities to revenue.

Revenue by category

Shows the gross revenue and the number of items sold per category for the selected period. The statistic shows the revenue distribution according to categories and also the efficiency of categories when it comes to the revenue they generate.

Revenue by country of delivery

Shows the revenue per country of delivery for the selected period. The statistic shows the countries of delivery that generated the most revenue, i.e. the most lucrative countries of delivery.

Revenue by shipping region

Shows the revenue per shipping region for the selected period. The statistic allows you to analyse which shipping regions are particularly profitable.

Revenue by payment method

Shows the gross revenue and the number of orders per payment method for the selected period. The statistic shows the payment methods that generated the most revenue, i.e. the most popular payment methods.

Shipping costs generated per shipping service provider

Shows the shipping costs by shipping service provider for the selected period. The statistics is based on the date of outgoing items.

Shopping cart development

Shows the average shopping cart value and the average shipping costs for the selected period. The statistic provides an overview of shopping carts' development month by month. This allows you e.g. to check if high shipping costs often prevent customers from going through with buying the items they placed in the shopping cart.

Order processing times

Shows whether the majority of the order processing time was used in reaching the status paid or the status shipped. You will also see the percentage of total processing time that was needed. In addition, it helps you to determine if there is any need for corrective measures due to disproportionately long processing times.

Pending amount by payment method

Shows the total pending amount and dunning level per payment method for the selected order statuses. The statistic shows the payment methods with the largest pending amounts and the highest dunning levels.

Status of the current orders

Shows the number of orders and the revenue for the order status. The status Shipped only includes orders from the current day. The statistic offers an overview of how orders are distributed across the different order statuses. For example, it allows you to see the number of unpaid orders at a glance.

Shipping orders by shipping service provider

Shows the number of shipping orders by shipping service provider for the selected period. The statistics is based on the date of outgoing items. The statistic shows how shipping orders are distributed across the different shipping service providers.

Order items

The order parameters and a variety of information about the revenue will be shown in a data table for the selected period. The statistic shows how revenue data of orders is composed. Tables allow you to compare amounts directly.

Reasons for return

Shows the number of returns and the revenue from returns for the selected period. Returns are shown sorted by reason for return. The statistic shows the number of returns and how much revenue was lost due to returns in the selected period. Furthermore, you can determine how the number of returns and the corresponding amounts are distributed among the different reasons for returns. The statistic allows you to monitor refunds and returns. By filtering by referrer, you can spot recurring reasons for return for specific referrers.

Sent email templates

Shows the ID and name of the email templates and the number of emails sent for the selected period. The statistic shows which email templates were used in the selected period. This can help you to determine which processes are frequent and which do not occur very often.

Sold quantities / returns

Shows the number of items sold and the number of returns and the revenue for the selected period. All items are shown, i.e. including those items without returns. The return rate shows you the relationship between how many times an item was sold and how many times it was returned.

Tops / Flops

Shows the top items, i.e. those sold most often, and/or the flops, i.e. the least sold variations for the selected period. The variations are shown in descending order. This list will end with whichever top variation was sold the least often. The list of flops begins with the variation that was sold the least often and progresses with variations that were sold more and more often.
You can only analyse and export data for a period of 6 months.
This statistic takes sold quantities into consideration when calculating basic items from item bundles. However, the purchase price and the revenue are not taken into consideration. The statistic shows which items are not lucrative. For example, you may notice that the warehouse and operating costs of an item are higher than the profit.

Sold item quantities

Shows items in sales ranges based on the number of items sold for the selected period. Furthermore, the total number of sold items and the percentage of total revenue is displayed for each sales range. The statistic shows how many items were sold in each sales range and what percentage of the revenue each sales range generated.

Current stock

Shows the value of items per category and the stock by warehouse. The statistic shows the available and reserved stock and stock values in each or all warehouses.

Estimated stock turnover and reorder levels

Shows the stock turnover of items sorted into categories according to their stock turnover in days. It also shows how many items were sold in one category during the selected period. This data is used to calculate the stock turnover in days and group the data into categories. The statistic shows whether there are items that only have enough stock to last a few more days.

Stock

Shows the value of items per variation and the stock per warehouse. The statistic shows the available and reserved stock and stock values for variations in each or all warehouses.

Incoming items by date

Shows the number of items and the value of incoming items by date. The statistic shows the values of incoming items and the item quantity per supplier per warehouse for the selected period.

Incoming items by supplier

Shows the number of items and the net value of items by warehouse and supplier. The statistic shows all values of incoming items and the item quantity per supplier for the selected warehouses.

Item revenue

Shows an analysis of the value of items by warehouse, order referrer, payment method and shipping profile for the selected period. The statistic shows how revenue data is composed.

Value of items

Shows an analysis of the value of items by warehouse, price and supplier for the selected period. The statistic shows the value of items and the quantity by warehouse.

Value of items by supplier

Shows the number of items and the net value of items by supplier for the selected period and warehouse. The statistic shows the value of items and the quantity by supplier.

Customs list for outgoing items

Shows an analysis of your outgoing items based on when the orders were received and the selected order type for the selected period. The statistic provides you with a variety of information about your orders and customers, which you can use for customs forms or for other purposes.

Consumer behaviour

Shows how many customers (grouped by order quantity) generated a certain amount of revenue. For example, you can see which customers generate the most revenue: those who rarely purchase in your store or those who make purchases regularly. The order quantities apply per customer. As such, e.g. the quantity <3 means that the customers shown have generated less than 3 orders per customer.

Top / Flop customers

Shows the revenue data sorted by customers who generated the most revenue and those who generated the least revenue in the selected period. The customers will be listed in descending order. Thus, the list will begin with the customer who generated the most or least revenue. The statistic shows which customers generate a lot or very little revenue, which will help you to analyse their purchase behaviour and target your promotional activities.

Revenue by customer class / feedback

Shows revenues and orders by customer class for the selected period and the selected order status. The statistic shows which customer classes are particularly profitable.

Tickets by current status

Analyses tickets by current status at the time when the statistic was created. The tickets are grouped by the types and statuses selected. A tooltip displays the number of tickets as a percentage of all the displayed tickets. The statistic shows the number of tickets of a type in a particular system state.

Tickets by status

Displays the tickets based on status and ticket type for the selected period. The statistic shows the number of tickets of a type in a particular system state.

Tickets by system state

Displays the tickets based on system state and ticket type for the selected period. The system state is assigned to a ticket automatically and cannot be changed.

Returns

Shows the monetary amounts of returns by reason for return for the selected period. The statistic shows the number of returns and the revenues affected by returns. Furthermore, you can determine how the number of returns and the corresponding amounts are distributed among the different reasons for returns. This helps you to monitor returns.

Revenue by date

Shows the item revenues (e.g. gross or net revenue) for the selected period.

Revenue by referrer

Shows the order revenues by the referrer shown for the selected period.

Revenue by country of delivery

Shows the order revenues by country of delivery for the selected period.

Revenue by client (store)

Shows the item revenues (e.g. gross or net revenue) by online store and/or client (store) for the selected period.

Revenue by item variation

Shows the revenue per variation of the item, e.g. gross revenue or contribution margin. The statistic shows which item variations are lucrative and which are not. For example, you may notice that the warehouse and operating costs of an item are too high and negatively influence the profit.

Stock

Shows the current stock by variation. Shows the value and the number of items of the available stock and of the reserved stock. It also shows several other stock parameters. The statistic shows the available and reserved stock and stock values per variation in each or all warehouses.

Incoming items by date

This statistic shows the incoming items by date within the selected time span. The data is displayed for the warehouse(s) and supplier(s) that were chosen. The statistic shows the value of items and the quantity by supplier. In addition, the value totals are shown by date in a line chart, e.g. the item quantity and the value of items per month.

Incoming items by supplier

Analysis of incoming items by warehouse and supplier in the selected period. The statistic shows the value and quantity of items per supplier for the entire period selected.

Value of items

Shows an analysis of the value of items by warehouse, price and supplier for the selected period. The statistic shows the value of items and the quantity by warehouse.

Value of items by supplier

Analysis of the value of items and the number of items by warehouse and supplier. Shows the number of items and the net value of items by supplier for the selected warehouses. The statistic shows the value of items and the quantity by supplier.

Total revenue

Shows the number of orders and the revenue for a specific customer and the selected period.

Revenue by referrer

Shows how much revenue was generated by each order referrer. Furthermore, it shows which percentage of the total revenue each referrer generated. The statistic shows how much revenue the customer generated with each referrer.

Revenue by category

Shows revenue per category and the number of items purchased by the customer by date. The statistic shows how much revenue the customer generated in each of the different categories. If you change the time span, then you can also see how much revenue the customer generated in the different categories during a specific period of time.

Name

The statistic’s display name is shown in the top left corner of the title bar.

Period

The period considered in the statistic is shown in the statistic’s title bar.

Click to update the chart with the current data.

Click to edit the statistic.

Zoom

Opens the statistic in a new window. Enlarge the window by dragging the bottom right corner. The window’s size is saved.
Tip: Left-click on the mouse and drag along a section of the column line combination chart to zoom in. Click on Show all to end zooming and show the entire statistic.

Totals

In table views, totals are displayed underneath the rows. There, you will see the column’s total value as well as the column’s average value.
Note: If the data table spans several pages, the totals are calculated for the entire table and not for the page currently visible.

Mouseover info

Click on an area to show additional information.

Chart view

Type of chart

Select how the values should be displayed. Values can be grouped in tables or in different types of charts.

Export

Click to export the statistic data to a CSV file. The statistics export only contains the values shown in the chart type Data table.

Raw data export

Click to export the raw data to a CSV file. The raw data export contains the data pool on which the values shown in the statistic are based.

Settings

Name

Display name of the statistic. The name can be changed at any time.

Period

Select the period from the drop-down list. Select a default value or user the option Date selection and set a start date and an end date.

Starting date;
End date

Enter a starting and ending date instead of selecting a Time span (optional). Only available if the option Date selection is selected.

Date based on

Select which event should be used for analysing the data: Order received, Incoming payment or Outgoing items.

From status / To status

Depending on the type of statistic there are different options available to narrow down the status. Default values are preset.
Note: All types of orders are included in the statistical analysis except for cancellations. Status 8 and Status 8.1 are thus excluded from the statistic.

Client (store)

Select the stores that you would like to include into the statistic.

Order referrer

Select the order referrers that you would like to include in the statistic.
The order referrers correspond to individual orders and not to order items.

Country

Select the country that you would like to include in the statistic. Select all to include all countries.

Payment method

Select the payment method that you would like to include in the statistic. Select all to include all payment methods.

Shipping profile

Select the shipping profile that you would like to include in the statistic. Select all to include all shipping profiles.

Paid orders only

Activate this option to only include paid orders in the statistic.

Orders with outgoing items booked only

Activate this option to only include orders with booked outgoing items in the statistic.

Chart

Amazon account

Select the Amazon account that you would like to include in the statistic.

eBay account

Select the eBay account that you would like to include in the statistic.

Data table

Displays data as a table.
Tip: Tables offer very detailed values at a glance. However, they do not show developments over time as clearly as line, column or bar charts.
Note: If the data table spans several pages, the totals are calculated for the entire table, not only for the page currently visible.

Column chart

Displays data in columns.

Line chart

Displays data as lines.

Column line combination chart

Displays one value as a column, i.e. vertically, and another value as a line, i.e. horizontally.

Bar and line chart

Displays one value as a bar, i.e. horizontally, and another value as a line, i.e. vertically.

Stacked column chart with percentages

Displays data in columns. The percentage data is stacked and shown in different colours.

Stacked double column chart

Displays data in columns. The data is stacked and distinguished by different colours.

Stacked bar chart

Displays data as different coloured bars.

Multi line chart

Displays data as different coloured lines.

2D pie chart

Displays data as two-dimensional pie chart.
Tip: Click on a pie piece to move it out of the pie. Click on each of the pie pieces to move all pie pieces out of the pie chart. Click on the pie piece again to move it back to its original position.

3D pie chart

Displays data as three-dimensional pie chart.
Tip: Click on a pie piece to move it out of the pie. Click on each of the pie pieces to move all pie pieces out of the pie chart. Click on the pie piece again to move it back to its original position.

Net

Amounts minus VAT

Gross

Amounts including VAT

Total

Revenue including shipping costs

Adjusted gross revenue

Gross revenue minus credit notes

Adjusted net revenue

Net revenue minus credit notes

Contribution margin I

Revenue minus purchase price, VAT and shipping costs

Contribution margin II

AdjustedItems

Adjusted items

AdjustedSales

Adjusted revenue

AdjustedSalesNet

Adjusted net revenue

AttributeValueSetID

ID of the item variation

AveragePurchasePrice

Average purchase price

AverageSales

Average revenues

AverageShipping

Average shipping costs

CategoryID

Category ID

CategoryName

Category name

City

Town

Claim

Pending amount

Company

Account

CountryID

Country ID

Country

Country

CountryOfDelivery

Country of delivery

CreditNotes

Credit note amounts

CreditNotesNet

Net credit note amounts

CustomerID

Customer ID

CustomerGroupID

Customer class ID

CustomerName

Customer name

CustomerRating

Feedback by customer

Customs

Customs

Date

Date

DatePaid

Incoming payment

DateShipped

Items shipped on

DistributionMarginOne

Contribution margin I

DistributionMarginTwo

Contribution margin II

Division

Partition number

DivisionDefinition

Order range, e.g. stock turnover

DunningLevel

Dunning level

EmailTemplateID

ID of email template

EmailTemplateName

Name of email template

EntryDate

Incoming order

ExternalItemID

External item ID

FirstName

First name

GrossPrice

Gross price

HouseNumber

House number

InvoiceNumber

Invoice number

InvoiceTotalGross

Gross invoice amount

InvoiceTotalNet

Net invoice amount

ItemID

Item ID

ItemMarking1

Flag 1

ItemMarking2

Flag 2

ItemName

Item name

ItemNo

Item number

ItemNumber

Item number

ItemPriceTotal

The item’s gross total price

ItemPriceTotalNet

The item’s net total price

ItemPriceUnit

Unit price

ItemPriceUnitNet

Net unit price

ItemPurchasePrice

Purchase price

ItemQuantity

Item quantity

Items

Number of items

ItemSellingPrice

Sales price

ItemWeight

Item weight

LastName

Last name

Legend

Legend

Losses

Refunds

Client

Default store or client

MethodeOfPayment

Payment method

NetItemValue

Value of items (net)

NetPrice

Net price

NetStock

Available stock

OperatingCosts

Operating costs

OrderID

Order ID

OrderRowID

Order item ID

OrderType

Order type

PaidAmount

Amount paid

PaymentCommission

Commission of payment method

PaymentMethodID

Payment method ID

PaymentMethodName

Payment method name

Percentage

Percentage

PhysicalStock

Total stock

Price

Price

ProducerCommission

Manufacturer commission

ProducerID

Manufacturer ID

ProducerName

Manufacturer

PurchasePrice

Purchase price

Quantity

Number of incoming items

QuantityOfBundleItems

Items in item bundles

QuantityOfCreditNotes

Number of credit notes

QuantityOfCustomers

Number of customers

QuantityOfItems;
QuantityItem

Number of items

QuantityOfItemsBundle

Items in item bundles

QuantityOfMessagesSent

Number of sent messages

QuantityOfOrders

Number of orders

QuantityOfReturns

Number of returns

ReasonOfReturnID

ID of return reason

ReasonOfReturnName

Name of return reason

Referrer

Order referrer

ReferrerID

ID of the referrer

ReservedStock

Reserved stock

ReturnedItems

Number of returned items

ReturnRate

Return rate

Returns

Gross amount returns

ReturnsNet

Net amount returns

Sales

Gross revenue

SalesAdjusted

Adjusted revenue

SalesAdjustedNet

Adjusted net revenue

SalesGross

Gross revenue

SalesNet

Net revenue

SalesPercentage

Percentage of revenue

SalesWithoutShippingCosts

Revenue minus shipping costs

ShippingCosts

Shipping costs (gross)

ShippingCostsGross

Shipping costs (gross)

ShippingCostsNet

Shipping costs (net)

ShippingProviderID

ID of the shipping service provider

ShippingProviderName

Name of the shipping service provider

ShippingRegion

Shipping region

SoldItems

Sold items

Status

Order status

StockCosts

Storage costs

StoreID

ID of the online store

Street

Street

Store

Default store or client

SupplierID

Supplier ID

SupplierName

Supplier name

Timestamp

Date at which the order was received

TimestampPaid

Date of incoming payment

TimestampShipped;
TimestampShipping

Date of outgoing items;
(Processing times)

ToPaidHoursAverage

Average number of hours needed for the order status to reach Paid

ToPaidPercentage

Percentage of total processing time needed for orders to reach Paid

ToPaidHoursPercentage

Average number of hours needed for the order status to reach Shipped

ToShippedPercentage

Percentage of total processing time needed for orders to reach Shipped

Total

Revenue including shipping costs

TradeRepresentativeCompany

Company of the sales representative

TradeRepresentativeID

Sales representative ID

TradeRepresentativeLastName

Last name of the sales representative

TradeRepresentativeName

Name of the sales representative

TransportationCosts

Transportation costs

Type

Order type

UserID

User ID

UserName

User name

VariationPurchasePrice

Purchase price of the item variation

ValueOfNetStock

Value of available stock

ValueOfPhysicalStock

Value of stock

ValueOfReservedStock

Value of reserved stock

Variation

Attribute values of the variation

VariantID

ID of the variation

VariantName;
VariationName

Name of the variation

VAT

VAT

WarehouseID

Warehouse ID

WarehouseName

Warehouse name

ZIPCode

Postcode