Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Is it possible to have 1 delivery with multiple cell codes and have tracking parameters for each of those cell codes?

madisonditullio
Level 1
Level 1

Hi all!

We are currently trying to figure out a way to track all cell codes, or campaign codes with just one delivery. Right now when we set up a campaign we normally have to set up multiple deliveries if there are more than 1 cell code for our team to later track the open rates and any reporting that they want done to an individual cell code.

Is it possible to just set up one delivery and have all those cell codes or campaign codes and create a custom reporting workflow that will automatically give all those reporting details to those separate cell codes or campaign codes with just one delivery step in the workflow?

1 Accepted Solution
MarcelSzimonisz
Correct answer by
Community Advisor
Community Advisor

Hello @madisonditullio,

you can do it but with use of split

  • Use Split activity
  • Set up your workflow like so: all Subset going to empty java script activity used here as flow through

MarcelSzimonisz_2-1628264269114.png

 

  • Add segment code to each subset of a split

MarcelSzimonisz_1-1628264227488.png

  • In delivery 'Object modification' script add

 

 

 

 

  var getSegmentName = function(name){
    if( name === undefined)
      logError("Argument 'name' is required."); 
    
    try{
      var res = sqlSelect("targetData,@" + name + ":string",
          "select " + name + " from " + vars.tableName + " GROUP BY " + name);
      return res.targetData[0]['@'+ name].toString();
    }catch(e){
      logWarning("Segment name '" + name + "' does not exist in the targeting table.");
      return false;
    }
  }
  
  delivery.deliveryCode = delivery.deliveryCode + '_' + getSegmentName('sSegmentCode'); 
  
  logError(delivery.deliveryCode);

 

 

 

 

@segmentCode is in SQL temporary table saved as sSegmentCode

 

 

 

Result:

MarcelSzimonisz_0-1628264954845.png

 


Enjoy!

 

Marcel

 

View solution in original post

2 Replies
MarcelSzimonisz
Correct answer by
Community Advisor
Community Advisor

Hello @madisonditullio,

you can do it but with use of split

  • Use Split activity
  • Set up your workflow like so: all Subset going to empty java script activity used here as flow through

MarcelSzimonisz_2-1628264269114.png

 

  • Add segment code to each subset of a split

MarcelSzimonisz_1-1628264227488.png

  • In delivery 'Object modification' script add

 

 

 

 

  var getSegmentName = function(name){
    if( name === undefined)
      logError("Argument 'name' is required."); 
    
    try{
      var res = sqlSelect("targetData,@" + name + ":string",
          "select " + name + " from " + vars.tableName + " GROUP BY " + name);
      return res.targetData[0]['@'+ name].toString();
    }catch(e){
      logWarning("Segment name '" + name + "' does not exist in the targeting table.");
      return false;
    }
  }
  
  delivery.deliveryCode = delivery.deliveryCode + '_' + getSegmentName('sSegmentCode'); 
  
  logError(delivery.deliveryCode);

 

 

 

 

@segmentCode is in SQL temporary table saved as sSegmentCode

 

 

 

Result:

MarcelSzimonisz_0-1628264954845.png

 


Enjoy!

 

Marcel

 

View solution in original post

Sukrity_Wadhwa
Employee
Employee

Hi @madisonditullio,

 

Were you able to resolve this query with the help of the given solution or do you still need more help here? Do let us know.


Thanks!