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:
Sample JSON data: