I want to see a report or data set that will show me how many emails my contacts are getting.
I looked at the Analytics Report and there is an “Email Frequency Report” but man I cant understand the output on that one.
I also know/looked at the Einstein Engagement Frequency report, but that is not really giving me the info we are looking for.
You would need to add it within the subquery to apply the filter before counting records:
SELECT
sends.SubscriberKey
, COUNT(sends.SubscriberKey) AS SentCount
FROM
(
SELECT
sent.SubscriberKey
, sent.EventDate
FROM _Sent AS sent
INNER JOIN _Job AS job
ON job.JobID = sent.JobID
WHERE
job.Category != 'Test Send Emails
AND job.TriggeredSendCustomerKey NOT IN ['SAPOrderConfirmationOA', 'SAPOrderConfirmationASN']
AND DATEDIFF(DAY, sent.EventDate, GETDATE()) <= 30
GROUP BY sent.SubscriberKey, sent.EventDate
) AS sends
GROUP BY sends.SubscriberKey
Keep in mind that I used AND instead of OR you proposed, as I suppose you want to filter out all emails matching any of those conditions.
