Skip to content

Instantly share code, notes, and snippets.

View wvpv's full-sized avatar

Adam Spriggs wvpv

123 followers · 49 following
View GitHub Profile
@wvpv
wvpv / sfmc-republish-triggers-by-folder.js
Created January 6, 2022 19:37
Republish Triggered Send Definitions recursively by folder
<script runat="server">
Platform.Load("core","1");
var debug = false;
var logDE = DataExtension.Init("republish_trigger_log");
try {
/* CONFIG */
var parentCategoryID = 1264; // Triggered Sends
@wvpv
wvpv / sfmc-republish-trigger-log.csv
Created January 6, 2022 19:35
SFMC Republish Trigger script log
FieldName DataType Length Precision Scale PrimaryKey Required DefaultValue
TriggeredSendCustomerKey Text 36 FALSE FALSE
Key Text 100 FALSE FALSE
Value Text FALSE FALSE
insertedDate Date FALSE FALSE getDate()
@wvpv
wvpv / sfmc-triggeredsendsummary-soap-object-retrieve-to-de.js
Created December 28, 2021 15:46
Retrieve TriggeredSendSummary SOAP object data and write to a Data Extension
<script runat="server">
Platform.Load("core","1");
var debug = false;
try {
var prox = new Script.Util.WSProxy();
// credit Jason Hanshaw: https://salesforce.stackexchange.com/questions/178299/setup-an-email-notification-to-admin-when-triggered-sends-exceed-a-level-of-500/230406#230406
@wvpv
wvpv / TriggeredSendSummary.csv
Created December 28, 2021 15:40
SFMC TriggeredSendSummary SOAP Object schema
FieldName DataType Length Precision Scale PrimaryKey Required DefaultValue
Client_ID Number TRUE TRUE
TriggeredSendDefinition_ObjectID Text 36 TRUE TRUE
ObjectID Text 36 TRUE TRUE
Name Text 100 TRUE TRUE
CustomerKey Text 36 TRUE TRUE
seq Number TRUE TRUE
SenderProfile_Name Text 100 FALSE FALSE
SendClassification_Name Text 100 FALSE FALSE
RowObjectID Text 36 FALSE FALSE
@wvpv
wvpv / sfmc_sql_subscribers_all_summary.sql
Created January 27, 2021 00:00
Summary of subscriber statuses by business unit
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 January 26, 2021 23:57
SFMC unsubscribes per business unit
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 January 26, 2021 23:53
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
@wvpv
wvpv / sfmc-ampscript-baby-shark-multiple-concat-loop.amp
Created October 26, 2020 22:09
%%[
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,"!"))
@wvpv
wvpv / sfmc-ampscript-baby-shark-string-concat-loop.amp
Created October 26, 2020 22:09
%%[
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)
@wvpv
wvpv / sfmc-ampscript-baby-shark-string-char-loop.amp
Created October 26, 2020 22:07
%[
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