6 Replies Latest reply on Feb 3, 2015 7:50 AM by thales

    What time frames do you use for your external community contests?

    thales

      I am setting up a yearly contest for our external community. I am looking at having two games. One is based on social engagement using Bunchball points, and the other is based on contribution using replies marked helpful and answered. Each year the points would reset. I would also have quarterly mini contests in conjunction, but it seems that it could get overwhelming as a community manager in order to determine winners and send out prizes.

       

      Jive Gamification User Group

        • Re: What time frames do you use for your external community contests?
          mnevill

          This may help.  If you have access to the system database you can run this query after editing the date range and email domain.  It pulls all answers marked as correct where their email domain does not match @company.com (remove employees) and where the person who asked didn't answer their own question.

           

          SELECT  jivequestion.threadid,

                  jiveanswer.messageid,

                  jivequestion.userid as "asker",

                  jiveanswer.userid as "answerer",

                  to_timestamp(jivequestion.creationdate/1000) as "creationdate",

                  to_timestamp(jivequestion.resolutiondate/1000) as "resolutiondate",

                  jiveanswer.correctanswer as "correct",

                  jiveuser.email as "answerer_e-mail",

                  jivequestion.containerid as "space_id",

                  jivecommunity.name as "space"

          FROM    jivequestion

          LEFT JOIN jiveanswer ON jiveanswer.threadid = jivequestion.threadid

          LEFT JOIN jiveuser ON jiveuser.userid = jiveanswer.userid

          LEFT JOIN jivecommunity ON jivecommunity.communityid = jivequestion.containerid

          WHERE  jiveanswer.correctanswer = '1' AND jiveuser.email NOT LIKE '%@company.com' AND to_timestamp(jivequestion.resolutiondate/1000) >= '2014-08-01 00:0:0' AND to_timestamp(jivequestion.resolutiondate/1000) < '2014-09-01 00:0:0' AND jivequestion.userid != jiveanswer.userid

          ORDER BY jivequestion.threadid asc

          • Re: What time frames do you use for your external community contests?
            blueumbrella

            Hey Timothy,

             

            Our external community is only 6 months old (we launched July last year), but we decided to reset everyone's points on January 1st (they will be reset each year as well). We awarded the top 10 members with a role badge, identifying the 2014 champions. We haven't gone down the tangible prize path yet, but it's probably something we'll look at in the future. Personally we didn't experience any negative reactions to resetting member's points, in fact people seemed to love the idea! Maybe it was because they were receiving the badges  

             

            During the year, we want to hold monthly missions, where people can earn extra points for completing a set mission during that month. These missions are around behaviour we want to encourage in the site, or feedback we want to gather. Our January mission is going really well but coming up with 12 missions is a little difficult, I have three at the moment. January is all around creating a blog post, and earning a certain number of likes. For February we're looking at holding a survey on the community since we haven't actively asked for feedback on the site yet.  


            I'd be interested to hear what you're doing for your quarterly contests? Are they along the line of missions, or bigger contests?

              • Re: What time frames do you use for your external community contests?
                thales

                Emily Billing, I like the idea of monthly missions to drive the activity.

                 

                We chose not to reset the points. We are using a leaderboard for the time period, and resetting that for each contest period. I was not able to use the random giveaways as it is considered a illegal sweepstakes (thanks to our legal team for the input), so I took it back to the very basic foundation of the contest were it is points only. Looking into having a social and contribution contest showed that the winners would have been the same people. We are doing a semi annual contest and awarding the top 10 for each period, and then a grand prize contest for the whole year that awards the top three. Here are the prizes we decided on:

                 

                MVP Grand Prizes


                There will be one prize package awarded for each prize level at the end of the contest period.

                 

                1st Place Grand Prize

                • 2015 MVP GeoNet Badge
                • Certificate of Achievement
                • Winner’s choice of either Esri UC Conference Registration or Dev Summit Conference Registration
                • Winner’s choice of Apple iPad or Microsoft Surface Tablet

                2nd Place Grand Prize

                • 2015 MVP GeoNet Badge
                • Certificate of Achievement
                • Winner’s choice of either Esri UC Conference Registration or Dev Summit Conference Registration
                • $100 Amazon Gift Card

                3rd Place Grand Prize

                • 2015 MVP GeoNet Badge
                • Certificate of Achievement
                • Winner’s choice of either Esri UC Conference Registration or Dev Summit Conference Registration
                • $75 Amazon Gift Card

                Semi-annual Prizes


                Awarded twice a year based upon points earned during that time period. 1st Prize

                • 2015 MVP GeoNet Badge
                • Esri Certification Exam Registration or ArcGIS Home Use License
                • $75 Amazon Gift Card

                2nd Prize

                • 2015 MVP GeoNet Badge
                • Esri Certification Exam Registration or ArcGIS Home Use License
                • $50 Amazon Gift Card

                3rd Prize

                • 2015 MVP GeoNet Badge
                • Esri Certification Exam Registration or ArcGIS Home Use License
                • $25 Amazon Gift Card

                4th-10th Prize

                • 2015 MVP GeoNet Badge
                • Choice of either one (1) Esri Virtual Campus course (up to $224 value) or one (1) Esri Press publication.