Identity Resolution
Fan identity confidence tiers & suspected link review
Confidence Tiers
Fully Identified
3020%
High Confidence
3020%
Suspected Match
4027%
Known UUID
3020%
Anonymous
2013%
Resolution Logic
1Event arrives (webhook, poll, click)
2Extract email → check fans table for match
3Match found → upsert, recalculate confidence
4No match → new UUID, create fans row
5Write fan_events row regardless
6Suspected matches → suspected_links (no auto-merge)
Confidence Deltas
Shopify purchase: +0.40Mailchimp subscribe: +0.30Show QR scan: +0.30Spotify OAuth: +0.25Instagram OAuth: +0.20Portal email verify: +0.20Email click: +0.10Reward redeemed: +0.10Email open: +0.05UTM click: +0.05
Suspected Links
Unknown(isabella.suarez@gmail.com)
Known UUID
72%
(daniel.cruz@gmail.com)Daniel Cruz
Fully Identified
name_similarity: 0.92city_match: truedevice_fingerprint: partial
Alejandro Flores(alejandro.flores@outlook.com)
Known UUID
65%
(luciana.moreno@hotmail.com)Luciana Moreno
Fully Identified
name_similarity: 0.88email_domain: same
Gabriela Martínez(gabriela.martinez@hotmail.com)
Known UUID
78%
(nicolás.diaz@outlook.com)Nicolás Díaz
Fully Identified
phone_partial: +57300****67name_similarity: 0.95
Suspected matches are never auto-merged. All links require manual review to prevent false positive identity merges. Only confirmed links result in fan profile consolidation.