Event Revenue Report
Below you will find information relating to the filters and column data found in the Event Revenue Report and should provide a basic understanding of how it works and where the data is drawn from.
Filters/ToolsFILTERS/TOOLS
Interval
The interval filter will allow you to specify how the sales records will be grouped within the selected period. The options for this filter are daily, weekly and monthly. Each sales record is fed into one of the interval options, and within the specified period, based on the completed date of that order. For the weekly interval option, it will take every day between the start of Sunday at midnight through to the next Saturday.
Start Date
The start date filter allows you to specify the starting date of the interval and includes every order completed after, and including, the start date.
End Date
The end date filter allows you to specify the ending date of the interval and includes every order completed before, and including, the end date.
Order Type
The order type filter will allow you to select between one of two options, “Online Sales” and “Point of Sale”. The former will return all orders that were completed via online checkout or transfer, while the latter will return all orders completed via a POS (Point of Sale) machine.
Event Status
The event status filter will allow you to view sales records of older events that are unpublished or of currently running and future events that have a status of published.
Events
The events filter is used to filter sales records based on a specific event or product. Each option in the dropdown also displays the date of the event in brackets.
ColumnCOLUMN DataDATA
Period
The period column is based off of the Interval filter where one of three values can be selected: daily, weekly or monthly. Results will be grouped by one of the selected filter options.
Subtotal
The subtotal column displays the collective amount before adjustments for all orders that are grouped for the specified period. Adjustments include coupons, gift cards, fees and refunds.
Fees Collected
The fees collected column displays the total amount of fees for all orders in the specified period.
Order totals
The order totals column displays the total amount collected for all orders in the specified period which includes all adjustments.
Promotions/Coupons
The promotions/coupons column displays the total amount of coupons applied against all orders for the specified period. Coupons can discount an order by being applied as a percent or fixed amount against an entire order subtotal or specific products in an order.
Redeemed Gift cards
The redeemed gift cards column displays the total amount of gift cards used against all orders for the specified period.
Paid Cash
The paid cash column displays the total amount paid in cash for all orders in the specified period. You will typically see paid cash records for POS sales etc.
Paid Credit
The paid credit column displays the total amount paid in credit for all orders in the specified period. You will typically see paid credit records for online sales etc.
Net Revenue
The net revenue column displays the total amount paid in both cash and credit against all orders in the specified period. This is typically the combination of the subtotal and fees, less any gift card or coupon amounts, and any partial refunds if there are any.