Users receiviving a sequence of a welcome email even with a condition in the query | Adobe Higher Education
Skip to main content
Level 2
February 8, 2024
Respondido

Users receiviving a sequence of a welcome email even with a condition in the query

  • February 8, 2024
  • 4 respostas
  • 1137 Visualizações

Hello!

 

I built a welcome workflow and in the query I put a condition to send the email only to those who still have not received it, but two users receive the email every time the workflow runs (every 15 minutes). I would like help to understand why this is happening since the query has a condition and what would be the possibilities to resolve this case. 

 

I really appreciate any help you can provide. Thank you 🙂

Este tópico foi fechado para respostas.
Melhor resposta por Sujith_02kumar

Hi @thaiskoliveiras1998 ,

 

Get the delivery code from the delivery and use an query activity to query your delivery logs based on the delivery code. Then use a deduplication activity to remove your address field to exclude such customers from main set.

 

I hope this helps.

 

Regards,

Sujith kumar

4 Respostas

ParthaSarathy
Community Advisor
Community Advisor
February 8, 2024

Hi @thaiskoliveiras1998 ,

Try replacing the Query activity with Incremental query.

The Incremental query activity allows you to filter and extract a population of elements from the Adobe Campaign database. Each time this activity is executed, the results from the previous executions are excluded. This allows you to target only new elements.

Reference document

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
SatheeskannaK
Community Advisor
Community Advisor
February 8, 2024

@thaiskoliveiras1998, I would suggest using simple query activity to determine whether they have received the email or not before sending them a welcome email. Assume the welcome email name is DM123 exclusion will look like the below,

https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/workflow-use-case/segmentation-targeting/workflow-cross-channel-retargeting.html?lang=en

 

Thanks, Sathees
Level 4
February 20, 2024

Hi @thaiskoliveiras1998 ,

 

Get the delivery code from the delivery and use an query activity to query your delivery logs based on the delivery code. Then use a deduplication activity to remove your address field to exclude such customers from main set.

 

I hope this helps.

 

Regards,

Sujith kumar

Sukrity_Wadhwa
Community Manager
Community Manager
February 27, 2024

Hi @thaiskoliveiras1998,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!

Sukrity Wadhwa