Loyalty Tier Lifecycle Messaging

A reference design for messaging members as they move between loyalty tiers, from upgrade welcomes to fair, well-timed downgrade warnings.

Type
Illustrative blueprint
Reading time
6 min
Updated
Author
GeekMidst Team
Reviewed by
Site owner
Banner for the GeekMidst illustrative blueprint “Loyalty Tier Lifecycle Messaging”, covering The business problem and The tier lifecycle

This is an illustrative blueprint. It is a reference architecture, not a write-up of a specific client project; outcomes depend on your data and setup.

This is a reference blueprint, not a write-up of a specific client project. It shows how we would design tier-based lifecycle messaging for a loyalty programme, with Marketing Cloud Engagement handling the messaging and a loyalty platform holding the rules.

Diagram showing a loyalty platform's daily extract compared with yesterday's snapshot in Automation Studio, writing tier changes to an entry data extension that feeds upgrade and downgrade journeys
Detect changes before refreshing the snapshot, and stop the automation on a bad import so members never receive false downgrades. View full size

The business problem

Loyalty tiers only change behaviour if members know where they stand. In many programmes the tier logic is sound but the communication is not: upgrades are announced weeks late in a monthly newsletter, members find out about a downgrade when a benefit stops working at the checkout, and nobody tells the member who is two purchases short of the next tier that they are close.

The result is a programme that costs money in benefits but gets little credit for them. Members who are downgraded without warning are also a common source of complaints.

The aim is a set of timely, accurate tier messages driven by the same data the loyalty platform uses, so what the email says always matches what the member sees in the app and at the till.

The tier lifecycle

Five moments matter for most tiered programmes:

  • Upgrade: the member has qualified for a higher tier. Announce it quickly and explain the new benefits.
  • Approaching next tier: the member is within a defined distance of the next threshold before the qualification period ends.
  • Requalification at risk: the member is on track to drop a tier at the end of the period.
  • Downgrade notice: the tier has changed. Explain why, what remains, and how to regain the tier.
  • Points expiry: points will lapse on a known date. Often governed by programme terms, so wording matters.

Upgrade, downgrade and expiry notices are usually part of running the programme and may be described in its terms as service communications. Approach and at-risk nudges are promotional by nature and should be sent only to members with marketing consent. Confirm the classification with your legal or privacy team.

Data flow

StageSystemWhat happens
Tier calculationLoyalty platform (for example Salesforce Loyalty Management or an external platform)Computes tier, qualifying spend or points, and period end date
Daily extractIntegration or file dropMember tier status lands in a Loyalty_Members_DE data extension
Change detectionAutomation Studio SQLCompares today's status with yesterday's snapshot and writes changes to an entry data extension
Snapshot refreshAutomation Studio SQLOverwrites the snapshot so tomorrow's comparison is correct
MessagingJourney BuilderSeparate journeys or splits for upgrade, downgrade, approach, at-risk and expiry
LoggingData extension and Data ViewsRecords what each member received for support and measurement

Detecting tier changes

If the loyalty platform can emit tier change events through an API, use them, because they are the most accurate source. Many platforms only offer a daily extract, in which case a snapshot comparison in Automation Studio works well.

Assumptions

  • Loyalty_Members_DE holds today's status with MemberId, SubscriberKey, EmailAddress, CurrentTier and TierRank (1 for the lowest tier).
  • Loyalty_Tier_Snapshot_DE holds yesterday's MemberId, Tier and TierRank.
  • The query writes to Tier_Change_Entry_DE with the Overwrite action. Field names are samples.
sql
SELECT
    c.SubscriberKey,
    c.EmailAddress,
    c.MemberId,
    p.Tier AS PreviousTier,
    c.CurrentTier,
    CASE
        WHEN c.TierRank > p.TierRank THEN 'Upgrade'
        ELSE 'Downgrade'
    END AS ChangeType,
    GETDATE() AS DetectedDate
FROM Loyalty_Members_DE c
INNER JOIN Loyalty_Tier_Snapshot_DE p
    ON p.MemberId = c.MemberId
WHERE c.TierRank <> p.TierRank
  AND c.EmailAddress IS NOT NULL
Sample change detection query for a Query Activity. Run it before the snapshot is refreshed.

The order of activities in the automation matters: import, change detection, snapshot refresh, then journey entry. If the snapshot refresh runs first, no changes are ever found. If the import fails and the query still runs against an empty or partial table, you can generate false downgrades, so add a verification step that stops the automation when the row count falls outside an expected range.

Journey design

Build the upgrade and downgrade journeys as separate journeys. They have different tone, different content owners, and different approval needs.

  • Upgrade journey: send within a day of the change. A short follow-up a week later highlights one benefit the member has not used yet, if your data shows benefit usage.
  • Approach journey: runs from a weekly query that finds members within the threshold distance and a set number of weeks before period end. Cap it so a member receives at most one approach message per period, otherwise it starts to feel like pressure.
  • At-risk and downgrade: the at-risk message goes out early enough for the member to act. The downgrade notice is factual, explains what the member keeps, and shows how to requalify. Avoid language that feels like a penalty.

Personalise with the member's actual numbers (spend or points needed, period end date), drawn from the same extract that drives the tier logic. Where numbers could be stale by the time the email is opened, phrase them with a date: "as of 14 March you need 1,200 more points".

At minimum you need member identity, current tier and rank, qualifying balance, threshold for the next tier, period end date and points expiry date. Keep a tier history table, not just the current tier, so support can answer "when did I drop to Silver?" and so measurement can look back. See data extension design for primary key and retention choices.

Use separate send classifications or publication lists for service-style loyalty notices and promotional nudges, so a marketing opt-out stops the nudges without stopping the factual notices your terms promise.

Testing and launch

Create seeded test members for every transition: each upgrade path, each downgrade path, members exactly on a threshold, members whose period ends today, and members in different time zones if the programme spans regions. Run the automation in a test business unit against these records and compare the entry data extension with the expected list before any journey is activated. Launch upgrades first, because they carry the least risk, then downgrades with a manual review of the first few batches.

How to measure

Measure the nudges, not the mandatory notices. For approach and at-risk messages, hold out a random share of eligible members and compare the proportion that reach or retain their tier by the end of the period. Track this per tier, because behaviour differs widely between entry and top tiers. For upgrade and downgrade notices, watch support contacts about tier status and complaint volumes against a pre-launch baseline. Our guide to measuring marketing automation honestly covers holdout design in more detail.

Risks and variations

  • Retroactive corrections: returns or reversed transactions can move a member back down after an upgrade email. Agree a grace rule with the programme team before launch.
  • Timing mismatch: if the extract runs before the loyalty platform finishes its nightly calculation, you message yesterday's truth.
  • Multiple programmes or regions: tier names and thresholds may differ by market. Keep tier content in a lookup data extension rather than hard-coded in emails.
  • App and wallet channels: push and wallet pass updates can follow the same change table once email is stable.

Design your tier messaging

If your loyalty programme has the rules but not the communication, we can map the lifecycle and build the data and journeys behind it.

Talk to a Marketing Cloud expert →

Tell us what you are trying to fix.

Share your Salesforce setup, goals and constraints. A practitioner reads every message and replies with questions, first thoughts or an honest view of whether you need outside help at all.

Talk to a Salesforce Expert
Book a Consultation