Workflow to re-target specific audience - query logic | Community
Skip to main content
M
MarioGlad
Level 2
January 13, 2022
Solved

Workflow to re-target specific audience - query logic

  • January 13, 2022
  • 1 reply
  • 1320 views

Masters of Adobe,

I need your advice on what would be the logic in a query of a workflow that will run either daily or weekly and target and re-target the following:
- past buyers who have not opened an email or made a purchase in the last 6 months.
I appreciate all the past hints and guidelines as always.

Thank you,

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 rajashekarchavva

Hi Mario,

 

When you say buy a product you need to get that information from your website as campaign doesn't have a mechanism to track that out of the box. Hence you need to ingest the product purchase details data and then query on that.

 

Regarding opens you can directly query the database for the deliveryname (assuming this is unique) and tracking details as shown in the below query.

 

Thanks,

Raja

1 reply

ShrawanSaxena-1
Adobe Employee
ShrawanSaxena-1Adobe Employee
Adobe Employee
January 13, 2022

Hi Mario,

You can go through below link which seems addressing the same query 

 

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

    M
    MarioGladAuthor
    Level 2
    January 14, 2022

    Hi ShrawanSaxena,

    The above link was very helpful in understanding the logic to build the query but
    another requirement or extended requirement is to add the following:
    - Check for those who did not open the email or buy a product.
    Somehow my query does not yield any results.
    Any additional information will be very welcome.

    Thank you,

    rajashekarchavva
    rajashekarchavvaAccepted solution
    Level 2
    January 17, 2022

    Hi Mario,

     

    When you say buy a product you need to get that information from your website as campaign doesn't have a mechanism to track that out of the box. Hence you need to ingest the product purchase details data and then query on that.

     

    Regarding opens you can directly query the database for the deliveryname (assuming this is unique) and tracking details as shown in the below query.

     

    Thanks,

    Raja

      Terms & ConditionsAccessibility statement

      Loading footer...