Shop statistics

Open Journal -> Shop Statistics. Compare purchases and refunds, find popular products and open order details.

September purchases for the selected project: confirmed orders, payments received and returns.

Select data

Field	How to use it
Project	Choose one project or all available projects.
Game server	After selecting a project, keep all servers or choose one.
Period	Today, the last 7, 30 or 90 days, the current year, the previous year, or custom dates.
From / To	Inclusive start and end dates in UTC. You can select earlier years, not only recent months.
Group by	Automatic, daily, weekly, monthly or yearly. Changes chart and calendar intervals, not the total for the selected dates.
Currency	Select a purchase currency. Its project and decimal precision appear beside it. Automatic selection displays one available currency, not a combined total of different currencies.
Rows per page	10, 25, 50 or 100 rows in the product list.

Press Refresh, the circular-arrow button, to apply your selection. The reset-filter button restores the initial values. Changing filters returns the product list to its first page.

All monetary values refer to the selected currency and project. Matching currency names in two projects do not mean their amounts are added together. Past purchases retain their order prices, not today's catalog prices.

Purchases and returns

The headline cards show Confirmed orders, Payments received, Money returned and After returns. The last value is the amount received minus refunds for the selected dates.

The Order summary includes:

• Created, delivered and cancelled orders: each count uses the date of that action. An order may be created in one month and delivered in another.
• Confirmed orders: paid purchases and separately confirmed free purchases. Free orders are shown separately; Payments counts only purchases with a positive amount.
• Paying players: distinct registered players with a positive payment. Repeat purchases by the same player do not increase this count. Guest orders are separate.
• Average payment: payments received divided by the number of payments. Free orders do not lower the average. Largest payment is the highest single purchase amount.
• Discounts and surcharges: price adjustments in confirmed orders.
• Refunded orders: orders refunded during the selected dates.

Main balance, bonus balance, direct payments and returned funds are shown separately.

The Payment source table separates main balance, bonus balance and direct payments. A purchase paid from multiple sources contributes its respective amounts to each row.

A refund uses the refund date, even if the purchase happened before the selected period. After returns can therefore be negative. For example, payments of 100 and refunds of 150 result in -50, not a new purchase with a negative price.

Charts and calendar

Payments and returns over time shows amounts received and refunded. Average payment over time is calculated separately for each interval. An interval without payments has no average.

Days without purchases stay on the calendar; averages appear only for intervals with a payment.

Expand Values by period to read exact amounts, confirmed and delivered order counts, and average payments. Change Group by and refresh to compare months or years. The first and last intervals may cover only part of a month or year, depending on the selected dates.

The same period grouped by month, with numerical values below the chart.

Activity and comparisons

By time

By hour (UTC) and By weekday (UTC) compare payment counts, amounts and average payments. Hourly rows combine the same hour across all selected days; they are not limited to today.

Both comparisons use the same period and currency, with times in UTC.

By game server

Compare payments, received and returned amounts, and average payments across the selected project's servers. Whole project refers to purchases not assigned to an individual server; it is not a repeated total of the other rows.

The Essence server's figures for the selected period.

Top buyers

The table lists up to ten registered players with the highest purchase amounts, their payment counts, refunds and average payments. Click a player to open their profile. Guest orders are available separately in the purchase journal through the Buyer type filter.

Repeat purchases by the same player are combined into one row.

Products and orders

Most purchased products lists up to ten offers with the highest purchased quantities. The complete Products list below it has page navigation.

Column	Meaning
Product	Offer name and image, project and game server.
Confirmed orders	Number of orders containing the offer.
Quantity	Purchased offer quantity. One bundle may contain several game items.
Value before discounts	Order-line value before discounts and surcharges, not final product revenue after all price adjustments.
Refunded quantity	Offer quantity in refunded orders and the number of those orders. Does not confirm removal of an already delivered item from a character.
Purchase journal	Opens purchases of this offer for the selected dates.

Actual purchases of three different offers: a coin bundle, a Soulshot pack and an Adena chest.

An order containing several offers appears in each product's row. Do not add those order counts to get the overall number of orders; use the headline card.

Click the journal icon beside a product, then the view icon beside an order. The purchase journal shows payment details, recipients and delivery results.

Missing or unavailable data

• Check the project, server, currency and dates. An empty period does not mean there have never been any purchases.
• If recent purchases are still being added, wait for the automatic refresh or press Refresh.
• Retry a failed load. For an oversized report, select one project or a shorter period.
• If the data changes or the selection expires, refresh and continue from the first page.
• If orders are awaiting confirmation or need review, open the journal and select that status.