Email Address - Data Value Change | Community
Skip to main content
Level 2
February 6, 2025
Question

Email Address - Data Value Change

  • February 6, 2025
  • 1 reply
  • 578 views

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. 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

SanfordWhiteman
Level 10
February 7, 2025

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.