Top 10 Travel Agents

Report Parameters

Field

Description

Report Name

The name of the report.

Start Date

The start date from when the data must be considered for generating the report.

End Date

The end date until when the data must be considered for generating the report.

Include Address/Phone/Email/Fax

When enabled, the Address/Phone/Email/Fax will be included in the report.

Top number of agents to return

Enter the number of top agents to be included in the report.

TA Category Code

Select a desired category code from the drop-down menu.

Sort Options

Available options include the following:

  • Top in Revenue - Sorts the travel agents by revenue generated.

  • Top in Rooms - Sorts the travel agents by number of rooms booked.

  • Top in Nights - Sorts the travel agents by number of nights for which the reservation was made.

Sample Report

Table

Description automatically generated

Report Fields

Field

Description

IATA#

The IATA number of a travel agent associated to the company.

Agency Name

Name of the travel agency.

Type

The type of the travel agent.

City

Name of the city where the travel agency is located.

State

Name of the state where the travel agency is located.

Comm?

Indicated whether the reservation is commissionable.

%

Percentage of commission.

Amt/Day

Amount of commission earned per day.

Amt/Stay

Amount of commission earned per stay.

Selected Date Range

Revenue

Sum of commission amounts earned by the travel agency for a selected date range.

Rooms

Sum of rooms sold with earnable commissions (includes groups rooms sold) for a selected date range.

Nights

Number of nights for which the travel agency earns commission for a selected date range.

Avg Rev/Night

The average rate during stay.

Y-T-D

Revenue

Sum of commission amounts earned by the travel agency for year-to-date period.

Rooms

Sum of rooms sold with earnable commissions (includes groups rooms sold) for year-to-date period.

Nights

Number of nights for which the travel agency earns commission for year-to-date period.

Avg Rev/Night

The average rate during stay.

Last Year

Revenue

Sum of commission amounts earned by the travel agency for last year.

Rooms

Sum of rooms sold with earnable commissions (includes groups rooms sold) for last year.

Nights

Number of nights for which the travel agency earns commission for last year.

Avg Rev/Night

The average rate during stay.

Prev Year

Revenue

Sum of commission amounts earned by the travel agency for the previous year.

Rooms

Sum of rooms sold with earnable commissions (includes groups rooms sold) for the previous year.

Nights

Number of nights for which the travel agency earns commission for the previous year.

Avg Rev/Night

The average rate during stay.