DakotaAudience Review
Prepared for the Board of Directors

2023–2025 Report & Analysis

How to read this page: Real calculated from the 2023–2025 Etix, POS and A-Train records (POS only where it matches an Etix table) From Dakota explanation or input needed

Overview & Scorecard

01
Food and drink counts only POS checks with a table number that matches an Etix table at that performance; every other POS check is left out. POS revenue = the sum of those matched checks. Average guest check = that sum ÷ every Etix table sold, including tables with no check. Average POS revenue per performance = POS revenue ÷ performances. Average ticket price uses paid non-member tickets only. Peaks and valleys are picked from the data. Each note compares that month with the same month in the other two years (shows, tables, tickets, prices, sell-out); the reason behind it comes from the Dakota. Formula legend →

Membership Value

02

What members bring in (dues, plus what they pay for tickets and food and drink) against the value of the benefits they receive, per level and overall.

2023–2025 comparison Real

Click a level to open or close it.

Scenario planner

Move the sliders to test a different price or number of members; the totals along the bottom update for all four levels.

Real Each box starts at the actual 2025 figures: members on the roster, free and discounted tickets used, and food and drink spent. Moving a slider holds each level's use per member at its 2025 rate. The sell-out slider starts at the 2025 average and the 10% slider at the share of members who actually bought discounted tickets. Membership prices are the club's current A-Train prices.

A free seat only costs the club when that seat would have sold.
Revenue from members (dues + tickets + F&B), all levels
Benefits given, all levels
Net revenue of dues and benefits given, all levels
Annual totals per member
Names: not loaded
Customer IDLevelDuesTickets & F&B paidTicket benefitF&B benefitNet ▾

Real Every 2025 member. The site stores Customer IDs only. To see names, open the names file (Names.csv, with a Customer ID column and name columns) from your computer: it is read in this browser tab only, never uploaded, and forgotten when the tab closes. Ticket benefit is shown at full seat value (before the sell-out slider).

Benefits are valued using what non-members paid, show by show: Free ticket value = free tickets × average price non-members paid for that same performance × sell-out % Discount value = the 10% taken off each discounted ticket, scaled by the share of members buying at 10% off F&B benefit = members' food and drink at their tables ÷ 9 (POS amounts are already after the 10% discount) Net = (dues + what members paid for tickets and food and drink) − (free ticket value + ticket discount + F&B benefit). Discounts are worked out on the full price: amounts are recorded after the 10%, so the discount is one ninth of what was paid. Formula legend →

Ticket Sales Lead Time

03
Year

How far ahead of each show tickets are bought, members compared with non-members. Not every show is on sale in every window: a show that goes on sale 45 days out cannot sell anything 91+ days out. So each window is measured only across the shows that were on sale during it.

Real Days ahead = performance date − purchase date, per ticket. Days on sale = performance date − Etix On Sale Date (or the first ticket bought, if a presale came earlier or the date is missing). Shows on sale = shows that were on sale at some point in the window. Tickets per show on sale = tickets the group bought in that window ÷ shows on sale in it. Share of tickets = the group's tickets in that window ÷ all of the group's tickets. Members are guests on that year's A-Train roster. Median = the middle purchase when all of a group's tickets are lined up by days ahead. Formula legend →

In-Venue Table Activity

04
Year

By price level Real

Ticket revenue from every ticket sold in each price level, the average non-member paid price per seat, member tickets used (A-Train free plus discounted), what they cost the club at the sell-out % chosen in Membership Value, and tables sold.

Table reading by price level Real

Food and drink (POS) per table and per guest, the share of available tables holding member free tickets (the small number is the count of those tables), and what members spend. Tables available = tables in each price level on the Tier 3 seating chart (67 in Price Level 1, 54 in Level 2, 27 in Level 3; Smart Seats counted in the level they sell at) × performances in the year. Shows priced with fewer levels sell more tables at Level 1, so this is a guide rather than an exact count.

Average member POS per performance Real

Average food and drink on a member's table at one performance, by membership level and price level. The small number is how many member tables it is based on.

Price-level rows come from Etix Price Level, which is set show by show, so a table can be in a different price level at different shows. Free vs discounted comes from the A-Train price codes. A table = one table at one performance. Avg POS per table = food and drink matched to show tables ÷ every Etix table sold (tables with no check count as $0). Avg POS per guest = the same food and drink ÷ seats at those tables. Member tables are tables bought by someone on that year's A-Train roster. Formula legend →

Activity by Genre

05
Year
Real Genre = Etix Subcategory. POS revenue and average check per table come from POS checks matched to each show's tables (same date and table, within 2 hours of show time). Click a column heading to sort.