Setup Guide - Hoopla with the Salesforce Integration

Connecting Hoopla with Salesforce is an easy way to automate management of Users and updates to Metrics.  Follow these instructions if you’re configuring Hoopla with the Salesforce integration. At a high level, you’ll create Salesforce reports and then use those reports to populate data into Hoopla.

Prep: Define Your Teams in Hoopla

Before getting started, you will need to Define Teams in Hoopla. Start by going to Configuration > Users and Teams. Do NOT add Users here. We’re going to do this later, with a Salesforce report.

  1. Click Teams.
  2. Click Add and give the Team a name. Optionally, upload a photo for the Team. Do not add members; the Salesforce integration will do this for you later.
  3. Repeat 1 & 2 for your remaining Teams.

Part I: Use Salesforce Reports to Populate Hoopla Data

Set Up the "Hoopla Reports" Folder

  1. In the Salesforce Reports tab, create a new report folder called “Hoopla Reports” and save it.

Create a User Report

  1. In the Salesforce Report Builder, create a new report based on the User object.
  2. Ensure the format is set to “Tabular”.
  3. Add criteria that will return the set of users who should be added to Hoopla. Only one report can be used to provision users, so make sure it includes ALL the right people!
  4. Add the “Email” field  and the “User ID” field as columns in the report; just click and drag each field from the left menu to the report. (You should also have First Name, Last Name,  and Username as columns, by default.)
  5. Run the report and save it to the “Hoopla Reports” folder.

Create Team Reports

You can manage Team membership through the Salesforce connector. Each Team in Hoopla can be populated and maintained with a single Salesforce report. Each time users are added or removed from the report, they are added or removed from the corresponding Hoopla Team. The beauty of using this feature is that it automates the assignment of players to Leaderboards and Newsflashes throughout your account.

  1. In the Salesforce Report Builder, create a new report based on the User object.
  2. Ensure the format is set to “Tabular”.
  3. Add criteria that will return the set of users who should be added to a specific Team within Hoopla. For example, you may want to build a report that will populate your Account Manager Team.
  4. Add the “User ID” field as a column in the report; just click and drag the field from the left menu to the report.
    • There is no need for additional fields, but you are welcome to leave first and last names in the report for your convenience.
  5. Run the report and save it to the “Hoopla Reports” folder.
  6. Repeat steps 1-5 for any additional Teams you want to populate in Hoopla.

Create Metric Reports

  1. In the Salesforce Report Builder, create a new report based on an object that you want to track.
  2. Example: Select the Opportunity object if you want to build a report on Month-to-Date Sales.
  3. Change the format to “Summary”.  This is the only format supported in Hoopla at this time.
  4. Group the report with a User Lookup field by dragging the desired field from the left to the drop zone.
  5. Example: on an Opportunity report, you’ll likely want to group by Opportunity Owner.
  6. Add Date Range criteria.
  7. Example: Close Date = This Month
  8. Add any other applicable criteria that will narrow down the results to the right set of records.
  9. Summarize the fields that will feed your Hoopla Metrics.
  10. Example: If you want to track Month-to-Date Sales, you’ll want to summarize the Amount field with the SUM for each Opportunity Owner.
  11. Run the report and save it to the “Hoopla Reports” folder.
  12. Repeat steps 1-7 for any other object types you want to track (e.g., Tasks and Events, Leads, Cases).

Part II: Map your data to Hoopla

Now that you’ve built all the necessary reports in Salesforce, you can now map your Users, Teams & Metrics into Hoopla.  

Connect Your Salesforce Reports to Hoopla

  1. In Hoopla Configuration, click the Add Integration menu in the upper right corner and select Salesforce.
  2. Click on the Salesforce tile that was just added to the Configuration home page.
  3. Click Authenticate with OAuth to connect to your Salesforce org. See this article for recommendations on who should click this button.
  4. Click Allow to grant Hoopla access.
  5. For Reports to Map, select the second option, which will show you the reports you’ve saved to the “Hoopla Reports” folder in Salesforce.
  6. In the User Provisioning section, click Select Report. Choose the report you created earlier, which includes ALL the users who should be added to Hoopla. Click Save at the top of the page.
  7. In the Teams Provisioning section, click Add. Select one of the Team reports you created earlier, and map it to the corresponding Team you defined in Hoopla. Click OK, and repeat for the remaining Teams.
  8. In the Report Wizard section, click Create a Leaderboard. Choose a Metric report, and map the desired fields from the report to the Metric(s) you’ve defined in Hoopla. If you have not defined any applicable Metrics in Hoopla, you may do so here by selecting Create a new Metric and giving it a Name. Schedule how often you want that report to sync with Hoopla, and then click next. You will then be prompted to create a Leaderboard. Give your Leaderboard a name, choose which type of Leaderboard you want to build (User or Team) and then add any additional Metrics to that Leaderboard (you only need one Metric, but may select up to four). Choose Players & Watchers for the Leaderboard and then click next.  Finally, you may select any Channels or Segments to add your new Leaderboard to (this is not required) and then click Create Leaderboard.
  9. If you simply want to map a report to a Metric without creating a Leaderboard, go into the Metric Sources section, click Add. Choose a Metric report, and map the desired fields from the report to the Metric(s) you’ve defined in Hoopla. Schedule how often you want that report to sync with Hoopla, click OK, then repeat for the remaining Metric reports.
  10. Click Save at the top of the page. Your reports will run in the background, updating your Users, Teams, and Metrics. That process may take a couple minutes.

Now you’re ready to configure your Hoopla TV Channels!

Use more of the Salesforce integration by creating Streaming Newsflashes and Data Tables.

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk