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?
Solved! Go to Solution.
Views
Replies
Total Likes
Hello @madisonditullio,
you can do it but with use of split
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:
Enjoy!
Marcel
Hello @madisonditullio,
you can do it but with use of split
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:
Enjoy!
Marcel
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!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies