Data Tool
Upload the file Dakota_Prep_Upload saves (it ends in _UPLOAD.xlsx), check it, and see how the period compares with the same weeks of earlier years. New here? Start with the step-by-step tutorial.
1 Upload and check
Only the _UPLOAD file. It has no names, emails, street addresses or phone numbers.Upload history
No data stored yet
Upload your first _UPLOAD file above. To set up the history, upload the 2023, 2024 and 2025 files once (one at a time); every later upload is compared with them.
2 Snapshot: this period vs history
Revenue by night ⓘ
Blue line = this period. Grey = the comparison year(s) on the same weekday-aligned night (a shaded band from lowest to highest when there are several years).
Average night by weekday
Best and worst nights ⓘ
Type a reason (weather, holiday, private event). Notes are saved and carry into the Board Report's peaks-and-valleys labels.
3 Shows, genres and pricing
Show by show
Genres ⓘ
4 Members and guests
Customer IDs only. The dollar value of membership, with sliders, is on the Board Report.A-Train members
Gone quiet: members with no purchase in 90+ days
Guests
Retention: this period vs history
Guest List (Customer ID 500) by show
5 Food and beverage (POS)
POS by half hour, per night open ⓘ
POS not counted ⓘ
Checks with no matching Etix table at that show. They are left out of every POS figure on this site.
Seated but no POS ⓘ
Average check by table ⓘ
Darker = higher average check. Hover or tap a table for its numbers.