Send email dynamic to date

[Aqeel_Akbar]

Hey guys,

Trying to figure out a way to trigger an email send X number of days before a date field in Salesforce.

So if a contact's renewal date is set in Salesforce, can we trigger an email send X number of days before that?

Thanks,

[Edward_Masson]

Through custom fields and time stamping, yes it can be done.
Some date fields from SFDC may not work in Marketo. Your contract date may be at the Account level and you may need to see that date on the contact.

Using a combination of work flow rules, when a date is stamped in a certain field, you can trigger a smart campaign to listen for that and add the lead into a wait step of 365 days etc then send email. Turn the smart campiagn into a recurring batch to come on every day to process new contacts.

Thats one way.

[Josh_Hill13]

So you'd want to set the Wait Step to be more like 30-90 days ahead of the anniversary date.

[Rachit_Puri2]

Another way to do this would be using a custom field and a webhook. Create a custom date field in Marketo like "30 Days before Renewal Date" or "Renewal Reminder Date". Now, using a webhook and external scripting, you can send the update the date field for this new custom field, based on your contract expiration date. Typically, the whole scripting shouldn't take more than 2-3 hours. 
This would ensure you don't have to add wait steps in your campaign flows, keeping them simple.