Is there a way to know the number of unique deliveries by month.
In my context i have a master data extension and the users creates others filtered data extension, but with the same SubscriberKey.
I want to know only the unique deliveries by month.
I tried to use this SQL Activity, but the numbers of records it's unreal.
SELECT Count(DISTINCT p.SubscriberKey) AS TotalSent, DATENAME(month, p.EventDate) as [MONTH], 'BU1' as [Business_Unit] FROM _Sent p INNER JOIN [Master_DE] B ON p.SubscriberKey = B.AccountID GROUP BY DATENAME(month, p.EventDate) HAVING Count(1) > 0