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

How to use data from a previous activity as a variable in a query in a next activity?

olsalas711
Level 2
Level 2

Hi community,

 

We'd like to know how can i use a data obtained from a previous activity as a variable in a following activity in a workflow?.

 

From delivery logs We obtain the profiles whose i sent an especific email, and in our ACS instance we have a custom resource called purchase orders related to profiles. To send a remarketing campaign we need to send an email to profiles with no purchase order after the the date we sent the first email. Until we hadn´t been able to pass the event date as parameter in the related purchase orders.

 

This is the workflow and configurations so far

 

olsalas711_0-1635880370572.png

 

1. We obtain the delivery logs

olsalas711_1-1635880445270.png

 

olsalas711_2-1635880472592.png

 

2. We reconciliate the profiles

olsalas711_3-1635880597381.png

 

3. We add purchase data

olsalas711_4-1635880667244.png

 

olsalas711_5-1635880701631.png

 

olsalas711_6-1635880740212.png

 

and this is how we try to filter the purchase orders after the first email was sent.

 

olsalas711_7-1635881061795.png

 

Thanks in advance for any help you can give us.

 

1 Accepted Solution
ramon_bisswanger
Correct answer by
Employee
Employee

Do you see "Additional data" in the filter dialog?

This normally should include the reference you looked up in the Enrichment and then should be available for the filtering

 

Note: you may need to add Max(purchase Date) or similar in the enrichment step

View solution in original post

2 Replies
ramon_bisswanger
Correct answer by
Employee
Employee

Do you see "Additional data" in the filter dialog?

This normally should include the reference you looked up in the Enrichment and then should be available for the filtering

 

Note: you may need to add Max(purchase Date) or similar in the enrichment step

View solution in original post

Sukrity_Wadhwa
Employee
Employee

Hi @olsalas711,

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

Thanks!