Mapping Data from Excel Online to Hoopla

To help automate Metric updates, you can map data from an Excel Online spreadsheet into Metrics that are defined in Hoopla. As the data in the spreadsheet changes, Hoopla will update Metric data accordingly.

How to Set Up Mappings from Excel to Hoopla

  1. In Configuration, click on the Excel Online tile.

  2. Under Metric Sources, click Add.

  3. Select the Excel spreadsheet from which you want to pull data. In each tab that you want to map, you must have a Column called “Email” that contains your Hoopla users’ email addresses.

  4. Start mapping your Columns to Hoopla Metrics.
    • Select the Column in Excel
    • Select the Metric to map the Column to

  5. Schedule how frequently Hoopla should sync with this Excel spreadsheet.

  6. Click OK, then Save.

What are the Rules for Mappings?

  1. Your Excel spreadsheet must contain summarized information, grouped by user email addresses. There must be a Column called “Email”, and the remaining Columns should contain Metric values for each user. Example:

    Email MTD Sales Calls Today
    andy@example.com $56,790 23
    braeden@example.com $66,720 34
    carrie@example.com $62,113 21
     
  2. Hoopla will only update data for rows that contain a valid email address for users who exist in Hoopla. In other words, if Hoopla doesn’t recognize the email, the row is ignored.

  3. Within a given Sheet Tab, you cannot map multiple Columns to one Metric.

  4. You can map multiple Columns to one Metric as long as those Columns come from different Sheet Tabs.

  5. You can map one Column to multiple Metrics.

  6. You cannot create "loops" by mapping the same Metric and Column in both directions. In other words, you cannot map Metric 1  Column A, then map Column A  Metric 1. 
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk