Add operationId to broadLogRcp in AC Classic?

Avatar

Avatar
Validate 1
Level 2
johnf48867289
Level 2

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
johnf48867289
Level 2

Likes

4 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 1
Boost 3
Boost 1
View profile
johnf48867289
Level 2

06-06-2018

Has anyone added the operationId from the Campaigns (nms:operation) schema to the Recipient delivery logs (nms:broadLogRcp) schema in Adobe Campaign Classic?

I need to include it for tracking, QC, reporting, etc... I know you can join it to other Adobe system tables in the DB, but I want it in the broadLogRcp table.

Any steps someone could provide including how it looks in the Target mappings would be great!

Thank you,

John

Replies

Avatar

Avatar
Establish
Employee
Adhiyan
Employee

Likes

241 likes

Total Posts

343 posts

Correct reply

124 solutions
Top badges earned
Establish
Give Back 50
Give Back 25
Give Back 10
Give Back 5
View profile

Avatar
Establish
Employee
Adhiyan
Employee

Likes

241 likes

Total Posts

343 posts

Correct reply

124 solutions
Top badges earned
Establish
Give Back 50
Give Back 25
Give Back 10
Give Back 5
View profile
Adhiyan
Employee

07-06-2018

Hi John,

You can get the Campaign ID in the broadLogRcp schema by adding it via the configure list option.

The broadLogRcp is joined with nms:Delivery which is turn is joined with nms:Operation.

Hence you can simply add the primary key of the campaign in the data tab of the broadLogRcp schema and export the data associated.

1503643_pastedImage_0.png

Regards,
Adhiyan

Avatar

Avatar
Boost 5
Level 4
AbdulZa
Level 4

Likes

43 likes

Total Posts

50 posts

Correct reply

8 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 4
AbdulZa
Level 4

Likes

43 likes

Total Posts

50 posts

Correct reply

8 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
AbdulZa
Level 4

21-06-2018

Adhiyan,

What about if I need to output the campaign's operation ID into a file?

I tried to use $(instance/@operation_id) and it output nothing. Maybe John is trying to do the same thing.

Avatar

Avatar
Affirm 25
Level 4
Deb007
Level 4

Likes

50 likes

Total Posts

86 posts

Correct reply

25 solutions
Top badges earned
Affirm 25
Boost 25
Applaud 5
Give Back 5
Validate 1
View profile

Avatar
Affirm 25
Level 4
Deb007
Level 4

Likes

50 likes

Total Posts

86 posts

Correct reply

25 solutions
Top badges earned
Affirm 25
Boost 25
Applaud 5
Give Back 5
Validate 1
View profile
Deb007
Level 4

04-10-2018

Hi John,

If you just want to check or export the Opertaion Id from broadlogRcp then it can be achieved using Configure List option as told by Adhiyan. If the Delivery is triggered from a technical workflow and it doesn't belong to any campaign, in that case Opeartion Id will be shown as "0".

You can also use Target mapping to store the Operation Id to Broadlog but in this it can be easily achieved using the existing relationship.

nms:broadLogRcp -> nms:delivery -> nms:operation.

Regards,

Deb