This article is a high-level overview defining all fields included in this report.
Event Start Time: Start Date and time of the event which the attendee has requested tickets
for.
Event Start Time Date: Start Date of the event which the attendee has requested tickets for.
ID: if the order is approved, this will become the buyer’s Order ID.
Created At: date and time the order request was submitted by the attendee.
Created At Date: date on which the order request was submitted by the attendee.
Buyer First Name: Lead buyer’s first name.
Buyer Last Name: Lead buyer’s last name.
Buyer Email: Lead buyer’s email address.
Host Purchased by Email: email of the host if the ticket is purchased by host.
Ticket Quantity: number of tickets which the buyer has requested.
Add-On Quantity: number of add-ons which the buyer has requested.
Ticket Types: Name of the ticket type requested.
Add-On Types: Name of the add-on type(s) requested.
Option Types: Name of the add-on option requested. This will only display if you have added
options to any of your add-ons (i.e., t-shirt sizes).
Order Status: this report will only ever show orders with the status of “unapproved”. Once
approved, the order will migrate to the Orders report. If declined, the information will be
removed.
Payment Processor: Name of the payment processor used. This will be Universe Payments (if
using Universe as your payment processor), Stripe Connect (if using Stripe), Offline Payment
(for any cash payments, or any other payments done through 3rd party card readers, like
Square) or Channel Partner (for any distributed commerce orders).
Payment Type: This will display details about the payment method, showing offline payments
(this can include cash payments, but can also include any payments completed through third
party card readers like Square), card payments, or any other payments done with alternate
payment methods (Paypal, Sofort, etc).
Payment Type Details: if this transaction was processed via the Add an Order page, this will
designate if it was a COMP or payment method OTHER. It will also pull in any notes added to the
transaction on Add an Order. If orders are being processed via the BoxOffice app, it will specify if with a card reader and the type of card reader used, payment via cash, and also the type of device used to
operate BoxOffice as well (IOS or Android). (examples: ios_square_reader / android_square_reader /
ios_third_party_reader / android_third_party_reader / ios_cash / android_cash).
Last 4 Digits: Last 4 digits of the card used for payment (if paid by credit/debit card).
Card Brand: Brand of the card used for payment (i.e., Visa, Mastercard).
Partially Refunded: Displays as True or False, and will tell you whether a partial amount has
been refunded. This will only display as True if the ticket has a partial refund, but is not
cancelled.
Do Not Sell: The value will display as true if a user has submitted a request through our privacy
page to not sell or share their personal information. The default value will display as FALSE if
the user has not submitted a request.
Base Price: Base ticket price before tax or fees.
Base Discount: Amount of discount in dollars (fiat currency).
Base Commission: Universe Service Charge fee (passed to buyer).
Base Commission Included: Universe Service Charge fee (absorbed/included in
price).
Base Voided Price: This is the refunded amount
Base Voided Discount: This is the discount that has been refunded.
Base Voided Commission: Universe Service Charge fee (passed to buyer) that has
been refunded.
Base Voided Commission Included: Universe Service Charge fee (absorbed/included
in price) that has been refunded.
Net Earnings:
Settlement Currency: event host receives funds in this currency.
Discount Codes: Indicates ticket(s) in this order were requested/purchased with a discount
code.
Access Keys Used: Indicates ticket(s) in this order were requested/purchased with an access
key.
Referral: Any referral codes used in URL.
Purchase Channel: Shows if the order was placed via an embedded widget, Add an Order,
BoxOffice app (version and device - Android or iOS).
Purchase Origin: the URL where the checkout widget is embedded, and where the order was
purchased, usually Universe.com or a client’s own website.
Title: Listing title or event name.
Listing URL: Web address of the event listing.
Purchase Device: This column will only populate if a ticket/order is purchased via the Universe
BoxOffice app, and it will show the team mate name given to the device.
Channel Partner: This is the name of the channel partner used if the ticket is purchased
through our Distributed Commerce channels.
Note: in order for any checkout questions to be surfaced on this report, they must be asked on
a “per order” basis.