Skip to main content
Arivu_Muthaiah
Level 2
Feb 11, 2025 10:51 AM UTC
Solved

How to Dedupe Recipients in Query for Email Opens

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!

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
Feb 11, 2025 11:20 AM UTC

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

2 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
Feb 11, 2025 11:20 AM UTC

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

Translate
~  ParthaSarathy S
Arivu_Muthaiah
Level 2
Apr 15, 2025 10:51 AM UTC

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!

Translate