Is it possible to create a Report for the Dashboard that shows the sum of Unopened Emails? Instead of Sum of Sent.

  • 2
  • Question
  • Updated 11 months ago
  • Answered
  • (Edited)
I am trying to create a chart for the Dashboard via the Report Builder (but if there is another way, I am open to that as well) that uses the MDA data for "Email Logs" to show the amount of Emails "Opened" vs "Unopened". Is this possible?

Currently, we have a report set up to Show Me: "Sum of Sent", "Sum of Click Count", and "Sum of Opened". 

The issue with this report is that it basically double counts the emails that were sent and opened and makes the total amount of email logs (Sent, Clicked, and Opened) appear greater than actual. Rather than have the Sent, I think it would show more value to compare Opened vs Unopened. Especially using the 'stacked column' chart option. 
Photo of Manmeet Dosanjh

Manmeet Dosanjh, Champion

  • 3,678 Points 3k badge 2x thumb
  • Unsure

Posted 11 months ago

  • 2
Photo of Scott Morris

Scott Morris, Alum

  • 6,312 Points 5k badge 2x thumb
Hi Manmeet:

Can you attempt to rebuild the report that I'm attaching below?  This should give you the data you're after.

Thanks
Scott
Photo of Manmeet Dosanjh

Manmeet Dosanjh, Champion

  • 3,678 Points 3k badge 2x thumb
What field are you using in the "Show Me" section? Count of?
Photo of Manmeet Dosanjh

Manmeet Dosanjh, Champion

  • 3,678 Points 3k badge 2x thumb
Wouldn't this just show me the sum of the opened emails? I would want one report/graph to compare the 'Sum of Opened' and 'Sum of Unopened'. 
(Edited)