Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
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?
