Workflow to re-target specific audience - query logic

[MarioGlad]

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,

[ShrawanSaxena]

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...

[MarioGlad]

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 · Accepted solution]

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