MhetaData Database Artistry logo Call a database artist 800-625-0369

Casino Direct Mail Marketing: Triggered Programs from Welcome to Win-Back

Casino marketing departments already know their players better than almost any other mailer. Every card-in session, every visit and every offer redeemed is in the player tracking system. The gap is usually in turning that data into mail fast enough to matter. Triggered programs close the gap by mailing each player when something changes, instead of waiting for the monthly core mailer.

Where the data comes from

Most casinos run a player tracking system from a vendor such as IGT or Aristocrat, or a similar platform. These systems hold player profiles, visits, play history, tier status and offer redemptions. They are built to run the floor, so marketing usually works from scheduled exports or a reporting database.

The practical setup is a SQL Server database that loads those exports every night. From there, stored procedures compute the things marketing cares about: days since last visit, trips in the last 90 days, average worth per trip, tier, birthday month and offer history. Each program is then a query against that table.

Keep raw exports separate from the cleaned tables. Vendors change export layouts during upgrades, and you want a load step that fails loudly instead of quietly mailing the wrong people.

The core programs

Program Trigger Goal
New member welcome Card signup Bring the player back for a second visit
Active player Recent visits above a threshold Keep frequency and reward value
Decliner Visits or worth dropping against their own history Catch the slide early
Pre-inactive Approaching your inactive cutoff Last nudge before they go quiet
Inactive win-back Past the inactive cutoff Reactivate lapsed players
Birthday Birthday month or week Personal reason to visit

New member welcome

A player who signs up and never returns is the most common loss in the database. A welcome piece mailed within days of signup, with a modest offer that expires soon, gives them a reason to make the second trip. Some properties send a second piece if the first offer goes unredeemed.

Active player

Active players are already coming in. The mail here rewards them and keeps them on schedule. Offers should match their worth so you are not giving away margin to players who would visit anyway.

Decliners

A decliner is a player whose visits or play are falling compared to their own past behavior. This is the program that most often gets skipped, because it takes real database work to measure each player against their own baseline. It is also the one that catches players before they leave.

Pre-inactive and inactive win-back

Pick an inactive cutoff that fits your market, such as a set number of days since last visit. Pre-inactive mail goes out shortly before a player reaches it. Win-back mail goes out after. Win-back offers usually need to be stronger, and the list should be trimmed hard with NCOA and CASS, because lapsed players move more often than active ones.

Birthdays

Birthday mail is simple to set up and personal by nature. Mail early enough that the piece lands before the date, and make the offer valid for the whole month so the player has room to plan a trip.

Offer logic

Offers should come from the data, not a flat grid. Common inputs include tier, average worth per trip, trip frequency, distance from the property and redemption history. Write the rules once as a stored procedure, so every program uses the same math and finance can review it in one place.

Version the offers in the print file, not in separate jobs. A VDP engine can pick the right offer text, value and barcode per record, so one merge produces every tier and version in presort order. That is the core of SQL-to-press automation.

Frequency caps and suppression

Triggered programs overlap. A player can be a birthday, a decliner and an active player in the same week. Without rules, they get three pieces and three offers.

  • Set a frequency cap per player, such as one triggered piece per set number of days.
  • Set a priority order so the most valuable program wins when two fire together.
  • Suppress current offer holders who still have an unexpired offer in hand.
  • Honor exclusions including self-excluded players, banned players and do-not-mail requests, applied to every program.

Write each of these as a join against a suppression or mail history table. Nobody should have to remember them.

Drive-time maps

A map on the mailer showing the drive from the player's home to the property is a strong personal touch, especially for win-back and out-of-market players. The map is generated per record from the player's address, so each piece shows their own route and drive time. See variable images for how these are produced and merged.

Tracking redemption

Every offer should carry a unique code, printed as a barcode the players club can scan. When the code is redeemed, the system records it against the player and the program. Load redemptions back into the database nightly and you can report response by program, tier, offer and version.

Adding the IMb to the same report shows when each piece was delivered, through Informed Visibility scan data. That lets you measure the time from in-home to visit, and spot programs that are mailing too late. See USPS mail tracking.

Good targeting pays off. Database optimization typically cuts mailing expense 20 to 30 percent and lifts response 20 to 30 percent, mostly by not mailing players who will not respond and spending that budget on those who will.

How MhetaData helps

We have been in casino direct mail for more than 30 years. See our casino direct mail services. We build triggered casino direct mail programs from player tracking exports through SQL Server, VDP output, tracking and redemption reporting. Read the hands-free triggered mail workflow or see our direct mail automation service. Call (800) 625-0369.

More from the notebook

Call (800) 625-0369