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.

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

1 Answer 1

Reset to default
0

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

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .