graspDATA
      Back to home
      1. Customer Support Knowledge Base
      2. graspDATA

      Advanced TMC Reports

      Our Advanced Reports provide a fresh view of your data with enhanced graphics. Some of the reports also offer interactive options. The list below gives detailed information on each report.

      Our Advanced Reports provide a fresh view of your data with enhanced graphics.  Some of the reports also offer interactive options.  The list below gives detailed information on each report.  

      • The report numbers may differ from what is listed in your database; however, the report names should remain the same. 
      • Reports with ‘Global’ in the title use the European date format and do not include the USD $ sign.  
      • NOTE: If you see a Blocked Content message when opening any of our Interactive reports,  please click here for our  page with the steps to resolve.  Microsoft recently decided to block Macros by default.


      Report 14521 - Advanced TMC More Than 3 Passengers on A Plane / 

      Report 21200 - Advanced TMC Global More Than 3 Passengers on A Plane

      Transaction type = Sales, Exchange                                     Booking Type = Air, Rail

      Includes

      PNR, Airline Name, Flight #, Origin, Destination, Schedule, Traveler Name, Ticket #, Class.

      Report Grouped by Account – Shows Account Interface ID and Account Name. Then grouped segment departure date and time.  Will only show when 3 or more travelers are on the same plane. Shows the most recent bookings that have not been exchanged. Example if a traveler has a sale and 2 exchanges.  The most recent exchanged booking will only be seen. 

       

      Report 18400 - Advanced TMC Exchange Ticket Cost Report / 

      Report 21203 - Advanced TMC Global Exchange Ticket Cost Report

      Transaction type = Sales, Exchanges                               Booking Type = Air, Rail

      Bar Chart 

      Shows the top 15 travelers with the highest total ticket cost amounts

      Grouped

      Report is grouped by traveler name, then original sale ticket 

      Includes

      Report includes exchanges for the date range specified as well as any historical ticket prior to the period selected 

       

      Report 18401 - Advanced TMC Exchange Ticket Report by Sort1 / 

      Report 21204 - Advanced TMC Global Exchange Ticket Report by Sort1

      Transaction type = Sales, Exchanges                                   Booking Type = Air, Rail

      Bar Chart 

      Shows the top 15 travelers with the highest total ticket cost amounts

      Grouped

      Report is grouped by Sort 1 then traveler name, then original sale ticket

      Includes

      Report includes exchanges for the date range specified as well as any historical ticket prior to the period selected 

       

      Report 18403 - Advanced TMC Exchange Detail Report / 

      Report 21205 - Advanced TMC Global Exchange Detail Report

      Transaction type = Exchanges                                            Booking Type = Air, Rail

      Sort

      Detailed booking level report sorted by issued date then passenger

      Includes

      Traveler name, issue date, depart date, return date, airline code, itinerary, invoice #, ticket #, original ticket# and total 

       

      Report 14070 - Advanced TMC Exception Code Detail / 

      Report 21188 - Advanced TMC Global Exception Code Detail

      Transaction type = Sales, Refunds and Exchanges          Booking Type = Air, Rail

      Calculations

      Lost Savings = Total Paid – Low Fare Savings = High Fare – Total Paid

      Graphics

      The lost savings and total savings graphics show the top 5 exceptions 

       

      Report 13512 - Advanced TMC Air Summary Year-Over-Year / 

      Report 21185 - Advanced TMC Global Air Summary Year-Over-Year

      Transaction type = Sales, Refund, Exchange                    Booking Type = Air

      Graphics 

      Top 5 Airlines plus Others  

      Summary list

      All Airlines in alpha order, Net count, Gross (Base Fare), Tax, Total (Base Fare + Tax)

      Note

      The date the report is processed will show the same time frame for the previous year. 

          • Example: 3/1/2019 to 3/31/2019 Previous year will show 3/1/2018 to 3/31/2018

       

      Report 14519 - Advanced TMC Hotel Summary by Parent Brand / 

      Report 21199 - Advanced TMC Global Hotel Summary by Parent Brand

      Transaction type = No Voids                                                  Booking Type = Hotel 

      Graphics

      Graph of Top 5 Hotel Brands based on number of nights.  Export report as Excel Data Only to see all the Hotel Brands. Grasp maintains the Parent Brand table for the report.

      Calculations:  

      ANR (Average Nightly Rate) = Total Paid / Number of nights

       

      Report 13511 - Advanced TMC Top 10 Market Pair / 

      Report 21184 - Advanced TMC Global Top 10 Market Pair

      Transaction type = Sales, Refund, Exchange                          Booking Type = Air

      Calculations

          • Number of O&D = Net Count 
          • O&D Amount = CityPair Fare
          • Average O&D = Count / CityPair Fare Number of Nights
          • Miles = CityPair Miles 
          • CPM = Miles / Amount

      Graphics 

          • Top 10 Market Pairs by Transaction Count 
          • Top Market Pair 
          • Average Ticket Price: Top Market Pair

      Note

      Details based on top transaction count, ranked by Top 10 Market Pairs plus others, and Grand Total 

      Summary list: Rank, Market Pair, Net count, Amount, Miles, CPM 

      The date the report is processed will show same time frame for previous year

          • Example:  3/1/2019 to 3/31/2019 Previous year will show 3/1/2018 to 3/31/2018 

       

      Report 14042 - Advanced TMC Class of Service Summary / 

      Report 21186 - Advanced TMC Global Class of Service Summary

      Transaction type = No Voids                                                     Booking Type = Air

      Calculation:

      Class Description blank, null, or UNKN are listed in Economy

      Graphics

      Graphic on the Right will show the following class breakout: 

          • ATP (Average Ticket Price) is defined for Economy, Business and First Class 
          • Bookings is the Net Transaction Count (Sales = 1, Refund = -1, Exchange = 0)
          • Total Paid = Overall cost of the ticket 
          • ATP (Average Ticket Price) = Total Paid / Bookings 

      Graphic on the Left will show the following class breakout: 

          • Class with Highest ATP (Average Ticket Price)
          • Class with Highest Total Paid
          • Class with Highest Total Bookings 

      Note

      Class of Service are maintained by user running report 9325 – Grasp QC–Class of Service Descriptions (Excel Only).   Once updated send to Support@Grasptech.com to be loaded.   This is a booking level report. 

       

      Report 17929 - Advanced TMC ATP 2 / 

      Report 21201 - Advanced TMC Global ATP 2 / 

      Report 20892 – Advanced TMC ATP 2 with Transborder / 

      Report 21211 – Advanced TMC Global ATP 2 with Transborder 

      Transaction type = Sales, Refunds and Exchanges                 Booking Type = Air

      Calculations: 

      ATP (Average Ticket Price) = Total Paid / NetTransCount

          • Net Transaction Count is used to determine the number of transactions. Sales = 1, Exchanges = 0, Refunds = -1
          • Report pulls in the date range chosen at run time as the current period. Previous 12-month period is calculated as the end date chosen at run time less than 12 months. So, if the report is run for June 2018, current period figures will reflect the June data. Previous and 12 Month figures will reflect the period of July 2017 – June 2018. If the report is run for a full year, the current and previous amounts will be the same.
          • Shift to calculation Class of Service is the difference between the total spend for the class booked and the total spend based on average ticket price for the class shifted to and the number of tickets purchased.
            • For example, 281 tickets purchased at the average Business ticket price of $4,440.52 is $1,247,786. Total spend for First class is $1,197,931 with 281 tickets purchased. First class spend ($1,197,931) less shift to Business amount ($1,247,786) results in a net loss of $49,855.
          • Shift to calculation Days Advance follows the same logic as above. The number of transactions for an advance purchase group times the average ticket price for another group to determine the shift to total spend. The difference between the actual spend and the shift to spend is the projected savings/loss.

      Graphics

      Page one contains Domestic, International and Transborder together.  Each page after shows the D, I, T options separately.  Graphs detailing Advance Ticket Purchase and Average Ticket Price.  Graph 1 shows a 12-month trend based on class of service. Graph 2 shows Average Ticket Price by class of service.  Graph 3 shows Class, number of transactions, total, and total amount.


       

      Report 13509 - Advanced TMC Hotel Summary by Chain / 

      Report 21182 - Advanced TMC Global Hotel Summary by Chain 

      Transaction type = No Voids                                                   Booking Type = Hotel 

      Graphics

      Graph of Top 5 Hotel Chains based on number of nights  

      Calculations:  

      ANR (Average Nightly Rate) = Total Paid / Number of nights

      Note

      Chains are maintained by user running report 12476 – Hotel Chain Master Table QC.  Export report to Excel Data Only to see all the Hotel Brands.  Once updated send to Support@Grasptech.com to be loaded.                                                                                                                                      

       

      Report 14148 - Advanced TMC Advance Purchase Summary / 

      Report 21194 - Advanced TMC Global Advance Purchase Summary / 

      Report 20890 - Advanced TMC Advance Purchase Summary with Transborder / 

      Report 21209 - Advanced TMC Global Advance Purchase Summary with Transborder 

      Transaction type = Sales Only                                                  Booking Type = Air 

      Grouped

          • Report is grouped by Domestic/International/Transborder
          • Sections grouped show the following:  # of Bookings, % of Total Bookings, Total Paid, and ATP (Average Ticket Price) 

      Calculations:  

          • ATP (Average Ticket Price) applies to each advance purchase date range
            • Total Paid/# Bookings = ATP
          • Boxes show the estimated savings on tickets booked 14–20 days and 21+ days Advance Purchase
            • 14-20 Days Advance Purchase   

      (ATP <= 13 days – ATP 14-20) * Total Booking ATP 14-20 = Estimated savings in group 14-20 days AP calculates difference between ATP <=13 AP and 14-20 AP, multiplied by # of bookings 14-20 AP

            • 21+ Days Advance Purchase

      (ATP <= 13 days – ATP 21+) * Total Booking ATP 21+   =   Estimated savings in group 21+ days AP calculates difference between ATP <=13 AP and 21+ AP, multiplied by # of bookings 21+ AP

       

      Report 14396 - Advanced TMC Advance Purchase Detail / 

      Report 21196 - Advanced TMC Global Advance Purchase Detail / 

      Report 20891 - Advanced TMC Advance Purchase Detail with Transborder / 

      Report 21210 - Advanced TMC Global Advance Purchase Detail with Transborder 

      Transaction type = Sales Only                                                   Booking Type = Air 

      Grouped

          • Report is grouped by Domestic/International/Transborder  
          • Sections grouped show total count and total fare.  ATP (Average Ticket Price)

      Fields included in the detail are:

      Traveler Name, issued date, Invoice #, PNR, Depart Date, Return Date, Origin, Destination, Airline Name, Ticket #, Total Paid

      Calculations:  

          • ATP (Average Ticket Price) less than 14 days Advance Purchase (AP)
            • Total Paid for bookings < = 13 days AP / Total Bookings <=13 days AP = ATP all tickets less than 14 days advance
          • Boxes show the estimated savings on tickets booked 14–20 days and 21+ days Advance Purchase
            • 14-20 Days Advance Purchase

      (ATP <= 13 days – ATP 14-20) * Total Booking ATP 14-20 = Estimated savings in group 14-20 days AP calculates difference between ATP <=13 AP and 14-20 AP, multiplied by # of bookings 14-20 AP

            • 21+ Days Advance Purchase

      (ATP <= 13 days – ATP 21+) * Total Booking ATP 21+   =   Estimated savings in group 21+ days AP calculates difference between ATP <=13 AP and 21+ AP, multiplied by # of bookings 21+ AP

       

      Report 14155 - Advanced TMC Where Are My Travelers / 

      Report 21195 - Advanced TMC Global Where Are My Travelers

      Transaction type = Sales, Refunds and Exchanges           Booking Type = Air, Rail, Car, Hotel

      Note:  Report will only show travelers that are currently traveling

       

      Report 13510 - Advanced TMC Top Property by Metro / 

      Report 21183 - Advanced TMC Global Top Property by Metro

      Transaction type = Sales, Refund, Exchange                        Booking Type = Hotel

      Grouped

      Grouped by Top Metro City, then Top 5 Properties plus others 

      Graphics 

          • Top 10 Hotel Metro Cities 
          • Top Metro City 

      Calculations: 

      ANR (Average Nightly Rate) = Total Paid / Number of Nights

      Note

      Details based on top number of nights 

      Summary list: Property Name, Number of Bookings, Number of Nights, ANR, Total Paid 

       

      Report 17942 – Advanced TMC One Page Summary / 

      Report 21202 – Advanced TMC Global One Page Summary / 

      Report 20564 -Advanced TMC One Page Summary with Transborder / 

      Report 21206 -Advanced TMC Global One Page Summary with Transborder 

      Transaction type = Sales, Refunds and Exchanges           Booking Type = Air, Car, Hotel, Service Fees

      Calculations

      Total Ticket Volume is calculated based on Sales and Exchanges only 

      Net Ticket Volume is Sales + Exchanges - Refunds

      Number of Trips = Distinct Count of Record Locators 

      If Transborder is used, totals are included in the International sections.  Vouchers not included. 

       

      Report 17953 - Advanced TMC Spend Analysis – This is an excel template report / 

      Report 21180 - Advanced TMC Global Spend Analysis – This is an excel template report  

      Transaction type = Sales, Refunds and Exchanges           Booking Type = Air, Rail, Car, Hotel

      Includes

      Report contains separate tabs for each booking type showing Spend Summary, Top 10 vendors for each booking type then Others that can be expanded to show all other vendors and overall Executive Summary.  

      Calculations:

      Lost Savings = Total Paid – Low Fare.

      Savings = Coach Fare (High) – Total Paid  

      Sorts 1 – 10 are grouped and labeled based on Corporation Settings                                                       

       

      Report 14128 - Advanced TMC Travel Management Summary / 

      Report 21189 - Advanced TMC Global Travel Management Summary / 

      Report 20888 - Advanced TMC Travel Management Summary with Transborder / 

      Report 21207 - Advanced TMC Global Travel Management Summary with Transborder

      Transaction type = Sales, Refunds and Exchanges          Booking Type = Air, Rail, Car, Hotel, Service Fee 

      Includes

      Breakdown of Current +12months, Online Totals Count and Percentage

      Sales Only for Air, Rail, Car, Hotel 

      Calculations:

      Negotiated Savings Vol.: LowFare Vol. – Air Net Vol.  

      Missed Savings Vol.:                   Air Sales Vol. (Gross) – LowFareVol. 

        

      Report 14064 - Advanced TMC Top Traveler Summary / 

      Report 21187 – Advanced TMC Global Top Traveler Summary

      Transaction type = Sales, Refund, Exchange                     Booking Type = Air, Rail, Hotel, Car

      Graphics

      Graphics show top travelers for each section. 

          • Total Trip Amount
            • Detail is sorted by total paid 
          • Total Trip Count 
            • Distinct count of the PNR Locator
          • Average Trip Amount 
            • Sum of the Total Paid / Distinct count of the PNR Locator

       

      Report 18007 - Advanced TMC Business Review/ 

      Report 21072 - Business Review with Transborder/

      Report 21179 – Advanced TMC Global Business Review

      Transaction type = Sales Only                                  Booking Type = Air, Car, Hotel, Service Fee

      Includes

      The cover page contains an ‘Open Control Panel’ button.  Click ‘Open Control Panel’ to add details for preferred vendors, benchmarks, advance purchase policy and VIP travelers, that can be applied throughout the report where applicable.  The details can be added in the Control Panel each time the report is processed, or a custom version can be quoted to hard-code specific criteria.  

      Tabs contain the following data:  Spend summary for each booking type, Top 10 Market Pairs, Advanced Purchase Summary, Top Traveler overall, Top Traveler breakout for Dom/Intl, Service Fee Totals and Online Adoption booking counts. All vendor data is pulled from the back office.

      Online agents must be defined for the data to populate

      To define Online – email your dedicated Online agent sine(s) to support@grasptech.com .  A case will be opened and sent to the developers to map the signs as Online. Once completed all reports that contain Online data/totals will populate based on the dedicated online sine(s) provided.   

      Calculations: 

      Current Period and Previous Period 

          • Example: Report ran by issued date 1/1/2019 to 1/31/2019. Previous period will show 1/1/2018 to 1/31/2018
          • Click Here to access our page with more details about the Business Review reports along with a list of standard reports that will tie back to the data.

                                                                                                          

      All Reports Listed Below Require Custom Programming

      Requirements

      The following reports require custom programming for Preferred/Non-Preferred options

        • Provide list of the Preferred 
        • If data is captured in UDID/Sort/Remark/Dept. field, report will need to be mapped

       

      Report 14145 - Advanced TMC ATP Summary /

      Report 21193 - Advanced TMC Global ATP Summary / 

      Report 20889 – Advanced TMC ATP Summary with Transborder / 

      Report 21208 - Advanced TMC Global ATP Summary with Transborder – Custom Programming

      Transaction type = Sales, Refunds and Exchanges               Booking Type = Air

      Customization required for the report to process data as designed.  

      Preferred vs non-preferred vendors based on the contract level. 

      Calculations

      Comparison of Preferred (contract) vs. Non-Preferred (non-contract) Airlines

          • Net Transaction Count is used to determine the number of transactions. Sales = 1, Exchanges = 0, Refunds = -1
          • Report pulls in the date range chosen at run time as the current period. Previous 12-month period is calculated as the end date chosen at run time less than 12 months. So, if the report is run for June 2018, current period figures will reflect the June data. Previous and 12 Month figures will reflect the period of July 2017 – June 2018. If the report is run for a full year, the current and previous amounts will be the same.
          • Shift to calculation Class of Service – the difference between the total spend for the class booked and the total spend based on average ticket price for the class shifted to and the number of tickets purchased.
            • For example – 281 tickets purchased at the average Business ticket price of $4,440.52 is $1,247,786. Total spend for First class is $1,197,931 with 281 tickets purchased. First class spend ($1,197,931) less shift to Business amount ($1,247,786) results in a net loss of $49,855.
          • Shift to calculation Days Advance – follows the same logic as above. The number of transactions for an advance purchase group times the average ticket price for another group to determine the shift to total spend. The difference between the actual spend and the shift to spend is the projected savings/loss

       

      Report 14137 - Advanced TMC Air Contract Summary / 

      Report 21190 - Advanced TMC Global Air Contract Summary – Custom Programming

      Transaction type = Sales, Refunds and Exchanges                  Booking Type = Air

      Count = Net Transaction                      Contract Savings = High Fare – Total Paid

      Customization required for the report to process data as designed. 

      Preferred vs non-preferred vendors based on the contract level 

      Calculations

      Comparison of Preferred (contract) vs. Non-Preferred (non-contract) Airlines

       

      Report 14142 - Advanced TMC Hotel Contract Summary / 

      Report 21191 - Advanced TMC Global Hotel Contract Summary – Custom Programming

      Transaction type = Sales, Refunds and Exchanges                 Booking Type = Hotel

      Customization required for the report to process data as designed 

      Preferred vs non-preferred vendors based on the contract level 

      Calculations

      Comparison of Preferred (contract) vs. Non-Preferred (non-contract) hotel chains. 

       

      Report 13315 -Advanced TMC Hotel Contract Rate Variance / 

      Report 21181 -Advanced TMC Global Hotel Contract Rate Variance – Custom Programming

      Transaction type = Sales and Exchanges                             Booking Type = Hotel

      Customization required for the report to process data as designed.  

      Preferred vs non-preferred vendors based on the contract level. 

      Calculations: 

      Report depends on contract level being defined and valid values in negotiated fare. Report ONLY returns results when the booked rate exceeds the negotiated fare.

      Preferred hotels (contract level =1) that are NOT in season are excluded 

      Preferred hotels inside blackout periods are excluded

      Exclude 0 Negotiated Fares. This means that either the booking fell outside a season start/end on the preferred list OR falls within a blackout period. 

       

      Report 14143 - Advanced TMC Car Contract Summary / 

      Report 21192 -Advanced TMC Global Car Contract Summary – Custom Programming

      Transaction type = Sales, Refunds and Exchanges              Booking Type = Car

      Customization required for the report to process data as designed. 

      Preferred vs non-preferred vendors based on the contract level.

      Calculations

      Comparison of Preferred (contract) vs. Non-Preferred (non-contract) Car Vendors  

       

      Report 14406 - Advanced TMC Car Summary by Company / 

      Report 21197 - Advanced TMC Global Car Summary by Company – Custom Programming 

      Transaction type = Sales, Refund, Exchanges                       Booking Type = Car

      Customization required for the report to process data as designed. 

      Preferred vs non-preferred vendors based on the contract level.

      Pie Chart

      Shows Top 5 rental companies by net bookings 

      Note

      Report can process without Preferred/Non-Preferred vendors defined  

          • The Preferred Vendor Utilization graph will show 0%

       

      Report 14422 - Advanced TMC Car Summary by Company and Car Type / 

      Report 21198 - Advanced TMC Global Car Summary by Company and Car Type – Custom Programming

      Transaction type = Sales, Refund, Exchange                          Booking Type = Car

      Customization required for the report to process data as designed. 

      Preferred vs non-preferred vendors based on the contract level.

      Graphics 

          • Top Rental Company
          • Top Rental Type
          • Preferred Vendor Utilization, CUSTOM
          • Avg. Daily Rate, Max Rental Days, Rental Type

      Calculations

      Avg Rate = Total before tax/Car Days

      Grouped

      Grouped by Car Company name, then number of Car Days

      Note

      Report can process without Preferred/Non-Preferred vendors defined  

          • The Preferred Vendor Utilization graph will show 0%