> For the complete documentation index, see [llms.txt](https://www.analytics-docs.laplacetec.com/guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.analytics-docs.laplacetec.com/guide/en/customdashboard/custom/about_values/order.md). # Order data {% hint style="info" %} Data collected from your connected online stores (Cafe24, Coupang, SmartStore, Imweb, etc.) is **organized into categories**. {% endhint %}

Measure	Description
Actual payment amount	(Product price + option price) × quantity sold - discount - coupon + shipping fee - reward points - deposit
Payment amount	(Product price + option price) × quantity sold - discount - coupon + shipping fee
Payment amount (excl. refunds/cancellations)	Even if a refund/cancellation occurs after the payment date, the value is deducted based on the product's payment date. This metric can change until all orders placed on the payment date are purchase-confirmed.
Gross merchandise value (GMV)	(Product price + option price) x quantity sold. Means GMV (Gross Merchandise Value). If the list price of the product at the time of order is provided, product price = list price; if not, product price = selling price. (Selling price = list price - selling price discount)
Selling price discount	The amount by which the selling price shown on the product detail page is discounted from the list price
Product sales amount	= Gross merchandise value (GMV) - selling price discount
Coupon	Discount amount from applied coupons
Discount	Discount amount applied without coupons, such as selling price discounts, cart discounts, product discounts, and period discounts. Order-level discount amounts are allocated to products and options, then summed.
Shipping fee	Shipping fee paid by the customer
Reward points used	Sums the reward points customers used at the sales channel. Naver Points are not included in reward points used.
Deposit used
Accrued refund / cancellation amount	Counts refund / cancellation amounts by the date the refund occurred. If an order paid on 2024-01-01 is refunded / canceled on 2024-02-01, the refund / cancellation amount is counted on 2024-02-01, the date it occurred. Used to calculate financial metrics on an accrual accounting basis.
Refund amount	Counts refund amounts by payment date. If an order paid on 2024-01-01 is refunded on 2024-02-01, the refund amount is counted on 2024-01-01, the payment date. Used to calculate sales performance quickly.
Accrued refund amount	Counts refund amounts by the date the refund occurred. If an order paid on 2024-01-01 is refunded on 2024-02-01, the refund amount is counted on 2024-02-01, the date it occurred. Used to calculate financial metrics on an accrual accounting basis.
Payment amount (excl. accrued refunds/cancellations)	Payment amount - accrued refund/cancellation amount Calculates expected net sales by deducting all claim payment amounts in order of refund and cancellation completion date.
Payment amount (excl. accrued refunds)	Payment amount - accrued refund amount Calculates the payment amount by deducting only the refund amounts that occurred on the refund completion date. A cancellation before shipping only cancels the payment and may not create a refund. To also deduct pre-shipping cancellations, use the Payment amount (excl. accrued refunds/cancellations) column.
Payment amount (payment day+0)	Payment amount - claim amount (payment day+0)
Actual claim amount (payment day+0)	Sums claim amounts completed on the day of payment. A claim means a completed cancellation, exchange, return, or refund. Takes reward points used and deposit used into account.
Actual payment amount (payment day+0)	Actual payment amount - actual claim amount (payment day+0)
Actual payment amount (payment day+0/excl. VAT)	(Actual payment amount - actual claim amount (payment day+0)) / 1.1
Gross merchandise value (GMV) (payment day+0)	Gross merchandise value (GMV) - claim GMV (payment day+0)
Product sales amount (payment day+0)	Product sales amount - claim product sales amount (payment day+0)
Coupon (payment day+0)	Coupon - claim coupon amount (payment day+0)
Discount (payment day+0)	Discount - claim discount amount (payment day+0)
Shipping fee (payment day+0)	Shipping fee - claim shipping fee (payment day+0)
Reward points used (payment day+0)	Reward points used - claim reward points used (payment day+0)
Deposit used (payment day+0)	Deposit used - claim deposit used (payment day+0)
Actual refund / cancellation amount	Takes reward points used and deposit used into account. Counts actual refund / cancellation amounts by payment date. If an order paid on 2024-01-01 is refunded / canceled on 2024-02-01, the refund / cancellation amount is counted on 2024-01-01, the payment date. Used to calculate sales performance quickly.
Actual payment amount (excl. refunds/cancellations)	Refund/cancellation values are deducted based on the payment date (not the refund/cancellation date). This metric can change until all orders placed on the payment date are purchase-confirmed. Used to calculate sales performance quickly.
Actual payment amount (excl. refunds/cancellations/VAT)	Refund/cancellation/VAT values are deducted based on the payment date (not the refund/cancellation date). This metric can change until all orders placed on the payment date are purchase-confirmed. Used to calculate sales performance quickly.
Gross merchandise value (GMV) (excl. refunds/cancellations)	Refund/cancellation values are deducted based on the payment date (not the refund/cancellation date). This metric can change until all orders placed on the payment date are purchase-confirmed. Used to calculate sales performance quickly.
Product sales amount (excl. refunds/cancellations)	= Gross merchandise value (GMV) (excl. refunds/cancellations) - selling price discount (excl. refunds/cancellations)
Coupon (excl. refunds/cancellations)	Even if a refund/cancellation occurs after the payment date, the value is deducted based on the product's payment date. This metric can change until all orders placed on the payment date are purchase-confirmed.
Discount (excl. refunds/cancellations)	Even if a refund/cancellation occurs after the payment date, the value is deducted based on the product's payment date. This metric can change until all orders placed on the payment date are purchase-confirmed.
Shipping fee (excl. refunds/cancellations)	If the entire order is canceled for the same order number and shipping group number, the shipping fee charged is deducted. Refund/cancellation values are deducted based on the payment date (not the refund/cancellation date). This metric can change until all orders placed on the payment date are purchase-confirmed. Used to calculate sales performance quickly.
Reward points used (excl. refunds/cancellations)	Refund/cancellation values are deducted based on the payment date (not the refund/cancellation date). This metric can change until all orders placed on the payment date are purchase-confirmed. Used to calculate sales performance quickly.
Deposit used (excl. refunds/cancellations)	Refund/cancellation values are deducted based on the payment date (not the refund/cancellation date). This metric can change until all orders placed on the payment date are purchase-confirmed. Used to calculate sales performance quickly.
Refund / cancellation amount	Counts refund / cancellation amounts by payment date. If an order paid on 2024-01-01 is refunded / canceled on 2024-02-01, the refund / cancellation amount is counted on 2024-01-01, the payment date. Used to calculate sales performance quickly.
Actual accrued refund / cancellation amount	Counts actual refund / cancellation amounts by the date the refund occurred. If an order paid on 2024-01-01 is refunded / canceled on 2024-02-01, the actual refund / cancellation amount is counted on 2024-02-01, the date it occurred. Used to calculate financial metrics on an accrual accounting basis.
Actual payment amount (excl. accrued refunds/cancellations)	Actual payment amount - actual accrued refund/cancellation amount Calculates expected net sales by deducting all actual claim payment amounts in order of refund and cancellation completion date.
Actual payment amount (excl. accrued refunds/cancellations/VAT)	(Actual payment amount - actual accrued refund/cancellation amount) / 1.1 Calculates expected net sales by deducting all actual claim payment amounts in order of refund and cancellation completion date. VAT is also deducted.
Sales channel fee (manual)	Calculates the fee for each sales channel based on the fee % set in Data management > Fees. Calculated on the actual payment amount, with amounts under 1 KRW truncated.
PG fee (manual)	Calculates fees based on the custom fee % set for each PG and payment method. This column is available to Enterprise customers only. Calculated on the actual payment amount, with amounts under 1 KRW truncated.
Fee	The sum of all fees, such as sales channel fees and PG fees. Calculated on the actual payment amount, with amounts under 1 KRW truncated.
Seller-paid shipping
Claim amount	Sums the amounts of completed cancellations, exchanges, returns, or refunds. Calculated for order numbers created at the time of payment.
Actual claim amount	Sums the amounts of completed cancellations, exchanges, returns, or refunds. Calculated for order numbers created at the time of payment. Takes reward points used and deposit used into account.
Claim amount (payment day+0)	Sums claim amounts completed on the day of payment. A claim means a completed cancellation, exchange, return, or refund.
Cancellation amount	Sums amounts canceled after payment and before shipping.
Exchange amount	Sums amounts of completed exchanges.
Return amount	Sums amounts canceled after shipping and returned.
Actual cancellation amount	Sums amounts canceled after payment and before shipping. Takes reward points used and deposit used into account.
Actual exchange amount	Sums amounts of completed exchanges. Takes reward points used and deposit used into account.
Actual return amount	Sums amounts canceled after shipping and returned. Takes reward points used and deposit used into account.
Canceled quantity	Quantity of items canceled. Counted when the final status of the item order is cancellation completed. If the provider has no partial-quantity cancellation feature or doesn't provide the data, the whole quantity is assumed to be canceled.
Exchanged quantity	Quantity of items exchanged. Counted when the final status of the item order is exchange completed. If the provider has no partial-quantity exchange feature or doesn't provide the data, the whole quantity is assumed to be exchanged.
Returned quantity	Quantity of items returned. Counted when the final status of the item order is return completed. If the provider has no partial-quantity return feature or doesn't provide the data, the whole quantity is assumed to be returned.
Refunded quantity	Quantity of items refunded. Sums the quantity of items whose refund has been completed. Counted by payment date. Used to calculate sales performance.
Accrued refunded quantity	Quantity of items refunded. Sums the quantity of items whose refund has been completed. Counted by refund completion date. Used to calculate net quantity sold.
Claim quantity	Quantity of claims (cancellations, returns, or exchanges) by payment date. (= canceled quantity + returned quantity + exchanged quantity)
Accrued claim quantity	Quantity of claims (cancellations, returns, or exchanges) by occurrence date. (= canceled quantity + returned quantity + exchanged quantity)
Quantity sold (excl. claims)	Quantity sold - claim quantity Quantity sold excluding claim quantity.
Quantity sold (excl. accrued claims)	Quantity sold - accrued claim quantity Quantity sold by payment date minus claim quantity by claim occurrence date.
Quantity sold (excl. accrued refunds)	Quantity sold - accrued refunded quantity Quantity sold by payment date minus refunded quantity by refund completion date.
Cancellations	Counts item orders whose final status is cancellation completed. If a customer adds 1 of product option A, 2 of B, and 3 of C to the cart, pays, then cancels the 2 of B and the 3 of C, cancellations = 2. Basket size (= item payments) is 3.
Returns	Counts item orders whose final status is return completed. If a customer adds 1 of product option A, 2 of B, and 3 of C to the cart, pays, then returns the 2 of B and the 3 of C, returns = 2, and basket size (= item payments) is 3.
Exchanges	Counts item orders whose final status is exchange completed. If a customer adds 1 of product option A, 2 of B, and 3 of C to the cart, pays, then exchanges the 2 of B and the 3 of C, exchanges = 2. Basket size (= item payments) is 3.
Claims	Counts item orders whose final status is cancellation, exchange, or return completed. If a customer adds 1 of product option A, 2 of B, and 3 of C to the cart, pays, then cancels the 2 of B and returns the 3 of C, claims = 2, and basket size (= item payments) is 3.
Full-claim payments	A full claim is when claims occur for every item and every unit in an order number. If a customer adds 1 of product option A, 2 of B, and 3 of C to the cart, pays, then cancels the 2 of B, returns the 3 of C, and exchanges the 1 of A, it's a full claim.
Partial-claim payments	A partial claim is when claims occur for some items or some units in an order number. If a customer adds 1 of product option A, 2 of B, and 3 of C to the cart, pays, then cancels 1 of B, returns 1 of C, and exchanges the 1 of A, it's a partial claim.
Cancellation rate	Cancellations / basket size
Return rate	Returns / basket size
Exchange rate	Exchanges / basket size
Claim rate	Claims / basket size
Full-claim rate	Full-claim payments / payments
Partial-claim rate	Partial-claim payments / payments
Canceled quantity ratio	Canceled quantity / quantity sold
Returned quantity ratio	Returned quantity / quantity sold
Exchanged quantity ratio	Exchanged quantity / quantity sold
Claim quantity ratio	Claim quantity / quantity sold
Payments	Counts the number of order numbers with a payment using a unique count.
Payments (excl. claims)	Payments - full-claim payments
Average selling price (ASP)	Average Selling Price. = Product sales amount / quantity sold ASP shows the average price of products and is used to analyze pricing strategy and the share of sales from high-/low-priced products.
Average order value (AOV)	Payment amount per payment. Average Order Value = Payment amount / payments
Average order value (AOV) (excl. refunds/cancellations)	Payment amount per payment. Average Order Value (excl. refunds/cancellations) = Payment amount (excl. refunds/cancellations) / payments (final)
Quantity sold
ARPPU	"Payment amount per customer. = Payment amount / paying users"
ARPPU (excl. refunds/cancellations)	Refund/cancellation values are deducted based on the payment date (not the refund/cancellation date). This metric can change until all orders placed on the payment date are purchase-confirmed. Used to calculate sales performance quickly.
Paying users
Paying users (excl. refunds/cancellations)	Refund/cancellation values are deducted based on the payment date (not the refund/cancellation date). This metric can change until all orders placed on the payment date are purchase-confirmed. Used to calculate sales performance quickly.
Basket size	"Number of product options in one order number If a customer adds 1 of product option A, 2 of B, and 3 of C to the cart and pays, basket size is 3 and quantity sold is 6"
Basket size (excl. claims)	Basket size - claims Calculated by payment date. This metric can change until all orders placed on the payment date are purchase-confirmed. Used to calculate sales performance quickly.
Average basket size (ABS)	"Basket size per payment = Basket size / payments"
Seller-paid shipping (excl. refunds/cancellations)	If the entire order is canceled for the same order number and shipping group number, the seller-paid shipping fee charged is deducted.
Unique products	Shows how diverse your product lineup is. A diverse range of products is more likely to meet the needs of more customers.
Unique options	Shows how diverse your product option lineup is. A diverse range of product options is more likely to meet the needs of more customers.
Shipments	Counts shipments by order number and shipping group number. Even for the same order number, there can be two or more shipping group numbers, for example for deliveries to remote or island areas.
Settlement amount	The amount scheduled to be settled from open-market channels.
Sales channel fee (auto)	The fee amount charged by open-market channels.
Payment amount (excl. accrued refunds/cancellations/VAT)	(Payment amount - accrued refund/cancellation amount) / 1.1 Calculates expected net sales by deducting all claim payment amounts in order of refund and cancellation completion date. VAT is also deducted.
Payment amount (excl. accrued refunds/VAT)	(Payment amount - accrued refund amount) / 1.1 Calculates the payment amount by deducting only the refund amounts that occurred on the refund completion date. VAT is also deducted. A cancellation before shipping only cancels the payment and may not create a refund. To also deduct pre-shipping cancellations, use the Payment amount (excl. accrued refunds/cancellations/VAT) column.