0

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
  • 1
    When I remove the join your query pulls expected data, So if you have incorrect numbers i would imagine its due to the join and the 1:N relationship on your joined field – EazyE Aug 20 at 21:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.