Analytics Now! – Typical Restaurant Loyalty Data Analysis Requests

I’ve run into quite a few restaurant companies with loyalty programs that need periodic data analysis help and don’t have an internal data team, or their team doesn’t have the cycles to handle all the ad hoc requests that come up. These are companies on the Paytronix platform, and because I’ve worked on the Paytronix platform for nine years with about a dozen companies, they call me. I offer modest retainer relationships that make it easy for clients to get things done quickly with someone who knows loyalty, is a seasoned analyst, knows the data and how the system works. They can just shoot an email or pick up the phone to get things done.

A SAMPLE OF TYPICAL REQUESTS

  • Segmentation of program members based on visit frequency with average visits, average check.
  • Retention of existing members from period to period (3-month period, 6-month period, 12-month period). How many that were active in both periods spent, more, less, or about the same?
  • Response to a specific offer, spending during a prior period and post period to identify lift.
  • Segmentation by store (identifying similarities and differences from store to store).
  • Performance of members by tier (for programs with tiers).
  • Members visiting specific stores on specific dates during specific times (typically for tracking attendance at certain event or during certain sporting events).
  • Cohort analysis: follow a group of members who joined in a given month to determine how many have one visit and don’t return. Create segmentation for those with more than one visit.
  • Create a segmentation by daypart. Who are the lunch-only members, versus dinner-only members, versus both?
  • Create weekday versus weekend segmentation.
  • Segmentation of members by net value: how much do they contribute (spend) versus cost (reward redemption).
  • Purchasing by item/plu – where check details are available.
  • Loyalty penetration overall and by store.