Skip to content

Instantly share code, notes, and snippets.

View wvpv's full-sized avatar

Adam Spriggs wvpv

View GitHub Profile
@wvpv
wvpv / file-upload-cb-processor.js
Created October 31, 2023 16:10
Content Builder File Upload Processor
View file-upload-cb-processor.js
<script runat="server" language="JavaScript">
Platform.Load("Core","1");
/* adapted from https://sfmarketing.cloud/2020/02/29/create-a-cloudpages-form-with-an-image-file-upload-option/ */
var results = {};
results.result = {};
results.debug = {};
results.error = {};
@wvpv
wvpv / file-upload-cb.html
Last active October 31, 2023 16:12
Content Builder File Upload
View file-upload-cb.html
<script runat="server" language="ampscript">
set @processingPageURL = "https://YOURTENANTHERE.pub.sfmc-content.com/YOURPATHHERE"
</script><!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width,initial-scale=1">
@wvpv
wvpv / isdst.amp
Created October 25, 2023 16:48
Check if date is DST with AMPscript
View isdst.amp
%%[
set @dateToCheck = "2023-10-25"
set @month = datepart(@dateToCheck, "M")
set @day = datepart(@dateToCheck, "D")
set @daysOfWeek = "SunMonTueWedThuFriSat"
set @dayOfWeekToFind = format(@dateToCheck,"ddd")
set @dayOfWeekNum = divide(add(indexof(@daysOfWeek,@dayOfWeekToFind),2),3)
@wvpv
wvpv / send_report.sql
Created August 9, 2023 17:30
Send Report
View send_report.sql
select
s.id JobID
, s.SentDate AT TIME ZONE 'Pacific Standard Time' as SentDate
, s.status JobStatus
, s.EmailName
, s.NumberTargeted Targeted
, s.NumberDelivered Delivered
, case
when isnull(s.NumberTargeted,0) = 0 then 0
else cast((s.NumberDelivered) as decimal(18,4)) / cast(s.NumberTargeted as decimal(18,4))
@wvpv
wvpv / JourneyJobs.sql
Created July 24, 2023 13:45
Journey Jobs
View JourneyJobs.sql
select
j.jobid
, j.emailName
, jn.journeyName
, max(jn.versionNumber) versionNumber
from _Job j
inner join (
select
convert(varchar(36), ja0.VersionID) VersionID /* UniqueIdentifier datatype doesnt play nicely with JO-INs */
@wvpv
wvpv / JourneyEmails.sql
Last active August 21, 2023 04:07
Journey Emails
View JourneyEmails.sql
select
left(convert(varchar(36), jn.VersionID),36) VersionID
, left(jn.JourneyName,100) JourneyName
, left(ja.ActivityName,100) ActivityName
, left(ja.JourneyActivityObjectID,36) JourneyActivityObjectID
from _Journey jn
inner join (
select
convert(varchar(36), ja0.VersionID) VersionID /* UniqueIdentifier datatype doesnt play nicely with JO-INs */
@wvpv
wvpv / assets.js
Created April 4, 2023 16:48
Content Builder Asset Inventory
View assets.js
<script runat="server" language="JavaScript">
Platform.Load("core","1");
var debug = false;
try {
var prox = new Script.Util.WSProxy();
var startTime = Now();
var timeoutMilliseconds = 1500000; // 25 minutes
@wvpv
wvpv / NotSent_Tracking.csv
Created January 17, 2023 16:18
Not Sent Tracking Schema
View NotSent_Tracking.csv
FieldName DataType Length Precision Scale PrimaryKey Required DefaultValue
ClientID Number TRUE TRUE
SendID Number TRUE TRUE
SubscriberKey Text 254 TRUE TRUE
EmailAddress EmailAddress FALSE FALSE
SubscriberID Number TRUE TRUE
ListID Number TRUE TRUE
EventDate Date TRUE TRUE
EventType Text 10 FALSE FALSE
BatchID Number TRUE TRUE
@wvpv
wvpv / short.io.postman_collection.json
Created December 28, 2022 16:43
Short.io Postman Collection Export
View short.io.postman_collection.json
{
"info": {
"_postman_id": "7526dd49-78b6-4589-a640-fe7b879ef751",
"name": "Short.io",
"schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json",
"_exporter_id": "407776"
},
"item": [
{
"name": "Shorten URL",