Skip to content

Instantly share code, notes, and snippets.

Avatar

Adam Spriggs wvpv

100 followers · 43 following
View GitHub Profile
@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",
@wvpv
wvpv / ImportResultsSummary.csv
Created December 21, 2022 16:19
ImportResultsSummary Schema
View ImportResultsSummary.csv
FieldName DataType Length Precision Scale PrimaryKey Required
ClientID Number TRUE TRUE
ObjectID Text 100 TRUE TRUE
StartDate Date TRUE TRUE
EndDate Date TRUE TRUE
TaskResultID Text 100 FALSE FALSE
ImportDefinitionCustomerKey Text 100 FALSE FALSE
ImportType Text 100 FALSE FALSE
ImportStatus Text 100 FALSE FALSE
ID Number FALSE FALSE
@wvpv
wvpv / ImportResultsSummary.js
Last active December 21, 2022 16:21
Mirror ImportResultsSummary Data to a Data Extension
View ImportResultsSummary.js
<script runat="server" type="JavaScript">
Platform.Load("core", "1");
try {
var debug = false;
var prox = new Script.Util.WSProxy();
var DEKey = "ImportResultsSummary";
@wvpv
wvpv / auditevents.js
Last active December 21, 2022 15:01
Mirror AuditEvent Data to a Data Extension
View auditevents.js
<script runat="server" language="JavaScript">
Platform.Load("core","1");
var debug = false;
// Mirrors AuditEvent REST Object data into a data extension
// - Audit Event Log must be configured in the account first -- Email Studio > Admin > Security Settings > Enable Audit Trail Data Collection: Yes
// - creates its own data extension
// - docs: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/getAuditEvents.html
// - defaults to the past 30 days of events
@wvpv
wvpv / sfmc-ampscript-two-click-unsubscribe.html
Last active March 18, 2022 21:12
SFMC two-click unsubscribe page
View sfmc-ampscript-two-click-unsubscribe.html
<script runat="server" language="ampscript">
set @debug = 0
set @unsubscribeFromAll = RequestParameter("unsubscribeFromAll") /* append this in the CloudPagesURL function, if desired */
set @submitFlag = RequestParameter("submitFlag")
/* on page load (pre-submit) */
if empty(@submitFlag) then
/* retrieve values from encrypted qs parameter send context */
@wvpv
wvpv / sfmc-ssjs-clear-de-wsproxy.js
Created February 15, 2022 14:32
SFMC Clear a Data Extension using WSProxy
View sfmc-ssjs-clear-de-wsproxy.js
<script runat="server" language="javascript">
var prox = new Script.Util.WSProxy();
var DEKey = "YourDEKey";
var clearDEResponse = prox.performItem("DataExtension",{"CustomerKey": DEKey},"ClearData");
</script>
@wvpv
wvpv / sfmc-republish-triggers-by-folder.js
Created January 6, 2022 19:37
Republish Triggered Send Definitions recursively by folder
View sfmc-republish-triggers-by-folder.js
<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
View sfmc-republish-trigger-log.csv
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
View sfmc-triggeredsendsummary-soap-object-retrieve-to-de.js
<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