Igor Ivitskiy, PhD in Mathematical Modelling
Reports count conversions. I count the cash you kept.
Follow a payment- Payments received
- Less refunds
Cash kept = payments received less refunds.
Illustrative order
- Reported
- £80
- Cash kept
- £65
- Gap
- £15
Exclude refused or uncollected orders.
Margin = cash kept less the costs listed in the report.
Starting with orders or receipts
From booked orders, set aside unpaid orders, including refused deliveries. Bank receipts already exclude them.
Deduct each refund once. If it already appears as a negative payment, the total already includes it.
For a shop, recorded costs can include goods and delivery. If a cost is missing, I say which costs the margin covers.
I follow one dated conversion all the way to its receipt.
- Dated ad eventReference
- CRM enquiry or shop order
- Invoice
- Payment and refund
If I cannot match a receipt, I keep it separate and name the missing reference.
Different IDs or subscription payments
When IDs differ, I match the date and amount against the customer or transaction details. I leave an uncertain match open.
For subscriptions, I group customers by sign-up month. I compare payments after refunds over the same agreed period from sign-up for each group.
An invoice within terms stays open.
- Late
- Paid after the cut-off. Keep the payment date.
- Lost
- Order refused or payment refunded. For a partial refund, I count only the refunded amount as lost.
- Open
- Outstanding quote or invoice within terms.
Lost deals and unmatched receipts
A CRM deal closed without a sale explains why a counted enquiry brought in no money. For an unmatched receipt, I record which reference I still need to identify the enquiry or order.
The label tells you what you can check.
| public-record | Original publication, author, date and wording |
|---|---|
| self-reported | Who said it and which period it covers |
| single-case | That case's records and calculation |
| pooled-private |
Published totals and sample. Individual records stay private.
Accounts came to a consultant. Each advertiser defined its own conversion. Field definitions |
A receipt proves payment. The ad's contribution takes a comparison.
Open data lets you repeat the calculation. Private totals let you check the arithmetic. Individual payments need source records.
Payment record
What was paid?Comparable case without the ad
What would have happened anyway?Repeat the calculation
I give the source version, units, dates, exclusions and calculation. I show how the answer changes when an assumption changes.