I should be able to lookup the lead using the email supplied on the form and pull a list of 'Visit web Page' activities within that time window but I can't seem to figure out how these two pieces of information are related. You're surely leaving many things out. It's important to state what you're trying to accomplish on a business level -- sometimes more important than getting into technical concepts because you may have an XY problem. The Filled Out Form activity and the Visit Web Page activity are linked by the Lead ID. In Marketo, the Email Address is not a primary key. It's merely a lookup key through which you can get (one of) the Lead IDs with that address. How are you getting the lead's email address into a process that will use the API? Why does that process not know the Lead's ID?
... View more
A few ways to do this. Here's one way: In Marketo create a textarea field to capture the history of the utm values On your site, implement your own cookie that cumulatively date stamps and tracks the utm values (save the cookie as string, update the cookie as a json array) On form submit, save the cookie data to Marketo as a string to the textarea field you created In your email alert to sales, use velocity to parse the json formatted string and use foreach to build a list/table of touchpoints
... View more