Dennis of Marketing Cloud Team
4/13/2018 - 1:15 PM

SQL - Hardbouncers

Selects the hard bouncers from the _Bounce data view. Requirements:

  • Access to _Bounce data view
  • Data extenstion with SubscriberKey (nvar 254) & BounceDate (Date)
SELECT b.SubscriberKey, b.EventDate AS BounceDate
From _Bounce as b
Inner join _Subscribers as s on s.SubscriberID=b.SubscriberID
        where b.IsUnique=1
        and DateDiff(day, b.EventDate,GetDate()) = 4
        and s.status = 'held'