Survey for Teamraiser Participants - Getting a Random Group Together

Options
Christina Relacion
Christina Relacion ✭
Ancient Membership Facilitator 1 Name Dropper Photogenic
in Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions

We're sending a survey out to a random group of our 2014 walk participants from Teamraiser. Is there a way for me to just get a random group of participants without having to go into each of our 50+ events, pulling contacts manually and then putting together a distribution group? Trying to see if there maybe was a query or something a little more automated that I could do. Again, just looking for a very random subset of all of our walk users so not a specific participant type.

 

Thanks!

Tagged:

Comments

  • Kent Gilliam
    Kent Gilliam Blackbaud Employee
    Ancient Membership Facilitator 4 Name Dropper Photogenic

    Hi Christina,

     

    There's not a way to randomize to pull X% of each TR event group. One thing you can do to create a random selection is create a query that uses the last digits of the Cons ID. 

     

    You do the following:

     

    Start by creating a query of just: 


    • Member of TeamRaiser Groups A, B, C, D....

    Run this and see how many you have in your results. Then add to the query to create:

     

    • Member of TeamRaiser Groups A, B, C, D....
    • AND Accept Email equals true
    • AND System Contact Range is 1 to 5 (Last 1 Digits)

    The "contact range" will go by those whose last digit in their cons ID ends with a 1, 2, 3, 4, or 5. This is about as random as you can get. Run this and if you have too many records, simply change the end number to 4. If you don't have enough just up it to 6. 

     

    It's not scientific but it's close as you can get to a randomized filter.

     

    Hope this helps.

    Kent

     

  • Brian Mucha
    Brian Mucha ✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    Kent Gilliam:

    Hi Christina,

     

    There's not a way to randomize to pull X% of each TR event group. One thing you can do to create a random selection is create a query that uses the last digits of the Cons ID. 

     

    You do the following:

     

    Start by creating a query of just: 


    • Member of TeamRaiser Groups A, B, C, D....

    Run this and see how many you have in your results. Then add to the query to create:

     

    • Member of TeamRaiser Groups A, B, C, D....
    • AND Accept Email equals true
    • AND System Contact Range is 1 to 5 (Last 1 Digits)

    The "contact range" will go by those whose last digit in their cons ID ends with a 1, 2, 3, 4, or 5. This is about as random as you can get. Run this and if you have too many records, simply change the end number to 4. If you don't have enough just up it to 6. 

     

    It's not scientific but it's close as you can get to a randomized filter.

     

    Hope this helps.

    Kent

     

    I did something like this once to A/B test a TR Coaching email. I used Even/Odd IDs rather than 1-5. My reasoning was to break up groups or families that registered together and got sequential IDs. (Not sure if that was really a valid concern.)

Categories