Skip to content

Instantly share code, notes, and snippets.

@marketingclouded

marketingclouded/Calculates Subscriber_Last_Open with DateDiff

Created September 23, 2020 20:44
Show Gist options
  • Save marketingclouded/cd4c68803493ff0633da57293888a45e to your computer and use it in GitHub Desktop.
Save marketingclouded/cd4c68803493ff0633da57293888a45e to your computer and use it in GitHub Desktop.
Download ZIP
Tracking Inactive Subscribers in SFMC: Calculates Subscriber_Last_Open with DateDiff
Raw
Calculates Subscriber_Last_Open with DateDiff
Select SubscriberID,
DateDiff(day,LastOpenDate,LastSentDate) AS 'DateDiff'
FROM Subscriber_Last_Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment