Can you use a variable / target data in a delivery label? | Adobe Higher Education
Skip to main content
P
PaulWotton
Level 2
March 24, 2022
해결됨

Can you use a variable / target data in a delivery label?

  • March 24, 2022
  • 2 답변들
  • 3135 조회

We have two groups of customers who are being emailed the same html, so it make sense to send them the same email delivery that contains this html. But we want to track the email engagement of each group separately. To achieve this we currently create two email deliveries with two different delivery labels and then load the same html into both deliveries. Is there any way to use just one email delivery but to pass through a variable for each group into the delivery label? 

 

Thanks.

 

이 주제는 답변이 닫혔습니다.
최고의 답변: Marcel_Szimonisz

Hello @paulwotton,

you can change the delivery label, or delivery code depending on any shared date in your segment coming from the targetData. It is undocumented feature but works since forever. 

  • split your target in any segments with split add your segment code to the segment code section in split
  • feed all the transitions into empty JS script activity
  • connect JS activity with you delivery activity, that is under the 'folder tree icon' 

       

 

  • in delivery modification script query your segment code from the target data to make delivery of same content but differentiate with delivery code or label or anything you that is required

       

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;
    }
}
var mySegment = getSegmentName("sSegmentCode");
delivery.deliveryCode = delivery.deliveryCode + mySegment;
delivery.label = delivery.label + mySegment;

//do not forget establish the link as for this type of activity link is not created automatically
delivery.operation_id = instance.operation_id;
delivery.workflow_id = instance.id;

 

Notes:

 

When you run this workflow it will create as many deliveries as many split transitions you have created.

 

Your workflow should end up looking like:

Segments are set in split as follwing:

 

SQL fields:

The SQL field names you want to add to the delivery can be found when you explore the population schema in your workflow.

 

Marcel Szimonisz

MarTech Consultant
for more tips visit my blog
https://www.martechnotes.com/

2 답변

DavidKangni
Community Advisor
DavidKangniCommunity Advisor
Community Advisor
March 24, 2022

Hi Paul, 

Not OOTB, but you can add a segment code to your broadLogRcp schema to collect segment code created during your workflow and use this segment code to group by in your engagement report.

 

Thanks,

David

David Kangni
Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity Advisor답변
Community Advisor
March 30, 2022

Hello @paulwotton,

you can change the delivery label, or delivery code depending on any shared date in your segment coming from the targetData. It is undocumented feature but works since forever. 

  • split your target in any segments with split add your segment code to the segment code section in split
  • feed all the transitions into empty JS script activity
  • connect JS activity with you delivery activity, that is under the 'folder tree icon' 

       

 

  • in delivery modification script query your segment code from the target data to make delivery of same content but differentiate with delivery code or label or anything you that is required

       

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;
    }
}
var mySegment = getSegmentName("sSegmentCode");
delivery.deliveryCode = delivery.deliveryCode + mySegment;
delivery.label = delivery.label + mySegment;

//do not forget establish the link as for this type of activity link is not created automatically
delivery.operation_id = instance.operation_id;
delivery.workflow_id = instance.id;

 

Notes:

 

When you run this workflow it will create as many deliveries as many split transitions you have created.

 

Your workflow should end up looking like:

Segments are set in split as follwing:

 

SQL fields:

The SQL field names you want to add to the delivery can be found when you explore the population schema in your workflow.

 

Marcel Szimonisz

MarTech Consultant
for more tips visit my blog
https://www.martechnotes.com/

    P
    PaulWotton작성자
    Level 2
    March 30, 2022

    Thanks for your reply Marcel. Although I was able to implement your suggestions, the result was the same in that both groups of customers are given the same delivery label and delivery code.

     

    In the target data I can see customers are being assigned different segment codes depending on which segment they are in and a segment code is being pulled into the delivery label and delivery code. However, it is the same delivery label and delivery code for all customers.

     

    I'm happy to try other suggestions but could it ultimately be that this isn't possible to achieve because Adobe Campaign will only ever assign a single delivery label and delivery code to a delivery?

    Marcel_Szimonisz
    Community Advisor
    Marcel_SzimoniszCommunity Advisor
    Community Advisor
    April 1, 2022

    Hello @paulwotton 

    You are doing something wrong. I use this for years. Can you share the screen shot? and also the place you change the label? Has to be added in second tab on delivery activity.. also the activity is not "Email delivery" but delivery where you create new send from template.

     

    Marcel

    약관 및 조건Accessibility statement

    Loading footer...