Extracts Reports
Reports in the Extracts menu extract data to a Comma Separated Values (CSV) format readable by Microsoft Excel.
Ticket Sales
Extracts > Ticket Sales
Selections:
- Sales date range
- Browse for location to save CSV file
This report summarises ticket sales for each production and extracts the data to a Comma Separated Values (CSV) format readable by Microsoft Excel.
Fields included are:
- Venue
- Production start date
- Production ID
- Title
- Paid value
- Paid count
- Complementary count
- Unpaid value
- Unpaid count
Account Code Payments
Extracts > Account Code Payments
Selections:
- Sales date range
- Browse for location to save CSV file
This report extracts information about payments for tickets and products and extracts the data to a Comma Separated Values (CSV) format readable by Microsoft Excel.
Fields included are:
- Sale ID
- User ID
- Payment type
- Production/product type
- Description
- Account code
- Payment date
- Value
- Operator ID
Futures
Extracts > Futures
Selections:
First to derive a list of productions:
- Performance date range
- Departments
- Projects
- Account Codes
- Option to exclude inactive productions
Then, having selected productions:
- Select to display only those performances falling within the performance date range
- Select the date range (specified previously)
- Select the type of date range (Sale Date; Allocation or Payment Date)
- Browse for location to save CSV file
This report summarises production payments falling within a specified date range – whether that be Sale, Payment or Allocation date, and extracts the data to a Comma Separated Values (CSV) format readable by Microsoft Excel.
Fields included are:
- Account code
- Gross
- Net, Sales Tax
- Inside Charges
Project Sales
Extracts > Project Sales
Selections:
- Sales date range
- Project
- Browse for location to save CSV file
This report summarises sales for a specified project and extracts the data to a Comma Separated Values (CSV) format readable by Microsoft Excel.
Data is summarised (Ticket counts only) by date of sale and includes a running total. Additonally there is a DaysOut column which represents the number of days out from the end of the specified date range.
The extract is typically used for graphing and year-on-year festival analysis.
Tickets Printed By Operator
Extracts > Tickets Printed By Operator
Selections:
- Sales date range
- Browse for location to save CSV file
This report summarises the number of tickets sold by each operator across a selected period and extracts the data to a Comma Separated Values (CSV) format readable by Microsoft Excel.
Members List
Extracts > Tickets Printed By Operator
Selections:
- Sales date
- Relationships to include
- Browse for location to save CSV file
This report lists member postal details along with Join Date and Fee Due Date and Member Category to aid mailouts of subscribed membership material. The data is extracted as a Comma Separated Values (CSV) format readable by Microsoft Excel.