Creating a Standard Supression using Promotions

Several folks at the conference mentioned that they had created standard supressions in Extraction Manager based on whether a patron had received /opened e-mails within a particular time frame. Can someone share with me the criteria used for this?

Thanks! 

  • Reynaldi,

    I am sure folks will jump in with the ways they are doing this and here is at least a start for you in the meantime. The second example assumes you are using one of our integrated email partners to track the opens and click throughs.  You may need to check with your colleagues about what values to use for some of the dropdowns depending on your setup.


    First, add a media criterion to the criteria list.  In T_KEYWORD add a row with the following values (accept the default on the rest):

    • Description: Promotion Media
    • Data Type: String
    • Detail Tbl: vs_promotion [this is case sensitive so make sure it is lowercase]
    • Detail Col: !.media_type
    • Ref Tbl: VRS_MEDIA_TYPE
    • Ref Idcol: id
    • Ref Desccol: description
    • Category: Promotions
    • Use for list: List Only
    • Keyword Desc: The media used for a promotion.

    To suppress constituents that have received an email in the last 7 days put the following criteria in the segment:

    Promotion Media IN [Select all email media types]
    Promotion Date <= DayRunDate -7 [Select from the dropdown Report Run Date +/- n Days, replace +/- n with -7]

    To suppress that have opened/clicked through an email in the last 7 days put in the following criteria:

    Promotion Media IN [Select all email media types]
    Promotion Response Date <= DayRunDate -7 [Select from the dropdown Report Run Date +/- n Days, replace +/- n with -7]
    Promotion Response IN Click Through, Opened Email, Trans Processed [This gets everyone who opened, clicked or made an order from emails]

    In either case if you are using this as a suppression you may want to consider in the Replace Individuals tab in the criteria set selecting Replace individual with household and add all primary affiliates [if you are on v12.1].

    Any time a new email media is added the suppression should be updated to be included. 

    Best,

    Anna