Data CloudIntermediateloyaltyintegrationprofilesretail
Design loyalty program integration with unified profiles
Real World Scenario
A airline loyalty program runs on a third-party platform while bookings exist in Salesforce and data warehouse. Points balance must appear on unified profile for service agents.
Expected Answer
• Ingest loyalty member ID, tier, points balance, and tier expiry as dedicated DMO attributes
• Match loyalty ID as high-priority identity key linking to CRM Contact
• Stream tier changes for real-time agent visibility during irrops
• Calculated insight for points-to-next-tier progress
• Activation to Service Cloud read-only fields—writes go through loyalty API not DMO
• Reconcile points nightly with loyalty platform as source of truth
• Handle member merges when duplicate loyalty accounts consolidated externally
Follow-Up Questions & Answers
Click to expand — each follow-up includes a direct, interview-ready answer
Direct answer: Ingest loyalty member ID, tier, points balance, and tier expiry as dedicated DMO attributes Also consider: Match loyalty ID as high-priority identity key linking to CRM Contact In practice: Stream tier changes for real-time agent visibility during irrops Balance speed of delivery with maintainability.
Architect Perspective
Loyalty data is authoritative in loyalty system—Data Cloud aggregates for view, not transactional writes.