Skip to main content
added 503 characters in body; added 4 characters in body
Source Link
Gravitai
  • 2.9k
  • 1
  • 10
  • 19

You certainly can - either through using a Measure and a Filter or writing a SQL Statement e.g.

Examples of below statements selects all customers who have been sent an email in the past 90 days but do not have any open events in the past 90 days.

Select a.SubscriberKey, a.EmailAddress
From _Subscribers a
Left Join _Sent s on a.SubscriberKey = s.SubscriberKey
Left Join _Open o on a.SubscriberKey = o.SubscriberKey
Where DateDiff(d, s.EventDate, GetUTCDate()) <= 90
And o.SubscriberKey is null

This statement should also work :

select 
subscriberkey, 
EmailAddress 
from _Subscribers 
where subscriberkey in     
  (select subscriberkey from _sent  WHERE s.EventDate > DATEADD(day, -90, GETDATE()) 
 and 
subscriberkey not in (select subscriberkey from _open  WHERE s.EventDate > DATEADD(day, -90, GETDATE())

You certainly can - either through using a Measure and a Filter or writing a SQL Statement e.g.

Select a.SubscriberKey, a.EmailAddress
From _Subscribers a
Left Join _Sent s on a.SubscriberKey = s.SubscriberKey
Left Join _Open o on a.SubscriberKey = o.SubscriberKey
Where DateDiff(d, s.EventDate, GetUTCDate()) <= 90
And o.SubscriberKey is null

You certainly can - either through using a Measure and a Filter or writing a SQL Statement e.g.

Examples of below statements selects all customers who have been sent an email in the past 90 days but do not have any open events in the past 90 days.

Select a.SubscriberKey, a.EmailAddress
From _Subscribers a
Left Join _Sent s on a.SubscriberKey = s.SubscriberKey
Left Join _Open o on a.SubscriberKey = o.SubscriberKey
Where DateDiff(d, s.EventDate, GetUTCDate()) <= 90
And o.SubscriberKey is null

This statement should also work :

select 
subscriberkey, 
EmailAddress 
from _Subscribers 
where subscriberkey in     
  (select subscriberkey from _sent  WHERE s.EventDate > DATEADD(day, -90, GETDATE()) 
 and 
subscriberkey not in (select subscriberkey from _open  WHERE s.EventDate > DATEADD(day, -90, GETDATE())
Source Link
Gravitai
  • 2.9k
  • 1
  • 10
  • 19

You certainly can - either through using a Measure and a Filter or writing a SQL Statement e.g.

Select a.SubscriberKey, a.EmailAddress
From _Subscribers a
Left Join _Sent s on a.SubscriberKey = s.SubscriberKey
Left Join _Open o on a.SubscriberKey = o.SubscriberKey
Where DateDiff(d, s.EventDate, GetUTCDate()) <= 90
And o.SubscriberKey is null