Ideas for NXT Report Builder reports for Marketing Emails?

In the time while we wait for there to be a better sync between RENXT constituent records and the marketing emails sent from RENXT, I've been trying to figure out ways to generate reports on our email activity.


Firstly, I go through a fairly roundabout way to mark the constituent records who received/opened/clicked on the various emails.  This involves running the lists back into RE database view as static lists and then using the Add Record tool in database view to add the email as an action to all records.  I've created an action attribute of "Mass Email Status" to then code the emails as Received/Opened/Clicked. So, at least at that point we can see the emails on the constituents' records.


Past that, though, I'd love to be able to use the NXT report builder to try to see if there are any insights we can pull based on the constituents themselves.  With my org supporting a high school, it would be great to see how the open rates compare among our constituent types (alumni, family members, board of directors).  It's at this point that I'm having trouble.  Any help would be greatly appreciated.

Comments

Categories