Company News

7 ways to get data into Hoopla


Some people say they don’t like math, but it seems everyone loves numbers. The Olympics, elections, fantasy football, everywhere you look people are throwing around numbers. There’s even a number in the title of this post! Hoopla is no different. There are a lot of ways to use Hoopla to communicate, but one of the key features is getting the numbers your team cares about onscreen.

Of course, at most companies the most important numbers are revenue. Sales teams have always had their eyes on numbers. And when it comes to displaying sales numbers, Hoopla has you covered. But remember, everyone loves numbers. Obviously, the marketing team wants to count leads and the support team wants to count cases. And Hoopla can do that. But you can also use Hoopla to track the medal count for the office Olympics or the results of the company taco eating contest. If there’s something you want to count, Hoopla has a way to track the data.

This post is going to take a look at all the ways you can populate metrics in Hoopla. There are currently seven, but we’re always looking to add new options. We’ll start with the simple and work our way towards the more powerful. Along the way, we’ll go over how each option works, and some examples of how it might be used.


1. Web App

How it works: Log into Hoopla, find the metric you want, and edit any player’s value. This is the simplest way to get data into Hoopla as well as the most flexible.

When to use it: For anything without a standardized data source. Here at Hoopla, we’ve used this to track volunteer hours and an office fitness challenge. Pretty much anything you want to count that doesn’t fit the other options.


2. Spreadsheet File Upload

How it works: Log into Hoopla and upload an Excel or .csv file with your team’s data.

When to use it: You probably already have someone in the office who’s a spreadsheet maestro. Anything you’re tracking in a spreadsheet, from calls made to progress towards President’s Club, is fair game.


3. Spreadsheet Email Upload

How it works: Email Hoopla with an Excel or .csv file with your team’s data.

When to use it: Just like uploading a file, but more convenient. We’re now getting into options that can be automated. Many data sources like CRMs can be configured to email a spreadsheet on a scheduled basis. Point those emails towards Hoopla and watch the data stream automatically.


4. Salesforce

How it works: In the Hoopla app, make an OAuth connection to Salesforce. Then choose the reports you want and Hoopla pulls the data automatically.

When to use it: This is a no-brainer. If you’re using Salesforce, you’ve got data to track. The odds are that you’re using a report to track it. Simply map that report into Hoopla and take your data from the CRM to the big screen.


5. Google Sheets

How it works: In the Hoopla app, make an OAuth connection to a Google account. Then choose the sheets you want to use.

When to use it: take our spreadsheet file upload, and kick it up to 11. First, Hoopla will automatically sync with your sheet, so you always have up-to-date numbers. Second, the numbers can flow both ways. This means you can export metrics into the sheet, perform any calculations you want, then take the result and throw it back into Hoopla. You can do this with metrics from any source, including Salesforce. This makes it perfect for running SPIFFs that are point based or for calculating win rates. Google Sheets are also great if you want to let your team self-report a metric. Just share the sheet and let your team enter their own numbers. Works wonderfully for fun office challenges.


6. Zapier

How it works: Zapier is a platform that connects apps. You can use Zapier to update a metric in Hoopla when one of your other apps triggers.

When to use it: The sky’s the limit with this one. Support cases from Zendesk? Check. Developer tickets in JIRA? Check. Marketo, Google Calendar, Twitter, a bunch of CRMs and hundreds of other apps? Check. Zapier already integrates with a ton of apps, which means so does Hoopla. So if there’s an app your team uses, check out if it has a Zapier connection. If it does, you can get your team’s numbers on Hoopla. Don’t let sales have all the fun, now any department can get their brag on!


7. API

How it works: Use Hoopla’s developer resources to write your own code to update your data in Hoopla.

When to use it: Now there are no limits. If you have coders at your disposal, you can feed data into Hoopla from anywhere. Hook up your home brew CRM or even track the downtime of industrial equipment. If you work at a software company, create a link from your product to Hoopla. The possibilities are endless.