View NotSent_Tracking.csv
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
View short.io.postman_collection.json
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"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", |
View ImportResultsSummary.csv
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
View ImportResultsSummary.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<script runat="server" type="JavaScript"> | |
Platform.Load("core", "1"); | |
try { | |
var debug = false; | |
var prox = new Script.Util.WSProxy(); | |
var DEKey = "ImportResultsSummary"; |
View auditevents.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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 |
View sfmc-ampscript-two-click-unsubscribe.html
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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 */ |
View sfmc-ssjs-clear-de-wsproxy.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<script runat="server" language="javascript"> | |
var prox = new Script.Util.WSProxy(); | |
var DEKey = "YourDEKey"; | |
var clearDEResponse = prox.performItem("DataExtension",{"CustomerKey": DEKey},"ClearData"); | |
</script> | |
View sfmc-republish-triggers-by-folder.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<script runat="server"> | |
Platform.Load("core","1"); | |
var debug = false; | |
var logDE = DataExtension.Init("republish_trigger_log"); | |
try { | |
/* CONFIG */ | |
var parentCategoryID = 1264; // Triggered Sends |
View sfmc-republish-trigger-log.csv
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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() |
View sfmc-triggeredsendsummary-soap-object-retrieve-to-de.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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 |
NewerOlder