• Naveen VM

Marketing Cloud Dynamic Email Based on Different Languages

Updated: Aug 4

Let's say that you / your company has an international product / service and as an email marketer, you will need to get in touch with customers in all the countries. You also know that you might need to get in touch with customers with their country languages to get more open & click rate.


Have you ever wondered how much time it would take to create each email with different languages of content, Preview & test the emails, creating a journey builder and adding multiple decision splits based upon country and add each email to those splits.

Uff... so much time for one email ?!


Or If you have a single email and you are using dynamic content or enhanced dynamic content, you have to maintain too much content for different countries and too much work on adding rules, content and testing it out.


Now, we have a solution! You just need a little amount of knowledge on the ampscript that's it!


Step 1: We need a Target data extension to which we need to send out an email. Below is the screenshot in which we have customers from different countries in the US, Germany & France.


Data Extension with different country records

Step 2: We need to create a data extension for email language translation:

  • In the below screenshot, Country_ISO is the primary key. Select some common identifiers between the Target DE and Translation DE. In this case I have taken country ISO as the common identifier.

  • Email content will be changing based upon the country ISO row.

  • For example, if the Target DE one of the recipients has country ISO 'DE' then we have made the ampscript to look for 'DE' in translation DE and pick up the related content.

  • You can also notice that in the Header Text column I have added the HTML directly in the data extension which the ampscript will render HTML along with content.


Data Extension for Content Translation

Step 3: Create an email:

Below is the initial email I have created:

Dynamic Email Based on Different Languages

Step 4: Change the email with AMPscript:

Below is the AMPscript to be placed in a HTML content (view code snippet).


Code Description:

  • Line 2 - It will fetch the Country_ISO field value from the Target data extension

  • Line 3 - The LookUp function will fetch the value of Subject attribute if the matching country_ISO has been found between Target DE and Translation DE.

  • You can also add an If and else condition if the country_ISO couldn't able to match the translation DE then add the country_ISO as default as 'US'

  • Replace the subject with Ampscript variable - %%=v(@Subject)=%%.

  • For Links you can replace it with - %%=RedirectTo(@CTA_Link)=%%

  • Similarly repeat the steps for other email contents as well like Pre-header, Header image etc..


Outcome:

Below is the email for different languages:

German:


French:

If you feel you need to change the content at a later point of time, you just need to change the contents in data extension. You don't have to worry about updating the journey builder email, ampscript will take care of those.


This is a great time saver! Let me know your thoughts on this.


Please feel free to leave your feedback/comment in case of any queries.


Happy Learning!


#SFMC #SFMCDynamicEmails