Reports: Data Export (beta)

Edited August 23, 2024 23:16

How to use the data export report

Top left, you can filter by date of order creation.
Top right, hover over the report and click the icon to download all results and data.

Column names, descriptions, and examples

Tip: Press CTRL+f (or CMD+f) on your keyboard to search for a column name.

Column Name	Description	Examples
Created Date	Date & time of order creation	September 26, 2021, 1:57 PM
Order Number	Order number for each order	RRR4JM1
Status	Status of an order; available options: Processing New Confirmed On Hold Pending Customer Pending Supplier Abandoned Cart Cancelled	Confirmed
Source	The channel in which the order was made through; available options: Internal Online Negotiated Rate Marketplace Rate	Online
Payment Status	Has the order been fully paid or pending (part payment or no payment made)	PAID
Customer First Name	First name of customer making the order	John
Customer Last Name	Last name of customer making the order	Smith
Participants Names	All participant names on the booking (this can include the customers first and last name if they are also travelling All names will be separated by a space	John Smith Joan Smith James Smith
Product Code	Product code booked which will show at product level only	PZXDYE
Product Name	Name of product booked which will show at product level only	Walking Tours of Sydney
Product Type	Category of product booked; available options: ACTIVITY DAYTOUR GIFT_CARD MULTIDAYTOUR PRIVATE_TOUR RENTAL TICKET TRANSFER LESSON CHARTER EVENT MERCHANDISE CUSTOMER This will show at product level only	DAYTOUR
Session ID	Unique session ID booked which will show at product level only	213,357,892
Session Start	Date and time of session booked which will show at product level only	September 26, 2021, 3:00 PM
Check In	Date and time of order check in	September 26, 2021, 3:02 PM
No Show	Date and time of order no show	September 26, 2021, 3:02 PM
Agent Name	Name of agent company who made the booking (if made by an agent)	GetYourGuide
Agent Reference	Unique agent reference to the order when booked	GYGFWX5VW3V9
Agent Source	The agent channel in which the order was made through; available options: Internal Online API	API
Agent Commission	Agent commission for order booked	60.52

Note: All columns from here onwards relate to the structure of an order which contains multiple items either sitting at an order level (od) or a product level (li). Each row has its own set of data and values, and sits in a hierarchy structure with the order level being highest and the product item level being the lowest.

Column Name	Description	Examples
Line Order	The level of granularity in order structure, available options: 1 = Order or Payment 2 = Subtotal or Surcharge 3 = Price Option, Extras, Adjustments or Taxes	1
Line Type	Specific line type which corresponds to the Line Order column, available options: order payment subtotal item	order
Line Name	Specific line name associated with the Line Type column, available options: od_order od_payment od_surcharge li_subtotal li_adjustment li_priceoption li_tax li_extra	od_order
Line Label	User created labels for each line item in the table which corresponds to the Line Name column, available options: od_payment: Currency od_surcharge: Unique string for each entry li_priceoption: Price option label li_tax: Tax label li_extra: Name of extra Note: od_order, li_subtotal & li_adjustment do not have values and will show as -	od_payment: AUD od_surcharge: Surcharge applied to order li_priceoption: Adult li_tax: GST li_extra: Bottle of water
Line Subtype	Rezdy created labels for each line item in the table which corresponds to the Line Name column, available options: od_payment: Payment option li_subtotal: Commission type li_priceoption: Price option type li_extra: Extra price type li_tax: Type of tax Note: or_order, od_surcharge & li_adjustment do not have values and will show as -	od_payment: Creditcard li_subtotal: NET_RATE li_priceoption: Unique price li_extra: ANY li_tax: PERCENT
Line Subtype 2	Rezdy created labels for each line item in the table which corresponds to the Line Name column, available options: od_payment: Payment gateway or method li_priceoption: Price group type li_tax: Tax fee type Note: or_order, od_surcharge, li_adjustment, li_subtotal & li_extra do not have values and will show as -	od_payment: STRIPE_CONNECT li_priceoption: EACH li_tax: TAX
Line Unit Amount	Individual amount per unit for each line item in the table which corresponds to the Line Name column	100.00
Line Quantity	Value assigned for each line item in the table which corresponds to the Line Name column; available options: od_order: 1 od_payment: 1 od_surcharge: 1 li_subtotal: 0 li_adjustment: 1 li_priceoption: 0 - 9999 li_tax: 0 (inclusive) or 1 (exclusive) li_extra: 0 - 9999	od_order: 1 od_payment: 1 od_surcharge: 1 li_subtotal: 0 li_adjustment: 1 li_priceoption: 6 li_tax: 0 li_extra: 2
Line Amount	Total value assigned for each line item in the table which corresponds to the Line Unit Amount x Line Quantity columns Note: Exceptions are li_subtotal which contains the total amount of product line items + surcharges and li_tax is inclusive	75.50
Transaction Date	The date and time of a transaction which appears on the od_payment line only	September 26, 2021, 1:57 PM
Transaction Detail	The detail of a transaction which appears on the od_payment line only	REZDY_STRIPE: pi_213546765132154HJBEYW76

How to use the data export report

Column names, descriptions, and examples

Related articles