Formula Flow

[Anonymous]

Hey All!
I need to set up a flow using a formula, is that an option?  For instance, we pull in the Last Order Date from Salesforce.  I need to market to people that have not ordered in the last 30/60/90 days but the flow requires a hard date.  Any suggestions?

[Anonymous · Accepted solution]

Hi Melinda,

I do something very similar, and I'd recommend creating a formula field in SFDC that calculates the days since last order date.

TODAY () - {LastOrderDateField}

Then, your flow in Marketo could run based on a filter "Days Since Last Order Date GREATER THAN 30/60/90/etc.