Additional profile merge criteria for travelclick updates
Hi Maike,
We will need to automatically merge the guest profiles only when multiple strong identifiers fully match.
As a hotel, we should be able to assign specific scores for each identifier and a specific threshold so if the potential matches exceed this threshold to automatically merge the guest profiles. These value should be configurable for each hotel either directly or through StayNTouch support.
For any fields that there is data in any of the profiles that are examined for merging we will need to use the latest data.
Any blank field should be disregarded so if the latest update has a blank field we can bring over the data from the previous version of the profile instead of erasing the data from that field.
Partial matches of a field cannot be considered a match (e.g. last name Vassis vs Vasiliou)
Recommended Scoring Model:
| Attribute | Weight |
|---|---|
| Exact Email | 40 |
| Mobile Phone | 35 |
| Loyalty Number | 80 |
| ID Number (Government ID/Passport) | 80 |
| DOB | 30 |
| Address | 20 |
| First Name Exact | 40 |
| Last Name Exact | 40 |
| Minimum Threshold for Auto Merge: | 100 |
Please let me know should you need to discuss any aspects of the requirments.
Thanks a lot
Alex
1 person likes this idea
Imperial Hotels would like to have additional criteria available for automatic guest profile merging when receiving updates via integrations/travelclick. Currently, profiles may be automatically merged when they share the same email address and last name.
Imperial Hotels would like the ability to define additional matching criteria, such as first name, so that profiles are only automatically merged when these additional criteria also match to help prevent incorrect automatic merges and provide greater control over guest profile management.