How we implement data within a custom macro field.
Questions:
- Can your system handle the parenthesis? Do these need to be removed? (833) 858-3628
- Can your system handle the backslash like 03/07/2025? Do these need to be replaced with dashes? (are there any issues with the zero in front of the month and day? 03/07/2025)
- Can your system handle the plus and underscore? mail+email+paid_social
Our Answer:
How we would implement these types of data within a custom macro field:
Make sure the data is encoded to match the implementation. Make sure to properly encode the column in the m&e file based on where you are going to be using the macro.
1) If the macro is going to be used as part of the HTML body (and not a url) and the values have special characters (whatever those are).
Make sure to have the values in the file HTML encoded. IE:
<body>
</body>
and custom 1 is supposed to be "Nemi & assoc." then the file should
have "Nemi & assoc." so it renders properly across all browsers
2) If the macro is going to be used as a query string then you should be URL encoding. IE:
<body>
<a href='https://www.hello.com?a=' >click here</a>
</body>
and custom 1 is supposed to be "Nemi & assoc." then the file should
have "Nemi%20%26%20assoc." so the url does not get broken.
For more information, view our Connect Self-Serve Guide.