Sales Summary - Management Reports Life Time Value Tab
Table Of Contents
The [ Life Time Value ] screen helps you assess the lifetime value of your customers. It combines the value of their orders with marketing and acquisition costs, helping you understand how valuable a customer segment may be over time.
For an overview of using this screen, see How To: Use the Life Time Value Screen.
Note: The information in this report is based on sales orders only. This includes both issued and unissued sales orders.
Filters
Use the filters to choose the customers you want to include in the analysis.
- Acquisition Year Start: The year the customer first started buying from you.
- Company Type (traffic light filter): Filters customers by their company type.
- Company Class (traffic light filter): Filters customers by their company class.
- Source Keycode (traffic light filter): Filters customers by their source keycode. This is usually the first keycode the customer used with you.
Query Parameters
The query parameters control the figures used to calculate lifetime value.
Some values are generated automatically by the system based on information from the acquisition year. These system-generated figures can be overwritten if required.
Retention Rate %
The percentage of acquired customers who are expected to continue ordering in subsequent years.
Note: The system estimates this using the number of repeat buyers in the acquisition year.
Retention Rate Inc %
The percentage by which the retention rate is expected to increase or decrease in subsequent years.
Referral Rate %
The percentage of acquired customers who are expected to refer new customers to your business.
Referral Rate Inc %
The percentage by which the referral rate is expected to increase or decrease in subsequent years.
Orders per Year
The number of orders customers are expected to place each year.
Note: The system calculates this from the actual order count in the acquisition year:Total Order Count ÷ Customer Count
Average Order Value
The expected value of each order.
Note: The system estimates this using the actual order value and order count from the acquisition year.
Cost of Sale %
The percentage of gross revenue represented by the cost of sale for your stock or goods.
Note: The system estimates this using the actual order value and cost of sale from the acquisition year.
Acquisition Cost
The marketing cost of acquiring the customers included in the analysis.
Note: The system estimates this using actual keycode costs from the acquisition year. For this calculation to work, keycodes need to be attached to orders generated by the target customers during the acquisition year.
Marketing Cost
The amount you expect to spend on marketing in subsequent years.
Marketing Cost Inc %
The percentage by which your marketing spend is expected to increase or decrease in subsequent years.
Segment Size
The number of customers used as the basis for the analysis.
Note: The system estimates the segment size from the actual number of customers matching the Acquisition Year Start, Company Type, Company Class and/or Source Keycode filters.
System-generated values: Where a query parameter is marked as system-generated on the screen, Khaos Control calculates the figure automatically. You can overwrite these values if you want to use different assumptions in your analysis.
Action Buttons
The screen includes actions to help you create and understand the lifetime value analysis.
- Use the information option next to a field to see how that field is calculated or where its information comes from.
- Double-click a line in the grid to open an information popup explaining what that line represents.
- Use Generate Header to populate the query parameter fields and create the header lines in the grid.
- Use the option to Generate the grid to calculate and display the results using your selected filters and parameters.
Important: Generate the header before populating the grid.
Understanding the Grid
Once the analysis has been generated, the grid shows the results across the acquisition year and subsequent years.
- Row Headings: Taken from the query parameters.
- Acquisition Year: Shows the results based on the parameters for the acquisition year.
- Year 2 to Year 5: Shows the results based on the parameters for each subsequent year.
By adjusting the filters and query parameters, you can compare different customer segments and assumptions to understand their projected value over time.