Expand my Community achievements bar.

SOLVED

Ussage of Event XML field from Archived Event Schema in marketing campaign

Avatar

Level 2

Is there a way if we can use an event xml field data present under archived event schema, for our marketing campaign to use in Email template?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @himanshu-singh,

it is the basic  functionality of message centre

 

You can access the rt event data

<ctx>
  <firstName>Marcel</firstName>
</ctx>

In transactional email template  by :

<%=rtEvent.ctx.firstName%>

EDIT:

Just realized you are referring to  marketing campaign. Each rt event is linked to recipient you can enrich your targeting dimension by any rt event based on query selection. For example you want last transactional message of specific type?
In query or enrichment activity click on add data under the query select data linked to the targeting dimension --> data linked to the filtering dimension 

Select on add Archived events and fill up the form and set to retrieve 1 record

Marcel_Szimonisz_1-1647506876636.png

 

Add your criteria:

Marcel_Szimonisz_2-1647506923893.png

 

Sort by event date

Marcel_Szimonisz_3-1647506979204.png

 

 

click ok pull information such as event xml that can be accessed later in email

EDIT2:

Event XML is not shown in field explorer you have to manually type ctx in the expression builder

Marcel_Szimonisz_2-1647527311583.png

It will get recognized

Marcel_Szimonisz_3-1647527366004.png

 

Marcel

View solution in original post

5 Replies

Avatar

Correct answer by
Community Advisor

Hello @himanshu-singh,

it is the basic  functionality of message centre

 

You can access the rt event data

<ctx>
  <firstName>Marcel</firstName>
</ctx>

In transactional email template  by :

<%=rtEvent.ctx.firstName%>

EDIT:

Just realized you are referring to  marketing campaign. Each rt event is linked to recipient you can enrich your targeting dimension by any rt event based on query selection. For example you want last transactional message of specific type?
In query or enrichment activity click on add data under the query select data linked to the targeting dimension --> data linked to the filtering dimension 

Select on add Archived events and fill up the form and set to retrieve 1 record

Marcel_Szimonisz_1-1647506876636.png

 

Add your criteria:

Marcel_Szimonisz_2-1647506923893.png

 

Sort by event date

Marcel_Szimonisz_3-1647506979204.png

 

 

click ok pull information such as event xml that can be accessed later in email

EDIT2:

Event XML is not shown in field explorer you have to manually type ctx in the expression builder

Marcel_Szimonisz_2-1647527311583.png

It will get recognized

Marcel_Szimonisz_3-1647527366004.png

 

Marcel

Avatar

Level 2

Hello @Marcel_Szimonisz ,

 

Thanks for your response!

When I have followed the steps mentioned by you in last steps after below step,

himanshusingh_0-1647521692069.png

when going to next step to pull information I am not able to see event xml option which I could fetch.

himanshusingh_1-1647521808487.png

 

Avatar

Community Advisor

Hello @himanshu-singh ,

type ctx in expression builder it is not shown on the field explorer

Marcel_Szimonisz_0-1647527256497.png

but it gets recognized

Marcel_Szimonisz_1-1647527279649.png

 

Marcel

Hi @Marcel_Szimonisz ,

 

Thanks for the solution earlier as noticed the solution you mentioned was working before whereas today something very peculiar happened and the solution is not working anymore , I am attaching the screenshot for your reference of the error which i am getting,

Error:-

himanshusingh_0-1649170366732.png

Also Wanted to know how can I fetch particular value from Event XML field as it is having multiple tags which are passed through ctx payload api.

Avatar

Community Advisor

Marcel_Szimonisz_0-1649263665474.png

What is this function? is it yours? please redo the activity or the items in it.. i presume when you access it it will throw error as well