Aim to recipients with a reminder email | Community
Skip to main content
J
Javi_Landa
Level 2
November 8, 2023
Solved

Aim to recipients with a reminder email

  • November 8, 2023
  • 2 replies
  • 1447 views

Here is my question: I am going to make a campaign with 2 workflows.

 

1) In the first time I send a welcome email to a recipient and I will enter a segment code=1, then after 7 days they will re-enter the workflow (doing a split by segment code=1) and I will send them new this email but I will insert a segment code=7 to note that it is a reminder.

2) In the second workflow I want to pick up this recipient with segment code=7 and I want to send him a final email.

 

I have seen in some instances that only a simple javascript is needed at workflow level, but i cant remember it...

 

Would you know how to do it?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

@javi_landa , temp schema will get deleted once the workflow goes to finished state if the operator disable 'keep the interim result' in workflow property. (as well, Asking operator to enable 'keep the interim result' won't be a best practice, as this option makes huge disk space risk in database).

And Each time the workflow runs, workflow's temp schema holds only the last run data in it. So the only way is you need to store the segment code along with recipient schema either in broad log schema or the solution-2 by adding a delivery code.

In you follow the solution-2, you can query as segmentCode = wkf_1_seg7 and event date = 7 days ago.

2 replies

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
November 8, 2023

Hello @javi_landa 

 

Are you looking for postevent function to trigger another workflow?

 

The code is 

xtk.workflow.PostEvent("workflow2", "signal", "", <variables var1={myVar1}/>, false);
Manoj  | https://themartech.pro
J
Javi_LandaAuthor
Level 2
November 13, 2023

Hi! not really, i just want to "rescue" the segment code i created in workflow 1 and use in segmentation in workflow 2 (as far as i remember, as part of the temporary schema).

ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor
Community Advisor
November 13, 2023

Hi @javi_landa ,

For this, you need to store the segment code in broad log schema.

Step-1:

In your broad log schema, create an attribute @segmentCode with data type as string.

Step-2:

Update database structure > disconnect - reconnect

Step-3:

Then, in your target mapping, storage tab > Additional fields, add as below

Source expression: [targetData/@segmentCode]

Destination: @segmentCode

So now in broadLog schema, you can able to see which recipients got targeted using which segment and belongs to which delivery

 

And in Workflow-2, you can do a query like,

Targeting dimension: Recipient

Filtering dimension: Recipient Delivery Logs (BroadLogRcp)

This Query will result out all recipients who had received segmentCode=7 email from Workflow1

 

Solution-2:

If you don't want to create separate attribute in broadLogRcp schema, then in your workflow-1 open the delivery of segmentCode=7 and in delivery property provide delivery code (example, Delivery code: wkf1_segmentCode_7)

 

Now, in your workflow-2, Query as below to fetch all the recipients who received workflow-1's segmentCode=7 delivery.

Targeting dimension: Recipient

Filtering dimension: Recipient Delivery Logs (BroadLogRcp)

[delivery/@deliveryCode] equals to wkf1_segmentCode_7

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    J
    Javi_LandaAuthor
    Level 2
    November 13, 2023

    Thank you for your information! It is helpful.

     

    I thought another way to solve it but i have not the tech knowledge. Maybe you can help me here.

     

    My idea is to obtain in a query the internal name of the campaign (i think i need js to do it),get the event date and the segment code that is saved in the temp schema (i think i need js here as well).

     

    With this hints, do you think it is possible to do it like this?

     

    My big fear is to contact a customer more times so his segment code will be changed... Or the segment code is saved for each comunication?

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity AdvisorAccepted solution
    Community Advisor
    November 13, 2023

    @javi_landa , temp schema will get deleted once the workflow goes to finished state if the operator disable 'keep the interim result' in workflow property. (as well, Asking operator to enable 'keep the interim result' won't be a best practice, as this option makes huge disk space risk in database).

    And Each time the workflow runs, workflow's temp schema holds only the last run data in it. So the only way is you need to store the segment code along with recipient schema either in broad log schema or the solution-2 by adding a delivery code.

    In you follow the solution-2, you can query as segmentCode = wkf_1_seg7 and event date = 7 days ago.

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

      Loading footer...