In general, the statistic export displays one line for each ticket that was sold in your ticketshop and gives you detailed information about it.
This article gives you an overview of all the fields (columns) you can display in the statistic export as well as a description of their content (e.g. values the field can take). This will help you create individualized reports for your company.
Fields | Description |
|---|---|
Order ID | number of the order |
Proof of purchase number | number of the proof of purchase/sales receipt of a booking |
Invoice number | number of the invoice that was issued to the customer. This field shows numbers for all invoices created for the payment method "invoice" or the invoices that were created as an additional tax voucher for the customer (tax invoice). |
Order Date | the day on which the order was placed |
Order Time | the time when the order was placed |
Date of participation | day when the customer will take part in the activity |
Time of participation | time when the customer will take part in the activity |
Item Type Please note: For gift vouchers, the information about price of the ticket is contained in the line with item type "gift voucher/gift voucher redemption" and not in the line with the item type "booking". | gives information about the type of ticket that was bought. The field can have the following values:
|
Ticket Code | barcode of the ticket that is also used in the QR code |
SKU Number | article number (SKU) as stated under Manage offers > My offers, for identification of product. The number looks like this and consists of a mix of letters and numbers: T-XXXX-XXXXXX |
Product ID | Number of the product as stated under Manage offers > My offers, for identification of product. The number looks like this and consists only of numbers: XXXXX (number of digits vary) |
Supplier ID | identification number for your Regiondo account |
Supplier Name | the name of your account |
Product Name | name of the offer |
Pricelist | name of the price list |
Ticket Option | name of the ticket category |
Resource 1 | the name of the first resource that was blocked with this ticket |
Resource 1 consumption | number of resources blocked for resource 1 |
Resource 2 | the name of the second resource that was blocked with this ticket |
Resource 2 consumption | number of resources blocked for resource 2 |
Customer Firstname | first name of your customer, for example John |
Customer Lastname | last name of your customer, for example Doe |
Subscription status | information whether the customer subscribed to your newsletter during checkout |
Coupon code | lists the coupon code or value voucher code that was redeemed in the booking |
Customer Email | customer’s email address |
Currency | The currency in which the price is stated, for example EUR or CHF |
Price (Net) | The price excluding the sales tax |
VAT | the VAT rate (see below) calculated from the gross price of the ticket after discounts have been applied |
VAT rate | value of added tax in percent |
Price (gross) | Price including the sales tax |
Amount Discount (gross) | value deducted from the gross price of the ticket due to usage of a value voucher or coupon code |
Price after Discount (net) | net price of the ticket after application of value voucher or coupon code |
Price after Discount (gross) | gross price of the ticket after application of value voucher or coupon code |
Supplier Earning | your profit |
Distribution Provision (%) | the percentage from your ticket price that you pay to the distribution channel. For exact amount that was deducted for this ticket, please refer to your monthly invoice. |
System provision (%) | percentage you are charged for using the system. For exact amount that was deducted for this ticket, please refer to your monthly invoice. |
Payment fee (%) | percentage you are charged for the payment transaction. For exact amount that was deducted for this ticket, please refer to your monthly invoice. |
Status booking | The field can have the following values:
|
Payment method | payment method the customer chose to pay, e.g. credit card or invoice |
Payment status | The field can have the following values:
|
Payment status changed for (Time) | date and time when payment status was changed |
Payment status changed by (User) | The employee who changed the payment status |
Shipping method | How the ticket is delivered to the customer, usually "Print-at-Home" ticket |
Sales Channel | the channel in which the ticket was sold |
Assigned to | The Regiondo users that were assigned to this ticket, e.g. the tour guide doing the tour with this customer |
Agent Name | email address of the Regiondo user or channel name that is responsible for the ticket booking |
Distribution Partner | name of the channel the booking was made on, e.g. GetYourGuide |
Sub ID | if that ticket booking was made via an integration using a Sub ID, you will find the respective Sub ID name here |
Reseller Bill Ref Number | this is the number of the monthly bill listing this booking |
Phone | Your customer’s phone number |
Order Option 1-5 | lists the information of your individually added order options. The export lists a max. of 5 additional order options shown in the same order they are displayed in checkout. |
Comment | The internal note that one of the users in your account manually added to the related booking |
Cancellation Date | The day when the booking was cancelled |
Validated by | The employee who scanned the ticket or validated it |
Validation Date | The day when the ticket was first validated |
Redemption Date | lists the date of redemption of gift certificates and value vouchers |
Invoice Date | the day the original invoice was issued |
Voucher balance | The remaining amount of money of the voucher (for both vouchers created by cancelation or vouchers bought in ticketshop) |
Refund with Value voucher | if a ticket has been canceled with a value voucher, you find the value voucher code here |
Reseller Payout Note: this field is relevant for Regiondo operator accounts, i.e. you are using the account to sell your own activities | amount paid out to you by Regiondo (Regiondo provisions are already deducted). If you are using your own payment methods, this number might be negative stating only the provisions from Regiondo. (operator account) |
Reseller Payout Date Note: this field is relevant for Regiondo operator accounts, i.e. you are using the account to sell your own activities | date when the amount of the field "reseller payout" was paid out/deducted (operator account) |
Reseller Canceled Payout Note: this field is relevant for Regiondo operator accounts, i.e. you are using the account to sell your own activities | amount of money that was sent back to customer due to cancelation (operator account) |
Reseller Canceled Payout Date Note: this field is relevant for Regiondo operator accounts, i.e. you are using the account to sell your own activities | date when the amount of the field "Reseller Canceled Payout" was deducted (operator account |
Partner Payout Note: this field is relevant for Regiondo partner accounts, i.e. you are using the account to sell the activities of other operators | your provision for selling tickets of other operators via online payments, paid out to you by Regiondo (partner account) |
Partner Payout Date Note: this field is relevant for Regiondo partner accounts, i.e. you are using the account to sell the activities of other operators | date when the amount of the field "partner payout" was paid out (partner account) |
Partner Canceled Payout Note: this field is relevant for Regiondo partner accounts, i.e. you are using the account to sell the activities of other operators | amount of money that was deducted from you (partner account) |
Partner Canceled Payout Date Note: this field is relevant for Regiondo partner accounts, i.e. you are using the account to sell the activities of other operators | date when the amount of the field "Partner Canceled Payout" was deducted (partner account) |
Paid by Credit card | amount that was paid by credit card |
Refunded by Credit card | amount that was refunded by credit card |
Paid by Debit card | amount that was paid by debit card |
Refunded by Debit card | amount that was refunded by debit card |
Paid by Cash | amount that was paid by cash |
Refunded by Cash | amount that was refunded by cash |
Paid by Invoice | amount that was paid by invoice |
Refunded by Invoice | amount that was refunded by invoice |