How to Dedupe Recipients in Query for Email Opens | Community
Skip to main content
Arivu_Muthaiah
Arivu_Muthaiah
Level 2
February 11, 2025
Solved

How to Dedupe Recipients in Query for Email Opens

  • February 11, 2025
  • 1 reply
  • 566 views

Hi everyone,

I'm trying to create a query to find targets who opened emails in the last X days/months, but the results include duplicate deliveries instead of unique recipients. I attempted deduplication using the email address, but it resulted in an error.

Has anyone encountered this issue before? Any suggestions on how to correctly dedupe the results?

 

Thanks in advance for your help - Thanks!

Best answer by ParthaSarathy

Hi @arivu_muthaiah ,

You can have targeting dimension as recipient and filtering dimension as trackingLogRcp, and query as ToDate(@logDate) on or after ToDate(DaysAgo(180))

and 

[delivery/@messageType] equals to Email

and

[url/@type] equals to Open

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
February 11, 2025

Hi @arivu_muthaiah ,

You can have targeting dimension as recipient and filtering dimension as trackingLogRcp, and query as ToDate(@logDate) on or after ToDate(DaysAgo(180))

and 

[delivery/@messageType] equals to Email

and

[url/@type] equals to Open

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Arivu_Muthaiah
    Arivu_MuthaiahAuthor
    Level 2
    April 15, 2025

    Creating Push Notification Sent Report Query in v7

    I'm trying to create a query to retrieve reports of push notifications sent over the past 12 to 24 months. Could anyone advise on how to structure this query in version 7?

    Any guidance or examples would be greatly appreciated!

    Thanks in advance!

    Terms & ConditionsAccessibility statement

    Loading footer...