Exclude bounced email addresses in query

Forum|Forum|1 year ago
July 12, 2024
1 reply
989 views

Hi all,

I think hard bounces are automatically excluded in email deliveries. However, I would like to exclude them in my query beforehand. Is there an easy way to do that in a workflow?

Until now I used the exlusion logs. But when the email address of a profile changes, the profile is still excluded. So I have to compare the email address that bounced with the email address of the profile.

Thanks,

Lara Vlasblom

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 SatheeskannaK

@laravl You can have a target query that looks at the profiles needed to enter into the workflow and add another query that looks for addressStatus resource to filter the hardbounce records needed and apply the exclusion activity to the outcome of query activity with the addressStatus query activity outcome.

SatheeskannaK

Accepted solution

Community Advisor

@laravl You can have a target query that looks at the profiles needed to enter into the workflow and add another query that looks for addressStatus resource to filter the hardbounce records needed and apply the exclusion activity to the outcome of query activity with the addressStatus query activity outcome.

Thanks, Sathees

L

LaraVlAuthor

Level 2

Thanks Sathees, this seems to work! Please review if I used the exclusion in a correct way.

I defined the profiles as the primary set.
Then I used 'joins' as exclusion method and joined the emailaddress from the addressStatus table with the emailaddress from the Profile table.

Thanks, Lara

SatheeskannaK

Community Advisor

@laravl Glad that it's working. You're on the right path! Everything looks perfect.

Thanks, Sathees

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded