Skip to main content
Level 2
Nov 14, 2025 11:28 AM UTC
Solved

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?

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ParthaSarathy
ParthaSarathyAccepted solution
Community Advisor
Nov 14, 2025 12:26 PM UTC

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.

~  ParthaSarathy S

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
Nov 14, 2025 12:26 PM UTC

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.

Translate
~  ParthaSarathy S