This page presents the full list of sheets available in Data AnalyTix. Depending on the activated verticals, only a sub-set of sheets may be available. The sheets of the GENERAL section are available in all verticals.

Latest revenue distribution [G]

Latest revenue distributed per product family, sales channel and product.

Package Sales [G]

Number of packages sold and revenue from packages distributed either over the following dimension, split by package:

• Purchase date

• Purchase month

• Purchase year

• Season

Distribution of the products sold within a package.

Membership Sales [G]

Total number of memberships sold and revenue from memberships.

Percentage of number of memberships and percentage of revenue from memberships per membership.

Number of memberships sold and revenue from memberships distributed either over the following dimension, split by membership:

• Purchase date

• Purchase year

• Purchase month

• Purchase day of the week

Service Sales [G]

Total number of services sold and revenue from services.

Percentage of number of services and percentage of revenue from services per service.

Number of services sold and revenue from services distributed either over the following dimension, split by service:

• Purchase date

• Purchase year

• Purchase month

• Purchase day of the week

Voucher Sales [G]

Total number of vouchers sold and revenue from vouchers.

Percentage of number of vouchers and percentage of revenue from vouchers per voucher.

Number of vouchers sold and revenue from vouchers distributed either over the following dimension, split by voucher:

• Purchase date

• Purchase year

• Purchase month

• Purchase day of the week

Donation Sales [G]

Total number of donations sold and revenue from donations.

Percentage of number of donations and percentage of revenue from donations per donation.

Number of donations sold and revenue from donations distributed either over the following dimension, split by donation:

• Purchase date

• Purchase year

• Purchase month

• Purchase day of the week

Goods Sales [G]

Total number of goods sold and revenue from goods.

Percentage of number of goods and percentage of revenue from goods per good.

Number of goods sold and revenue from goods distributed either over the following dimension, split by good:

• Purchase date

• Purchase year

• Purchase month

• Purchase day of the week

Open Product Sales [G]

Total number of open products sold and revenue from open products.

Percentage of number of open products and percentage of revenue from open products per open product.

Number of open products sold and revenue from open products distributed either over the following dimension, split by open product:

• Purchase date

• Purchase year

• Purchase month

• Purchase day of the week

Revenue utilization per product [G]

Scatter plot of the revenue and target revenue of each product.

Note: target revenues can be defined in the catalogue module of SecuTix, see here for more details.

Contact filters [G]

Number of filtered purchasers and total contacts, which also includes contacts with cancellations.

This advanced contact filtering sheet allows you to achieve more complex filtering cases.

For example, if we take the following sets of customers:

• Swiss customers

• Millen

• Customers having purchased this year

It possible to find the Swiss customers, excluding the millennials and also excluding those having purchased this year, i.e., A - (B U C), which is different than the Swiss customers, excluding the millennials having purchased this year, i.e., A - (B ∩ C).

Contact list [G]

List of contacts including the following information:

• Contact number

• Last name

• First name

• Structure name

• City (of residence)

• Postal code

• Postal address

• Email address

• Total revenue

• Ticket sold (Museum)

• Ticket sold (Live Entertainment)

• Attendance of performances

• Overdue (estimated), i.e., attendance overdue in days

• Last attendance

• Next anticipated attendance

• Interval since last attendance

• Attendance frequency

Catchment area [G]

Geographical map view of the number of contacts per postal code.

Contact purchase details [G]

Detailed view for a single contact.

Geoanalysis [G]

Geographical map view of the following

• Number of contacts

• Revenue

• Number of tickets sold

• Number of matches

Season ticket transition flow [G]

Season ticket transition flow between seasons split between cultural contacts having:

• purchased a season ticket that season

• purchased a single entry but no season tickets that season

• not purchased anything at all that season

Flow

Note: Not available in the Museums vertical

Upcoming performances KPI [LE]

Key Performance Indicators (KPI) for the upcoming performances, i.e., based on the performance date:

• Number of performances

• Total capacity

• Number of tickets sold

• Number of reservations

• Total revenue

• Revenue per ticket

• Average discount per ticket

Pivot table with the additional measures:

• Total tickets (sold + reserved)

• Attendance percentage

• Maximum revenue

• Revenue per seat

Latest sales KPI [LE]

KPI for the latest matches (based on performance date) and sales (based on sales date), compared with the previous period:

Latest performances [LE]

Ticket and revenue charts for the latest performances with respect to the full quota and target revenue respectively.

Pivot table by performance date, performance start time, performance and seat category, for the following measures:

• Seating capacity

• Number of sold tickets

• Capacity utilization

• Maximum revenue

• Target revenue

• Revenue

• Revenue per seat

• Revenue per ticket

• Discount per ticket

Latest events [LE]

Ticket and revenue charts for the latest events with respect to the full quota and target revenue respectively.

Pivot table by event for the following measures:

• Number of performances

• Seating capacity

• Number of sold tickets

• Capacity utilization

• Maximum revenue

• Target revenue

• Revenue

• Financial utilization

• Revenue per seat

• Revenue per ticket

• Discount per ticket

• Number of sold tickets per performance

• Revenue per performance

Event  KPI [LE]

KPI for an ongoing event, with a split on past and forthcoming performances:

• Number of performances

• Seating capacity

• Number of sold tickets

• Turnover

• Turnover per ticket

• Discount per ticket

and a view on the sales to date for the entire competition:

• Number of sold tickets per performance

• Revenue per performance

• Capacity utilization

• Financial utilization

• Revenue per seat

Note: Best for a selected competition.

Event weekday/month distribution [LE]

Number of performances, sold tickets/available seats and revenue/target revenue charts distributed over:

• days of the week

• months

Event utilization [LE]

Scatter plot of performances and events for the following sets of dimensions:

• number of sold tickets versus seating capacity

• revenue and target revenue

Note: target revenues can be defined in the catalogue module of SecuTix, see here for more details.

Latest sales per audience category [LE]

Latest ticket sales and revenue per sales date, split by audience category.

Pivot table by purchase month, purchase date, performance and audience category for the following measures:

• Number of sold tickets (including cancellations)

• Number of cancellations

• Number of sold tickets

• Revenue

• Revenue per ticket

• Discount per ticket

Latest sales per performance [LE]

Sold tickets/available seats and revenue/target revenue per match, split between latest sales and prior sales.

Pivot table by performance date, performance start time, match, seat category and contingent for the following measures:

• Number of sold tickets (including cancellations)

• Number of cancellations

• Number of sold tickets

• Revenue

• Revenue per ticket

• Discount per ticket

Calendar view [LE]

Performance date and purchase date calendar view, with coloring sliders, for the following dimensions:

• Number of performances

• Number of sold tickets

• Revenue

• Capacity utilization

• Financial utilization

• Revenue per seat

Year/season comparison [LE]

Sold tickets and revenue monthly comparison over two seasons or years, including cumulative numbers.

Pivot table by month of the performance, event, sub-theme and venue for the following measures of each selected periods and the differences:

• Number of performances

• Number of sold tickets

• Capacity utilization

• Revenue

Utilization per month [LE]

Sold tickets and revenue monthly comparison with respect to the full quota and target revenue respectively.

Pivot table by month of the match, event, sub-theme and venue for the following measures:

• Number of sold tickets

• Seating capacity

• Difference between the seating capacity and the number of sold tickets

• Capacity utilization

• Revenue

• Target revenue

• Difference between the adjusted target revenue and the revenue

• Financial utilization

• Maximum revenue

Seat cat./contingent utilization matrix [LE]

Pivot table by event and performance date for the following measures, split over seat category and contingent:

Sales potential per performance/seat cat. [LE]

Sold tickets and revenue distributed per performance and per seat category and performance, split by:

• Full price

• Reduced

• Complementary tickets

• Reservations

• Remaining seats

• Potential revenue

Reservations and remaining seats allow working on optimizing potential sales.

Configuration seat map [LE]

Seat map view of the configuration for a given performance, color coded by either:

• Sectors (area)

• Seat categories

• Contingents

Sales timeline seat map [LE]

Seat map view of the sales status for a given performance and at a given point in time, color coded by:

• Type of tickets

  • Full price

  • Season tickets

  • Reduced

  • Complementary tickets

  • Reserved

  • Packages

  • Remaining seats

Venue utilization [LE]

Map view of a venue color coded by:

• Utilization: how often a seat is sold

• Revenue: how much revenue a seat generates

• Hot seats: how early a seat is sold

Seasonal utilization [LE]

Performance capacity and financial utilization distributed either per:

• Season

• Year

• Month

• Week

• Day

• Weeks after premier

Event life cycle [LE]

Comparison of events by performance number with respect to either:

• Number of sold tickets

• Sales date relative to performance date

• Revenue

• Revenue per seat

• Capacity utilization

• Financial utilization

• Discount per ticket

After event premiere [LE]

Comparison of events by days after the premier with respect to either:

• Number of sold tickets

• Sales date relative to performance date

• Revenue

• Revenue per seat

• Discount per ticket

Sales period [LE]

Sold tickets and revenue by either:

• Day

• Week

• Month

• Season

• Year

Sales categorization relative to performance date [LE]

Sold tickets and revenue, totals and per performance, comparison in days before the performance, split by:

• Seat category

• Sales channel

• Audience category

• Ticket type (tariff)

Sales comparison relative to performance date [LE]

Sold tickets and revenue, absolute and per performance, comparison in days before the performance, split by:

• Day of the week of the performance

• Event

• Sub-theme

• Venue

• Month of performance

• Year of performance

• Season

• Performance

• Activity

Sales cross-distribution [LE]

Sold tickets and revenue:

Pivot table for the selected dimension and the following measures:

• Number of sold tickets

• Revenue

• Discount per ticket

• Revenue per ticket

• Percentage of total tickets of the selected dimension

• Percentage of revenue of the selected dimension

• Percentage of total tickets

• Percentage of revenue

Season ticket sales [LE]

Season ticket sales, sold tickets within a season ticket and revenue distributed per:

• season

Pivot table by season and season ticket for the following measures:

• Number of season tickets

• Number of tickets sold within a season ticket

• Average number of tickets sold per season ticket

• Revenue

• Revenue per season ticket

Season ticket sales per event/performance [LE]

Season ticket sales and revenue distributed per:

• event

• performance.

Pivot table by season, season ticket and seat category for the following measures: