Reports - Redemptions

This allows you to view all of your ticket redemption in real time. This report looks very similar to the Sales Report, but only shows redemptions based on what has been purchased.

You can click on the + icon next to the product in order to see additional information.

You can find the Redemption Report in Spark under Commerce> Reports> Redemptions

Redemption Report Overview

  1. Date range selector
  2. Sorting options (see below for details)
    1. Product
    2. Location
    3. Date
    4. User
    5. Location by Product
  3. Filters
    1. Category - Choose category or subcategory
    2. Product Type - Choose general admission or reserved products
    3. Channel - Choose sales that only originated Online or at Box Office
  4. Sharing options
    1. Print
    2. Export to Excel (simple view)
    3. Export Redemptions to Excel (detailed view)
    4. Export Redemptions Users
    5. Email (Excel file)
  5. Chart (hover over graph points to see exact number)
  6. Expandable view of redemptions

Sorting Options

Just like the Sales Report, the Redemption Report allows you to choose the date range and allows you to sort by Product, Location, Date, User, and Location by Product.

Product

Sorting by product gives you total redemptions for each category, which is then further broken out by subcategory, product, price type, and price.

Location

Sorting by location gives you total redemptions for each configured scanning location or gate, which is then further broken down by category, subcategory, product, price type, and price.

Date

Sorting by date gives you total redemptions for every day, which is then further broken out by hour, category, subcategory, product, price type, and price.

User

Sorting by user gives you total redemptions made by each configured user for the entirety of the selected date range. It is then further broken out by product, price type, and price.

Location by Product

Sorting with location by product gives you total redemptions made at each location, then bypasses categories and subcategories to give you a direct view of products redeemed. It also bypasses breaking products down further into price type and price.

Filtering Options

In addition to sorting, the redemptions report also allows you to filter by one or more field to give your data a tighter focus. For example, in the image below you can see the red box outlining currently filters types, while the blue shows what filtering options live in the dropdown.

Category

Choose from categories and subcategories that exist in your products

Product Type

Choose general admission or reserved products

Channel

Choose sales that only originated Online or at Box Office. When selecting box office you will have the option to further narrow by Direct Sales, Hold Conversion, or Pre-Printed batches.

Sharing Options

Allows printing the visible page either with or without the chart.

Export

Downloads the redemptions data as an Excel file (XLSX) with just the total redemptions field. This is an example of the Export created when sorted by Location by Product:

Export Redemptions

Downloads the redemptions data as an Excel file with a line item for each individual redemption. Data included for each scan includes date/time, product, price type, code, location, scanner info, order ID and more.

Export Redemption Users

Downloads the redemptions data as an Excel file with a line item for each individual redemption. Data included for each scan includes date/time, product, and detailed purchaser information sucha s address, phone number, and purchase date.

Email

Opens a modal window that allows you to send an email to one or more email addresses containing an attachment of the minimal Export data.

Codes Redeemed vs Total Redemptions

Codes Redeemed refers to the actual ticket that's been used. In many instances the number of codes redeemed and total redemptions will match, however, there are a few scenarios in which they may vary.

Total Redemptions is the total of scans that actually occurred. For example, if a single ticket is sold as a Family admission product, it may have 4 redemptions associated with that code. Therefore, Codes Redeemed would show 1 while your Total Redemptions may show 4.  In *some instances, Total Redemptions may reflect attendance numbers. This is also true for a "static code," a code that is used as a counter for Free admission for Kids under 5, special deal days, etc, these codes will show one (1) under Codes Redeemed and something drastically different under Total Redemptions.

*if a ticket is admission for one (1) at the gates and has additional scan rules/locations (such as a VIP Gate or Carnival location) then this number isn't the best way to determine your Attendance.

Gate Attendance Totals

The simplest way to determine traffic levels at each gate is to view the Redemption Report By Location, instead of By Product.