FICTIONAL TRAINING DATA ONLY
One row represents one order in the verified reference extract.
order_id: unique order identifier. F = February, M = March; prefixes are sample labels, not a production parsing rule.
order_date: ISO calendar date, YYYY-MM-DD. Reporting periods are full February and March 2026 in this exercise.
channel: web or store.
status: completed, returned, cancelled. These are final status snapshots; there is no refund or payment ledger.
order_value_eur: recorded order value in EUR; not net profit or accounting revenue. For this exercise only, sales means SUM(order_value_eur) WHERE status = completed.
The reference file is the verified source supplied by the fictional operations owner. It is not derived by guessing corrections from the raw file.
The raw file deliberately contains a duplicated M004, invalid date and missing channel on M006, and negative value on returned order M005. Do not silently fix unknown production values.
No customer IDs, costs, traffic, campaign assignments or order-line records are available. No causal, customer-retention or profit conclusions are supported.