SFMC all subscribers in all business units
select | |
s.SubscriberID | |
, s.SubscriberKey | |
, s.Status | |
, s.EmailAddress | |
, s.DateUnsubscribed | |
, s.DateJoined | |
, s.DateUndeliverable | |
, b.businessUnitMID | |
, b.businessUnitName | |
from _subscribers s | |
outer apply ( | |
select 1 businessUnitMID, 'Business Unit Name 1' businessUnitName union all | |
select 2 businessUnitMID, 'Business Unit Name 2' businessUnitName union all | |
select 3 businessUnitMID, 'Business Unit Name 3' businessUnitName union all | |
select 4 businessUnitMID, 'Business Unit Name 4' businessUnitName union all | |
select 5 businessUnitMID, 'Business Unit Name 5' businessUnitName | |
) b | |
/* name: subscribers_all */ | |
/* target: subscribers_all */ | |
/* action: overwrite */ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment