We'd like to review our communication limits, so as part of this, would like to see a high level average of number of emails that leads in our database receive with in any given time period (TBC). I saw that this could be done in Revenue Explorer, but the report I have tried is taking so long to populate as we have so much data. Tried with email name in column, lead full name in row and measure would be sent (week). Is there an easy way around this? Tried adding more filters to look at this on a weekly basis, but it's still not refreshing.
Run a smart list with the filter of "was sent email: is any" or possibly "was delivered email: is any" if that is more accurate. Use the following constraints:
- date of activity in the past [ex. 30 days]
- minimum number of times [ex. 3]
This resulting list will show all leads who have been sent at least 3 emails in the past 30 days. Adjust those two constraints accordingly to gather other timeframes and number of emails sent.