Email Activity non openers

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?

Best answer by 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.

Accepted solution

Community Advisor