# Tags and segmentation Add tags and sales data to the input file, and use Tag Maps to highlight or colour products on a fixture. *** ## Add tags Tags are how you segment products. You can add as many tags to the input file as Excel can take. - Add a column that starts with **“tags.”** in the **products sheet** such as `tags.branded` and `tags.Country` below: | name | tags.branded | tags.Country | | -------------------- | ------------ | -------------- | | Planflakes Original | Brand | United Kingdom | | Planflakes Honey | Brand | United Kingdom | | Own label cornflakes | Own label | Germany | - Make sure no two columns have the same tag name, as Studio will not register the tags. - Keep each tag’s values in the same format: ‘Brand’ is different from ‘brand’. ## Tag maps The values of a tag, each with its colour, under Highlight by tag - Tags for subgroups and other attributes in the Excel input let you use Tag Maps and the Analysis tab. The Vazen team can help with this before you upload an input. - This will allow you to see where specific products and brands are located on the fixture, and how many of them are present. - In Studio, open the **Tags** tab of the side panel. Under **Highlight by tag**, choose a tag, then the values you’d like to see highlighted on shelf, and give each one a colour. - The colours you give are saved with the project, and in the Excel file when you download it. The tag and values you chose to highlight are not: choose them again when you next open the project. - Tags in the data allow you to highlight key areas of interest on shelf, such as a brand or a subcategory. - These same tags are what [Analysis](/studio/analysis) measures share of shelf by. ## Sales data - Add a column called **“tags.sales”** within the input file in the products sheet - Here you can add your sales figures per product (they do not all have to have a number associated with them) ## Colour by numbers Tag Map can also apply a colour gradient over a fixture based on any numerical data. You may like to map things such as Rate of Sale, Share of Spend, Share of Space or any other numerical value. ### Add the numbers In the products tab of your [spreadsheet](/studio/studio-excel-file), add a column whose name starts with `tags.`, such as `tags.sales`, `tags.shareOfSpace` or `tags.awesome`. The word you choose is the tag you pick under **Highlight by tag**. In this new Tag column of your spreadsheet add the data you wish to be mapped to the fixture. If you leave a cell in this column empty, and **Show No Data** is on in **Display Settings**, the Tag Map will render a tile reading **NO DATA** on the fixture. And if you enter a non-numeric value, the Tag Map will render a tile reading **INVALID**, again only while **Show No Data** is on. Once you have all of your data in your new column, save the Excel file and open it in Studio again. As you hover tiles on the fixture the raw data will appear over the product, such as `sales: 68`. ### Choose the colours Under **Colour numbers by**, choose **Scale** to blend colours between the numbers you set, or **Thresholds** to give each band of values its own colour. Both start from the lowest and highest values in your data, and you can change the numbers and the colours. Under **Display Settings** you can change the **Fixture tint** and the **Data opacity**, draw products individually or as blocks (for a text tag, or numbers coloured by Thresholds), draw the colour as a fill or an outline, and show the values, a key, the no data tiles and a legend. ### Wide ranges of numbers Until you change it, the colour in the scale is applied evenly between the max and min values of the data. This means that the colour distinction between values will be more difficult to see the larger the data range is. For example where the min tag data value is 0 and the max is 4, you will be able to clearly see the difference between values 2 and 4. But where the min is 0 and the max is 200,000, detecting the visual difference between 90,000 and 100,000, will be much harder. ## Feedback If you have any feedback or suggestions, do let us know at .