When a spreadsheet is exported from Xeneta, it contains several columns of data relevant to the report you've chosen to export. The column information is explained in the table below.
Column | Definition |
Origin Name | The name of the origin port. |
Origin Code | The origin port's UN/LOC code. |
Destination Name |
The name of the destination port. |
Destination Code | The destination port's UN/LOC code. |
Supplier | The name of the supplier used for this price. |
Equipment | The container type included in the price. |
Contract Number | The contract number for the price. |
Valid From | The beginning date of the contract's validity period. |
Valid To | The ending date of the contract's validity period. |
My Price | The amount (in USD) you've paid the supplier for this price. |
Market Average | The average market rate (arithmetic mean) for the same combination of trade lane, date, and equipment type in your price. |
VS Market Average | *See information below. |
Market Low | The average market low rate for the same combination of trade lane, date, and equipment type in your price. |
Market Mid-Low | The average market mid-low rate for the same combination of trade lane, date, and equipment type in your price. |
Market Mid-High | The average market mid-high rate for the same combination of trade lane, date, and equipment type in your price. |
Market High | The average market high rate for the same combination of trade lane, date, and equipment type in your price. |
Rate Quality | The number of individually counted datapoints used to calculate market benchmarks (e.g. Market Average, Market Low, etc.) |
Aggregation Level |
Sometimes there are not enough rates for a specific port-port combination to provide an accurate market rate. If this occurs, rates may be provided from a wider regional area instead. Refer to the Geo-Hierarchy documentation for more information. |
Used Origin | The actual origin used to provide the rates. This changes based on if the aggregation level (see above) is changed. |
Used Destination | The actual destination used to provide the rates. This changes based on if the aggregation level (see above) is changed. |
THC Methodology | Information on any applicable terminal handling fees that are included in the rate. |
*Depending on the type of market rate comparison chosen within the report being exported, different comparisons will appear in the exported spreadsheet. For example, choosing Market Average as the comparison type will include the "VS Market Average" column within the report. This means that the "VS Market Average" report will display the difference between your price and the market average rate (either a positive or negative number). Similarly, choosing the Market Low comparison type in the report before exporting will display a "VS Market Low" column in the spreadsheet, which displays the difference between your price and the market low rate.