Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

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

Avatar

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

Avatar

Correct answer by
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

Avatar

Correct answer by
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

 

Avatar

Administrator

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!



Sukrity Wadhwa