This content has been marked as final. Show 3 replies
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.
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
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.
Let me know if you end up trying this!