Have Questions? (800) 477-0970

Picking a Random Contest or Survey Winner in SurveyGizmo

Posted by 4 Responses Filed in: Customer innovators, How-to articles

I saw a great thread in our survey forum this morning and thought I’d share a couple ideas brought out by our users “Leibiniz” and “donna d.” Donna wanted an anonymous survey to collect data but with a free offer contest to increase the submission rate.

Obviously you need to keep the survey results anonymous, but still collect the personal info to be able to send the winner of the contest their prize. She used a tried and true method of redirecting users who want to enter the contest to separate non-anonymous survey after they complete the first anonymous survey. You can send everyone via a redirect or you could use a question to ask if they’d like to continue on to the second survey. With a little logic thrown in on the respondents who wish to be redirected will. But then she had a problem… how to randomly pick the winner.

That’s when user Leibiniz suggested using www.random.org/integers to get a random number. What a nice simple little site. You get to set the number of random numbers you want (1 or more winners) and the range of possible values (number of entrants).

Leibiniz and Donna were discussing using a query string variable, but I think a simpler way is to just export your survey data when your survey is complete. Take the number of rows in your survey spreadsheet (minus 1 for the header row) and use this as the maximum value at the Random.org site. Voila! a random user selected by row number.

If you have more questions about surveys, survey contests, or random winners feel free to post here or the forums! Happy surveying.

Tags: ,
Share This:

Have you tried SurveyGizmo yet? Try our 14 day free trial

About the Author

Scott McDaniel
Scott McDaniel is the co-founder, CEO and lead designer at SurveyGizmo. He has been passionate about entrepreneurism and designing friendly, usable web applications for over 10 years at companies such as MarketingSherpa, LexisNexis, MessageMedia, and DoubleClick.


Responses
RSS feed for comments on this post.  •  TrackBack URI

  1. 1

    One other suggestion. I just saw a blog post about a gentleman who spammed a contest and won it.

    If you are running a contest you should use our “vote protection” feature to make sure this doesn’t happen. You can also use the “de-dupe” feature in reporting to weed out spammers people after-the-fact if you forget to turn it on before launching your contest.

    Remember, remove duplicated before choosing that winner!

    -Christian

    Christian Vanek on Tue, Jul 08 ’08 at 9:11 am #
  2. 2

    Hi, cool post. I have been wondering about this topic,so thanks for writing.

    KrisBelucci on Mon, Jun 01 ’09 at 7:54 pm #
  3. 3

    I think Random.org is not free when you need to pick winners with a proof of the draw, it is $4,95. There is also http://www.RandomResult.com which is totally free.

    Sunny on Mon, Jul 19 ’10 at 9:23 am #
  4. 4

    I use Excel’s “RANDBETWEEN” function to randomly select a number between 1 and X, where X is number of entries I have received. Since I download survey responses into Excel, its convenient to add the function to an empty cell and then have everything saved in a single file.

    Karla Embleton on Tue, Oct 05 ’10 at 2:54 pm #

Respond.


Start your free 14 day trial

Get all features for $50/month. Add users for $20/month each.

Questions? Call us anytime during your trial at (800) 477-0970.

No credit card required.

  • Call us at (800) 477-0970
    for help setting up larger teams.

* Extra users are free for the duration of your trial.
You can change the number before upgrading to a paid plan.

The Survey Expert Blog

By

Why Survey Design Matters for Feedback Surveys

February 3 2012 -

Survey Expert Ryan Farmer observes that many well-known companies aren’t branding their surveys, and discusses why survey design is hyper-important when you want to gather customer feedback.

By

New Team Management & User Permissions System

Starting February 2nd, SurveyGizmo is launching a new set of user management features. Learn more about them here!

By

5 Questions with SurveyGizmo co-founder and CEO Christian Vanek

Boulder’s Daily Camera newspaper interviews Christian Vanek, who shares what’s next for the company.

More from our Survey Experts