Search
  • Naveen VM

Marketing Cloud Dynamic Email Based on Different Languages

Updated: Apr 6

Let's say that you / your company have an international product / service and as an email marketer, you will need to get in touch with customers on 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 maintain too much of content for different countries and too much of work on adding rules, content and testing it out.


Now, we have a solution! You just need a little amount of knowledge on ampscript thats 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 of different countries on US, Germany & France.



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

  • In the below screenshot, Country_ISO is primary key. Select some common identifier 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 recipient has country ISO 'DE' then we have make 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 will ampscript will render HTML along with content.



Step 3: Create an email:

Below is the initial email I have created:

Step 4: Change the email with AMPscript:

Below is the AMPscript to be placed in a HTML content.


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 to change the content on 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.


Happy Learning!

Please feel free to leave a comment in case of any queries.


#SFMC #SFMCDynamicEmails


48 views