Draft for client-manager review. Scope: SYNTHETIC-MAPPING-REVISION
Calculated facts from verified input aggregates. No raw account matching or transaction attribution performed.
| period | currency | matched records | unmatched records | coverage | spend | leads | qualified leads | sales | attributed revenue | cash collected | cost per lead | cost per qualified lead | attributed roas |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| previous | USD | 3 | 1 | 0.7500 | 800 | 40 | 16 | 4 | 3200 | 2400 | 20.0000 | 50.0000 | 4.0000 |
| current | USD | 4 | 1 | 0.8000 | 1000 | 50 | 20 | 5 | 4500 | 3000 | 20.0000 | 50.0000 | 4.5000 |
| period | currency | channel | campaign | matched records | unmatched records | coverage | source references | spend | leads | qualified leads | sales | attributed revenue | cash collected | cost per lead | cost per qualified lead | attributed roas |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| current | USD | Paid search | Synthetic Search | 4 | 1 | 0.8000 | ['SYNTHETIC-ADS-CRM'] | 1000 | 50 | 20 | 5 | 4500 | 3000 | 20.0000 | 50.0000 | 4.5000 |
| previous | USD | Paid search | Synthetic Search | 3 | 1 | 0.7500 | ['SYNTHETIC-ADS-CRM'] | 800 | 40 | 16 | 4 | 3200 | 2400 | 20.0000 | 50.0000 | 4.0000 |
| currency | metric | absolute change | relative change |
|---|---|---|---|
| USD | spend | 200 | 0.2500 |
| USD | leads | 10 | 0.2500 |
| USD | qualified_leads | 4 | 0.2500 |
| USD | sales | 1 | 0.2500 |
| USD | attributed_revenue | 1300 | 0.4063 |
| USD | cash_collected | 600 | 0.2500 |
| USD | cost_per_lead | 0.0000 | 0.0000 |
| USD | cost_per_qualified_lead | 0.0000 | 0.0000 |
| USD | attributed_roas | 0.5000 | 0.1250 |
{
"periods": {
"current": {
"start": "2026-09-01",
"end_exclusive": "2026-10-01"
},
"previous": {
"start": "2026-08-01",
"end_exclusive": "2026-09-01"
}
},
"timezone": "Asia/Jerusalem",
"comparison_basis": "period_activity",
"sources": [
{
"reference": "SYNTHETIC-ADS-CRM",
"freshness": "2026-10-02T09:00:00+03:00",
"coverage_note": "Synthetic complete aggregates; coverage unit is sales records"
}
],
"definitions": {
"spend": "Advertising spend in stated currency, complete source extract",
"leads": "Unique leads created during the period",
"qualified_leads": "Unique leads qualified during the period",
"sales": "Unique closed-won sales during the period",
"attributed_revenue": "Recognized revenue assigned by the verified upstream rule, refunds reconciled",
"cash_collected": "Cash receipts less explicit refunds by receipt date; separate from revenue"
},
"attribution": {
"method": "Synthetic verified upstream account-to-lead rule; no raw matching performed here",
"evidence": "verified_rule"
},
"warnings": [
"Attribution is not verified click-level attribution.",
"Periods have different lengths; changes are not normalized per day.",
"Synthetic example only; not a production-verified report."
],
"exceptions": [
{
"reference": "SYNTHETIC-EXCEPTION",
"reason": "One unmatched sale; attributed revenue excludes its value",
"review_owner": "Client manager"
}
]
}Pending evidence-based commentary from the AI worker. Keep interpretation separate from the calculated facts above; review coverage and missing metrics before recommending changes.