Email Address - Data Value Change

[kgarcia]

I am attempting to automate an email send for users who have updated their email address. 

These email addresses come from a lead list upload, so the "data value change" is not always obvious. The system they are coming from also capitalizes all records, so when they are updated into marketo (when a prior record existed) it shows that there was a data value change even though the actual email did not change. 

ex: 
Original: email@email.com

Change Data Value from email@email.com to EMAIL@EMAIL.COM

Does anyone know how i might be able to manage this? I want to be able to identify when a unique email address was updated into a lead record. 

[SanfordWhiteman]

Is this an API upload? Because an upload via the UI can only make this kind of non-material change (i.e. case change to a field that's in practice case-insensitive) to the system Email field. It can’t make a material change, since it uses Email as the lookup field!

Anyway, the only way to distinguish material changes from non-material changes is to use a webhook-compatible service. You keep the previous value in another field and pass them both to the webhook, then get true or false back for whether it was a “real” change.