Skip to content

Instantly share code, notes, and snippets.

@marketingclouded

marketingclouded/Updates Account_Health_Monthly w ActiveSubscribers

Created September 23, 2020 19:55
Show Gist options
  • Save marketingclouded/6b79a422980c1ee008d420639a75e234 to your computer and use it in GitHub Desktop.
Save marketingclouded/6b79a422980c1ee008d420639a75e234 to your computer and use it in GitHub Desktop.
Download ZIP
Tracking SFMC Account Health: Updates Account_Health_Monthly w ActiveSubscribers
Raw
Updates Account_Health_Monthly w ActiveSubscribers
SELECT e.ActiveSubscribers, d.Month
FROM Account_Health_Daily e
INNER JOIN Account_Health_Monthly d
ON d.MonthStamp = e.DateStamp
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment