Skip to main content
Topics#Marketing CloudPregunta de Taylor Thomas
Taylor Thomas preguntó en #Marketing Cloud
Ayer, 15:06

Supressing contacts from data extension

I pulled a list of unengaged subscribers that have not opened at least one of our last 3 monthly sends. I want to suppress these contacts from our filtered data extension which we use to send to. How do I do this? And how would I keep this automated to continuously remove unegaged contacts. 

 

#Marketing Cloud  #Filter Data Extension

1 respuesta
  1. Digbijaya Paikaray (CONFIDENTIAL)
    Hoy, 08:36

    Hi Taylor,

     

    The most robust, automated way to handle this in Marketing Cloud is using Automation Studio with a SQL Query Activity or by using an Exclusion/Suppression List at send time.

     

    Here are the two industry-standard approaches depending on how your sends are orchestrated:

     

    Option 1: Automation Studio + SQL Query (Recommended for Ongoing Automation)

    Instead of manually maintaining a filtered Data Extension (DE), let Automation Studio calculate the sendable list on a daily or monthly schedule.

     

    1. Create a "Sendable" Data Extension

     

    • Create a DE that contains the subscribers eligible to receive the newsletter (e.g., Monthly_Newsletter_Audience).

     

    2. Write a SQL Query Activity

     

    • Query your master audience and use a LEFT JOIN or NOT EXISTS against the _Open Data View for the past 90 days (3 months):

     

    SQL

     

    SELECT 
        m.SubscriberKey,
        m.EmailAddress
    FROM [Your_Master_Sendable_DE] m
    WHERE NOT EXISTS (
        SELECT 1 
        FROM _Open o
        JOIN _Job j ON o.JobID = j.JobID
        WHERE o.SubscriberKey = m.SubscriberKey
          AND j.EmailName IN ('Monthly_Send_1', 'Monthly_Send_2', 'Monthly_Send_3') -- or filter by Category/Date
          AND o.EventDate >= DATEADD(month, -3, GETDATE())
          AND o.IsUnique = 1
    )

    3. Automate in Automation Studio

     

    • Build a scheduled automation:
      • Step 1: SQL Query (Data Action: Overwrite to your Monthly_Newsletter_Audience DE).
      • Step 2: Trigger your Email Send or Journey.

     

    Option 2: Use an Auto-Suppression Configuration or Send-Time Exclusion

    If you prefer to keep your existing Filtered Data Extension as-is and simply suppress those unengaged contacts at the moment of send:

     

    • Send-Time Exclusion:
      1. Store your unengaged subscribers in a dedicated DE (e.g., Unengaged_Suppression_DE).
      2. In your Email Send Definition or Journey Builder Email Activity, expand Delivery Options.
      3. Select Unengaged_Suppression_DE in the Exclusion List / Exclusion Script field.
    • Auto-Suppression List (Account-Wide):
      • If you never want these unengaged subscribers receiving any commercial email, go to Email Studio > Subscribers > Auto-Suppression Lists, create a list, and populate it via an Automation Studio query.
Escribir una respuesta...
0/9000