Generic Metrics via Google Sheets

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. 

Generic Identifier Value
Home Page 25,629
Product Page 20,093
Pricing Page 13,904

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.
    • 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.

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

  4. In Hoopla Configuration, click on the Google Sheets tile 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.
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk