Customer economics & RFM input template
A blank CSV containing only the columns this tool reads. Keep these headers for automatic matching where supported; tools with role selection ask you to choose the outcome and features. Data is processed in your browser and never sent to a server.
Customer economics & RFM template
8 columns · 7 required roles
Template columns
| Column | Meaning | Type | Required |
|---|---|---|---|
transaction_id | Transaction ID | string | Required |
order_id | Order ID | string | Required |
customer_id | Customer ID | string | Required |
recorded_at | Transaction timestamp | string | Required |
net_revenue | Net revenue after discounts/refunds | number | Required |
variable_cost | Variable cost | number | Required |
currency_code | Currency code | string | Required |
acquisition_cost | Initial customer acquisition cost | number | Optional |
Filling it in
- Use
YYYY-MM-DDfor every date. Mixed formats break period comparisons. - Numeric columns may use thousands separators and common currency wrappers such as
₩,$,KRW,USD, or원. Arbitrary text is rejected, so plain numbers remain the safest format. - Missing or invalid required values may exclude a row or stop the analysis, depending on the tool. Check its row and column diagnostics. Zero and blank are treated differently.
- Extra columns are fine—anything this tool does not use is ignored.