Skip to main content
I am new to marketing cloud and need to understand what does the each of the below component mean in the exclsuion sript.

 

ROWCOUNT(LOOKUPROWS("Exclusion_DATA_EXTENSION_NAME","EMAIL_ADDR_FIELD_NAME", EMAILADDR))>0
3 answers
  1. Nov 18, 2025, 4:55 PM

    @Nupur Jain

     

    What the whole script does

    It checks whether the subscriber’s email address exists in the exclusion Data Extension. If ROWCOUNT(...) > 0, then the subscriber is found in the exclusion DE and should be excluded from the send.

     

    Breakdown of the components

    ComponentMeaning 

    LOOKUPROWS() | Searches a Data Extension for rows that match a specific field and value. Returns all matching rows. 

    "Exclusion_DATA_EXTENSION_NAME" | The name of the Data Extension being checked. This is where exclusion records are stored. 

    "EMAIL_ADDR_FIELD_NAME" | The column in the Data Extension to compare (e.g., EmailAddress). 

    EMAILADDR | The value being checked — usually the subscriber's email sent in the context of a send. 

    ROWCOUNT() | Counts how many rows the LOOKUPROWS function returned. 

    > 0 | Checks if the count is greater than zero (meaning at least one match exists).

0/9000