Email Activity non openers

[AdobeWisdomWarrior]

Hi Community,

I need to retrieve all email addresses from the past year that did not open Or Click any emails across all campaigns. The output should include:

Deployment Date | Delivery Label | Email Address

Could you please guide me through the step-by-step process to achieve this?

[ParthaSarathy]

Hi @AdobeWisdomWarrior ,

In Query, Select targeting and filtering dimension as nms:broadLogRcp, and apply below filtering condition:

@status equal to Sent

AND

trackingLog do not exist

And in 'Add data' > add the below as output columns,

@eventDate, [delivery/@label], @address

Note: By default settings, Adobe campaign will store only last 6 months of tracking data.