Data Lab
Casino analytics demos with live CSV import.
A hands-on analyst dashboard for casino offer exports and weather-driven player traffic modeling. Download templates, fill required fields, import CSV files, and watch the metrics, histograms, and tables update.
Casino Offer Export Model
Live offer export analyzer
Download the template, fill out the highlighted required columns, import the CSV, and the table plus histogram update live.
Using demo data. Download the template, fill it out, then import it here.
Required Import Columns
Casino offer import
PlayerIDTierRankActiveInactiveTripsMonthDaysSinceLastTripNetADTSegmentNameOfferFSPOfferTGOfferHotelOfferFoodOfferGiftMailableFlagAppEligibleFlagValidationStatus
Histogram
Net ADT distribution
Player value after adjustments.
Avg
$296
Min
$88
Median
$218
Max
$690
Total
$1,775
3
$88–$188
1
$188–$289
0
$289–$389
1
$389–$489
0
$489–$590
1
$590–$690
Rows
6
Passed
3
Review
2
Failed
1
Total FSP
$525
Total Food
$195
Redeemed Value
$670
App Eligible
4
Detail Block
Imported table and export schema
| PlayerIDRequired | TierRankRequired | ActiveInactiveRequired | TripsMonthRequired | DaysSinceLastTripRequired | NetADTRequired | SegmentNameRequired | OfferFSPRequired | OfferTGRequired | OfferHotelRequired | HotelNights | HotelRoomType | OfferFoodRequired | OfferGiftRequired | MailableFlagRequired | AppEligibleFlagRequired | ValidationStatusRequired | ValidationNotes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| P100284 | Platinum | Active | 9 | 3 | 412 | Core Active | 125 | 70 | 2DLX | 2 | Deluxe | 45 | Premium Tumbler | Y | Y | Pass | Eligible and complete. |
| P100918 | Gold | Active | 5 | 9 | 248 | Mid Active | 75 | 35 | 1DLX | 1 | Deluxe | 30 | Kitchen Set | Y | Y | Pass | Eligible and complete. |
| P101337 | Diamond | Active | 12 | 1 | 690 | VIP Active | 250 | 175 | 2MS | 2 | Master Suite | 75 | VIP Gift | Y | Y | Pass | Hosted VIP. Offer package complete. |
| P102014 | Silver | Inactive | 0 | 112 | 88 | Reactivation | 25 | 35 | NONE | 0 | No hotel offer | 15 | Comeback Gift | Y | Y | Review | Email suppressed. Mail/app only. |
| P102880 | Gold | Active | 4 | 6 | 188 | Mid Active | 50 | 35 | NONE | 0 | No hotel offer | 30 | Mystery Gift | Y | N | Review | Missing UniversalID. Review before app import. |
| P103552 | Gold | Active | 3 | 13 | 149 | Suppressed | 0 | 0 | NONE | 0 | No hotel offer | 0 | — | N | N | Fail | Excluded due to suppression and bad address. |
Identity
PlayerIDUniversalIDFirstNameLastNameTierRankPlayerStatusActiveInactiveHostName
Player Value
TotalTripsTripsMonthTripsLast3MonthsTripsLast6MonthsLastTripDateDaysSinceLastTripCoinInTheoWinActualWinNetWinLossADTNetADTMonthlyTheoMonthlyActual
Eligibility
SegmentNameOfferGroupWorthGroupVIPFlagNewMemberFlagBirthdayMonthMailableFlagEmailableFlagAppEligibleFlagDoNotMailDoNotEmailBadAddressFlagExcludedFlag
Offers
OfferFSPOfferTGOfferHotelOfferHotelCodeOfferFoodOfferGiftOfferBonusEntriesBirthdayOffer
Valid Dates
FSPValidStartFSPValidEndTGValidStartTGValidEndHotelValidStartHotelValidEndFoodValidStartFoodValidEndGiftValidStartGiftValidEnd
Redemption
RedeemedFSPRedeemedTGRedeemedHotelRedeemedFoodRedeemedGiftTotalRedeemedValueRedemptionCountFirstRedeemDateLastRedeemDateOfferCostPostOfferTripsPostOfferTheoPostOfferActual
Audit
CampaignIDCampaignNameExportMonthExportDateSourceSystemSourceFileScriptVersionValidationStatusValidationNotesDuplicateFlagMissingIDFlagMissingOfferFlag