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.