Cost per lead by channel for the quarter
campaign-cpl-report · timeout 1200 s · source
The ask
Sent verbatim as the prompt. The agent works in a copy of the workspace below and sees nothing else.
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
Checks
The task passes only when every required check passes. Reference answers, tolerances, and the planted traps are in the repository, not here.
| Check | Type | Required | Failed (frozen) / 6 |
|---|---|---|---|
| cpl.xlsx exists | file_exists | yes | 0 |
| totals are live formulas | xlsx_has_formulas | yes | 0 |
| no error cells (Direct Mail has zero leads) | xlsx_no_errors | yes | 0 |
| Google Ads cost per lead | xlsx_value_present | yes | 0 |
| Meta cost per lead (facebook + instagram merged) | xlsx_value_present | yes | 0 |
| LinkedIn cost per lead (EUR converted) | xlsx_value_present | yes | 0 |
| Direct Mail spend shown | xlsx_value_present | yes | 0 |
| total leads (quarter only, no spam/test) | xlsx_value_present | yes | 0 |
| Q2 spend total (no subtotal double count) | xlsx_value_present | yes | 0 |
Recorded results, complete desk comparison
pass pass, frozen scorer only fail timed out
| System | Repetitions | Frozen / 3 | Raw / 3 | Median minutes | Mean cost (USD) |
|---|---|---|---|---|---|
| Proto / DeepSeek V4.1 Flash | 3 | 3 | 2.3 | 0.0314 | |
| Codex / GPT-5.6 sol | 3 | 3 | 5.8 | 0.8263 |
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".