Skip to main content
manmeet_dosanjh
Helper ⭐️
July 31, 2017
Solved

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

  • July 31, 2017
  • 3 replies
  • 66 views
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. 
Best answer by smorrisgainsightcom
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

3 replies

smorrisgainsightcom
Helper ⭐️⭐️⭐️
August 1, 2017
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

manmeet_dosanjh
Helper ⭐️
August 1, 2017
What field are you using in the "Show Me" section? Count of?
manmeet_dosanjh
Helper ⭐️
August 1, 2017
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'.