What do each of the exported fields mean?
For view exports and API queries, some or all of the following fields are returned:
id: Unique ID for the view
owner_id: ID of the Mindstamp user that owns the video
video_id: ID of the Video that the View took place on
video_title: Title of the Video that the view took place on
started: The datetime that the view started (UTC format)
finished: The datetime that the view ended (UTC format)
elapsed: The elapsed time in seconds between the start and finish, representing total engagement time
watched: The number of seconds of true video content the viewer spent watching
percentage: The percentage of the video content the viewer watched
furthest_point: The furthest point in the video content that the viewer reached during their experience
last_point: The point in the video the viewer was at when their experience ended
viewer_id: Mindstamp's unique identifier for the viewer
viewer_name: Viewer name, if exists
viewer_email: Viewer email, if exists
viewer_phone: Viewer phone, if exists
viewer_custom: Viewer custom ID, if exists
interaction_count: Number of interactions made by the viewer during this view
has_exact_location: Only true if precise location was enabled and viewer consented
latitude: Viewer's latitude, if collected via precise location
longitude: Viewer's longitude, if collected via precise location
browser: Viewer's browser name and version
screen_width: Width of viewer's screen
screen_height: Height of viewer's screen
participation: Score representing the percentage of questions the viewer responded to, e.g. responding to 3 out of 5 questions would be 60 to represent 60%
correctness: Score representing the percentage of questions the viewer responded to correctly out of total responses, e.g. getting 1 out of 4 questions correct would be 25
plink_id: The personalized link ID used within this viewing session, if exists
group_id: ID of the Mindstamp group this video is in, if exists
group_name: Name of the Mindstamp group this video is in, if exists
prompt_count: Number of questions within the video
response_count: Number of questions the viewer answered while viewing
correct_count: Number of questions answered correctly by the viewer
wrong_count: Number of questions answered incorrectly by the viewer
variables: Hash of variables set or passed in during the viewing experience
id: Unique ID for the view
owner_id: ID of the Mindstamp user that owns the video
video_id: ID of the Video that the View took place on
video_title: Title of the Video that the view took place on
started: The datetime that the view started (UTC format)
finished: The datetime that the view ended (UTC format)
elapsed: The elapsed time in seconds between the start and finish, representing total engagement time
watched: The number of seconds of true video content the viewer spent watching
percentage: The percentage of the video content the viewer watched
furthest_point: The furthest point in the video content that the viewer reached during their experience
last_point: The point in the video the viewer was at when their experience ended
viewer_id: Mindstamp's unique identifier for the viewer
viewer_name: Viewer name, if exists
viewer_email: Viewer email, if exists
viewer_phone: Viewer phone, if exists
viewer_custom: Viewer custom ID, if exists
interaction_count: Number of interactions made by the viewer during this view
has_exact_location: Only true if precise location was enabled and viewer consented
latitude: Viewer's latitude, if collected via precise location
longitude: Viewer's longitude, if collected via precise location
browser: Viewer's browser name and version
screen_width: Width of viewer's screen
screen_height: Height of viewer's screen
participation: Score representing the percentage of questions the viewer responded to, e.g. responding to 3 out of 5 questions would be 60 to represent 60%
correctness: Score representing the percentage of questions the viewer responded to correctly out of total responses, e.g. getting 1 out of 4 questions correct would be 25
plink_id: The personalized link ID used within this viewing session, if exists
group_id: ID of the Mindstamp group this video is in, if exists
group_name: Name of the Mindstamp group this video is in, if exists
prompt_count: Number of questions within the video
response_count: Number of questions the viewer answered while viewing
correct_count: Number of questions answered correctly by the viewer
wrong_count: Number of questions answered incorrectly by the viewer
variables: Hash of variables set or passed in during the viewing experience
Updated on: 09/02/2024
Thank you!