Events dataset

Events by Project

Stores details of all active events in Monterosa Studio within the customer Organisation.

Table name: customer_schema.silver_events

Data source: Monterosa Control API

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]
event_name	string	Name of event in Monterosa Studio	Weekly quiz 11/23
start_time	timestamp	Time the event started in Studio (UTC)	2023-11-23 12:00:12.000
end_time	timestamp	Time the event ended in Studio (UTC)	2023-11-30 12:00:02.000
content_tags	array(string)	List of content tags assigned in Studio	[“bulls”,”lakers”,”weekly-quiz”]
state	string	State of event - future, current or past	current
event_type	string	Type of Experience this event represents	Daily Trivia
question_count	integer	No. of questions in the event	4

Sample CSV data:

"project_id","event_id","event_name","start_time","end_time","content_tags","state","event_type","question_count"
"3e5f63c1-2b8f-4f28-b2e4-0a3097c6c153","b6a96d1c-c62d-4c28-a0d8-9f8378e5a1fd","Trivia Night","2023-11-01 19:00:00","2023-11-01 20:30:00","ENG,WAL,SCO","current","trivia",5
"45c3a076-2643-4a2b-9c02-9f67b9e5c18d","db347e45-3dd2-4f8c-8aef-6c0ed0ac9ef1","Vote for Your Fave","2023-11-15 08:00:00","2023-11-15 20:00:00","FRA,IRE","past","vote",1
"88a7d5ed-9833-47b9-8667-1d14c1e864c4","2ff46fe5-6ea9-44da-bb12-72c6d7f86ef8","Sports Trivia","2023-12-05 19:30:00","2023-12-05 21:00:00","ENG,SCO","current","trivia",6
"4c4ce4b3-589a-49d3-8966-2f57b4a41c2a","98712b6e-1b25-421d-893b-596d09c3f65e","MVP Vote","2023-11-20 08:00:00","2023-11-20 19:00:00","SCO,WAL","past","vote",1
"feb18ef4-2c7c-498f-86ab-86ed564b7c1e","bcf7f184-085c-4218-9323-36be1eb61b45","Daily Trivia","2023-12-10 20:00:00","2023-12-10 21:30:00","ENG,IRE","current","trivia",6

Sample JSON data:

[
  {
    "project_id": "3e5f63c1-2b8f-4f28-b2e4-0a3097c6c153",
    "event_id": "b6a96d1c-c62d-4c28-a0d8-9f8378e5a1fd",
    "event_name": "Trivia Night",
    "start_time": "2023-11-01 19:00:00",
    "end_time": "2023-11-01 20:30:00",
    "content_tags": ["ENG", "WAL", "SCO"],
    "state": "current",
    "event_type": "trivia",
    "question_count": 5
  },
  {
    "project_id": "45c3a076-2643-4a2b-9c02-9f67b9e5c18d",
    "event_id": "db347e45-3dd2-4f8c-8aef-6c0ed0ac9ef1",
    "event_name": "Vote for Your Fave",
    "start_time": "2023-11-15 08:00:00",
    "end_time": "2023-11-15 20:00:00",
    "content_tags": ["FRA", "IRE"],
    "state": "past",
    "event_type": "vote",
    "question_count": 1
  },
  {
    "project_id": "88a7d5ed-9833-47b9-8667-1d14c1e864c4",
    "event_id": "2ff46fe5-6ea9-44da-bb12-72c6d7f86ef8",
    "event_name": "Sports Trivia",
    "start_time": "2023-12-05 19:30:00",
    "end_time": "2023-12-05 21:00:00",
    "content_tags": ["ENG", "SCO"],
    "state": "current",
    "event_type": "trivia",
    "question_count": 6
  },
  {
    "project_id": "4c4ce4b3-589a-49d3-8966-2f57b4a41c2a",
    "event_id": "98712b6e-1b25-421d-893b-596d09c3f65e",
    "event_name": "MVP Vote",
    "start_time": "2023-11-20 08:00:00",
    "end_time": "2023-11-20 19:00:00",
    "content_tags": ["SCO", "WAL"],
    "state": "past",
    "event_type": "vote",
    "question_count": 1
  },
  {
    "project_id": "feb18ef4-2c7c-498f-86ab-86ed564b7c1e",
    "event_id": "bcf7f184-085c-4218-9323-36be1eb61b45",
    "event_name": "Daily Trivia",
    "start_time": "2023-12-10 20:00:00",
    "end_time": "2023-12-10 21:30:00",
    "content_tags": ["ENG", "IRE"],
    "state": "current",
    "event_type": "trivia",
    "question_count": 6
  }
]