Skip to content

Instantly share code, notes, and snippets.

@marketingclouded

marketingclouded/Overwrites Account_Health_Monthly w Account_Health_Daily

Created September 23, 2020 19:54
Show Gist options
  • Save marketingclouded/97a982337ca98dadd96ab5884b315e8b to your computer and use it in GitHub Desktop.
Save marketingclouded/97a982337ca98dadd96ab5884b315e8b to your computer and use it in GitHub Desktop.
Download ZIP
Tracking SFMC Account Health: Overwrites Account_Health_Monthly w Account_Health_Daily
Raw
Overwrites Account_Health_Monthly w Account_Health_Daily
SELECT
Month,
SUM(SentCount) AS 'Sent',
SUM(NewSubscribers) AS 'NewSubscribers',
SUM(Unsubscribes) AS 'Unsubscribes',
SUM(BounceCount) AS 'Bounces',
SUM(NewSubscribers) - SUM(Unsubscribes) AS 'NetGrowth',
MIN(DateStamp) AS 'MonthStamp'
FROM Account_Health_Daily
GROUP BY Month
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment