SSJS: Day 17 focused on Resource
Write an SSJS Script to retrieve tracking information from a business unit
<script runat="server" language="Javascript">
Platform.Load("Core","1");
try{
var filter={
Property:"CustomerKey"
,SimpleOperator:"equals"
,Value:"XXXX-XXXX-XXX-XXX-XXXXXXX"
};
var acctTracking = Account.Tracking.Retrieve(filter);
//Write(Stringify(acctTracking));
Write('\n \n Write Tracking information about the account :\n \n');
var trackingDE = DataExtension.Init("Tracking");
for(var i=0;i<acctTracking.length;i++)
{
Write("Sends : \n");
Write("\t \t Total :" + acctTracking[i].Sends.Total +"\n");
Write("Bounces : \n");
Write("\t \t Total :" + acctTracking[i].Bounces.Total +"\n");
Write("\t \t HardBounces :" + acctTracking[i].Bounces.HardBounces +"\n");
Write("\t \t SoftBounces :" + acctTracking[i].Bounces.SoftBounces +"\n");
Write("\t \t BlockBounces :" + acctTracking[i].Bounces.BlockBounces +"\n");
Write("\t \t TechnicalBounces :" + acctTracking[i].Bounces.TechnicalBounces +"\n");
Write("\t \t UnknownBounces :" + acctTracking[i].Bounces.UnknownBounces +"\n");
Write("Clicks : \n");
Write("\t \t Total :" + acctTracking[i].Clicks.Total +"\n");
Write("\t \t Unique :" + acctTracking[i].Clicks.Unique +"\n");
Write("Opens : \n");
Write("\t \t Total :" + acctTracking[i].Opens.Total +"\n");
Write("\t \t Unique :" + acctTracking[i].Opens.Unique +"\n");
Write("Unsubscribes : \n");
Write("\t \t Unique :" + acctTracking[i].Unsubscribes.Unique +"\n");
//Store the details into a data extension
trackingDE.Rows.Add(
{
TotalSends:acctTracking[i].Sends.Total
,HardBounces:acctTracking[i].Bounces.HardBounces
,SoftBounces:acctTracking[i].Bounces.SoftBounces
,BlockBounces:+acctTracking[i].Bounces.BlockBounces
,TechnicalBounces: acctTracking[i].Bounces.TechnicalBounces
,TotalClicks:acctTracking[i].Clicks.Total
,UniqueClicks:acctTracking[i].Clicks.Unique
,TotalOpens:acctTracking[i].Opens.Total
,UniqueOpens:acctTracking[i].Opens.Unique
,Unsubscribes:acctTracking[i].Unsubscribes.Unique
}
);
}
}
catch(ex){
Write(ex.message);
}
</script>
Solutions Architect | SFMC Engagement | Data Cloud | MCP
2yWhy don’t scientist trust atoms ? Because they made up everything ! 🙏
Senior Software Engineer at Globant | Salesforce Developer | 4x Salesforce Certified | Trailhead Ranger
2yGreat work, thanks for sharing! Is there a limitation on number of records retrieved?
Salesforce Marketing Cloud Architect | Automation Expert | CRM Manager | Developer | Blogger | Marketing Champion 2020-24 🏆
2yDid chatGPT write this?
4X Certified | Salesforce Marketing Cloud Consultant in Tata Consultancy Services
2yGrt effort