Creating a Better Identifier for "Was Sent Email in Last X Days" | Community
Skip to main content
Delinda_Tinkey1
Delinda_Tinkey1
Level 5
November 8, 2013
Solved

Creating a Better Identifier for "Was Sent Email in Last X Days"

  • November 8, 2013
  • 2 replies
  • 1564 views
We're big on using the filter "Not Was Sent Email in last X Days", which can slow down the speed of smart list calculations. I'm thinking of ways to improve system performance and get the same result.

For example, what if we add leads to a list whenever they are sent an email, wait X days, then remove them from the list? Then we can use the "Member of List" filter instead of "was sent email."

Has anyone tried something like this before with any success?

Thanks for your input!
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by
Hey Delinda,

The only issue I see with your idea is that you would need multiple lists for the amount of days. For example, if you are looking for Leads who have not been sent an email in the past 7 days, opposed to 10, they will all be part of the same list and you will have to have another filter clarifying when they were added to the list., Ot you will need a list for 1 day ago, 2 days ago, 3 days ago, etc. which doesn't sound like a whole lot of fun. 

One idea would be to create a custom field in Marketo, something like "Last sent email date". Then, you can have one trigger campaign to update that field with the date whenever a Lead is sent an email. So when you go to filter based on last email sent (which could include Sales Emails as well), you can reference that field and only those with dates older than 7 days would qualify.

2 replies

A
Anonymous
Accepted solution
November 8, 2013
Hey Delinda,

The only issue I see with your idea is that you would need multiple lists for the amount of days. For example, if you are looking for Leads who have not been sent an email in the past 7 days, opposed to 10, they will all be part of the same list and you will have to have another filter clarifying when they were added to the list., Ot you will need a list for 1 day ago, 2 days ago, 3 days ago, etc. which doesn't sound like a whole lot of fun. 

One idea would be to create a custom field in Marketo, something like "Last sent email date". Then, you can have one trigger campaign to update that field with the date whenever a Lead is sent an email. So when you go to filter based on last email sent (which could include Sales Emails as well), you can reference that field and only those with dates older than 7 days would qualify.
    Delinda_Tinkey1
    Delinda_Tinkey1Author
    Level 5
    November 8, 2013
    That's a great idea Jeff. Thanks!
    Terms & ConditionsAccessibility statement

    Loading footer...