Finding Contacts that Have Opened One Specific Email

Forum|Forum|3 years ago
January 12, 2023
3 replies
3073 views

I've imported a list into Marketo that was used for one particular "terms and conditions" type email. A large portion of this list are non-marketable contacts. However, there are some contacts that are on this list that are involved in other campaigns I'm running. I can't figure out how to run a smart list to find the following:

Member of List: List is A

Has only been sent Terms and Conditions Email

The filters I'm running seem to be showing me who's on the list and was sent the email. But that isn't meaning they couldn't have received others. Hope this is making sense and that there's an expert out there!

Marketo

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 Katja_Keesom

I think you need to very closely review your criteria, as you are both talking about opening an email and even being sent one. Assuming you are doing proper housekeeping in your programs when it comes to program status updates, I would add a filter for Member of Program is false where program is not the one you are looking for. Please do bear in mind that activities like Send / Open email are only kept for 90 days, so any emails having been sent longer ago cannot be monitored by looking at the activities themselves.

W

wbwhitleyAuthor

New Participant

Thank you both! It would appear that both responses helped. We should be using Program data more than we have been, but also we should use both an Activity filter and Non-Activity filter that corresponds. That did the trick! Much appreciated.

Darshil_Shah1

Community Manager

Glad to hear that! You’re very welcome.

Katja_KeesomAccepted solution

Community Manager

I think you need to very closely review your criteria, as you are both talking about opening an email and even being sent one. Assuming you are doing proper housekeeping in your programs when it comes to program status updates, I would add a filter for Member of Program is false where program is not the one you are looking for. Please do bear in mind that activities like Send / Open email are only kept for 90 days, so any emails having been sent longer ago cannot be monitored by looking at the activities themselves.

Darshil_Shah1

Community Manager

I agree with Katja! Given that you're following the proper practice of updating program statuses for people, you should use the Member of Program filter over the email engagement filters as the former is retained for a period of 25 months from the day of activity, unlike the email send/delivered activities which are retained for a period of 90 days from the day of activity.

Katja_Keesom

Community Manager

Quick correction: Program membership is not based on an activity, so is not even bound to the 25 months.

Darshil_Shah1

Community Manager

Along with the activity filter (e.g., if you're reporting on opens for a specific email, its activity filter would be Opened Email, Email is <email-name>), why don't you also add its corresponding inactivity filter (for opens, it'd be Not Opened Email) with email is not "<email-name>" constraint in an AND operation? I think that should do the trick.

If you want to see people who were just sent a particular email (remember opens and sent are different email activities in Marketo), you can use the Was Sent Email, and Not Was Sent Email filters in a similar configuration.

While you're pulling data for your requirement, I'd like you to be aware of Marketo's data retention policy per which high-volume activities (email sends, delivered, etc.) are purged after a period of 90 days from the date of the activity and low-volume activities (email opens, email clicks, form fills) are purged after a period of 25 months from the date of activity from the lead activity log.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded