Revenue & Booking Overview: Difference between revisions
No edit summary |
No edit summary |
||
| Line 95: | Line 95: | ||
|- | |- | ||
|13. Total Chargeable Weight by Customer | |13. Total Chargeable Weight by Customer | ||
| | |Aggregates the total chargeable weight and groups it by customer to compare side by side in a clustered bar chart. | ||
| | |This chart displays the total chargeable weight attributed to each customer. | ||
|} | |} | ||
Revision as of 10:41, 21 August 2025
Summary
Filters
| Filter | Description |
|---|---|
| Carrier | Select to filter the Quote page by Carrier Name |
| Customer | Select to filter the Quote page by Customer |
| Origin Airport | Select to filter the Quote page by Origin Airport |
| Destination Airport | Select to filter the Quote page by Destination Airport |
| Spot Rate Only | Select to filter the Quote page by either Spotrates or Non Spotrates |
| Hide Lost/Deleted | Select to filter the Quote page by choosing to Hide Lost & Deleted Quotes or show Lost & Deleted Quotes |
Data Transformation Applied
| Query | Transformations |
|---|---|
Calculations
| Columns | Calculation | Description |
|---|---|---|
| 1. Total Revenue | ||
| 2. Total Bookings(Confirmed) | ||
| 3. Total Direct Bookings(Confirmed) | ||
| 4. Total Converted Booking(Confirmed) | ||
| 5. Total Chargeable Weight | ||
| 6. Top Customers By Revenue | Aggregates total revenue from confirmed bookings and groups it by customer to compare side by side in a clustered bar chart and with specific currency used for each. | This chart displays the highest revenue-generating customers, showing amounts in their respective currencies. |
| 7. Top Bookings (Confirmed) by Origin | Counts only confirmed bookings (converted quotes that have been finalized as bookings), then groups them by origin to compare side by side in a clustered bar chart. | This chart shows the total confirmed bookings for each origin location, making it easy to identify which origins generate the highest booking volumes and highlight performance differences across locations. |
| 8. Top Bookings(Confirmed) by Destination | Counts only confirmed bookings (converted quotes that have been finalized as bookings), then groups them by destination to compare side by side in a clustered bar chart. | This chart shows the total confirmed bookings for each destination location, making it easy to identify which destinations receive the highest booking volumes and highlight performance differences across locations. |
| 9. Top Bookings by Service | Counts only confirmed bookings and groups them by service type to compare in a clustered bar chart. | This chart highlights the total confirmed bookings for each service type, making it easy to see which services are most in demand and where performance differences exist across offerings. |
| 10. Bookings by Weight Breaks Matrix Table | ||
| 11.Conversion Rate by Month | Calculates the percentage of quotes converted into confirmed bookings for each month, grouping results over time to show conversion trends. | This chart highlights how effectively quotes are turning into bookings month by month. |
| 12. Total Monthly Revenue | Aggregates total revenue from confirmed bookings and groups it by month to show revenue trends over time, plus the respective currencies. | This chart provides a clear view of monthly revenue performance, showing amounts in their original currencies. |
| 13. Total Chargeable Weight by Customer | Aggregates the total chargeable weight and groups it by customer to compare side by side in a clustered bar chart. | This chart displays the total chargeable weight attributed to each customer. |