Short answer
Divide the value of included sales by the count of those same sales, using a common currency and period rule. Open quotes, customers and partial payments are not interchangeable denominators. Show median, count and cancellations to reveal whether one large transaction distorts the average.
Key verification: Reconcile the total and sales count with eligible transactions, checking currency, cancellations and period.
Sources and limitationsAverage sale value describes the mean transaction amount under a specific rule. It does not describe a customer's lifetime contribution or remaining profit. Define a sale and the amount to sum before opening a CRM report.
Choose a consistent basis
Decide whether you study accepted orders, recognised billing or receipts, labelling the measure accordingly. Do not add open quotes to closed sales. Paying for one operation in instalments does not automatically create several sales.
Use consistent treatment of tax, discounts and refunds, reviewed with the person managing those records. Keep a common currency and document conversion where needed. Adding euros and dollars without a rule produces a number without a valid unit.
Original example: mean and median
| Eligible fictional sale | Amount in EUR |
|---|---|
| A | 100 |
| B | 100 |
| C | 100 |
| D | 100 |
| E | 600 |
| Total | 1000 |
| Mean: total divided by sales | 1000 / 5 = 200 |
| Median: ordered central value | 100 |
The mean is two hundred euros, but four of five sales are worth one hundred. The median better describes the central transaction in this sample. The fictional example sets no recommended service price.
Denominator worksheet
- Unique transaction identifier.
- Eligible status and date used.
- Original amount and currency.
- Cancellations, refunds and treatment rule.
- Service or segment for comparing mixes.
- Amount source and reconciliation reference.
A transaction without confirmed value remains pending; it is not converted into a zero-value sale to complete reporting. Two distinct purchases by one customer count as two operations when that is the defined unit. Two payments for one purchase do not become two sales.
Why the average can rise without business improvement
If small transactions disappear leaving one large project, the average may rise while volume falls. Present total value and transaction count alongside the mean. Review service mix before attributing change to pricing increases or better sales work.
Average value is not margin: larger sales may carry greater costs. It does not demonstrate retention either. Compare periods with equivalent scope and separate facts from hypotheses.
What to verify in Riibase CRM
The official Riibase page describes commercial management and reporting. Confirm access to the fields, statuses and detail the worksheet needs. Do not assume an automated answer uses the same sales definition as your calculation.
Reproduce the result with a small authorised sample before relying on a dashboard. If cancellations or currencies are missing, complete analysis in an appropriate register. CallsIQ has not run this Riibase query; the table and worksheet provide a checkable calculation without requiring a new CRM purchase.
Sources and limitations
Documentary review: . Content type: Documentation-based guide with original resource.
Sources describe terms and capabilities stated by their owners. Proposed protocols and fictional examples do not establish product tests performed by CallsIQ.
- official Riibase pagewww.riibase.com
Check current terms
Consider these options if they solve the problem described. Confirm features, limits and availability in your country.
Riibase CRMAffiliate linkThe labelled commercial links may earn CallsIQ a commission or referral reward. Our commercial policy.
Official sources, explained calculations and clearly labelled examples. Read about our methodology and use of AI in writing.