CDP applies the following standardization on data:
This data processing is done through a third-party component called Melissa Data.
Currently, the following countries are supported:
US
CA
UK
TR
Melissa Data ingests the following information from the Address feed shared by customers:
Address1
Address2
Zip
City
State
CountryCode
It standardizes the data, processes the data against the USPS database, and provides the following information:
CountryCode
is not provided, CDP defaults to US
and tries to
standardize and validate accordingly.CountryCode
is invalid, CDP does not validate the address
and returns the result as invalid.CountryCode
is valid but not supported, CDP does not validate the
country. CDP sends the data through as it is.Address1
,
Zip
, City
, State
, and Country
, it tries to revalidate the
address by using the combination of Address2
, Zip
, City
,
State
, and Country
. This is called field shuffling or swapping.
If the updated combination is validated, Melissa Data returns
the address as Address2
, Address1
, Zip
, City
,
State
, and Country
in the same order. Therefore, CDP swaps
Address1
and Address2
in DW.true
.The processing is identical for every tenant. However, Melissa Global Data
for UK
addresses can be used only in the EU data center. CDP uses the same
process for validating UK
addresses as is used to validate US
and
CA
addresses. This is done by populating Certified and DPVConfirm
attributes in UDM with their UK
equivalent.
The processing is identical for every tenant. However, Melissa Global Data
for TR
addresses can be used only in the EU data center. CDP uses the same
process for validating TR
addresses as is used to validate US
and
CA
addresses. This is done by populating Certified and DPVConfirm
attributes in UDM with their TR
equivalent.
This data processing is done through a third-party component called Melissa Data.
To process email addresses through this component, email addresses must have valid syntaxes with known domains. Additionally, email addresses must not be in the list of known spam-traps.
After processing the data, Melissa Data returns:
The following values or email statuses in UDM+:
@
, domain, or mailbox.Email addresses that contain obvious typos and forbidden characters are
sometimes cleaned up. For example, sue.gore.@leeaudio.net
is corrected
as sue.gore@leeaudio.net
. Additional examples:
Input | Output | Email Status |
---|---|---|
erisa85d@hotmail.com |
erisa85d@hotmail.com |
V |
erisa85d@homtail.com |
erisa85d@homtail.com |
U |
erisa85d@@hotmail.com |
erisa85d@hotmail.com |
V |
erisa85d@whatever.com |
erisa85d@whatever.com |
X |
erisa85d@hotmailcom |
erisa85d@hotmail.com |
V |
erisa85d@hotmail.co |
erisa85d@hotmail.co |
U |
CDP analyzes your most occurring values and ignores dummy values such as
none@none.com
. While surveying your data, CDP might come across a few high
occurring values with a valid format. The values might be linked to marketing
tests, resellers, or bulk buyers. In such cases, Acquia works with you to
confirm the proper course of action based on what suits your business needs.
This data processing is done through a third-party component called Melissa Data.
Important
This feature is available only for the US and Canada. CDP cannot check the actual country of the customer. You must use this feature only for the US and Canada phone numbers. However, if you use this feature for non-US numbers, international formats and numbers are not corrected properly.
Validation: When validation is enabled, it returns the following in the
<phonecolumnname>validity
UDM column:
V
for valid numbersX
for invalid numbersThe validation process provides the following results:
V
if valid and X
if invalid.Standardization occurs only when the phone number is considered valid. Standardization:
CDP analyzes your most occurring values and ignores dummy values such as
0000000000
. While surveying your data, CDP might come across a few high
occurring values with a valid format. The values might be linked to marketing
tests, resellers, or bulk buyers. In such cases, Acquia works with you to
confirm the proper course of action based on what suits your business needs.