Tasks · desk · Spreadsheet
Lifetime value per customer from the shop export
customer-value-summary · 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.
Maya wants lifetime value for every customer before the loyalty launch. Work it out from the order export and save customer_value.csv - her note explains the ids, refunds and test orders.
Workspace
- customer_id_changes.csv
- customers_export_2026-06.csv
- note_from_maya.txt
- orders_export_all_time.csv
Expected deliverables
- customer_value.csv
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 |
|---|---|---|---|
| requested columns | csv_columns | yes | 0 |
| customer list | csv_set_equal | yes | 0 |
| row count | csv_row_count | yes | 0 |
| order count | csv_values_match | yes | 0 |
| lifetime value | csv_values_match | yes | 0 |
| first and last order | csv_values_match | 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 | 1.2 | 0.0157 | |
| Codex / GPT-5.6 sol | 3 | 3 | 2.2 | 0.2851 |
Per-attempt check verdicts, raw and frozen verdicts, usage, receipt and artifact hashes for this task are in results/latest/attempts.jsonl under "task": "customer-value-summary".