SSJS: Day 17 focused on Resource

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>        
Shashi Prasad

Solutions Architect | SFMC Engagement | Data Cloud | MCP

2y

Why don’t scientist trust atoms ? Because they made up everything ! 🙏

Like
Reply
Aayush Kukreti

Senior Software Engineer at Globant | Salesforce Developer | 4x Salesforce Certified | Trailhead Ranger

2y

Great work, thanks for sharing! Is there a limitation on number of records retrieved?

Charlie Fay

Salesforce Marketing Cloud Architect | Automation Expert | CRM Manager | Developer | Blogger | Marketing Champion 2020-24 🏆

2y

Did chatGPT write this?

Nitin Kumar

4X Certified | Salesforce Marketing Cloud Consultant in Tata Consultancy Services

2y

Grt effort

To view or add a comment, sign in

Others also viewed

Explore topics