Market Share by Airline

The Market Share by Airline report compares the market share ("market" being city pairs) of a particular airline at your agency to all airline business at your agency. It reads the true origin/destination segments, but excludes voided tickets.

Running the Report

To run the report:

On the Commission submenu, click Market Share by Airline.

The Market Share by Airline dialog box appears.

Field descriptions

The following table describes the fields on the Market Share by Airline dialog box.

Field

Description

Account ID

Full or partial customer account ID. Specify a full account ID to include segments for this account ID only. Use the wildcard character (*) to specify a partial account ID, as shown in the following examples:

71*	Includes information for account IDs that begin with "71" (for example, "7126" and "7153").
*71	Includes information for account IDs that end with "71" (for example, "2071" and "10071").
71	Includes information for account IDs that contain "71" anywhere (for example, "7126", "10713", and "10071").

The account IDs available are restricted to those to which the user has access.

You can also specify @TAGGED to include information for tagged accounts only, or @ followed by a customer interest code (for example, @SKI) to include information for only accounts with that interest.

Leave this field blank to include segments for all customers.

To find and select a customer account ID, click the lookup () button. The Find an Account ID screen appears. For details, see Using the Lookup Buttons and Screens.

Airline

Alpha airline code (for example, UA) or number (for example, 016) for which to run the report. If you specify an airline number, GlobalWare will change it to the airline's two-character alpha code. This field is required.

Dom/Intl

Domestic or international segments. The report will include segments that match this indicator. Leave this field blank to include both domestic and international segments. You can specify one of the following:

D	Domestic
I	International

Sort By

Indicates how to sort the report data. This sort is the primary sort for the report. Subtotals are included with sorted data. Select one of the following options from the drop-down list:

none – Indicates to not sort data (no subtotals included).
Customer – Sort by customer account ID.
Booking Agent – Sort by booking agent sine code.
Selling Agent – Sort by sales agent sine code.

City Pair Sort By

Indicates how to sort city pairs. This is the secondary sort for the report. Sort order affects the calculation of the MktShare column amount on the report. Select one of the following options from the drop-down list:

AL Fares – City pair total fare for the specified airline (high to low).
AL Seg Count – City pair segment count for the specified airline (high to low).
City Pair – Alphabetical listing of city pairs.
Tot Fares – City pair total fare for all airlines (high to low).
Tot Seg Count – City pair segment count for all airlines (high to low).

Report By

Select Only Top to limit the number of city pairs that appear on the report. If you select Only Top, a number field displays for you to enter the number of city pairs to display; all other city pairs are grouped in an "All Others" category.

Show Returns Separately

Indicates whether to list opposite city pairs separately. If not selected, the city pairs are combined (for example, AUS-ORD and ORD-AUS would both be counted under AUS-ORD).

Subtotal by Dom/Intl

Indicates whether to subtotal by domestic and international flights. This sort occurs between the sort selected in the Sort By field and the sort selected in the City Pair Sort By field.

Date Type

Type of date range to use for the From and To fields. Select one of the following options from the drop-down list:

Invoice Date Range – Uses invoice dates.
Travel Date Range – Uses travel (departure) dates.
Comm Rcvd Date Range – Uses commission received dates.
Cash Rcvd Date Range – Uses cash received dates.

From (for dates)

Beginning date of a range of dates. If the Date Type field is set to Invoice Date Range, use invoice date. If set to Travel Date Range, use travel (departure) date. If set to Comm Rcvd Date Range, use commission received date. If set to Cash Rcvd Date Range, use cash received date. Segments within the specified range of dates will be included on the report. You must use this date in conjunction with the To date to define a range.

To (for dates)

Complete the fields as appropriate.

Note: The Airline field and the date fields for Dates are required.
Choose one of the following print options:
- To print the report immediately, click PRINT.
  The Send to dialog box appears. Select a report destination. For more information, see Printing Overview.
- To store the report as part of a batch for printing later, click BATCH.
  The Choose a Batch dialog box appears. For more information, see Batch Printing.

Report Example

Market Share by Airline report example

Report Notes

Information on the report includes:

Report Column	Description
# Flights	Number of flights for the city pair.
(airline) Flights	Number of flights for the city pair on the airline you specified.
(airline) MktShare	Number of flights divided by the airline’s number of flights, which is the percentage that airline’s flights constitute in the market.
(airline) Fare	Total amount of fares for the city pair on the airline you specified.
Total Fares	Total amount of fares for the city pair.

GlobalWare calculates the % of Acct and % of Total columns on the report as follows:

Selected subtotals	% of Acct Calculation	% of Total Calculation
Customer or agent only	On the City Pair line, city pair number of flights divided by customer/agent number of flights. On the subtotal line, none.	Customer/agent number of flights divided by report number of flights.
Dom/Int only	On the City Pair line, none. On the subtotal line, Dom/Int number of flights divided by report number of flights.	None.
Customer or agent and Dom/Int	On the City Pair line, city pair number of flights divided by customer/agent number of flights. On the Dom/Int subtotal line, Dom/Int number of flights divided by customer/agent number of flights. On the customer/agent subtotal line, none.	On the Dom/Int subtotal line, Dom/Int number of flights divided by report number of flights. On the customer/agent subtotal line, customer/agent number of flights divided by report number of flights.

Selected subtotals

% of Acct Calculation

% of Total Calculation

Customer or agent only

On the City Pair line, city pair number of flights divided by customer/agent number of flights.

On the subtotal line, none.

Customer/agent number of flights divided by report number of flights.

Dom/Int only

On the City Pair line, none.

On the subtotal line, Dom/Int number of flights divided by report number of flights.

None.

Customer or agent and Dom/Int

On the City Pair line, city pair number of flights divided by customer/agent number of flights.

On the Dom/Int subtotal line, Dom/Int number of flights divided by customer/agent number of flights.

On the customer/agent subtotal line, none.

On the Dom/Int subtotal line, Dom/Int number of flights divided by report number of flights.

On the customer/agent subtotal line, customer/agent number of flights divided by report number of flights.