Elements dataset

Elements by Event

Stores details of all active elements/questions in Monterosa Studio within the customer Organisation.

Table name: customer_schema.silver_elements

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]
element_id	string	Unique Element identifier	[uuid]
poll_id	integer	Unique Element identifier referenced by the interactions dataset	98765
content_type	string	Monterosa content type for the element	trivia
element_name	string	Name of Element - normally the text of the question	Which player scored the most points this week?
options	array(string)	List of answer option texts	[“Curry”,”Djokic”]
option_metadata	array(string)	List of metadata associated with each answer option (e.g. Team ID)	[“DEN”,”MIN”]
element_order	integer	1-based index of the order of the element within the event (e.g. question number in a quiz)	3
correct_option	integer	1-based index of correct answer (where relevant)	1
start_time	timestamp	Time the question started in Studio (UTC)	2023-11-23 12:00:12.000
end_time	timestamp	Time the question 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”]

Sample CSV data:

"project_id","event_id","element_id","poll_id","content_type","element_name","options","option_metadata","element_order","correct_option","start_time","end_time","content_tags"
"3e5f63c1-2b8f-4f28-b2e4-0a3097c6c153","b6a96d1c-c62d-4c28-a0d8-9f8378e5a1fd","c8d7e1c3-542a-4b3e-9f87-9f8e7a1d29cf",12345,"trivia-question","Question 1",["Option A","Option B","Option C"],[],1,2,"2023-11-01 19:00:00","2023-11-01 19:30:00",["ENG","SCO"]
"45c3a076-2643-4a2b-9c02-9f67b9e5c18d","db347e45-3dd2-4f8c-8aef-6c0ed0ac9ef1","6ed3b7f2-45e2-4b1d-8a1f-3e6e6a2f0b7e",67890,"trivia-question","Question 2",["Option X","Option Y","Option Z"],[],2,1,"2023-11-15 08:00:00","2023-11-15 08:30:00",["FRA","IRE"]
"88a7d5ed-9833-47b9-8667-1d14c1e864c4","2ff46fe5-6ea9-44da-bb12-72c6d7f86ef8","f6e8d1d1-af12-4d2a-8cf1-9f9e8e2e95ff",54321,"trivia-question","Question 3",["Option P","Option Q","Option R"],[],3,3,"2023-12-05 19:00:00","2023-12-05 19:30:00",["ENG","SCO"]
"4c4ce4b3-589a-49d3-8966-2f57b4a41c2a","98712b6e-1b25-421d-893b-596d09c3f65e","d4c8d9b6-1e85-4b4b-8e4a-a1b8b8f8bc8d",98765,"trivia-question","Question 4",["Option M","Option N","Option O"],[],4,2,"2023-11-20 08:00:00","2023-11-20 08:30:00",["SCO","WAL"]
"feb18ef4-2c7c-498f-86ab-86ed564b7c1e","bcf7f184-085c-4218-9323-36be1eb61b45","e1c8e4f7-7f4d-4b1d-8f32-5c6c0e1e4fcd7",13579,"trivia-question","Question 5",["Option J","Option K","Option L"],[],5,1,"2023-12-10 20:00:00","2023-12-10 20:30:00",["ENG","IRE"]

Sample JSON data:

[
  {
    "project_id": "3e5f63c1-2b8f-4f28-b2e4-0a3097c6c153",
    "event_id": "b6a96d1c-c62d-4c28-a0d8-9f8378e5a1fd",
    "element_id": "c8d7e1c3-542a-4b3e-9f87-9f8e7a1d29cf",
    "poll_id": 12345,
    "content_type": "trivia-question",
    "element_name": "Question 1",
    "options": ["Option A", "Option B", "Option C"],
    "option_metadata": [],
    "element_order": 1,
    "correct_option": 2,
    "start_time": "2023-11-01 19:00:00",
    "end_time": "2023-11-01 19:30:00",
    "content_tags": ["ENG", "SCO"]
  },
  {
    "project_id": "45c3a076-2643-4a2b-9c02-9f67b9e5c18d",
    "event_id": "db347e45-3dd2-4f8c-8aef-6c0ed0ac9ef1",
    "element_id": "6ed3b7f2-45e2-4b1d-8a1f-3e6e6a2f0b7e",
    "poll_id": 67890,
    "content_type": "trivia-question",
    "element_name": "Question 2",
    "options": ["Option X", "Option Y", "Option Z"],
    "option_metadata": [],
    "element_order": 2,
    "correct_option": 1,
    "start_time": "2023-11-15 08:00:00",
    "end_time": "2023-11-15 08:30:00",
    "content_tags": ["FRA", "IRE"]
  }
]