company_customer_cohorts
Build customer cohort tables by month of first order, calculating repeat rates, revenue, acquisition costs, payback months, and value-to-cost ratios for a specified window.
Instructions
Build the sealed customer cohort table for the window: every customer first seen in the window grouped by the month of their first persisted order, with the orders, repeat rate, revenue per customer and its curve by month since, contribution per customer at the window's margin report margin, the acquisition spend per month from the persisted cost registers, the cost per acquired customer, the months to pay it back, and the value-to-cost ratio; returning customers from before the window are counted separately (payload: optional window_start, window_end).
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| now | No | ||
| engine | No | ||
| operation | No | build | |
| entity_ref | No | ||
| project_id | Yes | ||
| bundle_json | Yes | ||
| payload_json | No | {} |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |