1

I am trying to write a query to identify all subscribers that opened at least 2 emails in the last 6 months.

I will pull from a data extension called "Clients" and look for all opens in the "_open" Data view. Since the "_open" data view only holds 6 months worth of data, I will not enter a date constraint.

My sample query is as follows:

select * from clients

where EmailAddress in (Select Distinct SubscriberKey FROM _open)

This query identifies all unique subscribers (by emailaddress) in the Client DE that opened any email in the last 6 months.

I am struggling to modify the query so that it pulls all records where a subscriber opened at least 2 separate emails.

Any help is appreciated.

  • Would this work? - in query do a join on _opens where _opens is GROUP BY SubscriberKey HAVING COUNT(SubscriberKey) > 1 – mattcameron Aug 11 '16 at 11:47
0

To resolve do a join on _opens where _opens is GROUP BY SubscriberKey HAVING COUNT(SubscriberKey) > 1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.