How to pull a list of all users who haven't interacted with an email in the last six months?

Forum|Forum|8 years ago
February 6, 2018
2 replies
2986 views

Marketo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Dan_Stevens_

Level 10

Use inactivity filters for this: like “not clicked in any email” filter. Keep “opens” out of the equation since they‘re so unreliable. Just know that automated spam bots will probably influence these numbers.

Nicholas_Manojl

Level 8

This'll find everyone who hasn't clicked within the last 6 months and the last 5 minutes. I'm assuming the questioner wants more depth than just haven't clicked in 6 months (but they'll have to clarify that).

It's a tough one to solve without an external timestamp in a datetime format, which gives you access to "in period before", instead of just "within".

Dory_Viscoglio

Level 10

Nicholas, not sure what you mean by this. The filter that Dan suggested should only include people who have not clicked on a link in any email in the last 6 months. If they clicked on any link (which is why automated link checkers can throw this off) they will be excluded from the report.

To solve for the above you can also include a filter that they must have visited a webpage as well, assuming that the link in the emails goes to a tracked page.

Dory_Viscoglio

Level 10

The only thing I'd add to Dan's suggestion is to also probably include a 'was sent email' filter because otherwise you'll get people who were sent emails and didn't interact with them, but also people who were not eligible to receive emails.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded