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

Updated on: 09/02/2024