Can I change the content of an email based on the day of the week it is sent?

[Anonymous]

Basically what we are looking to do is have a portion of an email state the day of the week that is two days after the day the email is sent (not including weekends). So if the email is sent on a Tuesday, a sentence would say "Can I give you a call on Thursday?"

Two possible ideas I had would be to make a custom token that would include today's day of the week + two days, or segment an email with the static text changed and then in the flow include a way saying, if today is Tuesday, send the version mentioning Thursday.

Unfortunatley I couldn't find the right tokens or flow items to make either of these ideas work. Does anyone know how I could get them working or have a better solution? Thanks!

[Josh_Hill13]

you might have to do this with a custom SFDC formula field to generate Day of Week based on the calendar. I doubt Marketo can do this on its own in an easy way.

[Anonymous · Accepted solution]

Marekto does not have a Day function, but if you are synching with a CRM like SFDC, you could create a hidden Lead / Contact field synched to Marketo (e.g. Day of week - 2 days out).  In SFDC, you would create a formula field / workflow rule that would update this field's value based on the system date to an appropriate day of the week value.  Be aware that you'll need some clever logic to handle the situation where 2 days out is a weekend day or holiday.  When you send your Marketo email, you would include a token to this field

[Anonymous]

Hi Daniel,

Depends on if you have SFDC or another CRM that could do the heavy lifting for you. If you can, it's a fairly straightforward formula and I definitely recommend doing it there.

If not, I just thought of a way to do it in Marketo but it is a little gnarly. I've never tried it but it should work in theory.

You'll need the following:

• one custom Marketo text field: "2 days from now - DOW" (you can name it whatever you'd like)
• 7 separately batch campaigns that run weekly on each day of the week: for example, one of the campaigns will run weekly on Monday morning at 12:01am and change the field value to "Wednesday", the Tuesday one will change the value to "Thursday", etc.

If you choose to go this route, I recommmend using programs and keeping the smartlist on these campaigns to only members of the program, otherwise, it might slow down your instance if you have a big database.

Let me know if you end up trying this!