Loyalty Register

Loyalty glossary · 7. Data and analytics (31)

Data Clean Room

A data clean room is a controlled environment where a loyalty programme and a partner can match and analyse customer data without either side seeing or copying the other's raw records, with output released only as aggregated or differentially private results.

The data clean room is the least bad answer to a real problem. Loyalty programmes need to measure partner campaigns without exposing member level data. Cookies are dying and third party data is dirty. A clean room lets both sides bring encrypted identifiers into a neutral space, match them, and take out only aggregated numbers.

A clean room encrypts the join key before it leaves each side. The vendor holds the key and performs the match. The output is row level only inside the room, and only aggregated or noise injected results leave. That design is sound until someone brings a weak match key. If both sides match on email alone, the encrypted identifier is just a pseudonym for the same identity, and a breach of the vendor reveals everything.

Work the arithmetic. Assume a programme issues 1 billion points per year. A clean room test with a retail partner shows a 15 percent lift in redemptions when a member sees a partner offer. That is 150 million points of incremental cost. But the same test shows a 3 percent cannibalisation effect, meaning 30 million points would have been redeemed anyway. The net attributable increment is 120 million points, and an accrual model built on the gross 150 million overstates liability by exactly that 30 million.

The trap is treating the clean room as a neutral referee. It is a software product, usually sold by the same vendor that runs the ad server or the CDP. That vendor has an interest in showing lift, because lift justifies more spend. No external auditor checks the match rate or the suppression logic. A programme that does not run its own holdout group will receive whatever the vendor's default model produces.

Activity based qualification rules determine who enters the clean room in the first place. A programme that only qualifies members who have already redeemed is measuring the most engaged segment and calling it the whole base. An actuarial model fed on that output will project a redemption curve that is too steep, and an accrual assumption built on that curve will release too little liability.

Related