Exclusion Script for multiple Send Log variables in Journey Builder Email Send

Question

Have a bit of a complex exclusion requirement and haven't been able to find a script that works.

Background

A contact submits a web form for a brochure on a model called 'Pear'. This enters them into a journey called 'Brochure', AND a sendable DE called brochure contacts with data:

• model (Value = Pear in this eg)
• EmailAddress
• Consent
• DateAdded
• List item

Have also set up a email send log data extension to capture each email sent to the contact that's been injected into the journey. This DE include fields:

• SubscriberKey (Primary)
• EmailID (Email Send ID)
• model (Value = Pear in this eg)
• EmailName (Value = brochure request acknowledgement)
• SendDate (Current)
• EmailAddress (Email Address in Send)

Goal

The aim is to avoid a contact getting the same up-sell email being sent in another Journey they may have entered. E.g

1. When this contact submitted a form for the brochure of the 'Pear' model, they received the 'acknowledgement' trigger, and was sent an up-sell and a follow up email named 'Pear Tech'.
2. This contact then submitted a form for a quote on the same model (Pear), received a 'quote acknowledgement' email, but should be excluded from receiving the same 'Pear Tech' email they would have received in the 'brochure' journey. However, if this was a quote for an 'Orange' model, they should receive the 'Orange Tech' up-sell.

Exclusion scripts applied to the Tech Email in both journey's which haven't worked:

ROWCOUNT(LOOKUPROWS("ContactSendLog-UAT", "EmailAddress",emailaddr,"model", AttributeValue("model"),"EmailName","ALM_Tech")) > 0


ROWCOUNT(LOOKUPROWS("ContactSendLog-UAT", "EmailAddress", AttributeValue("EmailAddress"),"model", AttributeValue("model"),"EmailName", AttributeValue("EmailName"))) > 0


ROWCOUNT(LOOKUPROWS("ContactSendLog-UAT", "EmailAddress",emailaddr,"model", AttributeValue("model"))) > 0 AND AttributeValue("EmailName") == "ALM_Tech"

Not sure if it's even possible or if there's a better way to work around this?

P.S All send data are stored in data extensions and not synced with CRM, so journeys are working with individual form submit lists.

Answer 1

Salvara, here's one solution for you. Albeit, probably not the best.

Add your exclusion script logic to the email and confirm you get the expected results when performing a send preview.

If your unable to get the logic to work from an exclusion script, you can instead have the logic execute in the email and call RaiseError if the exclusion is true.

This should work, but not the best solution because SFMC will charge for the email send in this scenario even though no email was deployed.

Answer 2

I don't think you'd need an exclusion script to manage this if you're trying to avoid sending someone a specific message in a journey.

I would recommend creating a Data Extension with your Contact Key and a boolean field that designates whether the Contact has received your message or not. Make sure this Data Extension is connected in an Attribute Group in Data Designer so your Journey can see/modify this data.

Then, after a contact receives the message, the next step in the journey is to update the contact and change the evaluation field from FALSE to TRUE.

Each journey can then have a decision split that skips the particular shared email in question.

I think that would work as well or better than an exclusion script, because it might be simpler to understand for non-technical folks.

Answer 3

Thanks all for bouncing ideas. Found this worked on on exclusion scripts across different journeys, using 3 different web forms to collect details into three different sendable data extensions. Would only recommend this for temporary data / not managing contacts via audience builder (which would be optional to have as source of truth).

Updated the ContactSendLog DE to have the fields:

• SubscriberKey (Primary)
• EmailID (Latest Email Send ID / Nullable)
• model (Value = Pear in this eg / Nullable)
• EmailName (Latest Email Sent Name)
• SendDate (Current / Nullable)
• EmailAddress (Email Address in Send / Nullable)
• EmailMessage1 (Boolean / Nullable)
• EmailMessage2 (Boolean / Nullable)
• EmailMessage3 (Boolean / Nullable)

Updated the Exclusion Script to:

LOOKUPROWS("ContactSendLog-UAT", "EmailAddress",emailaddr,"model", AttributeValue("model"),"EmailMessage1",1)

The above script will check if that email address has already been sent the EmailMessage1.

Not using SubscriberKey as the same customer can sign up for a 'brochure' of multiple models, and receive EmailMessage1 for multiple models, but not the same one.

SubscriberKey is also logged as unique for every web form submission SubcriberKey = email@email.com0.12345 and Email = email@email.com.