Undelivered Smart List | Community
Skip to main content
A
Anonymous
March 1, 2016
Solved

Undelivered Smart List

  • March 1, 2016
  • 2 replies
  • 2431 views

Hi,

I am trying to create a smart list that will provide only those email accounts, addresses, ID, etc. that were undelivered. I understand there is a current Smart List filter that reads "was delivered email"; however, when exporting this list, I have to do a vlookup to find those email addresses that were undelivered. I tried to find "was undelivered email" or simply search in the smart list filter search bar for "undelivered" but found that neither of these exist. Is this something that my particular Marketo instance consist of? Has anyone else had success to creating smart lists that show only undelivered accounts? I found a filter called "Not Was Delivered Email" but this filter does not show the undelivered, as I thought maybe did. Any thoughts or suggestions on this?

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 Justin_Cooperm2

Please note that this won't be perfect. I highly discourage people from trying to get an exact list of people for certain email metrics. It's just not possible to do correctly.

There are tons of issues with that approach but here is a quick example:

Sometimes an email that was sent to a person in your database will be recorded as "Delivered" because we received that response from the email receiver, but shortly after we'll get a "Bounce" activity. In this case, our Email Performance Report has special business logic to decrement the "Delivered" count and increase the "Bounce" count. However, our activity log will still show both activities. Because Smart Lists in Marketo are based on the activity log, this lead would be counted as "was delivered email" which is not true in reality.

2 replies

Justin_Cooperm2
Justin_Cooperm2Accepted solution
New Participant
March 2, 2016

Please note that this won't be perfect. I highly discourage people from trying to get an exact list of people for certain email metrics. It's just not possible to do correctly.

There are tons of issues with that approach but here is a quick example:

Sometimes an email that was sent to a person in your database will be recorded as "Delivered" because we received that response from the email receiver, but shortly after we'll get a "Bounce" activity. In this case, our Email Performance Report has special business logic to decrement the "Delivered" count and increase the "Bounce" count. However, our activity log will still show both activities. Because Smart Lists in Marketo are based on the activity log, this lead would be counted as "was delivered email" which is not true in reality.

Justin_Cooperm2
Justin_Cooperm2
New Participant
March 2, 2016

See this as well

Why Does My Smart List Count Not Match the Email Performance Report?​

Grégoire_Miche2
Grégoire_Miche2
New Participant
March 1, 2016

Hi Megan

Combine the "was sent email" with the "not was delivered email".

-Greg

Terms & ConditionsAccessibility statement

Loading footer...