Is this possible to filter on? One event happening after another?

[Vivre]

For example - Person was sent an email AFTER filling in a particular form (and not a email relating to that form, unrelated campaign).

I can do Filled in Form X before <date> and was sent email X after <same date> but I dont want to center around a particular date, just an email send happening any time AFTER a specific form was filled in

[Darshil_Shah1]

AFACIT, Marketo does not have built-in functionality to filter on an event happening after another event without specifying a particular date. However, there are workarounds involving getting activity data using the Marketo API and filtering people based on the relative activity date.

[SanfordWhiteman]

Well, if you can trigger on Activity A you can filter on Activity B happening earlier. The fundamental problem is Sent Email isn’t triggerable. Email is Delivered is, though.

[Vivre]

Thanks for your suggestion. These are both events that have already happened and requirement is just for investigation purposes. 

[SanfordWhiteman]

You’ll need to involve some outside process then.

Either:

(1) a fully offline app that exports using the Bulk Export API and uses a SQL window function or equivalent

or

(2) a webhook-compatible service to compute the distance between dates; you save the last form fillout and last delivered email to DateTime fields, then pass the people who filled out a form through the webhook and respond with which one came first