How do i create a report that shows quantity of emails sent per contact
Hello, I am trying to see how many emails each of our active contacts received for a month, quarter, and year. How do i generate a report that shows, contact name, the total amount of emails that they received per month per quater and per year from their timeline? i also want to break that down by email category
Like
The object you'll want to use for the dashboard or report is the "Bulk email recipient (audience)" object. From that object you can get to the contact and also a count of opens or clicks, and also can get to the bulk email and use the "Started on" date as the date the bulk email started (not necessarily the date the contact received it since it's sent in batches and if you're throttling sending periods, but likely close enough). You can then also group by email category via the bulk email as well.
Ryan
Also, this would work best as a dashboard, however you could create it as a report using the Excel Reports add-on in the marketplace.