Generic Metrics via Google Sheets (Hoopla)

Many business metrics cannot be attributed to an individual user or even a team. For example, you may want to show the company's stock price, website traffic, or month-over-month growth. To display those types of values in Hoopla, you should leverage Generic Metrics.

Each Generic Metric value has a Generic Identifier, which takes the place of what is traditionally a User or Team.
Example: You have a Metric called Website Traffic. Within that Metric, you may have three values represented by three different Generic Identifiers: Home Page, Product Page, and Pricing Page.

Adding a Generic Identifier Value via Google Sheets

  1. Within a Google spreadsheet, create a new sheet tab.
    Name it something that you'll be able to recognize later.

  2. Add a column with the label Generic Identifier.

  3. Within that column, enter one or more names that will carry metric values. (See examples above.) You can use Generic IDs that you've used before, or define a new one.

  4. Assign a value to each Generic Identifier.
    (These values could be calculated from other metrics, or even come from other systems.)

  5. In the Hoopla Configure menu, go to Integrations/Google Sheets and add or edit a spreadsheet mapping configuration. In the Google Hoopla section, select your Generic Identifier sheet tab and map the appropriate columns to their corresponding Hoopla Metrics. Save.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request