The following includes details for the items and calculations used in the Business Review reports and standard reports that tie back to the data.
The information below is for the following three reports:
- 18007 Advanced TMC Business Review
- 21179 Advanced TMC Global Business Review
- 21072 Business Review With Transborder
*Please note, if you do not see the report number noted above, search by the REPORT NAME. The report # may be different on your server.
Click the hyperlinks below to go directly to that section on this page:
Air Spend
- Includes Sale, Refund and Exchanges
- Domestic and International determined from the booking level indicator
- Run one of the following reports and Filter for Air only and the data will tie back to this section:
- Report 5 – Air Activity by Invoice and filter for Air Only.
- Report 81 – Traveler Insurance Report
- Report 168 – Traveler Insurance Report Simple
- Any Traveler Activity, Air Activity, Air Detail Report filtered for Air only.
- Run one of the following reports and Filter for Air only and the data will tie back to this section:
Top 10 Market Pairs
- Sales Only
- Run any of the following Market Pair reports and Filter for Sales only and the data will tie back to this section:
- Report 1714 – Top 100 Market Pairs with Miles with Class
- Report 265 – MarketPair by Passenger
- Report 504 - Top 200 Market Pair by Trip Count
- Run any of the following Market Pair reports and Filter for Sales only and the data will tie back to this section:
Advance Purchase Summary
- Air and Sales Only
- Run any Advanced Purchase Detail report. No additional filters are needed to tie back to this section.
Top Traveler Summary
- This is based on Air and Sales Only
- Run report 30 – Traveler Activity by Passenger and Filter for Air and Sales Only. The total balances to this section.
Top Traveler Summary 2
- This is based on Air and Sales Only Separated by Dom/Intl to show only the Top 10 Travelers for each section.
- Run report 30 – Traveler Activity by Passenger and Filter for Air/Sales/Domestic or Not Domestic Only. The total balances to this section.
Car Spend Overview
- This is based on Car and Sales Only
- Run any of the following reports and Filter for Sales only and the data will tie back to this section.
- Report 314 – Car Detail by Company
- Report 12 – Car Detail by Passenger
- Report 52 - Car Detail by Invoice
- Report 1590 – Global Car Detail by City
- Run any of the following reports and Filter for Sales only and the data will tie back to this section.
Hotel Spend Overview
- This is based on Hotel and Sales Only
- Run any of the following reports and Filter for Sales only and the data will tie back to this section.
- Report 55 – Hotel Detail
- Report 309 – Hotel Detail by Property
- Report 17 – Hotel Detail by Passenger
- Report 1473 – Global Hotel Detail by City
- Run any of the following reports and Filter for Sales only and the data will tie back to this section.
Service Fees Online Adoption
- Service Fee based on Sale Only
- Report 59 – Service Fee by Month Summary
- Run any Traveler Activity, Air Activity, Air Detail Report and Filter for Air only.
- Online Adoption based on Air and Sales Only
- Report 1274 - Air Detail Report by Passenger with Regions
- Run any Traveler Activity, Air Activity, Air Detail Report and Filter for Air only and Booking Source = Online.