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.
Solved
Is it possible to create a Report for the Dashboard that shows the sum of Unopened Emails? Instead of Sum of Sent.
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
View originalCan you attempt to rebuild the report that I'm attaching below? This should give you the data you're after.
Thanks
Scott
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
Can you attempt to rebuild the report that I'm attaching below? This should give you the data you're after.
Thanks
Scott
1 person likes this
What field are you using in the "Show Me" section? Count of?
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'.
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.