...
| Info |
|---|
Live Statuses - All statuses with the type New or In Progress. Excluded Statuses - All statuses with the type Archived or Deleted. |
Enquiries
Total Enquiries
All enquiries where the status is not defined as an excluded status filtered by agent and dates if specified
Total Live Enquiries
All enquiries where the status is not an excluded status. and the status is a live status filtered by agent and dates if specified
Tasks
Total Outstanding Tasks
Tasks not marked as completed filtered by date and agent if specified
Total Outstanding Tasks Today
Tasks not marked as completed due between 00:00 and 23:59 on the current day filtered by agent if specified.
Bookings
Total Bookings
All enquiries with a booking where the enquiry status is not an excluded status filtered by agent and dates if specified.
Bookings Total Value
The sum of Booking Total Price for all enquiries with a booking where the enquiry status is not an excluded status filtered by agent and dates if specified.
Conversion
Percentage figures based on Total Bookings / (Total Enquiries - Total Live Enquiries)
Pipeline
...
The pipeline value is derived from one quote per enquiry, specifically from quotes that have a status of Draft or Live
...
Has three figures available to use Minimum, Maximum and Mean. This is a setting against the dashboard component, the default is Maximum.
...
The pipeline is calculated using figures provided on a quote where the enquiry has a live status and is filtered by agent and dates of specified.
...
.
Available Calculation Methods
The pipeline can be based on one of three values per enquiry, the default is Maximum:
Minimum – Uses the lowest-priced quote.
Maximum (default) – Uses the highest-priced quote.
Mean – Uses the average price across quotes.
How It Works
One Quote Per Enquiry – The pipeline calculation selects a single quote per enquiry based on the chosen method (Minimum, Maximum, or Mean).
Filtered by Status & Criteria – Only enquiries with a Live* status are considered, and filtering is applied based on the assigned agent and specified date range.
Summing for Dashboard Display – The chosen price from each enquiry is summed to produce the total pipeline value displayed on the dashboard.
*Live statuses for enquiries can be determined in platform settings
Example
Enquiry | Quote | Total Price |
|---|---|---|
5001 | 1 | 800 |
5001 | 2 | 700 |
5002 | 3 | 1500 |
Calculation
Enquiry | Max Pipeline Setting | Mean Pipeline Setting | Min Pipeline Setting |
|---|---|---|---|
5001 | 800 | 750 | 700 |
5002 | 1500 | 1500 | 1500 |
Pipeline Total | 2300 | 2250 | 2200 |