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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Compute Delivery Code from TargetData

Avatar

Level 2

I need to include a variable from the TargetData in my deliveryCode or deliveryLabel so that I can use this to exclude the recipeint from the workflow at a later date. 

eg. Identify if the target recipient has recieved an email with variable X in the last 7 days

 

The variable X is based on where they may have been on our website, it can vary a lot, and I do not want to have mutliple templates, but a single continous one. 

I though I could compute the Delivery code with the variable X, that I could then use to exclude the recipient in my workflow.

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

 

Follow these steps, assuming nms:recipient is recipient table:

  1. Alter nms:broadLogRcp, adding sql field 'variableX'
  2. Alter target mapping mapRecipient, adding variableX to storage. Source field is [targetData/variableX]
  3. In future campaign workflows add condition 'broadlogrcp does not exist such as variableX=y'

 

Thanks,

-Jon

View solution in original post

3 Replies

Avatar

Level 5

Hi @kimh76108924 ,

You can compute delivery code and label by navigating to delivery property > Analysis (tab) > check the checkboxes 

 

Analusis 2.PNG

 

Regards,

ParthaSarathy S

Avatar

Correct answer by
Community Advisor

Hi,

 

Follow these steps, assuming nms:recipient is recipient table:

  1. Alter nms:broadLogRcp, adding sql field 'variableX'
  2. Alter target mapping mapRecipient, adding variableX to storage. Source field is [targetData/variableX]
  3. In future campaign workflows add condition 'broadlogrcp does not exist such as variableX=y'

 

Thanks,

-Jon

Avatar

Administrator

Hi @kimh76108924,

Was any of the given solutions helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!