Cohort revenue report

Draft for review · SYNTHETIC_COHORT_MAPPING_V1 · through 2026-12-15 (Asia/Jerusalem)

Acquisition groups follow lead creation. First-payment groups follow the first actual payment. Cash follows each payment date. Do not add these views together. Gross LTV is before refunds; net cash is after dated refunds.

Calculated from the supplied mapped snapshot. Missing amounts and excluded records can make totals incomplete; inspect the issues below.

Period summary

account attribution rateall attributed revenueblended revenue to spendcash collectedcost per paid leadcrm closedcurrencydirect roasnet cashpaid attributed revenuepaid leadspaid salespaying accountsperiodrevenue per converted leadsales ratespendunpaid leads
UNAVAILABLE0UNAVAILABLE0UNAVAILABLE2ILSUNAVAILABLE00400SeptemberUNAVAILABLE0.000000UNAVAILABLE2
1.00000019501.950000550250.0000002USD1.9500005501950422September975.0000000.50000010002
UNAVAILABLE0UNAVAILABLE0UNAVAILABLE0ILSUNAVAILABLE00000DecemberUNAVAILABLEUNAVAILABLEUNAVAILABLE0
UNAVAILABLE0UNAVAILABLE0UNAVAILABLE0USDUNAVAILABLE-2000000DecemberUNAVAILABLEUNAVAILABLEUNAVAILABLE0

Acquisition and first-payment cohorts

average gross ltvaxiscohort monthcurrencycustomersgross ltvnew revenuereturning revenuereturning shareundated revenue
0.000000acquisition2026-05ILS1000UNAVAILABLE0
90.000000acquisition2026-05USD1909000.0000000
0.000000acquisition2026-08ILS1000UNAVAILABLE0
1182.000000acquisition2026-08USD1118210001820.1539760
0.000000acquisition2026-09ILS4000UNAVAILABLE0
600.000000acquisition2026-09USD4240020004000.1666670
0.000000acquisition2026-10ILS2000UNAVAILABLE0
340.000000acquisition2026-10USD268060000.00000080
1200.000000acquisition2026-11ILS11200120000.0000000
300.000000acquisition2026-11USD130030000.0000000
0.000000first_payment2026-05ILS2000UNAVAILABLE0
270.000000first_payment2026-05USD254054000.0000000
0.000000first_payment2026-06ILS1000UNAVAILABLE0
700.000000first_payment2026-06USD170070000.0000000
0.000000first_payment2026-07ILS1000UNAVAILABLE0
1182.000000first_payment2026-07USD1118210001820.1539760
0.000000first_payment2026-09ILS2000UNAVAILABLE0
275.000000first_payment2026-09USD255055000.0000000
0.000000first_payment2026-10ILS4000UNAVAILABLE0
637.500000first_payment2026-10USD4255021504000.1568630
1200.000000first_payment2026-11ILS11200120000.0000000
300.000000first_payment2026-11USD130030000.0000000

Payment-date cash flow

cash collectedcogs coveragecurrencygross profitknown allocated cogsnet cashpayment daterefunds
900.000000USDUNAVAILABLE0902026-05-060
4500.000000USDUNAVAILABLE04502026-05-150
7000.000000USDUNAVAILABLE07002026-06-100
10000.000000USDUNAVAILABLE010002026-07-120
320.000000USDUNAVAILABLE0322026-08-190
1500.000000USDUNAVAILABLE01502026-08-250
3000.000000USDUNAVAILABLE03002026-09-100
2500.000000USDUNAVAILABLE02502026-09-150
10000.000000USDUNAVAILABLE010002026-10-050
6000.000000USDUNAVAILABLE06002026-10-070
500.000000USDUNAVAILABLE0502026-10-080
5000.000000USDUNAVAILABLE05002026-10-200
2200.000000USDUNAVAILABLE02202026-10-220
3000.000000USDUNAVAILABLE03002026-11-060
12000.000000ILSUNAVAILABLE012002026-11-080
4000.000000USDUNAVAILABLE04002026-11-100
00.000000USDUNAVAILABLE0-2002026-12-02200

30/60/90-day windows — new package logic

cohort monthcurrencydata completedaysfinal window revenuematureobserved revenuepre lead grace revenue excluded
2026-05ILSTrue300True00
2026-05USDTrue3090True900
2026-05ILSTrue600True00
2026-05USDTrue6090True900
2026-05ILSTrue900True00
2026-05USDTrue9090True900
2026-08ILSTrue300True00
2026-08USDTrue30150True15032
2026-08ILSTrue600True00
2026-08USDTrue60150True15032
2026-08ILSTrue900True00
2026-08USDTrue90150True15032
2026-09ILSTrue300True00
2026-09USDTrue301550True15500
2026-09ILSTrue600True00
2026-09USDTrue601950True19500
2026-09ILSTrue90UNAVAILABLEFalse00
2026-09USDTrue90UNAVAILABLEFalse19500
2026-10ILSTrue300True00
2026-10USDFalse30UNAVAILABLETrue6800
2026-10ILSTrue60UNAVAILABLEFalse00
2026-10USDFalse60UNAVAILABLEFalse6800
2026-10ILSTrue90UNAVAILABLEFalse00
2026-10USDFalse90UNAVAILABLEFalse6800
2026-11ILSTrue30UNAVAILABLEFalse12000
2026-11USDTrue30UNAVAILABLEFalse3000
2026-11ILSTrue60UNAVAILABLEFalse12000
2026-11USDTrue60UNAVAILABLEFalse3000
2026-11ILSTrue90UNAVAILABLEFalse12000
2026-11USDTrue90UNAVAILABLEFalse3000

Acquisition spend per new customer — new package logic

acquisition spend per new customercurrencyknown new accountsnew unique customersperioduncertain accounts
UNAVAILABLEILS['A01', 'A05A', 'A05B']3September[]
333.333333USD['A01', 'A05A', 'A05B']3September[]
UNAVAILABLEILS[]0December[]
UNAVAILABLEUSD[]0December[]

Reconciliation of known amounts

attributed revenueattribution differencecash collectedcash differencecurrencyeligible gross chargesexcluded ambiguousexcluded missing dateexcluded no accountexcluded no leadexcluded pre leadgross without cash date
1200012000ILS1200000000
3202060420USD61227000220550145080

Data quality issues

entityidkind
accountA04ambiguous_identity
accountA09inferred_contact_match_review
chargeC15missing_amount
chargeC21missing_amount
chargeC17missing_payment_date
chargeC14no_account
chargeC20no_account
chargeC20status_direction_conflict
chargeC16unmapped_status

Definitions and evidence

{
  "params": {
    "as_of_date": "2026-12-15",
    "currency_policy": "separate",
    "enable_cac": true,
    "history_complete": true,
    "identity_mode": "contact_fallback",
    "pre_lead_grace_days": 3,
    "timezone": "Asia/Jerusalem",
    "windows_days": [
      30,
      60,
      90
    ]
  },
  "sources": [
    {
      "coverage_note": "Synthetic handoff scenarios; includes deliberately missing and contradictory records.",
      "freshness": "2026-12-16T00:00:00+02:00",
      "reference": "SYNTHETIC_SNAPSHOT"
    }
  ],
  "limitations": [
    "Gross LTV excludes refunds; net cash subtracts dated refunds.",
    "Known amounts only; missing or excluded records are itemized, not imputed.",
    "As-of means end of the specified local calendar day; not a historical database snapshot.",
    "Currency rows and report axes must not be added together.",
    "Contact matches require operator review; this is not click-level attribution.",
    "No FX, forecasting, provider extraction or booking-cost parsing.",
    "Installed engine execution and live client pilots are unverified."
  ]
}

AI interpretation is pending. Keep narrative separate from calculations and obtain client-manager review.