Submit Feedback

ARC Origin and Destination Sales Summary (ODSS)

Market-level city pair data from all ARC participating carriers

ARC Origin and Destination Sales Summary provides you with the market-level city pair settled transaction data that can help you maximize, track, and manage incentive programs, validate carrier calculations, and assess the value you provide to clients.

Origin and destination (O&D) data from ARC provides a true depiction of passenger travel information by city pairs, including fare levels and transaction counts. This information is essential for effective contract management, targeting travel promotions, and identification of new revenue opportunities.

Reports are delivered in Microsoft Excel format via ARC's secure e-mail server. Costs vary based on whether you purchase a one-time report, a quarterly subscription, or a monthly subscription.

Pricing and Ordering: Costs vary based on whether you purchase a one-time report, a quarterly subscription, or a monthly subscription. For specific pricing, please contact an ARC representative at +1 703.816.8530 or complete an information request form.

Learn more about participation

  • Settled data for all ARC participating carriers
  • Grouped by PED
  • Excel file

Report Versions

You can choose to receive any one of the following versions of the ODSS data set:

  • Detailed - Your agency, one carrier, high detail
    In-depth data for your agency's transactions in the same format as offered to ARC participating carriers. This report is specific to United Airlines only and is offered to travel professionals to ensure that both agent and carrier receive the same data in the same format and time frames.
  • Enhanced - Your agency, all carriers, industry benchmarking
    Aggregate industry and your agency's O&D fare data for ARC participating agencies and carriers by city pair and class of service. Report now includes new fields for benchmarking city pair counts by market.
  • Focused - Your agency, one carrier
    Detailed and summarized O&D data for your agency's transactions on one ARC participating carrier of your choice by city pair and class of service over a period of time.
  • Basic - Your agency, all carriers
    Detailed and summarized O&D data for your agency's transactions by city pair, class of service, and carrier over a period of time for all carriers you sold. Report can be created based on either date of transaction processing, or date of travel, depending on your agency's specific needs.

Data Elements

Each file contains 38 data elements, including:

  • Processing Period Ending Date
  • 445 Month
  • Ticketing Carrier/Validating Supplier
  • Primary Ticket Key
  • Primary Ticket/Document Number
  • Agency Code Number
  • Domestic/International Indicator
  • Transaction Type Code
  • System Provider Identifier
  • Date of Issue
  • Ticket/Document Number
  • PNR Reference
  • Conjunction Ticket Indicator
  • Electronic Ticket Indicator
  • Fare Basis/Ticket Designator
  • Tour Code
  • Fare Amount
  • Fare Calculation Mode Indicator
  • Currency Type
  • Original Issue Information
  • ISO Country Code
  • Segment Identifier
  • Transaction Coupon Total
  • Coupon Number
  • Origin Airport/City Code
  • Destination Airport/City Code
  • Stopover Code
  • Flight Date
  • Timing and Delivery
  • Reports are delivered in Microsoft Excel format, electronically via ARC's secure e-mail server. Reports can be delivered on a one-time basis, or by monthly or quarterly subscription.

  • Enables "snapshot" view of activity that can help negotiate contracts with carriers
  • Timely data to help manage business
  • Data can help guide advertising decisions and track results

Origin & Destination (O&D) is also known as a city pair. For example, if a passenger travels from JFK-ORD-LAX, then JFK-LAX is considered the O&D city pair.

City pairs are derived from the itinerary data using the stopover code field and exclude all intermediate cities where a stopover is not permitted. For Example, if a passenger travels from SDF through ATL to TPA and returns TPA through ATL to SDF, the city pairs for this itinerary are SDF to TPA and TPA to SDF. ATL is a connection city and therefore is not shown in the O&D data.

No, marketing carriers may not necessarily be in the ARC system as a participating carrier. Whichever carrier is identified in the itinerary with a corresponding flight number is the marketing carrier recognized in the O&D suite of reports.

Yes. When an HOL orders a report it will always contain information for the ACNs associated with it. A branch cannot order any of the four reports; only the HOL or independent agency can do so.

Benchmarking data in the O&D report compares your agency's average fare for a city pair and class of service to all other sales reported to ARC for that same period where the city pair and class of service match.

Only the owner or officer of record (verified by ARC's files) has permission to sign the order form and purchase these reports. The ODSS suite of reports can be ordered by Home and Independent agents and CTDs only. The report data will include data for all subordinate offices (i.e. branches, STPs) if the requestor is a home office.

A one-time report for the Basic, Focused, and Enhanced versions only are available with historical data. All monthly and quarterly subscriptions will contain data from the date of the signed contract going forward.

Agent Sales Summary reports contain settled transactions by plating carrier including PTAs, MCOs, etc, and do not include itinerary information or analytics. The suite of O&D reports excludes PTAs, MCOs, etc. and show itinerary data by marketing carrier code, and city pair. Fare benchmarking data is also included in the enhanced report.

The format of the O&D reports allows you to measure your sales in a similar manner as your carrier partners. By focusing on marketing carriers by city pairs, you will have access to timely data to help you manage and maximize contracts with carriers.

Other possible business applications include:

Route and Network Planning, Revenue and Yield Management
  • Analyze route performance
  • Plan appropriate route adjustments
  • Understand passenger behavior
  • Create passenger demand forecasts
  • Receive daily Marketplace data
  • Benchmark on specific routes
Sales
  • Improve corporate contracts
  • Identify new revenue opportunities
  • Assess agency incentive programs
  • Conduct point of sale analysis
Marketing
  • Target advertising efforts
  • Optimize promotional programs
  • Measure marketing successes