Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Workflow to re-target specific audience - query logic

MarioGlad
Level 3
Level 3

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,

3 Replies
MarioGlad
Level 3
Level 3

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
Level 1
Level 1

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.

rajashekarchavva_0-1642436870409.png

rajashekarchavva_1-1642436931202.png

 

Thanks,

Raja