Skip to main content

Loyalty Data in Insights

How loyalty program, level and VIP status data appears in Insights, how current it is, how to read bookings with more than one program, and how to analyze an individual program accurately.

Written by Ashley Dehertogh

Loyalty data in Insights lets you see how guests who belong to loyalty programs, or who carry a VIP status in your PMS, contribute to your units, revenue and ADR, and how their bookings differ from the rest. Insights reads each reservation's loyalty program, level and VIP status from your PMS and adds them as fields you can break down and filter by, in the same way you already use Segment or Channel. This article explains the fields, how current the data is, how to read a booking that carries more than one program, and how to look at an individual program accurately.

In this article:

  • What you can do with loyalty data

  • The loyalty and VIP fields

  • How current the data is, and what it covers

  • Reservations with more than one program

  • What the combined value gives you

  • Looking at an individual program

  • If you want each program on its own line

  • If a program shouldn't be there, or is missing

  • Common questions

  • Good to know

What you can do with loyalty data

  • Compare bookings with and without a loyalty program. See whether loyalty bookings differ in lead time, length of stay, cancellations or revenue.

  • See which programs and tiers bring the most production. Look at units, revenue and ADR by program and by tier.

  • Watch the mix change. Follow how the share of each program and tier in your production moves over time.

  • Focus on VIP guests. Look at the production from bookings that carry a VIP status.

  • Check which channels loyalty bookings come through. See whether bookings with a loyalty program come through direct channels or other channels.

The loyalty and VIP fields

Insights shows five fields, each taken from the reservation in your PMS.

Field

What it shows

Loyalty Program

The loyalty program or membership type attached to the reservation. It shows every program, separated by commas, when more than one is attached.

Loyalty Program Code

The code your PMS holds for that program.

Loyalty Level

The loyalty level attached to the reservation, when your PMS holds it separately from the program.

Loyalty Level Code

The code your PMS holds for that level.

VIP Status

The VIP status your PMS holds for the guest on the reservation. It is a single value for each reservation.

Insights shows these values as your PMS holds them. It doesn't rename, convert or compare programs, levels or VIP statuses, so your own program and VIP names appear as you know them.

Tiers inside a program name. Some PMS setups record the tier as part of the program name, such as FLYR Rewards - Platinum, and leave the separate level field empty. In that case Loyalty Program carries the tier and Loyalty Level stays empty, which is how the PMS holds the data.

How current the data is, and what it covers

  • Latest values. Insights shows the latest loyalty program, level and VIP values your PMS has sent for each reservation. If your PMS later sends different values for the same reservation, the new values replace the earlier ones.

  • No history. Insights doesn't keep a history of loyalty or VIP changes. A report groups bookings by their latest values, so it doesn't show the tier or VIP status a guest had when they booked or when they stayed.

  • When values are captured. Loyalty values have been collected on a rolling basis across PMS integrations since mid-September 2026. From then, they are captured when a reservation is created, and when an existing reservation, future or past, is updated or canceled.

  • Reservations that aren't updated. A reservation that hasn't received an update since then continues to reflect the information already received.

  • Supported PMSs. The following PMSs aren't supported: Cloudbeds, Apaleo and Opera On-Prem (OXI). Reservations from those PMSs have no loyalty values.

  • Changes in your PMS. If the loyalty or VIP information in your PMS changes, new reservations and reservations updated after the change carry the revised values into Insights.

Reservations with more than one program

Your PMS can attach more than one loyalty program to a booking. When it does, Insights keeps the booking on a single row and shows every program in the same field as one combined value, for example FLYR Rewards - Platinum, FLYR Partner Card.

  • A reservation with one program shows that program.

  • A reservation with two or more programs shows all of them in the same field, separated by a comma and a space.

  • A reservation with no program attached has no loyalty value.

Insights shows exactly what your PMS has attached to the reservation. It doesn't add, infer or remove anything. The same applies to level fields. VIP Status is always a single value, so it isn't combined.

A breakdown by Loyalty Program for Flagship Berlin by Flyr might look like this. Bookings with no program attached appear as a blank value, and the table shows only the bookings that carry at least one program. The figures are illustrative.

Loyalty Program value

Units

Revenue

FLYR Rewards - Platinum

120

€48,000

FLYR Rewards - Platinum, FLYR Partner Card

85

€34,500

FLYR Rewards+

40

€12,800

FLYR Partner Card

25

€7,500

Total unique production

270

€102,800

What the combined value gives you

A booking has one set of units and one amount of revenue. Your PMS tells Insights which programs are attached to it, but not how much of the booking belongs to each program, because there is no such split. A reservation carrying both FLYR Rewards - Platinum and FLYR Partner Card is one booking, not two. Keeping every program on that booking's single row means:

  • Correct totals everywhere. Each booking is counted once in every report, including reports that don't use a loyalty field at all, such as production by stay date.

  • Totals that match your PMS. Add up every row in a Loyalty Program breakdown, including the blank row for bookings with no program, and you get your true total.

  • Overlap you can see. Each combination has its own row, so you can see which programs occur together and how much production sits in bookings that carry more than one.

  • Rows that stand alone. Each row is its own set of bookings, with no overlap between rows, the same way Segment and Channel rows read.

  • Nothing inferred. The values are what your PMS holds for the reservation, no more and no less.

Looking at an individual program

The breakdown by Loyalty Program above is the starting point. Each exact combination is its own row, and each row is its own set of bookings, so the rows add up to your total. The examples use the figures from that table.

  • A row with one program name is production from bookings that carry only that program: 25 units for FLYR Partner Card, for example.

  • A row with two names is production from bookings that carry both: 85 units for FLYR Rewards - Platinum, FLYR Partner Card. This is also how you see how many bookings two programs share.

  • Everything for one program means the bookings that carry it alone plus the bookings that carry it with others. For FLYR Partner Card that is 110 units and €42,000: the 25 units where it appears alone plus the 85 units where it appears with FLYR Rewards - Platinum. You can ask Chat for this, one program at a time, for example "units and revenue for bookings that include FLYR Partner Card".

A few habits make these results easier to trust:

  • Compare programs side by side, and don't add them together. Bookings that carry both programs appear in both results.

  • Use the full program name. A name such as FLYR Rewards is also part of FLYR Rewards+ and every tier, so use the full name when you want one tier.

  • Prefer names to codes. Short codes are easier to match by accident, and some PMS setups share one code across different programs.

  • Label individual-program numbers clearly. Call a result "bookings including FLYR Partner Card" so nobody reads it as a share of a total.

If you want each program on its own line

Seeing each program on its own line is a natural thing to want, and asking about one program at a time gives accurate numbers for that program. The approaches in this section look as though they would give you every program on its own line at once, but they produce inaccurate numbers, so it helps to know why.

A booking that carries two programs belongs to both of them. Any method that gives each program its own line has to either leave the booking on one line only, which understates the other program, or put it on both lines, which counts the booking twice. Your PMS doesn't divide a booking between programs, so there is no accurate third option.

Custom groups and overlapping programs

A custom group puts each booking into one group only, and it works down your list of rules in order. The first rule that matches takes the booking, and no later rule ever sees it. We suggest avoiding custom groups for loyalty programs, because the result is wrong in a way that is hard to spot.

Suppose you build groups in this order: bookings that include FLYR Rewards - Platinum, then FLYR Partner Card, then FLYR Rewards+.

Group

Units shown

Revenue shown

Units that actually carry the program

Revenue that actually carries the program

FLYR Rewards - Platinum

205

€82,500

205

€82,500

FLYR Partner Card

25

€7,500

110

€42,000

FLYR Rewards+

40

€12,800

40

€12,800

Total

270

€102,800

The groups add up to your true total, so the table looks complete. But the 85 bookings carrying both Platinum and Partner Card were all given to the Platinum group, so Partner Card is understated by 85 units and €34,500. Reverse the order and the error moves to Platinum. The first group in the list is always right, and each later group is understated by whatever it shares with the groups above it.

This applies whether you build the groups yourself or ask for them in Chat. You may see an option to create custom groups in some views. For loyalty programs, asking about one program at a time gives accurate results.

Adding up individual-program results

A result for the bookings that include one program is correct for that program. Run it for each program and you get:

Program

Units

Revenue

FLYR Rewards - Platinum

205

€82,500

FLYR Partner Card

110

€42,000

FLYR Rewards+

40

€12,800

Added together

355

€137,300

Each row is right on its own. The sum is not, because the 85 bookings carrying both programs appear in the first two rows, so 355 units are reported against 270 unique units. The same thing happens if you export the data and split the combined value into separate rows in a spreadsheet or another tool.

Excluding a program to hide it

Excluding bookings that contain a program removes the whole booking, including any other program it carries. Excluding FLYR Partner Card would also remove the 85 Platinum bookings that carry it. If a program shouldn't be in your loyalty reporting, see "If a program shouldn't be there, or is missing" below.

Why there isn't a separate field for each program

A field that gave each program its own line would have to repeat every booking that carries several programs, so any total built from it would stop matching your real production. Placed next to the combined value, that field would also make it easy to use the wrong one without noticing. Insights uses the combined value so that the figure you see is the figure that's true.

If a program shouldn't be there, or is missing

Insights mirrors what is attached to each reservation in your PMS, so your numbers always match it. If a program appears that you don't consider a loyalty program, for example a card or ID type that has been set up as a membership, the place to change it is your PMS.

Speak to whoever configures membership and loyalty fields for your property in your PMS. Once the value is no longer attached in the supported membership fields, it stops appearing on reservations created or updated after the change. Reservations that aren't updated keep the values already received.

The same applies when a program you expected is missing. If it isn't attached to the reservation in the PMS membership fields, Insights has nothing to show for it.

Common questions

How do I see revenue for one loyalty program? Ask Chat for the units and revenue of bookings that include the program. The result includes every booking carrying that program, alone or with others. See "Looking at an individual program" above.

Why does one booking show two programs? Your PMS has both programs attached to that reservation. Insights shows both on the booking's single row so that its units and revenue are counted once.

Why does a booking show a different tier or VIP status than when the guest booked? Insights shows the latest values your PMS has sent for each reservation, and replaces earlier values when the PMS sends new ones. It doesn't keep a history of earlier tiers or VIP statuses.

Why do my individual-program numbers add up to more than my total? Bookings that carry several programs are counted under each of them. Nothing is wrong with your data. Use the total from the Loyalty Program breakdown for any overall figure, and treat each individual-program result as its own answer.

My groups add up to my total. Does that mean they're right? Not necessarily. Adding up to the total only shows that no booking was dropped. The split between programs can still be wrong, as in the custom groups example above. Ask Chat for the same program on its own and compare. If a group is lower than that result, the group is understated.

Why can't I see any loyalty data? Insights can only show the loyalty information your PMS sends it. The following PMSs aren't supported: Cloudbeds, Apaleo and Opera On-Prem (OXI). Otherwise, a reservation carries loyalty values once it has been created or updated since collection began for your PMS, and a booking with no program attached in your PMS has no loyalty value.

Why don't my loyalty numbers match my PMS loyalty report? Insights uses the programs attached to each reservation, and the latest values your PMS has sent for it. PMS loyalty reports are often built from the memberships on the guest profile, which can include programs that weren't applied to the booking, so the two can differ.

Good to know

  • Results for different individual programs overlap, so compare them and don't add them together.

  • VIP Status is a single value for each reservation, so it doesn't overlap or combine the way programs can.

Did this answer your question?