I'm trying to identify email subscribers from within a specified data extension who have not clicked since 2/1/2013, but my query isn't working.
I posted a similar topic yesterday, and received some great info, so I'm hoping that if someone here has a free second today, I could get some advice on my query.
SELECT b.Email FROM BRAND_PREPOLICY b JOIN _Click c ON c.SubscriberID = b.Email WHERE c.EventDate < '2013-3-1'
I want this query to say: From the data extension titled BRAND_PREPOLICY, give me all email addresses that haven't clicked since before 3/1/2013. Email address (field name = Email) is set as the subscriber key for the BRAND_PREPOLICY data extension.
I've tried a few tweaks, but I can't figure out why my resulting data extension is showing up empty after I run this query. We definitely had clicks in ET before 3/1/2013.