Hi Sanford, This is what conversant has come back to me with -  The main purpose of email tagging is to help conversant identify Farnell customers and be able to reach (Display ads) them online within different devices. The reason for SHA256 is because the customer file we receive from your company is hashed out with SHA256. Having SHA256 on the email tagging, we can then map the hashed email address to a User in conversant since those are in the customer file as well. Also, just to clarify, we don’t reverse the hashes to its normal email address as those become PII information. Not sure what to make of this. ... View more

I'm lost in all this process, not sure which way to go. Do you have example how to use Unique codes or will best option be coding some velocity using Base64. Thanks ... View more

Hi Sanford, Not sure answer to on any of those, I was told that the email address needs to encrypted as it is personal data, below is what they mentioned -  Yes, encryption is required as that is personal data and we would want to make sure CNVR does not ingest those due to legal reasons. Hope you still can help. Thanks again. ... View more

Thanks Tony! but not sure I have the knowledge to this. ... View more

Hi Sanford, it will not be one time load - all customers in our database will be affected at some point. Basically we are working with Conversant(part of Commission Junction), they have provided those parameters which will allow them to track our customer behaviour but we need the email address encrypted. We add the following to our email head: Email Tag Code: <img src="http://login.dotomi.com/ucm/UCMController?dtm_com=2&dtm_cid=61538&dtm_cmagic=a0ad3c&dtm_fid=<Form ID>&dtm_format=6&cli_promo_id=99& dtm_email_hash={{lead.Email Address}} & dtm_user_id={{lead.ID}} & dtmc_drop_id={{program.id}} " width="1" height="1" border="0"> <!-- End Conversant Tag --> and links will have the following parameter: dtm_email_hash parameter ( dtm_email_hash={{lead.Email Address}} ) should be encrypted using SHA256 hashing as that is personal information...which will look something as follows: https://www.domain.com?dtm_email_hash={{hashed_lead.Email}} If you can help with the coding, would be gratefully appreciated  - as you said using base64 now. Thanks for all your help!  ... View more

Sorry, we are targeting existing LEADS within Marketo and was told these email addresses will not change for now. ... View more

The leads are existing Leads we send these emails to, so email address will never change and no new is being created. Sanford that would be great help if you could create the SHA-256 code  I am sure it will come in handy for a lot of of others using Marketo. Trying to have this up and running within 5 to 7 days, is that duable? Thanks for all your help.  ... View more

Sorry, will the link still be: https://mydomain.com/dtm_email_hash={{lead.Email Address}}, Plus why do we need the Data Value Changes in smart flow? Not sure how I would test it as this makes it triggered and cannot Run Once ... View more

Thanks Jay! Will try this, hopefully it will do the job for me. Quick one, the endpoint.php in your screen grab is that the file with the php code you provided me? Thanks again! ... View more

Hi Jay, Thanks for that, not sure how to go about with PHP with Marketo, new to this. Will it be possible to give some more guidance? Thanks! ... View more

Cool, is this the code? https://nation.marketo.com/community/product_and_support/blog/2019/10/13/base64-ing-a-string-in-velocity-without-using-reflection  I'll see if I can manage to do something. ... View more

Thanks again Any chance you can provide an example or velocity code I can look at to build this? ... View more

Thanks Sanford! Is there any webhook-compatible service you know of? Would help me look into it a little more. ... View more

# set ( $currentURLNoProto = $co_record . URL_1 ) # foreach ( $link in [ 1 . . 3 ] ) # evaluate ( "${esc.h}set( ${esc.d}URL_${foreach.parent.count}_${foreach.count} = ${esc.d}currentURLNoProto )" ) #end #set($daysRemaining = $math.abs($daysRemaining)) ##set($co_record.URL_1 = $DynamicCustomObjectList.URL_1) ##set($co_record.URL_2 = $DynamicCustomObjectList.URL_2) ##set($co_record.URL_3 = $DynamicCustomObjectList.URL_3) ##set($co_record.URL_4 = $DynamicCustomObjectList.URL_4) ##set($co_record.URL_5 = $DynamicCustomObjectList.URL_5) ##set($co_record.URL_6 = $DynamicCustomObjectList.URL_6) #if($convert.toInteger($daysRemaining) < 5 && $co_record.SendID == "Pattern Breakers Engineer") <table id="bodyContent" class="innertable2" align="center" width="600" cellpadding="0" cellspacing="0" style="background-color:#ffffff;"> <tr> <td valign="top"><table width="100%" style="font-size: 3px;"> <tbody> <tr> <td> </td> </tr> </tbody> </table></td> <td rowspan="6"><img src="http://planet.farnell.com/email/newtemplate/email_assets/spacer.gif" width="2" height="10" class="spacer"/></td> <td rowspan="6" style="background-color:#e4e4e4;"><img src="http://planet.farnell.com/email/newtemplate/email_assets/spacer.gif" width="4" height="1"/></td> <td rowspan="6"><img src="http://planet.farnell.com/email/newtemplate/email_assets/spacer.gif" width="2" height="10" class="spacer"/></td> <td valign="top"><table width="100%" style="font-size: 3px;"> <tbody> <tr> <td> </td> </tr> </tbody> </table></td> </tr> <tr> <td valign="top"><table width="289" border="0" cellspacing="5" cellpadding="5" class="innertable3"> <tr> <td > <table width="100%" border="0" cellspacing="0" cellpadding="0" align="left"> <tr > <td> <table width="15%" border="0" cellspacing="0" cellpadding="0" align="right" class="w100"> <tr> <td> <a href="https://${URL_1_1}" target="_blank"> <img src="$co_record.Image_1" width="100" style="border-collapse:collapse; padding:0px; margin:0px; border-spacing:0; display:block;"/></a> </td> </tr> </table> <table width="15%" border="0" cellspacing="0" cellpadding="0" align="right" class="w100"> <tr> <td> <a href="https://$co_record.URL_2" target="_blank"> <img src="$co_record.Image_2" width="100" style="border-collapse:collapse; padding:0px; margin:0px; border-spacing:0; display:block;"/></a> </td> </tr> </table> Some sample code above utilizing code you provided, but link only pulling from $URL_1 CO field, I need to pull from   $URL_2, $URL_3 etc.. ... View more

Sorry, new to using the discussion. I have 6 links within the CO which need pulling in, the example you gave seems to pull only URL_1 - is there a way to use the code you had provided and pull all 6 links? Below is how I had set it up but links broke.    #set($co_record.URL_1 = $DynamicCustomObjectList.URL_1)    #set($co_record.URL_2 = $DynamicCustomObjectList.URL_2)    #set($co_record.URL_3 = $DynamicCustomObjectList.URL_3)    #set($co_record.URL_4 = $DynamicCustomObjectList.URL_4)    #set($co_record.URL_5 = $DynamicCustomObjectList.URL_5)    #set($co_record.URL_6 = $DynamicCustomObjectList.URL_6)   For example each link was added as -       <a href="https://$co_record.URL_1&CMP=e-email-tracking" target="_blank"><img src="$co_record.Image_1" width="100" style="border-collapse:collapse; padding:0px; margin:0px;    border-spacing:0; display:block;"/></a>    <a href="https://$co_record.URL_2&CMP=e-email-tracking" target="_blank"><img src="$co_record.Image_2" width="100" style="border-collapse:collapse; padding:0px; margin:0px;    border-spacing:0; display:block;"/></a>    <a href="https://$co_record.URL_3&CMP=e-email-tracking" target="_blank"><img src="$co_record.Image_3" width="100" style="border-collapse:collapse; padding:0px; margin:0px;    border-spacing:0; display:block;"/></a> Hope you can help. Thanks, Haroon ... View more

Thanks Sanford! That helped loads. There is a little issue, I have six links in the custom object to pick up but the code above only pulling the same link for each.  ##set($co_record.URL_1 = $DynamicCustomObjectList.URL_1) ##set($co_record.URL_2 = $DynamicCustomObjectList.URL_2) ##set($co_record.URL_3 = $DynamicCustomObjectList.URL_3) ##set($co_record.URL_4 = $DynamicCustomObjectList.URL_4) ##set($co_record.URL_5 = $DynamicCustomObjectList.URL_5) ##set($co_record.URL_6 = $DynamicCustomObjectList.URL_6) Is there a way to pull each link? Thanks again, Haroon ... View more

At the moment I'm not totally comfortable with Velocity scripting. Is it possible to help with the example code provided? ... View more

Hi, Was this resolved? I am having similar issue. Thanks, Harry ... View more

Done. ... View more