When a profile property value on a profile changes, and that profile property is being used for profile merging, BlueConic sets out to find if there are other profiles that match this new value.
The concept of merging profiles sounds simple enough. Behind the scenes however, merging is a fairly complex and computationally expensive process. To protect data integrity and performance, BlueConic imposes some limits on profile merges. In general, you should not run into these limits.
These are the limits on profile merging:
- Look-up maximum
- Maximum 1,000 merges for a single profile
- Merge only on values with more than 3 characters
- Maximum 20 matching profiles
Profiles merge based off configured merge rules for profile properties. BlueConic can have multiple of these rules and profile properties can have multiple values.
BlueConic imposes a limit of 24 look-ups to check if a profile must merge with another existing profile. This is best explained in a couple of examples:
- Example 1: merge rule purely based on "Email address"
- The email address property may hold up to 24 addresses that could lead to successful merges. The 25th address would not be processed by BlueConic to find potential merges, as it is above the limit of 24 look-ups.
- Example 2: merge us based on "Email address" and "Customer ID"
- The multiplication of assigned values in both properties must not exceed 24 to lead to successful merges. For example:
- A profile with 4 email addresses and 6 customer ids (4 * 6 = 24) would lead to successful merges on all values.
- A profile with 3 email addresses and 7 customer ids (3 * 7 = 21) would lead to successful merges on all values.
- A profile with 5 email addresses and 5 customer ids (5 * 5 = 25) would only lead to successful merges on 24 out of 25 available values. There is no telling beforehand which of the values will not be processed.
- Example 3: merge rule is based on "Email address", "Customer ID" and "City"
- Same as above: multiply the number of values for the profile properties involved in the profile that changes. The outcome must not exceed 24.
- 4 email addresses, 2 customer IDs and 3 city values (4 * 2 * 3 = 24) would lead to successful merges on all values.
- 2 email addresses, 5 customer ids and 2 city values (2 * 5 * 2 = 20) would lead to successful merges on all values.
- 10 email addresses, 1 customer id and 3 city values (10 * 1 * 3 = 30) would only lead to successful merges for 24 values ouf of 30. There is no telling beforehand which of the values will not be processed.
BlueConic imposes a limit of 1,000 merges for a single profile.
If a matching profile if found based on a merge rule and that profile has already been merges 1,000 times, no merge will happen.
Any profile property value that is used in a merge rule will only be considered for merging if it has more than 3 characters. For example:
- The value
abcdwill be used for finding matching profiles to merge.
- The value
abcdoes not have more than 3 characters and therefore will not be considered for merging.
BlueConic will try to find matching profiles for a merge rule. A merge will only take place if there are up to 20 matching profiles for the merge rule.
If there are 21 or more matching profiles, a merge will not take place.