Appearance
Analytics
Also known as
- Sales analytics
- report
- kpi
- sales report
- sales by customer
- sales by item
- sales by rep
- win rate
- backlog
- open orders
Sales analytics brings the sales KPIs and the catalogue of sales reports together. Sales managers and finance use it to review bookings, revenue, pipeline, backlog and performance per customer, item and rep. Figures are in the base currency.
Read the KPIs
The tiles show Bookings (month to date), Sales revenue (month to date), Weighted pipeline, Order backlog, Win rate, Quote-to-order conversion, Average order value and Returns rate, with the change against last month where it applies. Pin them to a dashboard from Dashboards.
Open a report
- Open Sales & CRMAnalytics.
- Select a report in its group. It opens in the report view.
| Group | Report | What it shows |
|---|---|---|
| Pipeline | Pipeline by stage | Open opportunities per stage: count, amount and weighted amount. |
| Win rate | Won and lost opportunities per rep closed in the period, win rate and won amount. | |
| Quote-to-order conversion | Quotes of the period per owner: sent, accepted, converted and the conversion rate. | |
| Sales | Sales by customer | Booked orders, net sales, invoiced revenue and margin per customer. |
| Sales by item | Booked quantity, net sales and average price per item. | |
| Sales by rep | Orders, net sales and invoiced revenue per sales rep. | |
| Sales by month | Bookings, invoiced revenue, orders and average order value per month. | |
| Margin by item | Shipped revenue, cost of goods and margin per item. | |
| Orders and returns | Backlog | Confirmed, unshipped order value per customer and order. |
| Open orders | Orders confirmed but not closed, with fulfilment and invoicing progress and lateness. | |
| Returns rate | Shipped and returned quantity per item and the returns rate. | |
| Performance | Target attainment | Targets of the period with actuals and attainment. |
| Commission statements | Commission per rep and run in the period. |
Sales reports also appear in the shared Reports catalogue, and the sales datasets (orders, order lines, quotes, opportunities, leads, returns, activities, commission lines) can be used in the report builder.
