Macros and Personalized Content Implementation

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.

Macros and Personalized Content Implementation

How we implement data within a custom macro field.