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
BedrockMission!

Learn More

View all

Sign in to view all badges

How to retrieve campaign name from its workflow

Avatar

Avatar
Validate 1
Level 2
gabrieleg615679
Level 2

Likes

12 likes

Total Posts

36 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 10
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
gabrieleg615679
Level 2

Likes

12 likes

Total Posts

36 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 10
Boost 5
Boost 3
Boost 1
View profile
gabrieleg615679
Level 2

06-05-2021

Hi,

I have a query with profiles and I want as additional data the name of the campaign where is located the workflow where is running the query. 

So for instance, I have

CAMPAIGN A

Inside "Campaign A" there is  "Workflow A"

I run a query on "workflow a" and I want as additional data 'Campaign A'

 

I guess I need something like context.workflow.campaign.name but this doesn't work.

 

Kr

Gabriele

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Boost 5
Employee
kpotts1985
Employee

Likes

6 likes

Total Posts

7 posts

Correct Reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile

Avatar
Boost 5
Employee
kpotts1985
Employee

Likes

6 likes

Total Posts

7 posts

Correct Reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 5
Affirm 3
View profile
kpotts1985
Employee

11-05-2021

Hi Gabriele, 

 

When querying directly on profile resource, the Workflow and Campaign details are not directly exposed in the table links.  However what you can do is configure a second query on the Workflow resource itself and then use an enrichment to join the Campaign details to the profile records.

 

kpotts1985_0-1620770365515.png

 

First, set the profile query (add an additional column with a value set to 1)

kpotts1985_2-1620770588835.png

 

Second, set the workflow query conditions to target the current workflow from which you are building (adding the Campaign Id and Campaign Label, also add an additional column with a value set to 1... same as above)

kpotts1985_3-1620770637656.png

 

Third, you will configure an enrichment using Profile as the primary set and using the additional columns (each set to 1) as the join condition.  Within the enrichment after you set the join, also add the Campaign Id and Label as Additional Data.

kpotts1985_4-1620770671161.png

 

Final result gives all of the profiles you queried (workflow still remains on the profile resource as the targeting dimension) but now all of the additional data from the Campaign itself is included as added columns.

kpotts1985_1-1620770533524.png

 

-KP