The query is intended to populate LastClick and LastOpen data in our Master Subscribers DE.
Here is the query:
SELECT a.Email, a.LeadUID, MAX(o.EventDate) as LastOpenDate, MAX(c.EventDate) as LastClickDate FROM [Master Subscribers] a LEFT JOIN _Open o ON a.Email = o.SubscriberKey LEFT JOIN _Click c ON a.Email = c.SubscriberKey GROUP BY a.Email, a.LeadUID
After talking with support they have recommended that we "split the joins into multiple queries so the data can be filtered down sequentially."
I understand the logic behind this but am unsure how to go about implementing it. Could anyone help me to take a step in the right direction with splitting this query into more digestible pieces? Thank you.