How to Dedupe Recipients in Query for Email Opens

[Arivu_Muthaiah]

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!

[ParthaSarathy · Accepted solution]

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

[Arivu_Muthaiah]

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!