Im working a complex dynamic build and was thinking of using an ampscript look up array to pull the content from a data extension. The idea being that the content can be updated and uploaded via csv rather then wading through numerous content item and the similar if statements.

How does ET and the CSV work together for embedded html (Special characters)? What should I look out for?

Cheers jjp


You can certainly store HTML and special characters in Data Extensions.

I would not recommend using a .CSV for getting the data into SFMC. Tab or pipe-delimited is a better option. Saving Excel files as Unicode (tab-delimited, .txt) works well.

Link wrapping is a drawback of storing HTML blocks in Data Extensions. You'll have to hardcode or inject the httpgetwrap| prefix for all of your links if you want to track the clicks. It is limited to 100 unique URLs tracked per send job. That's been discussed several times around here:

How do I track urls found in a content data extension column that contains other data?

Dynamic trackable links in ExactTarget email


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.