Every Spektrix system comes with a wide range of Standard Reports available by default, which allow you to report on all sorts of information about customers, events, sales, fundraising activity, and much more. In this article we’re taking a look at all of these Standard Reports and breaking down the details of each one and what it’s best used for so that you can understand what’s available and quickly find the most suitable report for your needs.
How to use this article
You’re welcome to go through the reports here from top to bottom, but we'd suggest searching the article for specific words in order to see which reports are most appropriate for what you need. For each report we've included a range of information which you can easily search through:
- Type: which report type each report is based on (see this article for information on different report types)
- Criteria Set: which Criteria Set(s) each report can be run using by default
- Items reported on: which items (orders, order items, campaigns, etc.) each report looks at
- Description: a quick description of what each report does
- Best use: which areas of business each report is most useful for
- Other keywords: anything else which might be appropriate to search for, against each report
The easiest way of searching for this information is by using the standard search functionality in your browser. Use Ctrl + F (or ⌘ + F on a Mac) to start a search, then enter the word or phrase you’re looking for. Here are a few suggestions:
- Search by department best use: e.g. box office, marketing, fundraising, finance, etc.
- Search by keyword: e.g. financial reconciliation, credit card, promo code, capacity, etc.
- Search by type: e.g. searching for Type: Analysis will highlight the reports with an Analysis report type
When you search in this way, each example of a word that’s been found will be highlighted in your browser, and you’ll be able to scroll through all of these to see which reports they apply to.
Accounting Date Audit
- Type: Accounting
- Criteria Set: By Date Confirmed; By Accounting Date
- Items reported on: transactions
- Description: provides details of transactions with an altered Accounting Date.
- Best use: fundraising; development; finance
- Other keywords: N/A
Activities Report (detailed)
- Type: Activities
- Criteria Set: Due this week; Due this month; By Campaign; Incomplete Activities by Type; By Assignee and Due Date
- Items reported on: Activities
- Description: Activities grouped by month due and complete/incomplete status. Includes information on Opportunities, Campaigns, Campaign stages and Opportunity values. Most useful for keeping track of Activities’ status and due dates.
- Best use: fundraising; development
- Other keywords: prospects; donors
Activities Timeline with User breakdown (run as Excel - Formatted)
- Type: Activities
- Criteria Set: Incomplete Activities - Next 6 Months; Incomplete Activities - Next 12 Months; Completed Activities - Last 12 Months; All Activities - This Financial Year; All Activities - By Campaign
- Items reported on: Activities
- Description: a Gantt chart grouped by Activity Type and linked record. Includes a user breakdown in separate sheets. Most useful for seeing a calendar view of all Activities.
- Best use: fundraising; development
- Other keywords: prospects; donors
All Active Reservations
- Type: Analysis
- Criteria Set: By Instance Start Date
- Items reported on: reservations
- Description: all reservations ordered by timeout date/time, with expired and due-to-expire orders highlighted
- Best use: box office
- Other keywords: N/A
Average Price Tracker
- Type: Analysis
- Criteria Set: By Event; By Event excl comps; By Instance Start Date
- Items reported on: Tickets
- Description: an analysis of ticket prices grouped by Event (for more than 10 Events the report will group the totals for the whole dataset). A visual snapshot, in graph form, of how the average price for a particular show or group of shows changes over time
- Best use: box office; marketing
- Other keywords: dynamic pricing
Booking Behaviour Report
- Type: Analysis
- Criteria Set: By Transaction Date
- Items reported on: orders
- Description: allows you to export the number of orders and their value by hour, day of week and sales channel; designed to give you an at-a-glance reference of the busiest times for your box office, both online and on the phone/counter
- Best use: box office; marketing
- Other keywords: trends; sales; weekday; day of week
Campaign Detail
- Type: Campaigns
- Criteria Set: By Campaign
- Items reported on: Campaigns
- Description: details of your Campaigns with donor name, amounts, and transaction dates
- Best use: fundraising; development
- Other keywords: Opportunities
Campaign Summary
- Type: Campaigns
- Criteria Set: By Campaign
- Items reported on: Campaigns
- Description: a breakdown of how your Campaigns are performing over time
- Best use: fundraising; development
- Other keywords: Opportunities
Cashier Activity Report
- Type: Accounting
- Criteria Set: By Date & Cashier
- Items reported on: order items
- Description: this breaks down all activity by cashier over a selected date range, and includes customer, payment and item details in full
- Best use: box office; finance
- Other keywords: financial reconciliation; user; sales channel; credit card; transactions; web
Current Members
- Type: Memberships
- Criteria set: Current Members
- Items reported on: Memberships
- Description: a breakdown of all customers with current subscriptions to the selected Membership(s), covering their start date, expiry date and price paid
- Best use: box office; marketing
- Other keywords: expiry date
Customer & Household Analysis
- Type: Customer
- Criteria Set: All Active Customers
- Items reported on: customers
- Description: analysis of active customers, covering average spend per order, average spend per ticket, postcode/zip code, time booked in advance, customers who have never booked, customers with only email or only mailing address, and total number of customers in database
- Best use: box office; marketing; fundraising; development
- Other keywords: postcode; post code; postal code; zip code; average spend; contact preferences; advance sales
Customer Behaviour Analysis
- Type: Analysis
- Criteria Set: By Active Flag
- Items reported on: tickets
- Description: analysis of customer behaviour, covering group size, questionnaire answers, Events booked (and their crossover %), time booked in advance, Offers used, Promo Codes used and sales channels
- Best use: box office; marketing
- Other keywords: sales channel; advance sales; delivery method; groups; discounts; Offers
Customer Demographic Analysis
- Type: Analysis
- Criteria Set: By Transaction Date; By Event Instance; By Event; By Instance Start Date
- Items reported on: tickets
- Description: analysis of customer demographics e.g. Ticket Types, post codes, age
- Best use: box office; marketing; fundraising; development
- Other keywords: zip code; post code; postcode; postal code
Customer Questionnaire Analysis
- Type: Analysis
- Criteria Set: By Transaction Date; By Event Instance; By Event; By Instance Start Date
- Items reported on: tickets
- Description: breakdown of the answers given by customers to the questionnaire
- Best use: box office; marketing
- Other keywords: sales channel; responses; answers
Donation Conversion Analysis
- Type: Analysis
- Criteria Set: Donation Conversions; Donations Conversions by User; Donations Conversions under $50; Value Donation Conversions as proportion of tickets
- Items reported on: donations and tickets
- Description: an analysis of the percentage of orders containing donations and tickets. Use this to measure your donation goals and benchmark against your peers using the Insights Report data.
- Best use: box office; fundraising; development
- Other keywords: average donation amount; funds
Donations Analysis
- Type: Analysis
- Criteria Set: By Transaction Date
- Items reported on: order items
- Description: analysis, by sales channel, of proportion of transactions containing donations. It will also list totals by sales channel, Fund and cashier, your average donation value and provides a breakdown by amount donated
- Best use: fundraising; development
- Other keywords: Fund; conversion; average donation; sales channel; weekday; day of week; time of day
Donations Report
- Type: Analysis
- Criteria Set: By Fund & Transaction Date; By Transaction Date
- Items reported on: donations
- Description: donations during a date range broken down by fund, campaign, and donor with totals
- Best use: fundraising; development
- Other keywords: recognition; tribute
Event Instances Occupancy Report
- Type: Sales
- Criteria Set: By Instance Start Date; By Event Instance
- Items reported on: seats
- Description: seat occupancy report for the specified Instances, giving the price, seat number, seat status and Ticket Type (where sold) of every seat in the venue, with customer details
- Best use: box office
- Other keywords: seating area, scanned, printed, delivery method
Donor Giving History
- Type: Analysis
- Criteria Set: Lifetime Donations (use with Customer List); Lifetime Donations - By Tag
- Items reported on: donations
- Description: a list of donors with a breakdown of their total, average, latest, and largest gift information
- Best use: fundraising; development
- Other keywords: N/A
Event Sales Comparison
- Type: Analysis
- Criteria Set: By Event
- Items reported on: tickets
- Description: comparison of sales for a set of Events, showing revenue generated by week, both singular and cumulatively. Can be used to compare multiple Events against each other
- Best use: box office; marketing
- Other keywords: advance sales; weeks out; opening night
Event Sales Report (Detailed)
- Type: Sales
- Criteria Set: By Event
- Items reported on: seats
- Description: a sales report for all Instances, listed with one page per Instance, covering sales (including and excluding reservations), reservations, availability, Locks, gross financial capacity, Ticket Types, Price Bands, Lock Types and sales by sales channel (Web, Counter and Phone)
- Best use: box office; marketing
- Other keywords: capacity; gross; yield; sales channel; Ticket Type; Price Band; seating area; comps
Event Sales Report (Instances Summary)
- Type: Sales
- Criteria Set: By Event
- Items reported on: seats
- Description: sales by Event broken down by Instance, with one page per Event. Covers the number of Instances, gross sales (including and excluding comps), ticket yield, concession/discounted sales, comps, reservations, Locks, and availability
- Best use: box office; marketing
- Other keywords: value; reservations; reserved; available; locked; Lock Type; tax; offers; comps; net; financial target
Event Sales Report (Movement by Event)
- Type: Accounting
- Criteria Set: By Event; By Instance; By Instant Date; By First Instance
- Items reported on: seats
- Description: sales made in the past day, 7 days and 30 days, as well as total sales, broken down by Event
- Best use: box office; marketing
- Other keywords: value; reservations
TIP: This doesn't report on returned reservations, but it does report on timed out reservations.
Timed out reservations appear as available on a Sales Report, but still as Reserved tickets on the Event Sales Report (Movement by Event)
Event Sales Report (Movement by Instance)
- Type: Accounting
- Criteria Set: By Event; By Instance; By Instance Date; By First Instance
- Items reported on: seats
- Description: sales made in the past day, 7 days and 30 days, as well as total sales - broken down by Instance
- Best use: box office; marketing
- Other keywords: -
Event Sales Report (Summary)
- Type: Sales
- Criteria Set: By Event; By Instance Start Date; By Event Instance
- Items reported on: seats
- Description: sales summary by Event; as per the Event Sales Report (Instances Summary) but offering one summarised line per Event
- Best use: box office; marketing
- Other keywords: -
Individuals & Contacts
- Type: Customer
- Criteria Set: By Data Protection; By Tag
- Items reported on: individuals
- Description: all active individuals and their contacts details, outputting their ID, title, name, organisation, email and mailing address
- Best use: box office; marketing; fundraising; development
- Other keywords: contact preferences; tags
Membership Activity in Last 30 Days
- Type: Memberships
- Criteria Set: All
- Items reported On: Memberships
- Description: new, renewed and lapsed subscriptions in the last 30 days, broken down into new, renewals, lapsed and due-to-lapse members and displayed one line per member
- Best use: box office; marketing
- Other keywords: -
Membership Activity in Last 30 Days by Membership
- Type: Memberships
- Criteria Set: All
- Items reported on: Memberships
- Description: new, renewed and lapsed subscriptions in the last 30 days, broken down into new, renewals, lapsed and due to lapsed members and displayed one line per member, separated to one page per Membership type
- Best use: box office; marketing
- Other keywords: -
Monthly Membership Activity
- Type: Memberships
- Criteria Set: All
- Items reported on: Memberships
- Description: monthly Membership activity for the last 12 months, displayed one page per month. Covers the Memberships sold and returned, the new, renewed and lapsed members, the total members at the end of each month and the difference to the previous month
- Best use: box office; marketing
- Other keywords: -
Offer Analysis
- Type: Analysis
- Criteria Set: By Transaction Date; By Event Instance; By Event; By Instance Start Date
- Items reported on: tickets
- Description: analysis of sales made using Offers, covering the numbers and percentages of customers, orders and tickets, and the total values discounted. Summarised for the specified range and also broken down by Event
- Best use: box office; marketing
- Other keywords: discount
Opportunity Funnel
- Type: Opportunities
- Criteria Set: All Open Opportunities; By Close Date; By Campaign & Close Date; By Campaign
- Items reported on: Opportunities
- Description: a summary of your Opportunities displayed visually as funnel charts
- Best use: fundraising; development
- Other keywords: -
Opportunity Pipeline by Month
- Type: Opportunities
- Criteria Set: All Open Opportunities; By Close Date; By Campaign & Close Date; By Campaign
- Items reported on: Opportunities
- Description: a pipeline of your Opportunities by the date you have anticipated they will close
- Best use: fundraising; development
- Other keywords: -
Payments & Activities Report
- Type: Accounting
- Criteria Set: By Date
- Items reported on: transaction items
- Description: shows all payments received over a given period and how these broke down into activities, summarised for the specified time period. This report breaks down all your payment types (including card types, gift vouchers and custom payments) and also shows the gross totals for commissions, Events, merchandise sales, donations and Memberships
- Best use: box office; finance
- Other keywords: financial reconciliation; mixed payments; credit card; cash; gift vouchers; net
Payments & Activities Report (by User)
- Type: Accounting
- Criteria Set: By Date & Cashier
- Items reported on: transaction items
- Description: as the Payments & Activities Report, broken out by individual Spektrix users
- Best use: box office; finance
- Other keywords: financial reconciliation; mixed payments; credit card; cash; gift vouchers; exchanges; net; totals
Payments & Activities Report (Daily Breakdown)
- Type: Accounting
- Criteria Set: By Date
- Items reported on: transaction items
- Description: as the Payments & Activities Report, with additional individual breakdowns for each day which saw payments made
- Best use: box office; finance
- Other keywords: financial reconciliation; mixed payments; credit card; cash; gift vouchers; exchanges; net; totals
Payments & Activities Report (Detailed)
- Type: Accounting
- Criteria Set: By Date
- Items reported on: transaction items
- Description: as the Payments & Activities Report but with extra columns for gross, VAT and net amounts and a payments breakdown (cash, card, custom payments, gift vouchers, account and mixed) for each Event and item
- Best use: box office; finance
- Other keywords: financial reconciliation; mixed payments; credit card; cash; gift vouchers; exchanges; net; totals
Payments Report
- Type: Accounting
- Criteria Set: By Date
- Items reported on: transaction items
- Description: full details of all payments across the specified date range, with one line per payment. Includes transaction codes, order ID and payment details such as registers, card identifiers and Custom Payment Attributes
- Best use: box office; finance
- Other keywords: financial reconciliation; transactions
Pledge Installments By Campaign
- Type: Pledges & Legacies
- Criteria Set: By Campaign; By Fund; By Date Pledged; By Outstanding Balances Only
- Items reported on: Pledges
- Description: Pledges and their installment statuses, expected fulfillment dates, campaign totals, and grand totals. Useful for keeping track of your outstanding earned income by tracking Pledge due dates and payment schedules. Helpful for financial forecasting, as you can know when money is due to arrive. Also offers a great snapshot of outstanding and received income.
- Best use: fundraising; development
- Other keywords: -
Post Show Analysis Report
- Type: Sales
- Criteria Set: By Event
- Items reported on: seats
- Description: a comprehensive report for show-specific analysis, covering number of Instances, performance date range, admin area breakdown, first time visitors, gross totals, sales and seats targets, average yields, advance sales (sold before the first Instance), Ticket Types, comps and Price Bands, broken down to one page per Event
- Best use: box office; marketing
- Other keywords: -
Promotion Code Analysis
- Type: Analysis
- Criteria Set: By Transaction Date; By Event Instance; By Event; By Instance Start Date
- Items reported on: tickets
- Description: analysis of sales made via Promotion Code, per code and Event
- Best use: box office; marketing
- Other keywords: Promo Code
Reattendance Analysis
- Type: Analysis
- Criteria Set: By Transaction Date; By Event Instance; By Event; By Instance Start Date
- Items reported on: tickets
- Description: information about customer reattendance for the specified Events, covering the number of tickets sold and linked/not linked to a customer, with their number of visits and average group size
- Best use: box office; marketing
- Other keywords: repeat customers
Register of Attendance
- Type: Sales
- Criteria Set: By Event; By Event Attribute & Date
- Items reported on: tickets
- Description: a register of who's booked into each Instance of an Event, including customers’ emergency contact details
- Best use: box office
- Other keywords: classes; camp; education; summer school; registration
ROI Report by Mailing
- Type: Mailing ROI
- Criteria Set: -
- Items reported on: -
- Description: a page per mailing, looking at overall ROI, and sales by Event resulting from the mailing
- Best use: marketing; fundraising; development
- Other keywords: -
Sales History for an Event Instance
- Type: Analysis
- Criteria Set: Sales Activity over last 24 hours
- Items reported on: tickets
- Description: all the sales, returns, active reservations and timed out reservations for each Instance, covering customer names, Ticket Types, seat numbers, transaction dates, sales channels and sales operators
- Best use: box office; marketing
- Other keywords: -
Ticket Sales Analysis
- Type: Analysis
- Criteria Set: By Transaction Date; By Event Instance; By Event; By Instance Start Date
- Items reported on: tickets
- Description: a breakdown of ticket sales by sales channel, sales operator, Ticket Type, Price Band and Event, with quick sales analysis (items sold without a customer name)
- Best use: box office; marketing
- Other keywords: sales channel; delivery method; user; Ticket Type; Price Band; Fixed Series
Ticket Subscriptions Analysis
- Type: Ticket Vouchers
- Criteria Set: All Unexpired Vouchers; By Ticket Subscription; By Date Purchased; All Unredeemed Vouchers
- Items reported on: ticket vouchers
- Description: Analysis at aggregate level of total ticket subscription purchases and ticket voucher redemption details. Includes analysis by Ticket Subscription and Pricing Set or Ticket Subscription and Month/Year Purchased
- Best use: box office
- Other keywords: Ticket Subscriptions, Ticket Vouchers, expired vouchers, unexpired vouchers, unredeemed vouchers
Ticket Subscriptions by Customer
- Type: Ticket Vouchers
- Criteria Set: All Unexpired Vouchers; By Ticket Subscription; By Date Purchased; All Unredeemed Vouchers
- Items reported on: ticket vouchers
- Description: Analysis at customer level of total ticket subscription purchases and ticket voucher redemption details. Includes grouping by either Ticket Subscription or Customer first
- Best use: box office
- Other keywords: Ticket Subscriptions, Ticket Vouchers, expired vouchers, unexpired vouchers, unredeemed vouchers
If you can’t find what you’re looking for with any of these reports, please don’t hesitate to get in touch with the Spektrix Support team to discuss whether the information you need is available elsewhere, or whether it might be appropriate to request a custom report.