Many of you are using the Gamification, Engagement, and Rewards module to incentivize particular behaviors in your community, and you're probably familiar with the reporting available on the Analytics tab:
- Users (total and new users)
- Points (total points earned from actions/badges)
- Actions (top actions completed and count)
- Challenges (top badges completed and count)
If you're like me, you might find the Challenges to be the most useful report, but also like me, you might find that you need data on more than the top 10 missions. What you might have not known is that Bunchball has some advanced reporting behind the scenes that you can use to get a full list of completed missions. Here is how you can get access and run this report:
- First off, you're going to need access to the advanced Nitro console at Nitro Admin Console along with the advanced reports. You're also going to need an additional set of credentials to download the Segment reporting files, so request all this in a support case before you proceed.
- Once you log into the Nitro console, you'll see a bunch of extra tabs along the left column, but the important one for our purposes is the Analytics tab.
- On that tab, you should see a new addition at the top of the page for Segments reporting in addition to Metrics.
- Click on that Segments tab. You'll see a few options for reports in the User Segment dropdown, like All Actions Logged, All Challenges Logged, etc.
- For this completed mission report, I just enter in a name, the chosen data, a date range, and an email to receive the output. Once I have this completed, I click Submit.
- You'll get an email notification when the user segment calculation is complete to the address you specified when creating the report. When you return to the Nitro console, you'll see your report in the Queued / Completed Segments section over on the right.
- If you click on the report URL from the email or the Completed Segments tab, it'll prompt you for your advanced reporting credentials. Enter those, and it'll download a TSV file containing the data.
- Once you have TSV file downloaded, you can open Excel and open the file. It'll take you through a few screens to format the data, but just click Finish and it'll format just fine. Be sure to open Excel first then open the file; Excel might not know what to do with it otherwise.
- Select all of the data (ctrl-a) and Insert > Pivot Table.
- Inside of that pivot table, pull Challenge Name into the Row Labels box and User ID into values. Change the value field settings for User ID to 'count' instead of 'sum' so that each id counts as a separate mission completion.
- Then voila! You have all of your missions completion counts for the month. You can place this data into your standard reporting mechanism. I personally recommend pulling this data once a month a trending over time. You're investing time and money in your gamification program, and you need to be able to report on the efficacy of this investment.
Note: Once you download the data, you'll see that the timestamps are in a crazy Unix timestamp, but unless you're reporting daily numbers, you won't need to get to this level. Just select a full month of data and use it in full.
Also note: If you want to see the people who have completed a particular mission, drag in User Id below the Challenge Name in the Row Labels. That'll keep the mission as the primary and give you the user id breakdown as well.
I hope you find this writeup helpful, and please let me know if you have any other gamification reporting tricks I can add to my arsenal.