I'm trying to query the _click table to fill a new table with the email of the users who have clicked a link in the email and on the date clicked. What would my query look like? Also trying to figure out what columns are needed for the target Data Extension. Any ideas?
I was using something like to find all clicks to see if it works, but im getting 0 results.
SELECT Email from ( SELECT SubscriberKey AS Email, MAX(EventDate) AS MaxDate FROM _Click WHERE AccountID = xxxx GROUP BY SubscriberKey ) AS Foo