How to get the subscribers who haven´t opened the last X campaigns

[Jose Vega]

Hi guys , I needed to create a segment with all the subscribers who haven´t opened any campaigns during the last 2 months.

So I want to share the SQL I used to:

1- get the subscribers who haven´t opened any campaigns sent in the last two months

2- Verify what campaigns they have opened, just in case...

I hope it´s helpful for you guys...

Here´s the file with the snippets.

https://drive.google.com/file/d/0B6nmyp5p7PnYODdka3NHN1JjR2M/view?usp=sharing

 

[omniknoweth]

Thanks brov