Skip to main content

Upload reference: Tags tab

Columns, rules and examples for the Tags tab of the upload workbook.

Columns

Column

Required

Description

type

Yes

The kind of tag, for example facility or business_unit

name

Yes

The tag's identifier. This is the value you use to reference the tag everywhere else.

title

No

The display name shown in Measure

Any other column

No

Each extra column becomes a trait. The column header is the trait name and the cell is its value.

Key: type + name

Example

type

name

title

country

administrative_area

locality

facility_type

us_egrid

facility

denver-office

Denver - Office

US

CO

Denver

Office

RMPA

facility

denver-warehouse

Denver - Warehouse

US

CO

Denver

Warehouse

RMPA

business_unit

west

West Region

Rules for type

  • Use lowercase letters, digits and underscores only, for example business_unit.

  • Hyphens, periods and spaces are not allowed in a type.

  • Don't name a type ref_id, label, category, active_at, retired_at or action. These are reserved column names on the Activities tab.

  • Watch for typos. facilty creates a separate tag type that won't match your other data.

Rules for name

  • Letters and digits, with single hyphens, underscores or periods between them, for example denver-office or site_01.

  • Must start and end with a letter or digit.

  • No spaces, no other punctuation and no accented characters.

  • We recommend all lowercase.

Do you need a row here?

You only need a Tags row for a tag if you want to give it a title or traits. If an activity references a tag that doesn't exist yet, Measure creates it automatically, but with no title.

Tags with controlled types, such as country, fuel_code, gas and us_egrid, generally don't need a row here. Measure already knows them and shows their display names.

Did this answer your question?