Cost per lead by channel for the quarter
The request
The task request supplied to the adapter, alongside the workspace below. Runtime instructions, authorized tools and skills also affect the system. Containerized runs withhold host-side references; local mode is not an isolation boundary.
Work out our cost per lead by channel for the second quarter from the finance spend sheet and the CRM leads export. Dana's email has the details. Save it as cpl.xlsx.
Workspace
- ad_spend_q2_2026.xlsx
- crm_leads_export_2026-07-06.csv
- email_from_dana.txt
Expected deliverables
- cpl.xlsx
Recorded acceptance checks
The table uses check names and outcomes from the frozen campaign ledger. Acceptance requires all required predicates to pass; a predicate may itself contain a tolerance or coverage threshold. Its scope is part of the measurement contract.
| Recorded check | Type | Required | Failed / observed |
|---|---|---|---|
| cpl.xlsx exists | file_exists | yes | 0 / 6 |
| totals are live formulas | xlsx_has_formulas | yes | 0 / 6 |
| no error cells (Direct Mail has zero leads) | xlsx_no_errors | yes | 0 / 6 |
| Google Ads cost per lead | xlsx_value_present | yes | 0 / 6 |
| Meta cost per lead (facebook + instagram merged) | xlsx_value_present | yes | 0 / 6 |
| LinkedIn cost per lead (EUR converted) | xlsx_value_present | yes | 0 / 6 |
| Direct Mail spend shown | xlsx_value_present | yes | 0 / 6 |
| total leads (quarter only, no spam/test) | xlsx_value_present | yes | 0 / 6 |
| Q2 spend total (no subtotal double count) | xlsx_value_present | yes | 0 / 6 |
Current task declaration (9 checks)
From task.yaml. Original runner grading and frozen retrospective scoring are separate. Read the frozen source for the rules behind the reported results.
- cpl.xlsx exists —
file_exists, required - totals are live formulas —
xlsx_has_formulas, required - no error cells (Direct Mail has zero leads) —
xlsx_no_errors, required - Google Ads cost per lead —
xlsx_value_present, required - Meta cost per lead (facebook + instagram merged) —
xlsx_value_present, required - LinkedIn cost per lead (EUR converted) —
xlsx_value_present, required - Direct Mail spend shown —
xlsx_value_present, required - total leads (quarter only, no spam/test) —
xlsx_value_present, required - Q2 spend total (no subtotal double count) —
xlsx_value_present, required
Recorded results, desk release
| System | Repetitions | Frozen / 3 | Original / 3 | Median minutes | Mean model estimate (USD) |
|---|---|---|---|---|---|
| Proto / DeepSeek V4.1 Flash | 3 | 3 | 2.3 | 0.0314 | |
| Codex / GPT-5.6 sol | 3 | 3 | 5.8 | 0.8263 |
These are repeated executions on the released fixture, not independent new business cases. Cost is captured model usage priced under the recorded assumptions, excluding infrastructure and human review. Per-attempt check verdicts, raw and frozen verdicts, usage, receipt and artifact hashes for this task are in results/latest/attempts.jsonl under "task": "campaign-cpl-report".
Recorded results, desk comparison, 28 September 2026
| System | Repetitions | Frozen / 3 | Original / 3 | Median minutes |
|---|---|---|---|---|
| Proto / GPT-6 sol | 3 | 3 | 2.7 | |
| Codex / GPT-6 sol | 3 | 3 | 3.1 | |
| Proto / DeepSeek V4.1 Flash | 3 | 3 | 1.3 |
A separate campaign under the same frozen scorer, not pooled with the release. Conditions and data.