Leaderboard (Event) dataset

User ranks and scores by event

Stores details of all leaderboards for events where these are set up in Monterosa Studio.

Table name: customer_schema.silver_leaderboard_event

Data source: Monterosa Gamify

Update method: Batch

Update frequency: TBD

See Monterosa Identifiers for details of the IDs used in this dataset

Column	Type	Description	Example
project_id	string	Unique Project identifier	[uuid]
event_id	string	Unique Event identifier	[uuid]
user_id	string	Monterosa User identifier	[uuid]
rank	integer	1-based rank in leaderboard (adjusted for ties, e.g. 1,2,3,3,5,6)	2122
points	integer	Total points scored by the user in this event	90

Sample CSV data:

"project_id","event_id","user_id","rank","points"
"e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb","8eaf7fab-7ee3-416e-ab13-1501d1b52717","30e560e7-4528-4c4c-8725-657bec61a6e1",1,200
"e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb","8eaf7fab-7ee3-416e-ab13-1501d1b52717","d3291944-1d88-4686-8f16-7d0de6bb17d8",2,190
"e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb","8eaf7fab-7ee3-416e-ab13-1501d1b52717","6f508617-0a4f-4953-9e2d-925c10ffec67",3,180
"e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb","8eaf7fab-7ee3-416e-ab13-1501d1b52717","27e21f6c-0b8e-4e89-bc22-6e499f61142c",4,170
"e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb","8eaf7fab-7ee3-416e-ab13-1501d1b52717","8c6e1a86-581e-4fa5-92e7-905c61a4efb6",5,160

Sample JSON data:

[
    {
        "project_id": "e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb",
        "event_id": "8eaf7fab-7ee3-416e-ab13-1501d1b52717",
        "user_id": "30e560e7-4528-4c4c-8725-657bec61a6e1",
        "rank": 1,
        "points": 200
    },
    {
        "project_id": "e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb",
        "event_id": "8eaf7fab-7ee3-416e-ab13-1501d1b52717",
        "user_id": "d3291944-1d88-4686-8f16-7d0de6bb17d8",
        "rank": 2,
        "points": 190
    },
    {
        "project_id": "e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb",
        "event_id": "8eaf7fab-7ee3-416e-ab13-1501d1b52717",
        "user_id": "6f508617-0a4f-4953-9e2d-925c10ffec67",
        "rank": 3,
        "points": 180
    },
    {
        "project_id": "e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb",
        "event_id": "8eaf7fab-7ee3-416e-ab13-1501d1b52717",
        "user_id": "27e21f6c-0b8e-4e89-bc22-6e499f61142c",
        "rank": 4,
        "points": 170
    },
    {
        "project_id": "e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb",
        "event_id": "8eaf7fab-7ee3-416e-ab13-1501d1b52717",
        "user_id": "8c6e1a86-581e-4fa5-92e7-905c61a4efb6",
        "rank": 5,
        "points": 160
    }
]