Interactions dataset

User interactions by Element

Stores details of all active user interactions with questions (or other interactive elements). This is streamed in near-real time.

Table name: customer_schema.silver_interactions

Data source: Monterosa Enmasse Warehouse

Update method: Batch or stream

Update frequency: TBD

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

Note that this table can be provided with a subset of these fields when it is used in conjunction with other datasets described here. The full dataset can also be used as a standalone export of interactions.

Fields marked in bold are provided in the reduced 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 Studio	Daily Trivia 10/10
user_id	string	Monterosa User identifier (signed in users)	[uuid]
user_sid	string	Monterosa Anonymous User identifier (all users)	[uuid]
user_external_id	string	Customer/SSO user ID (signed in users)	[uuid]
element_id	string	Unique Element identifier	[uuid]
poll_id	integer	Unique Element short identifier	98765
question_text	string	Text of question in Studio	Which team will win?
option	integer	1-based index of user’s selected option	2
option_text	string	Text of answer option in Studio	Lakers
correct_option	integer	1-based index of correct option (if known)	1
interactions	integer	Number of interactions (usually 1 but can be more for some content types)	1
timestamp	double	Time the interaction happened (UTC)	2023-11-30 12:00:02.000
date	date	Date the interaction happened (UTC)	2023-11-30

Sample CSV Data:

"project_id","event_id","event_name","user_id","user_sid","user_external_id","element_id","poll_id","content_type","question_text","option","option_text","correct_option","interactions","timestamp","date"
"8eaf7fab-7ee3-416e-ab13-1501d1b52717","e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb","Daily Trivia 10/10","30e560e7-4528-4c4c-8725-657bec61a6e3","b195eb6f-3cdb-4e35-8039-c5dfcda71910","09d20d99-dfd8-4b24-b460-4ee589cd234a","f9febbdf-60d4-49c6-b6e5-2d33a740e5c1",46244,"quickfire-quiz-question","Which stadium was this year's World Cup Final held in?",3,"Stade de France",3,1,1699276107662,"2023-11-06"
"8eaf7fab-7ee3-416e-ab13-1501d1b52717","e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb","Daily Trivia 10/10","30e560e7-4528-4c4c-8725-657bec61a6e3","b195eb6f-3cdb-4e35-8039-c5dfcda71910","09d20d99-dfd8-4b24-b460-4ee589cd234a","585953bc-bc70-427d-be0f-282677754eab",46245,"quickfire-quiz-question","Whose try was disallowed?",2,"Siya Kolisi",1,1,1699276118865,"2023-11-06"

Sample JSON Data:

[
  {
    "project_id":"8eaf7fab-7ee3-416e-ab13-1501d1b52717",
    "event_id":"e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb",
    "event_name":"Daily Trivia 10/10",
    "user_id":"30e560e7-4528-4c4c-8725-657bec61a6e3",
    "user_sid":"b195eb6f-3cdb-4e35-8039-c5dfcda71910",
    "user_external_id":"09d20d99-dfd8-4b24-b460-4ee589cd234a",
    "element_id":"f9febbdf-60d4-49c6-b6e5-2d33a740e5c1",
    "poll_id":46244,
    "content_type":"quickfire-quiz-question",
    "question_text":"Which stadium was this year's World Cup Final held in?",
    "option":3,
    "option_text": "Stade de France",
    "correct_option":3,
    "interactions":1,
    "timestamp":1699276107662,
    "date":"2023-11-06"
  },
  {
    "project_id":"8eaf7fab-7ee3-416e-ab13-1501d1b52717",
    "event_id":"e3d9c9f4-b16d-4d69-a9ce-3fb4ff6477bb",
    "event_name":"Daily Trivia 10/10",
    "user_id":"30e560e7-4528-4c4c-8725-657bec61a6e3",
    "user_sid":"b195eb6f-3cdb-4e35-8039-c5dfcda71910",
    "user_external_id":"09d20d99-dfd8-4b24-b460-4ee589cd234a",
    "element_id":"585953bc-bc70-427d-be0f-282677754eab",
    "poll_id":46245,
    "content_type":"quickfire-quiz-question",
    "question_text":"Whose try was disallowed?",
    "option":2,
    "option_text": "Siya Kolisi",
    "correct_option":1,
    "interactions":1,
    "timestamp":1699276118865,
    "date":"2023-11-06"
  }
]