The organisations Yapster serves are multi-site operators who use the Yapster newsfeed to distribute company news and recognition pieces at scale. Yapster’s newsfeed announcements feature allows senior leadership teams to communicate critical updates, with teams needing to interact with these posts to acknowledge the announcement (orange flashing icon).
Announcements pushed to the newsfeed are by definition relevant to all staff, whereas standard newsfeed posts aren’t guaranteed to be relevant to all teams at the same time.
Multi-timeline setup makes sure everything that you can see on your News tab stays relevant to you.
Download this template in order to complete your hierarchy importer - we'll require this in order to understand your company hierarchy, and how your sites relate to areas and regions within the organisation.
We've put together the following explainer to help you complete the above template. Feel free to send us your completed spreadsheet for review.
Hierarchy Imports
Fields
Hierarchy Flavour
The type of group being specified.
Will be either ‘location’ or ‘function’ (for role based groups.)
Group ID
The ID of the group in the user/group data provided to Yapster, as provided by the upstream HR system (e.g. RMS, Fourth, S4, CPL, etc.)
⚠️ CSV Imports
ℹ️ Creating New Groups
|
Group Name
The display name for the group. Note that you *only need to specify this for new groups.
If you specify a name in this import file for an existing group it will overwrite the name currently in use.
Group Role
An optional designation for the ‘level’ at which the group sits in the hierarchy.
For example, in a traditional retail store based business you will typically have a hierarchy similar to:
Example
In this example we have store, area, and region groups and these are the ‘roles’ we would assign. These roles can be used to provide more relevant grouping and greater fidelity in the dashboards and data analysis provided by Yapster.
⚠️ Yapster's dashboards are configured to work with ‘region → area → store’ hierarchies by default, if you wish to use other roles for your groups please discuss this with your account manager. |
Constructing a Row
Each row of the CSV file specifies one ‘branch’ of the hierarchy you are creating.
A row must specify:
The
hierarchy flavour
.At least two groups, specified by ID (with names if they are new groups.)
An example of a minimal import file follows:
hierarchy flavour | group id 1 | group id 2 |
location | A–10 | S–100 |
location | A–10 | S–110 |
location | A–20 | S–200 |
location | A–20 | S–220 |
This would establish the following hierarchy:
A–10
S–100
S–110
A–20
S–200
S–220
⚠️ Numeric Suffixes on Group Columns
Note that we have added a numeric suffix to the ‘group id’ columns: ‘group id 1’ and ‘group id 2’.
These must be provided and dictate the relationship between the groups. In this example the groups in ‘group id 1’ are the parents of those in ‘group id 2’.
The hierarchy is constructed in ascending order, from lowest to highest:
‘group id 1’
‘group id 2’
‘group id 3’
‘group id 4’
(The group specified under ‘group id 1’ becomes the parent of the group under ‘group id 2’, etc.)
You can specify as many groups on a row as you wish but they must have unique suffixes and those suffixes should be the same for the ‘group id’, ‘group name’, and ‘group role’ of each individual group.
(The order of the columns in the file doesn’t matter—only the numeric sequence.)
ExampleThis example presents the import sheet for a fictional group of pubs that we want to group by country and region so that we can address all pubs (and therefore employees) with relevant regional, or country specific news and announcements. A sample of our company hierarchy looks like, group IDs are in parenthesis:
|
Our user/group import is a CSV file that only specifies each employees primary location (e.g. the pub they work in.) We also have country and region managers that are assigned to those groups.
After a user/group import our Yapster directory just has the following groups in a flat list:
England (ENG)
Northern England (NE)
Southern England (SE)
The Bishop on the Bridge (TBOTB)
The Four Elms (TFE)
The Union Arms (TUA)
Wales (WLS)
There is no hierarchy and no way to address all employees in a given region or area.
We can use a hierarchy import to fix that and create the relationships between our countries, regions, and pubs:
hierarchy flavour | group id 1 | group role 1 | group id 2 | group role 2 |
location | ENG | region | NE | area |
location | ENG | region | SE | area |
location | NE |
| TUA | store |
location | SE |
| TBOTB | store |
location | WLS | region | TFE | store |
In the above example we’ve:
Specified that Northern and Southern England (‘NE’ and ‘SE’ respectively) are areas within the England (ENG) region (lines 1 and 2.)
Placed The Union Arms (TUE) into Northern England (line 3) and The Bishop on the Bridge (TBOTB) into Southern England (line 4.)
Added The Four Elms (TFE) as a store within the Wales (WLS) region (line 5.)
After importing this file our group hierarchy in Yapster would match that of the diagram above.
(We’ve used the roles of ‘region’, ‘area’, and ‘store’ to benefit from Yapsters existing data analysis based on those groupings.)
We could also specify the exact same hierarchy by having one row in the import file per pub:
hierarchy flavour | group id 1 | group role 1 | group id 2 | group role 2 | group id 3 | group role 3 |
location | ENG | region | NE | area | TUA | store |
location | ENG | region | SE | area | TBOTB | store |
location | WLS | region |
|
| TFE | store |
This would result in exactly the same relationships and hierarchy being created in Yapster. There is no benefit to either style—you can use whichever is most convenient for you and your data (and even have a mix of both!).
Creating New Groups
The above example has regional groupings for England but none for Wales as they were not present in our primary user/group import.
We can rectify this by creating Welsh regional groups in our hierarchy import:
hierarchy flavour | group id 1 | group role 1 | group id 2 | group name 2 | group role 2 |
location | ENG | region | NE |
| area |
location | ENG | region | SE |
| area |
location | WLS | region | CDG | Ceredigion | area |
location | NE |
| TUA |
| store |
location | SE |
| TBOTB |
| store |
location | CDG |
| TFE |
| store |
Or, again, with all the groups of a ‘branch’ on a single row:
hierarchy flavour | group id 1 | group role 1 | group id 2 | group name 2 | group role 2 | group id 3 | group role 3 |
location | ENG | region | NE |
| area | TUA | store |
location | ENG | region | SE |
| area | TBOTB | store |
location | WLS | region | CDG | Ceredigion | area | TFE | store |
ℹ️ Note that we only need to specify the name of the new group, we don’t need to specify the names of the other groups as they already exist in Yapster.
Following this import our hierarchy in Yapster would look like:
England (ENG)
Northern England (NE)
The Union Arms (TUA)
Southern England (SE)
The Bishop on the Bridge (TBOTB)
Wales (WLS)
Ceredigion (CDG)
The Four Elms (TFE)