Transaction Filtering
Only successful transactions are included - Pending, cancelled, or unsuccessful transactions are excluded from the data model, which means transactions may appear in reports several days after creation depending on the payment method
Orders without successful transactions are excluded - Only orders that contain at least one successful transaction will appear in the data model
Date Attribution
Order creation and success dates are determined by the first successful transaction associated with the order. The order creation date will be the creation date of that first successful transaction, while the order success date will be when that transaction was successfully completed. For example, if the first successful payment was created on Monday and completed on Wednesday, the order creation date will be Monday and the success date will be Wednesday
All transactions are backdated to the initial order creation or success date for reporting purposes, meaning future installments and refunds will appear on the original order date in P&L statements
Revenue Calculation
Gross revenue represents actual customer payments before refunds, not expected order value. For installment plans, if a customer pays 2 out of 3 planned €50 installments before cancellation, the gross revenue will be €100, not €150
GMV (Gross Merchandise Value) equals gross revenue since discounts are pre-deducted by Ablefy and cannot be separately tracked
Discounts always show as €0 in P&L statements because they are already deducted from amounts received from Ablefy
Line Item Modeling
Order-level metrics are distributed to line items to ensure all metrics are available at the granular level required for detailed analysis
Revenue allocation is calculated proportionally when individual product pricing is undefined (common with payment plans), using sold quantity share and other variables to determine each line item's share of revenue, taxes, and fees