1

Question about Marketing Cloud Connect - In case of Individual Email Result in Salesforce, an email preview is sent from MC to SF object along with a thumbnail preview of the email template (as base64 encoded image). This thumbnail has two problems.

a. isn’t clear enough for the sales agent to see what was sent to customer

b. can’t find what offer percentage was given to customer as the preview has ampscript value instead of actual value.

enter image description here

There is no way to change the default configs of MCC to increase the thumbnail size. To solve this and improve the image resolution, I’ve thought of below solutions. Is there any other possible way that you’ve done?

  1. From customer send log, take ‘view_email_url’ and get the html using a visual force page and remove all the ‘https://click…xx.com/’ links to ensure click/ open counts aren’t impacted. Downside - # of api calls to make are higher

  2. For every email, create a jpg preview of the email template and store it in MC and store this in SF in a custom object as ‘EmailName vs EmailPreviewUrl’. And, whenever a marketer creates a new email, they have to ensure that they create a jpg copy in MC and update associated record in Saleforce custom object. Downside - sales agent will not know what % of offer is given to customer (ps - % of offer is decided in MC automation based on raw order information we’ve about this customer). To manage this downside, we can send the offer details of each customer to SF using updateSingleSalesforceObject method everytime an email is sent. To do this, all the campaigns should be standardized to some extend.

Any other thoughts? is there any configs that I can flip to increase the image size?

Matheswaran Kanagarajan
  • 441
  • 6
  • 19

1 Answers1

1

To answer this question, we ended up creating a cloudpage code resource (similar to API) that returns the complete HTML of 'view_email_url' (aka view as web page) for a given email + Subscriber + datesent + BU. We used SSJS to query sendLog DE using these inputs to figure out the view_email_url value. To avoid counting view_email_url opens to tracking opens, we wrapped the open counter pixel inside a context variable - something like below.

%%[ 
  IF _messagecontext != 'VAWP' THEN
]%%

<custom name="opencounter" type="tracking" />

%%[ ENDIF ]%%
Matheswaran Kanagarajan
  • 441
  • 6
  • 19
  • How can you render the email without having the Data Extension which was used to be sent? – Daniel G.F. Jan 09 '23 at 17:17
  • The DE must be present. Alternatively, you can write an app that would fetch the HTML of view_email_url periodically and store them in an app server (say, heroku + postgres / mongodb) and from CRM's individual email results, call your app server to return the html. This way, html is stored 'as-long-as' you want in your own server. – Matheswaran Kanagarajan Jan 23 '23 at 00:27
  • I think your use case is not covering emails sent with custom Data Extensions, where you need to be able to link the JobID to the Data Extension that was used in the send in order to render back the email with the used DE columns. In SFMC APIs you simply can't relate a JobID to the used DataExtension, so I wonder how "view_email_url" can do the trick. On top of that, sendLog DEs don't store the Data Ext used per jobId - https://salesforce.stackexchange.com/questions/42043/retrieving-data-extension-used-to-filter-e-mail-send – Daniel G.F. Jan 23 '23 at 15:00