Level 3

質問

workflow reminder issue on query

Forum|Forum|2 years ago
September 14, 2023
2 の返信
1740 ビュー

Hello

I am trying to send a reminder email 2 days after a recipient surbscribe to our newsletter.

1- from website, user enter email

2- message cnter process through transactionnal messages (evet type name: welcome)

3- I query on Archived events (maybe should not) to get all users created on on or after 2 days before and status equal to Sent and event type equal to 'welcome'

4- I am blocked here, cause I tryied a change dimension on recipient and 0 population get through the transition to the delivery, I have also tried to change the target mapping of th edelivery in the TO section, for Real time event (nms:rtEvent) and even Archived element (nms:eventHisto) but message got into conflict at the prepare step.

Have you ever tried to set up a reminder after a welcome email have been received and not open by user?

thanks

このトピックへの返信は締め切られました。

LakshmiPravallika

Community Advisor

Hi @rbiri ,

Please use the OOTB Target Mapping named "Archived element" which has the Targeting Schema as nms:eventHisto to send the email , and also change dimension is not required as the Target Mapping Data will match the query's Data and try sending email to the Targeted recipients. PFA below screenshot of the Target Mapping to be used in your workflow.

Regards,

Pravallika.

R

rbiri作成者

Level 3

Hello

You screenshot is blurry and I cant for some reason open it too, how do I get to this config?

LakshmiPravallika

Community Advisor

Hi @rbiri ,

Please go to the folder "/Administration/Campaign Management/Target mappings/" Folder and select the "Archived element" Target Mapping in your Delivery activity and you can remove Change dimension activity in your workflow.

Regards,

Pravallika.

ParthaSarathy

Community Advisor

Hi @rbiri ,

To Send Reminder Email to the audience who have received the email (via transactional message), but haven't opened it, you can configure a workflow as below:

Query:

Targeting Dimension: nms:eventHisto

Filtering Dimension: nms:eventHisto

This condition results All audience who had received email 2 days back, and haven't opened it.

Deduplication: (If Required in your use case)

Select Temporary schema > Identify duplicate based on email > limit the count to 1

Recurring Delivery

To > select target mapping as 'Archived events'

And the reason you get 0 as output for change dimension is, nms:eventHisto and nms:recipient table is linked with eventHisto's external Identifier and Recipient's account field.

If your SOAP request have externalId in <rtEvent/> tag, and if it match recipient record's @account field, then you will get output in change dimension.

<urn:domEvent>
<rtEvent type="welcome" email="partha@test.com" wishedChannel="0" externalId="123456" />
</urn:domEvent>

~ ParthaSarathy S

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

R

rbiri作成者

Level 3

hello

Thank you for all the details provided, it is very helpful, I have tried your solution, but my question is.this complmentary with LakshmiPravallika solution where I need to update the target mapping of event history too?

cause I have been trying your solution with same query, but I get an error on delivery Recurring when performing action 'Prepare' on delivery.

Is it mean I need to update archive element target mapping?

current config: