2 Replies Latest reply on Sep 10, 2019 7:30 AM by roy at keelaro dot com

    Process to correct faulty first name values?

    Michael Saikaly

      Hi there,


      We are looking for some kind of process to fix faulty first name values for personalization.

      Either to update those faulty values to blank or use some kind of string of code that we can use in the subject line when we use personalization.


      Has anyone come across this?


      Our data feed is coming in from SFDC.


      Thank you



        • 1. Re: Process to correct faulty first name values?

          I would use a program canvas with a contact washing machine step to fix values on new contact creation and on update. Either by Proper casing or removing a value if blank like you mentioned. You could also look for specific values and change accordingly.

          • 2. Re: Process to correct faulty first name values?
            roy at keelaro dot com

            Data Quality is not new and if you can't fix the values at source (SFDC in your instance) then you can't rely on the field for personalisation.


            A solution in Eloqua is to use something like Social Sign-in and have the individual give you access to their first name as used in that environment. You can store this value (which is likely to be more accurate, but still not guaranteed ) in a Contact Field or a Custom Object field and then field merge from there.


            You could set a default value on blank so that you get "Dear Valued Customer," but I wouldn't recommend or expect great results. If you want to personalise you need to put the effort in and really find out who you are targeting and why they are going to take some action. Personalisation is not automating a email to thousands of contacts by doing a first name field merge.