Skip to content

Instantly share code, notes, and snippets.

View katydorjee's full-sized avatar
🤩

Karma Tsering Dorjee katydorjee

🤩
22 followers · 5 following
View GitHub Profile
@katydorjee
katydorjee / Get Email bounce data of a Journey builder email sent.sql
Created October 20, 2025 00:27
Get Email bounce data of a Journey builder email sent
SELECT su.emailaddress,
su.subscriberkey AS ContactKey,
j.journeyname,j.versionnumber,ja.activityname AS EmailName,
s.eventdate AS SendTime, s.jobid, s.listid,
b.eventdate AS BounceTime, b.BounceType,b.SMTPBounceReason, b.SMTPMessage, b.SMTPCode
FROM [_sent] AS s
INNER JOIN [_journeyactivity] AS ja
ON s.triggerersenddefinitionobjectid = ja.journeyactivityobjectid
INNER JOIN [_journey] AS j
ON ja.versionid = j.versionid
@katydorjee
katydorjee / SSJS to delete record from publication list.js
Created September 8, 2025 04:07
SSJS to delete record from publication list
<script runat="server">
Platform.Load("core","1.1.1");
var subkey = "SubscriberKey"
var email = "[email protected]"
var api = new Script.Util.WSProxy();
var sub = [
{
SubscriberKey: subkey,
EmailAddress: email,
@katydorjee
katydorjee / ssjs to update all subscribers.js
Created August 20, 2025 11:43
ssjs to update all subscribers
<script runat="server">
Platform.Load("core","1.1");
var prox = new Script.Util.WSProxy();
var de = DataExtension.Init("my_data_extension");
var data = de.Rows.Retrieve();
for (var i = 0; i < data.length; i++) {
var row = data[i];
try {
var subscriber = {
@katydorjee
katydorjee / Updating Data Extension Records Using SSJS in SFMC.js
Created May 20, 2025 12:06
Updating Data Extension Records Using SSJS in SFMC
<script runat="server">
Platform.Load("core", "1");
try {
var de = DataExtension.Init("DataExtensionExkey");
var payload = {
@katydorjee
katydorjee / SQL Query to Convert from CST to AEST or AEDT.sql
Created April 9, 2025 02:51
SQL Query to Convert from CST to AEST or AEDT
SELECT
CASE
/* Check if the current date is between the first Sunday of October and the first Sunday of April (AEDT period) */
WHEN GETDATE() >=
/* First Sunday in October */
DATEADD(DAY, 1 - DATEPART(WEEKDAY, DATEFROMPARTS(YEAR(GETDATE()), 10, 1)) + 7 * (1), DATEFROMPARTS(YEAR(GETDATE()), 10, 1))
AND GETDATE() <
/* First Sunday in April */
DATEADD(DAY, 1 - DATEPART(WEEKDAY, DATEFROMPARTS(YEAR(GETDATE()), 4, 1)) + 7 * (1), DATEFROMPARTS(YEAR(GETDATE()), 4, 1))
THEN DATEADD(HOUR, 17, GETDATE()) /* AEDT (UTC+11) */
@katydorjee
katydorjee / UTC Date in AMPscript.html
Created June 23, 2024 21:24
UTC Date in AMPscript
%%[
var @systemDate, @utcDate
set @systemDate = Now()
set @utcDate = DateParse(@systemDate,1)
]%%
UTC Date: %%=v(@utcDate)=%%
@katydorjee
katydorjee / Remove subscriber from Auto Suppression List.js
Created May 16, 2024 04:46
Remove subscriber from Auto Suppression List
<script runat="server">
Platform.Load("Core","1.1.1");
var autoSuppressionExternalKey = "AutoSuppressionExternalKey";
var SubscriberstoRemoveFromAutoSuppressionList = "Data_Extension_ExternalKey";
var deleteRecords = DataExtension.Init(SubscriberstoRemoveFromAutoSuppressionList);
var data = deleteRecords.Rows.Retrieve();
for (var i=0; i < data.length; i++) {
var emailAddress = data[i].Email;
var deleteRow = Platform.Function.DeleteData(autoSuppressionExternalKey,['Email Address'],[emailAddress]);
@katydorjee
katydorjee / A script to run an automation in a child BU from another child BU.html
Created March 1, 2024 00:35
A script to run an automation in a child BU from another child BU.
/*
##To initiate an automation from one child business unit (BU) to another or from a child BU to a parent BU.
#1. Run the following Script in the parent BU and obtain the ObjectID of the automation in the child BU.
*/
<script runat="server">
Platform.Load("core","1.1.1");
var prox = new Script.Util.WSProxy();
var MID = 10000000000;
@katydorjee
katydorjee / Select Auto-Suppression list using SQL Query.sql
Created February 29, 2024 10:51
Select Auto-Suppression list using SQL Query
SELECT status, [Date Added], [Email Address] from [Global Suppression List]
/* ------------
You can find the Auto-Suppression list in:
--Email Studio > Email > Admin > Send Management > Auto-Suppression list > [Your list name]
In above query [Global Suppression List] is an example of list created in Auto-Suppression list
*/
@katydorjee
katydorjee / Logging SSJS errors on the client side.js
Last active February 16, 2024 05:55
Logging SSJS errors on the client side.
<script runat="server">
var isDebug = true;
try {
var a = 1;
var b = "six";
var result = 1 / b;
if(isDebug)
Write('<script>console.log("result: ' + result + '")</script>');