Skip to main content
Salesforce

Return to Question

added 36 characters in body
Source Link
cropredy
cropredy
  • 73.3k
  • 8
  • 128
  • 284

I'm trying to confirm that the query I have written is correct. I'm trying to pull back people from the 3 lists in the query that have not opened an email within the last 6 months to start a re-engagement/inactive campaign. Also, can Salesforce look past 6 months if I wanted to do the same for clicks? Thanks! (Note - we use subscriber key as email)

SELECT distinct SubscriberKey FROM _Sent WHERE EventDate > dateadd(day, -180, getdate()) AND SubscriberKey NOT IN ( SELECT SubscriberKey FROM _Open WHERE EventDate > dateadd(day, -180, getdate()) ) AND ListID IN ('3672' , '3673' , '3671')

SELECT distinct SubscriberKey
FROM _Sent
WHERE EventDate > dateadd(day, -180, getdate())
AND SubscriberKey NOT IN (
   SELECT SubscriberKey
   FROM _Open
   WHERE EventDate > dateadd(day, -180, getdate())
)
AND ListID IN ('3672' , '3673' , '3671')

I'm trying to confirm that the query I have written is correct. I'm trying to pull back people from the 3 lists in the query that have not opened an email within the last 6 months to start a re-engagement/inactive campaign. Also, can Salesforce look past 6 months if I wanted to do the same for clicks? Thanks! (Note - we use subscriber key as email)

SELECT distinct SubscriberKey FROM _Sent WHERE EventDate > dateadd(day, -180, getdate()) AND SubscriberKey NOT IN ( SELECT SubscriberKey FROM _Open WHERE EventDate > dateadd(day, -180, getdate()) ) AND ListID IN ('3672' , '3673' , '3671')

I'm trying to confirm that the query I have written is correct. I'm trying to pull back people from the 3 lists in the query that have not opened an email within the last 6 months to start a re-engagement/inactive campaign. Also, can Salesforce look past 6 months if I wanted to do the same for clicks? Thanks! (Note - we use subscriber key as email)

SELECT distinct SubscriberKey
FROM _Sent
WHERE EventDate > dateadd(day, -180, getdate())
AND SubscriberKey NOT IN (
   SELECT SubscriberKey
   FROM _Open
   WHERE EventDate > dateadd(day, -180, getdate())
)
AND ListID IN ('3672' , '3673' , '3671')
Source Link
J. Donders
J. Donders
  • 1
  • 1

Query for Engagement Campaign

I'm trying to confirm that the query I have written is correct. I'm trying to pull back people from the 3 lists in the query that have not opened an email within the last 6 months to start a re-engagement/inactive campaign. Also, can Salesforce look past 6 months if I wanted to do the same for clicks? Thanks! (Note - we use subscriber key as email)

SELECT distinct SubscriberKey FROM _Sent WHERE EventDate > dateadd(day, -180, getdate()) AND SubscriberKey NOT IN ( SELECT SubscriberKey FROM _Open WHERE EventDate > dateadd(day, -180, getdate()) ) AND ListID IN ('3672' , '3673' , '3671')