Email Stats/Trends

Erin Gyuleseryan

Hi All,

We would like to test putting those most engaged with our NXT email content on our appeal mailing lists. I can't figure out a way to pull data on who is opening or clicking our emails outside of looking at each individual email. Is anyone using a work around for this type of data?

Thanks,

Erin

Evan Webb

Unfortunately we cannot query on email history. It's a real challenge. If someone has figured out a workaround, I'd love to know.

Megan Tope

I have not found a good workaround - with this data not being available in query, in my opinion it's almost totally useless. There are a couple ideas in the idea bank about making it available in query (ideas 8541 and 3686) that you can vote for, but I'm not holding my breath that Blackbaud is going to make that change.

Elizabeth Johnson

Links below for ease of voting.

When I voted I added this comment (first sentence differs):

And more than 18 months of history too. (Idea 8541)Yes! Along with soft bounces and more than 18 months of history too. (Idea 3686)

Why is this important to my org? This morning I have to go out to the six emails we sent last week and make a list, download it multiple time to capture how and if they engaged with it, do some Excel magic, use the id to add actions to the records so I can then report on who didn't actually receive it so we can reach out via snail mail.

In OLX I pressed one button and I could see it all on the appeal tab and query on it.

Elizabeth Johnson

I just want to add to what I opened earlier. Not only do I have to create lists for each type of response but each time I do - it takes me right to lists and then I have to navigate back to email find the email I was just trying to export (they are very simliar so names are nearly identical) and then do it over again after saving everything so I remember where I have left off. I'm looking forward to a solution that can do better sooner.

Elizabeth Johnson

Another area that makes email marking stats difficult is when you are looking at the history you can not expand the columns and you can only see approximately 17 characters of the email name. Please vote for this idea (6008) too.

I dictated my steps involved for exporting just one of the hyperlinks and wow:
This morning I realized that it would be beneficial to save as a static query and export from query instead of constituent list as I want to see more emails than simply their primary email so I can import appeals/actions appropriately.

1. Go to Communications > Email.
2. Find the email.
3. Click the Recipients hyperlink.
4. From the flyout, click Create List.
5. Save as a new list.
6. Paste the base email name.
7. Add Recipients to the start of the name.
8. Description: Select One-time use from my commonly used prepopulated descriptions.
9. Set Sharing.
10. Click Save.
    Edit on 7/24/2026 - If for any reason you included inactive (say for a data breach or community out reach that impacts current and past constituents) you have to also add the inactive field, select it, and then save again.
11. Click Export.
    (Edit on 7/24/2026 -Or save as static query - better if you want more output than a constituent list provides)
12. Click Start Export.
13. Wait for processing to finish.
14. Click the download hyperlink.
15. Click Download.
16. Verify the file downloaded.
17. Repeat for Opens, Clicks, Transactions, Bounces, and Unsubscribes.

Here were my biggest pain points:
Creating a list removes the user from the email they are working with, forcing constant navigation back to the Communications page.
My best solution: Bookmark the direct email page into bookmark bar and keep to the left for easy access.

Temporary lists require manual naming, descriptions, and permission settings every single time.
My best solution: Can copy and paste from notepad if you plan ahead.

There is no way to export multiple statistics for an email in a single operation. Each email statistic (Recipients, Opens, Clicks, Transactions, Bounces, Unsubscribes) must be exported separately, repeating the same workflow six times.
My best solution: Having the steps right infront of me and try not to be interrupted. Keep note on the notepad of the planned naming so I can list where I left off.

There is no indication of export progress or estimated completion time, particularly for larger exports. The download link is only prominently available for a few seconds after processing, making it easy to miss if interrupted.
My best solution: Naming the constituent list before exporting and remembering I can look at the notifications bell if I miss the 5 second window it appears.



The process generates numerous temporary constituent lists that serve only as an intermediate step before exporting data.
My best solution: Trying to remember to delete them as soon as I am done with the project. I'm getting better at this.

I use power query to merge together the lists from a folder, Select the 5 columns I want to keep and remove the rest, set a priority based on a custom column I create from the name (why I put the stat type at the front of the file name), add a few more custom columns based off the name of the list, sort, dedupe, get my stats from a pivot, Import into RE with Omatic Cloud. Sometimes appeal, sometimes action, sometimes both.

I'm curious if anyone can help me streamline this further. I hope this helps someone else and I will add this to the idea bank 8541 and 3686.