Trouble formulating a Query in Raiser's Edge

Options
Tracie Varnell
Tracie Varnell
Ancient Membership First Comment Facilitator Level 1 Praiser Level 1
in Blackbaud Raiser's Edge NXT®: General Discussion
Hello!


I'm trying to clean up our data a bit and see how many active constituents we have on the email list that we use in NetCommunity Sphere. What is the most simple way to pull a list of people who have opened zero emails in the last six months? I really don't want to go to each and every email sent in the last six months and pull the list of "opened" because that's going to be quite a mess. There has to be a way to query "date last email opened earlier than June 1" for example. 


Thanks in advance!

Tracie
Tagged:

Comments

  • Ryan Hyde
    Ryan Hyde
    Tenth Anniversary 1,000 Likes 500 Comments Name Dropper

    Tracie Varnell:

    Hello!


    I'm trying to clean up our data a bit and see how many active constituents we have on the email list that we use in NetCommunity Sphere. What is the most simple way to pull a list of people who have opened zero emails in the last six months? I really don't want to go to each and every email sent in the last six months and pull the list of "opened" because that's going to be quite a mess. There has to be a way to query "date last email opened earlier than June 1" for example. 


    Thanks in advance!

    Tracie

    It's possible you may have more luck asking this question in the NetCommunity forum. I know some folks here use NC, but I don't, and I know I'm not the only one. 


    Best of luck!


    https://community.blackbaud.com/products/netcommunity

  • Tracie Varnell
    Tracie Varnell
    Ancient Membership First Comment Facilitator Level 1 Praiser Level 1

    Ryan Hyde:

    Tracie Varnell:

    Hello!


    I'm trying to clean up our data a bit and see how many active constituents we have on the email list that we use in NetCommunity Sphere. What is the most simple way to pull a list of people who have opened zero emails in the last six months? I really don't want to go to each and every email sent in the last six months and pull the list of "opened" because that's going to be quite a mess. There has to be a way to query "date last email opened earlier than June 1" for example. 


    Thanks in advance!

    Tracie

    It's possible you may have more luck asking this question in the NetCommunity forum. I know some folks here use NC, but I don't, and I know I'm not the only one. 


    Best of luck!


    https://community.blackbaud.com/products/netcommunity

     

    Thanks! I'll crosspost it there.

Categories