Tiers

The Tiers file contains data on the various tiers.

Delta export. Each daily file contains tiers created or updated during that day. Upsert on levelId and keep the row with the latest updatedAt.

File: analytics/Tiers/tiers_YYYY_MM_DD.csv Primary key: levelId

A sample file is provided below:

tiers_all_until_2025_09_16.csv

5KB

Open

Available Data:

Column	Type	Can be empty	Description
levelId	uuid	No	Unique tier ID
tenantId	uuid	No	Tenant ID
name	string	Yes	Tier name
description	string	Yes	Tier description
hasPhoto	boolean	Empty = false	Whether a photo exists
active	boolean	Empty = false	Whether active
conditionValue	decimal	Yes	Deprecated minimum condition
rewards	json array	No	Tier benefits
createdAt	datetime	No	Date created
updatedAt	datetime	No	Date last updated
tierSetId	uuid	Yes	Tier set ID
tierSetName	string	Yes	Tier set name
conditions	json array	No	Minimum conditions to reach the tier

conditionValue is a deprecated field. Use values from the conditions column instead.