Using alt_customer_id instead of email
Overview
If the customer database has multiple records with the same email address, we recommend that the alt_customer_id should be used to identify customers instead of the email address. The table below shows the three customers in the Connect database who have the same email address, [email protected]. A new column is added for alt_customer_id.
Customer_id |
Alt_customer_id |
Active_email_address |
Subscription status to “conv” |
1002 |
10001 |
Subscribed(5) |
|
1005 |
10012 |
Subscribed(5) |
|
1007 |
10023 |
Subscribed(5) |
XML
The XML below shows how to use the alt_customer_id field to unambiguously target the right customer.
<?xml version=
"1.0"
encoding=
"UTF-8"
?>
<kanaRoot>
<EventRequest CompanyName=
"default"
CampaignName=
"ETCamp5"
>
<Customer KeyField=
"Alt_customer_id"
Alt_customer_id=
"10012"
Postal_Code=
"101201"
>
</Customer>
</EventRequest>
</kanaRoot>
Result
The customer 1005 receives the email.
Note: The KeyField attribute can have two possible values as follows:
EmailAddress (default): The EmailAddress attribute value is used to fetch the customer from the Connect database.
Alt_customer_id: This attribute is case sensitive. If the attribute is alt_customer_ID then the keyfield entry should be keyfield="alt_customer_ID".