Quotes Overview (W+M): Difference between revisions
| Line 22: | Line 22: | ||
!Description | !Description | ||
|- | |- | ||
| | |Quote revenue from reporting database | ||
|SELECT * FROM reporting_db_quote_revenue | |SELECT * FROM reporting_db_quote_revenue | ||
| | | | ||
Revision as of 13:16, 26 November 2025
Summary
This page provides a comprehensive historical overview of quotes (type = 8), excluding lost and deleted jobs, on a weekly and monthly basis. It highlights key business KPIs, including total quotes, converted bookings, quoted customers, won quotes percentage, direct bookings, chargeable weight, revenue, gross profit, routes, and margin.
Filters
| Filter | Description |
|---|---|
| Sites | filter by site name |
| Weekly/Monthly Button | Enables switching between weekly and monthly values. |
| Date picker | Filters by date. |
Data Transformation Applied
[To be added]
| Query | Calculations | Description |
|---|---|---|
| Quote revenue from reporting database | SELECT * FROM reporting_db_quote_revenue |
Calculations
| Reference | Calculation | Description |
|---|---|---|
| TBC | TBC |
TBC |