Skip to content

Instantly share code, notes, and snippets.

@wvpv

wvpv/sfmc_sql_subscribers_all_summary.sql

Created January 27, 2021 00:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wvpv/b75f9fb3943b6739fa6005e6e8bf62e5 to your computer and use it in GitHub Desktop.
Save wvpv/b75f9fb3943b6739fa6005e6e8bf62e5 to your computer and use it in GitHub Desktop.
Download ZIP
Summary of subscriber statuses by business unit
Raw
sfmc_sql_subscribers_all_summary.sql
select
s.businessUnitMID
, s.businessUnitName
, s.status
, count(*) count
from subscribers_all s
group by
s.businessUnitMID
, s.businessUnitName
, s.status
/* name: subscribers_all_summary */
/* target: subscribers_all_summary */
/* action: overwrite */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment