Sales Summary - Management Reports Circulation Plan
Table Of Contents
The Circulation Plan helps you plan catalogue activity and other marketing campaigns using customers' sales history. It can help you identify when previous campaigns performed well, distinguish one-time customers from repeat customers, and create customer segments for targeted promotions.
The Circulation Plan is available within
[ Sales Summary | Management Reports ]. Sales Summary Overview lists Circulation Plan as one of the available Management Reports. What can you use the Circulation Plan for?
You can use the report to:
- Review sales performance over a selected period.
- Filter customers by Source Keycode to analyse customers associated with a particular marketing source.
- Use previous sales figures to help set targets for future campaigns, such as increasing sales year on year.
- Identify customers who have only ordered once and target them with campaigns designed to encourage repeat purchases.
- Separate one-time and repeat customers into Single and Multi segments.
- Add a customer segment to List Manager for further targeting.
From List Manager, you can work with selected groups of customers for marketing and CRM activity. This fits with Khaos Control's wider customer reporting tools, which can also pass groups of customers to List Manager for promotional activity.
How Customer Segments Work
The Circulation Plan includes customers whose last purchased date falls within the selected date range. Customers are then divided into Single and Multi segments according to their purchasing history.
For example:
- Customer A appears in the 1–6 month Single segment because they have only placed one order.
- Customer A later places another sales order on 04/02/2016.
- If you run the report on 05/02/2016, or use an As Of Date of 05/02/2016 or later, Customer A moves to the 1–6 month Multi segment. They have now purchased more than once and appear in the latest period in which they purchased.
Note: Customer segments are dynamic. The current or As Of date and the last purchase date range used for the report can change the segment in which a customer appears.
Before Running the Report
Keep the following points in mind:
- The report may take some time to run when analysing customers' lifetime sales, particularly if you have many years of sales history.
- Figures reflect the customer's lifetime order history held in Khaos Control.
- When comparing the number of customers in a segment with the number who have ordered, only the creation date of the customer's most recent sales order is relevant.
- Issuing a Return Credit does not change the segment in which a customer appears.
- After changing the filters, click Refresh to update the grid.
Khaos Control's Sales Summary is designed for reporting and analysis across areas including sales, customers, keycodes and profitability. [servicedes...ontrol.com]
Circulation Plan Filters
Date From and Date To
Set the date range used by the report. The range is based on the Sales Order creation date.
Date To defaults to today.
Include Delivery
Select Include Delivery if you want delivery charges included in the sales figures.
This option is off by default.
Periods (1–12)
Choose the number of months represented by each customer segment.
Available periods are:
- 1 month
- 2 months
- 3 months
- 4 months
- 6 months
- 12 months
The default is 6 months.
Source Keycode
Use Source Keycode to filter customers according to the first keycode they used in Khaos Control.
Note: This filter relates to the customer's original source keycode rather than subsequent sales using the same keycode. A customer's Source Keycode can affect reporting and filtering elsewhere in Khaos Control. [servicedes...ontrol.com]
Company Class
Use Company Class to restrict the results to customers belonging to the selected Company Class.
Understanding the Circulation Plan Grid
Segment
Customers are separated according to their purchasing history:
- Singles – customers who have only ever placed one order.
- Multis – customers who have placed more than one order during their purchasing history.
Counts
- Customer – the total number of customers who have placed orders.
- Order – the total number of orders placed.
Sales Orders
- Qty Sent – the number of items despatched.
- Grs Sales – total gross sales for the segment, including VAT. Delivery may also be included depending on the Include Delivery setting.
- Grs AOV – the gross average order value.
- VAT Total – the total VAT applied to the orders.
- Net Total – the total value of the orders excluding VAT.
Returns
- Count – the number of returns.
- Net Value – the value of returns excluding VAT.
- Value % – the value of returns as a percentage of the Net Sales Order Total.
Sales and Profitability
- Net Sales – the total value of sales excluding VAT.
- COS – the cost of sales for the items sold.
- Profit – Net Sales minus Cost of Sales.
- Margin – Profit divided by Net Sales, expressed as a percentage.
Working with Customer Segments
You can use the Circulation Plan grid to take a customer segment into List Manager.
Right-click the required segment and select Add Segment to List Manager. Alternatively, double-click the segment.
You can then work with the customers in that segment and use them for targeted marketing activity, such as promotions or catalogue campaigns.
Depending on the activity required, customer records can also contain keycode and Communication Log information. The Communication Log provides a history of customer interactions and follow-up activity. [servicedes...ontrol.com]
Circulation Plan Grid Context Menu
The following options are available:
- Add Segment to List Manager – sends the customers from the selected segment to List Manager, allowing you to work with that group for targeted activity.
- Clear Selection – deselects the currently selected line or lines.