Query to find profiles without consent for CASL

Prepare to Remove Marketing permissions for those without consent

Query for profiles without Express Consent Mailer Records:

The summary of your query will look like this:

*** Profile Level 3 Filter Number 1 _____________________
(Profile Type [Leisure,Corporate])
AND (Profile Status Is Equal to Active)
AND (Activity Filter Type: Does NOT Have Any Activity Records with the following criteria)
(Mailers (All))
AND (Subject Contains "Express Consent")

Use a level 3 profile query. Click "Add Filter". On the General info Tab select Leisure and Corporate under profile type.

Move to the Activities Tab. Select Filter type: "Does NOT Have Any Activity Records with the following criteria" and select Activity Type: "Mailer". Scroll to the bottom and in the Subject line select "contains" and add "Express Consent" in the next field to the right. Click "OK" to save the filter.