How to Leverage Dynamic Links for Emails From Spreadsheet in AJO

[Hurston]

With current ESP we create our email campaigns with placeholder links such as "Primary CTA" and "Footer US EN Legal" and in our ESP we upload a CSV file of links that dynamically create the necessary urls for the email campaigns going out. So a single email with content in different languages gets the appropriate linsk with correct attribution tracking.

Is there some way to do this in AJO today or what is the recommended way of doing this? Do we need to build out all of the possible footers and headers and use them as part of a dynamic template or some other method?

[Pradeep_Kumar_Srivastav]

Hi @Hurston , While AJO doesn't have a direct CSV import feature like your current ESP, it provides powerful tools to achieve similar results like Fragments(Dynamic Content Blocks), Template Variants, and Decisioning etc. which can be used for such use cases.

[Ivan_Mironchuk · Accepted solution]

@Hurston - the links you are talking about are they specific to an individual profile? or are the 1:Many. If they are one to many, then using global variables and expression fragments could be a great way to update. In this case, you would have your email template set with variables like 

{{primaryCTA}} {{ENlegal}}

Then you would have an expression fragment sitting in your fragments library where you could update the definition of these variables. The benefit here is that if you are using a fragment, you can track all references to this fragment and you can update live Journeys and Campaigns with any changes to the fragment without having to republish. 

Inside your fragment you would have something like 

{% let ENlegal = "all the legal text here" %} {{ENlegal}}

Let expression helper 

[Hurston]

Thank you, I think this is what I'm looking for.