• Business Intelligence and Reports Content Map
• Reporting Permissions Requirements
• Business Intelligence and Reports - Generated Reports
  • Business Intelligence and Reports - Generated Reports Pages
    • Business Intelligence and Reports - Generated Reports|Reports Page
    • Business Intelligence and Reports - Generated Reports|Parameters Page
  • Using Generated Reports
    • Running a Generated Report
    • Changing the Output of a Generated Report
    • Saving a Report
  • Date Formats within AudienceView Reports
  • AudienceView Reports
    • Access Control Reports
      • Real Time Access Control Report
      • Scanned Tickets by Hour Report
      • Scanning Failures Report
    • Accounting Reports
      • AV Transaction Report
      • Credit Card Transaction Summary Report
      • Daily Payment Summary Report
      • End of Day Summary Report
      • General Ledger Report
      • Payment Details Report
      • Payment Gateway Transaction Summary Report (AudienceView 6.8.11)
      • Performance Order Allocations Report
      • Performance Payment Allocations Report
      • Sales Audit Report
      • Sales by Series Performance and Price Type (AudienceView 6.8.10)
      • Sales Report by Series Performance Report
      • Unallocated Payment Details Report
      • Unbalanced Orders Summary Report
    • Charges Report
    • Dashboard Reports
      • Daily Sales Dashboard Report
      • Fundraising Dashboard Report
      • Notes Dashboard Report
      • Ticket Sales Dashboard Report
    • Donation Reports
      • Donation by Sales Date Report
      • Donor Biography Report
      • Donation Detail Summary Report
      • Funds Detail Report
      • Opportunities and Goals Report
    • Marketing Reports
      • Call Over Report
      • Customer Biography Report
      • Email Marketing Report
      • Front of House Report
      • Order Marketing Data Report
      • Question Response Summary Report
      • Ticket Usage Report
    • Miscellaneous Items Report
    • Pricing Reports
      • Performance Pricing by Date Report
      • Performance Pricing by Price Type Report
    • Sales Reports
      • Admission Release Summary Report
      • Admissions by Delivery Method Report
      • Agent Event Sales Report (AudienceView 6.8.19)
      • Allocated Admission Detail Report
      • Bundle Performance Requests Report
      • Bundle Sales Report
      • Comp Admission Details Report
      • Event Availability by Price Zone and Hold Report
      • Gift Certificate and Gift Card Transactions Report
      • Gift Certificates and Gift Cards by Role Report
      • Held Tickets by Hold Type Report
      • Holds for Performance Report
      • Hold Type Range Report
      • Hourly Ticket Sales Report
      • Movement Report
      • Offer Status Report
      • Order Detail by User Role Report
      • Orders Paid by Date Report
      • Performance Audit Report
      • Performance Availability Report
      • Performance Payment Distribution Report
      • Performance Popularity Report
      • Performance Sales by Price Report
      • Performance Settlement Report
      • Sales Staff Analysis Report
      • Ticket Sales by Performance Report
      • Ticket Sales by Price Type and Price Zone Report
      • Ticket Sales Report
      • Wrap Report
    • Security Reports
      • Security by Group Report
      • Security by User Report
    • Technical Reports
      • Booking Protect Report (AudienceView 6.8.8)
      • Credit and Debit Card Payment Reconciliation Report
      • Duplicate Account Summary Report
      • Fortress Ticket Reconciliation Report
      • Order Reconciliation Report (Available as of AudienceView 6.8.7)
      • Seat History Report
      • Tickets Printed Report
      • Venue Proof Report
• Business Intelligence and Reports - Saved Reports
  • Business Intelligence and Reports - Saved Reports Pages
    • Business Intelligence and Reports - Saved Reports|Reports Page
    • Business Intelligence and Reports - Saved Reports|Parameters Page
  • Using Saved Reports
    • Running a Saved Report
    • Changing the Output of a Saved Report
    • Configuring Saved Report Folders
    • Modifying a Saved Report
    • Copying a Saved Report
    • Deleting a Saved Report
    • Scheduling a Report to Run at Regular Intervals
• Business Intelligence and Reports - Business Intelligence
  • Business Intelligence and Reports - Business Intelligence Pages
    • Business Intelligence and Reports - Business Intelligence|Search Page
    • Business Intelligence and Reports - Business Intelligence|Results Page
    • Business Intelligence and Reports - Business Intelligence|Formulas Page
    • Business Intelligence and Reports - Business Intelligence|Criteria Page
    • Business Intelligence and Reports - Business Intelligence|Filters Page
    • Business Intelligence and Reports - Business Intelligence|Preview Page
  • Using Business Intelligence
    • Masking Payment Methods
    • Creating a BI Query
    • Working with BI Criteria
      • Searching for BI Criteria
      • Adding Criteria to a BI Query
      • Example - Customer Query
      • Using Relative Dates and Times with a BI Query
      • Deleting BI Criteria
    • Working with BI Filters
      • Searching for a BI Filter
      • Adding a Filter to a BI Query
      • Example Session Filter - Filtering Customers by Create User
      • Example Filter - Filtering Performances by Venue and Date Range
      • Deleting a BI Filter
    • Working with BI Formulas
      • Creating a BI Formula
      • Modifying a BI Formula
      • Deleting a BI Formula
    • Working with Result Members
      • Adding New Result Members to a BI Query
      • Sorting, Grouping or Totalling Result Members
      • Sorting Results by Data Not Included as a Result Member
      • Defining an Aggregate Function
      • Creating a Pivot Extract (Display Types)
      • Deleting Result Members
    • Running a BI Query
    • AudienceView Charting
      • Creating an AudienceView Chart
      • Example Chart BIs
      • Modifying the Chart Output
      • AudienceView Charting Options
      • Working with AudienceView Charts
      • Saving an AudienceView Chart
      • Printing an AudienceView Chart
      • Emailing an AudienceView Chart
    • Saving a BI Query
    • Saving a BI Query to a Folder (Custom Searches)
    • Scheduling a BI Query
      • Configuration of the Business Intelligence Scheduler
      • Scheduling Business Intelligence Queries
      • Defining the Number of Concurrently Scheduled Queries
    • Creating a Customer Correspondence Extract (Prior to AudienceView 6.8.10)
    • Joining BI Queries
    • Copying a Saved Query
    • Deleting a Saved Query
• Business Intelligence and Reports - Saved Business Intelligence
  • Business Intelligence and Reports - Saved Business Intelligence Pages
    • Business Intelligence and Reports - Saved Business Intelligence|Saved Queries Page
    • Business Intelligence and Reports - Saved Business Intelligence|Parameters Page
    • Business Intelligence and Reports - Saved Business Intelligence|Preview Page
  • Running a Saved BI Query

AudienceView Business Intelligence enables you to create queries to extract data specific to your needs from your database relating to customers, orders, admissions, notes and more.

The data extracted using BI queries can be presented in various ways such as PDF, HTML and CSV/Excel, and can be viewed on-screen, saved and/or printed.

The following sections describe how to work with business intelligence:

• Masking Payment Methods
• Creating a BI Query
• Working with BI Criteria
  • Searching for BI Criteria
  • Adding Criteria to a BI Query
  • Example - Customer Query
  • Using Relative Dates and Times with a BI Query
  • Deleting BI Criteria
• Working with BI Filters
  • Adding a Filter to a BI Query
  • Searching for a BI Filter
  • Example Session Filter – Filtering Customers By Create User
    Describes how to filter a BI query by the customers accounts created by a user.
  • Example Filter – Filtering Performances By Venue and Date Range
    Describes how to filter a BI query by performances by venue and date range.
  • Deleting a BI Filter
• Working with BI Formulas
  • Creating a BI Formula
  • Modifying a BI Formula
  • Deleting a BI Formula
• Working with Result Members
  • Adding New Result Members to a BI Query
  • Sorting, Grouping or Totalling Result Members
  • Sorting Results by Data Not Included as a Result Member
  • Defining an Aggregate Function
  • Creating a Pivot Extract (Display Types)
    • Example Pivot Extract – Customers with Same Last Name in Same City
      Describes how to create a BI query that searches customers with the same last name in the same city.
    • Example Pivot Extract – Sales by Postal Code
      Describes how to create a BI query that searches for sales by postal code.
  • Deleting Result Members
• Running a BI Query
• AudienceView Charting
  • Creating an AudienceView Chart
  • Example Chart BIs
  • Modifying the Chart Output
  • AudienceView Charting Options
  • Working with AudienceView Charts
  • Printing an AudienceView Chart
  • Emailing AudienceView Chart
• Saving a BI Query
• Saving a BI Query to a Folder (Custom Searches)
• Scheduling a BI Query
  • Configuration of the Business Intelligence Scheduler
  • Scheduling Business Intelligence Queries
  • Defining the Number of Concurrently Scheduled Queries
• Creating a Customer Correspondence Extract (Prior to AudienceView 6.8.10)
• Joining BI Queries
• Copying a Saved Query
• Deleting a Saved Query