Skip to content

Instantly share code, notes, and snippets.

Avatar

Adam Spriggs wvpv

View GitHub Profile
@wvpv
wvpv / sfmc_sql_subscribers_all_summary.sql
Created Jan 27, 2021
Summary of subscriber statuses by business unit
View 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
@wvpv
wvpv / sfmc_sql_subscribers_all_unsubs.sql
Created Jan 26, 2021
SFMC unsubscribes per business unit
View sfmc_sql_subscribers_all_unsubs.sql
select
u.BusinessUnitID businessUnitMID
, u.SubscriberKey
, u.subscriberId
, 'unsubscribed' Status
, u.UnsubDateUTC DateUnsubscribed
, case
when u.businessUnitID = 1 then 'Business Unit Name 1'
when u.businessUnitID = 2 then 'Business Unit Name 2'
when u.businessUnitID = 3 then 'Business Unit Name 3'
@wvpv
wvpv / sfmc_sql_subscribers_all.sql
Created Jan 26, 2021
SFMC all subscribers in all business units
View sfmc_sql_subscribers_all.sql
select
s.SubscriberID
, s.SubscriberKey
, s.Status
, s.EmailAddress
, s.DateUnsubscribed
, s.DateJoined
, s.DateUndeliverable
, b.businessUnitMID
, b.businessUnitName
View sfmc-ampscript-baby-shark-multiple-concat-loop.amp
%%[
set @s = buildrowsetfromstring("Baby shark|Mommy shark|Daddy shark|Grandma shark|Grandpa shark|Let's go hunt|Run away|Safe at last|It's the end","|")
set @d=", doo doo doo doo doo doo"
set @n=char(10)
for @v=1 to 9 do
set @r = row(@s,@v)
set @f = field(@r,1)
outputline(concat(@f,@d,@n,@f,@d,@n,@f,@d,@n,@f,"!"))
View sfmc-ampscript-baby-shark-string-concat-loop.amp
%%[
set @s=buildrowsetfromstring("Baby shark|Mommy shark|Daddy shark|Grandma shark|Grandpa shark|Let's go hunt|Run away|Safe at last|It's the end","|")
for @v=1 to 9 do
for @l=1 to 4 do
set @r = row(@s,@v)
set @f = field(@r,1)
View sfmc-ampscript-baby-shark-string-char-loop.amp
%[
set @s = "Baby shark|Mommy shark|Daddy shark|Grandma shark|Grandpa shark|Let's go hunt|Run away|Safe at last|It's the end|"
for @i=1 to 112 do
set @c = substring(@s,@i,1)
if @c == "|" then
View sfmc-ampscript-baby-shark-double-loop-string-parse.amp
%%[
set @s = "Baby shark|Mommy shark|Daddy shark|Grandma shark|Grandpa shark|Let's go hunt|Run away|Safe at last|It's the end|"
for @v=1 to 9 do
set @f = substring(@s,1,add(indexOf(@s,"|"),-1))
set @s = replace(@s,concat(@f,"|"))
for @l=1 to 4 do
View sfmc-ampscript-baby-shark-single-loop-mod-math.amp
%%[
set @s = buildrowsetfromstring("Baby shark|Mommy shark|Daddy shark|Grandma shark|Grandpa shark|Let's go hunt|Run away|Safe at last|It's the end","|")
for @v=1 to 36 do
set @l=substring(add(divide(add(@v,-1),4),1),1,1)
set @r = row(@s,@l)
set @f = field(@r,1)
View sfmc-ampscript-baby-shark-single-loop-mod.amp.amp
%%[
set @l = 0
set @s = buildrowsetfromstring("Baby shark|Mommy shark|Daddy shark|Grandma shark|Grandpa shark|Let's go hunt|Run away|Safe at last|It's the end","|")
for @v=1 to 36 do
set @m=mod(@v,4)
set @l=add(@l,iif(@m==1,1,0))
View sfmc-ampscript-baby-shark-260-uncompressed.amp
%%[
set @s = buildrowsetfromstring("Baby shark|Mommy shark|Daddy shark|Grandma shark|Grandpa shark|Let's go hunt|Run away|Safe at last|It's the end","|")
for @v=1 to 9 do
for @l=1 to 4 do
set @r = row(@s,@v)
set @f = field(@r,1)