Skip to content

Instantly share code, notes, and snippets.

@marketingclouded

marketingclouded/Create Filter Criteria for Inactive_Subscribers

Created September 23, 2020 20:45
Show Gist options
  • Save marketingclouded/4dbf88ec11dd88cf65785dd5c661e324 to your computer and use it in GitHub Desktop.
Save marketingclouded/4dbf88ec11dd88cf65785dd5c661e324 to your computer and use it in GitHub Desktop.
Download ZIP
Tracking Inactive Subscribers in SFMC: Create Filter Criteria for Inactive_Subscribers
Raw
Create Filter Criteria for Inactive_Subscribers
SELECT *
FROM Subscriber_Last_Open
WHERE LastOpenDate < DATEADD(d,-90,GETDATE()) AND Status = 'Active'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment