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.
[G]
Latest revenue distributed per product family, sales channel and product.
[G]
Number of packages sold and revenue from packages distributed either over the following dimension, split by package:
Distribution of the products sold within a package.
[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:
[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:
[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:
[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 th
[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:
[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:
[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.
[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:
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 mA - (B ∩ C).
[G]
List of contacts including the following information:
[G]
Geographical map view of the number of contacts per postal code.
[G]
Detailed view for a single contact.
[G]
Geographical map view of the following dimensions per postal code:
[G]
Season ticket transition flow between seasons split between cultural contacts having:
Flow data table for two seasons.
Note: Not available in the Museums vertical
[LE]
Key Performance Indicators (KPI) for the upcoming performances, i.e., based on the performance date:
Pivot table with the additional measures:
[LE]
KPI for the latest matches (based on performance date) and sales (based on sales date), compared with the previous period:
Past performances | Sales |
---|---|
|
|
[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:
[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:
[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
and a view on the sales to date for the entire competition:
Number of sold tickets per performance
Revenue per performance
Capacity utilization
Revenue per seat
Note: Best for a selected competition.
[LE]
Number of performances, sold tickets/available seats and revenue/target revenue charts distributed over:
days of the week
months
[LE]
Scatter plot of performances and events for the following sets of dimensions:
Note: target revenues can be defined in the catalogue module of SecuTix, see here for more details.
[LE]
Latest ticket sales and re
Pivot table by purchase month, purchase date, performance and audience category for the following measures:
[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:
[LE]
Performance date and purchase date calendar view, with coloring sliders, for the following dimensions:
[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:
[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:
[LE]
Pivot table by event and performance date for the following measures, split over seat category and contingent:
Tickets | Revenue |
---|---|
|
|
[LE]
Sold tickets and revenue distributed per performance and per seat category and performance, split by:
Reservations and remaining seats allow working on optimizing potential sales.
[LE]
Seat map view of the configuration for a given performance, color coded by either:
[LE]
Seat map view of the sales status for a given performance and at a given point in time, color coded by:
[LE]
Map view of a venue color coded by:
[LE]
Performance capacity and financial utilization distributed either per:
[LE]
Comparison of events by performance number with respect to either:
[LE]
Comparison of events by days after the premier with respect to either:
[LE]
Sold tickets and revenue by either:
[LE]
Sold tickets and revenue, totals and per performance, comparison in days before the performance, split by:
[LE]
Sold tickets and revenue, absolute and per performance, comparison in days before the performance, split by:
[LE]
Sold tickets and revenue:
distributed per | and split by |
---|---|
|
|
Pivot table for the selected dimension and the following measures:
[LE]
Season ticket sales, sold tickets within a season ticket and revenue distributed per:
Pivot table by season and season ticket for the following measures:
[LE]
Season ticket sales and revenue distributed per:
Pivot table by season, season ticket and seat category for the following measures:
[LE]
Season ticket sales, sold tickets within a season ticket and revenue distributed per:
Pivot table by season ticket for the following measures:
[LE]
Resales KPI:
Resold tickets, resales revenue, net resale platform revenue and reseller profit distributed per match.
Pivot table by match and seat category the following measures:
[LE]
Customers and total contacts, which also includes contacts with cancellations, distributed per:
[LE]
Customers and total contacts, which also includes contacts with cancellations, distributed per:
[LE]
Number of customers, sold tickets and revenue
distributed per | and split by |
---|---|
|
|
Pivot table for the selected dimensions and the following measures:
[MU]
KPI for the latest attendance (based on visit date) and sales (based on sales date), split by individuals and groups:
[MU]
Latest ticket sales and revenue per sales date.
Pivot table by month and purchase date for the following measures:
[MU]
Monthly sold tickets comparison over the last two seasons or years, including cumulative numbers.
Sold tickets distributed per year, split by:
[MU]
Monthly revenue comparison over the last two seasons or years, including cumulative numbers.
Pivot table by month of purchase for the following measures:
[MU]
Daily attendance split by:
Pivot table for the selected dimension and by year of visit, month of visit and date of visit for the following measures:
[MU]
Attendance distributed per time of the day, day of the week and month of the year, split by:
[MU]
Group attendance:
distributed per | and split by |
---|---|
|
|
[MU]
Individuals attendance:
distributed per | and split by |
---|---|
|
|
[MU]
Pivot table by month of visit for the following measures:
Attendance distributed per year, split by:
Previous versus current year monthly attendance comparison.
[MU]
Attendance distributed per price type, split by:
Attendance pivot table by rate type, split by price type.
[MU]
Attendance distributed per hour of the day, split by individual/group.
Relative attendance distributed per:
[MU]
Ticket scans distributed by gate.
Ticket scans pivot table by year of scan, date of scan and hour of scan.
Gate to gate ticket scan flow chart.
Ticket scans gate to gate pivot table.
[MU]
KPI for the latest group visit ticket sales and revenue:
Relative revenue from groups distributed per:
Pivot table by ticket kind (product family), visit theme/visit space/activity/sub-theme/rate type and visit language, for the following measures:
[MU]
Upcoming group visit ticket sales, split by the following measures, and revenue distributed per visit date:
Pivot table by ticket kind (product family) and visit date for the following measures:
[MU]
KPI for the latest individual visit ticket sales and revenue:
Relative revenue from groups distributed per:
Pivot table by ticket kind (product family), visit theme/visit space/activity/sub-theme/rate type and visit language, for the following measures:
[MU]
Upcoming group visit ticket sales, split by the following measures, and revenue distributed per visit date:
Pivot table by ticket kind (product family) and visit date for the following measures:
[MU]
Attendance and revenue distributed per time of the day.
Pivot table by hour of visit for the attendance and hour of purchase for the revenue.
[MU]
Attendance, sold tickets and revenue both distributed and split by:
Pivot table for the selected dimensions and the following measures:
[MU]
Scatter plot of attendance and revenue for each:
[MU]
Timeslots and groups start-time calendar view per date of visit, month of visit and day of the week of visit, color coded by:
Pivot table for timeslot month, timeslot date and timeslot start time for the following measures:
Pivot table for group date, group arrival time for the following measures:
[MU]
Customers and total contacts, which also includes contacts with cancellations, distributed per:
[MU]
Number of customers, sold tickets and revenue
distributed per | and split by |
---|---|
|
|
Pivot table for the selected dimensions and the following measures:
[SP]
Key Performance Indicators (KPI) for the upcoming matches:
|
|
[SP]
KPI for the latest matches (based on match date) and sales (based on sales date), compared with the previous period:
Past matches | Sales |
---|---|
|
|
[SP]
Sold tickets and revenue charts for the latest matches with respect to the full quota and target revenue.
Pivot table by match date, match start time, match and seat category, for the following measures:
[SP]
Comparing sold tickets or revenue with respect to match date for the following dimensions:
Match
Team 1
Team 2
Seat category
Audience category
Sales channel
Includes team logo display.
[SP]
Ticket and revenue charts for the latest competitions with respect to the full quota and target revenue respectively.
Pivot table by event for the following measures:
[SP]
KPI for an ongoing competition, with a split on past and forthcoming matches:
Number of matches
Seating capacity
Number of sold tickets
Turnover
Turnover per ticket
and a view on the sales to date for the entire competition:
Number of sold tickets per match
Revenue per match
Capacity utilization
Revenue per seat
Note: Best for a selected competition.
[SP]
Number of matches, sold tickets/available seats and revenue/adjusted target revenue charts distributed over:
days of the week
months
[SP]
Latest ticket sales and revenue per sales date, split by audience category.
Pivot table by purchase month, purchase date, match and audience category for the following measures:
[SP]
Sold tickets/available seats and revenue/adjusted target revenue per match, split between latest sales and prior sales.
Pivot table by match date, match start time, match, seat category and contingent for the following measures:
[SP]
Sold tickets and revenue monthly comparison over two seasons or years, including cumulative numbers.
Pivot table by month of the match, competition and site for the following measures of each selected periods and the differences:
[SP]
Sold tickets and revenue monthly comparison with respect to the full quota and target revenue respectively.
Pivot table by month of the match, competition and site for the following measures:
[SP]
Sold tickets and revenue distributed per match and per seat category and match, split by:
Reservations and remaining seats allow working on optimizing p
[SP]
Seat map view of the configuration for a given match color coded by either:
[SP]
Seat map view of the sales status for a given match and at a given point in time, color coded by:
[SP]
Map view of a venue color coded by:
[SP]
Match attendance percentage distributed either per:
[SP]
Comparison of competitions by match number with respect to either:
[SP]
Total sold tickets and revenue by either:
[SP]
Sold tickets and revenue:
distributed per | and split by |
---|---|
|
|
Pivot table for the selected dimension and the following measures:
[SP]
KPI and pivot table for a season ticket:
Note: Best for a selected season ticket.
[SP]
Season ticket sales, sold tickets and revenue distributed per seasons.
Pivot table for the season tickets and the following measures:
[SP]
Season ticket sales, sold tickets and revenue distributed per either:
Pivot table
[SP]
Number of tickets within a season ticket and their revenue utilization, i.e., shows/no-shows, per match.
Number of tickets resold within a season ticket and their resales revenue per match.
[SP]
KPI for resales:
Ticket resales and revenue of resales distributed per match and split between resold and open for resales.
Net resale platform revenue and reseller profit per match.
Pivot table for the matches and seat categories and the following measures:
[SP]
Number of customers, sold tickets and revenue
distributed per | and split by |
---|---|
|
|
Pivot table for the selected dimensions and the following measures:
[SP]
Customer loyalty flow between seasons split between:
Flow data table for two seasons.
[SP]
Seat map view of the access control scans for a given match, color coded by:
[SP]
Seat map view of the access control for a given match and a given point in time, color coded by:
[SP]
Number of access control scans per 10 minute slots, split by either:
Timeline of the access control scans, split over the selected category.
[SP]
Seat map view of the customer knowledge, i.e., how well you know your customers, for a given match, color coded by:
[SP]
Scatter plot of matches and competitions for the following sets of dimensions:
Note: target revenues can be defined in the catalogue module of SecuTix, see here for more details.
[SP]
Pivot table by competition and match date for the following measures, split over seat category and continge
Tickets | Revenue |
---|---|
|
|
[SP]
Match date and purchase date calendar view, with coloring sliders, for the following dimensions:
[SP]
Customers and total contacts, which also includes contacts with cancellations, distributed per:
[SP]
Customers and total contacts, which also includes contacts with cancellations, distributed per: