What does each exported field mean?

Mindstamp Export and API Fields Explained

Short answer

A views export has one row for each viewing session. The main columns are the start time, video, viewer identity, watched percentage, scores, watch and engagement time, last point and furthest point, browser, screen size and location. The API and view webhooks return the same data with snake_case field names.

Views CSV columns

STARTED and FINISHED: when the session started and when it ended, in the timezone of your account.
VIDEO: the video title.
NAME, EMAIL, PHONE, CUSTOM_ID: the viewer identity, if it was collected or passed in.
WATCHED_PERCENTAGE: unique seconds played, divided by the video length.
INTERACTIONS: the number of answers, clicks and responses in the session.
PARTICIPATION: the percentage of questions the viewer answered. Three answers out of five questions is 60.
CORRECTNESS: the percentage of answers that were correct. One correct answer out of four is 25.
URL: the page where the video played. For an embed, this is the host page.
STREAMED TIME and STREAMED SECONDS: video content the viewer played.
ENGAGEMENT TIME and ENGAGEMENT SECONDS: time from the start of the session to its last activity, including pauses and time on questions.
LAST POINT and FURTHEST POINT: where the viewer stopped, and the latest point they reached.
BROWSER, SCREEN WIDTH, SCREEN HEIGHT, CITY, REGION, COUNTRY: device and approximate location.
ID and VIEWER ID: the view record and the viewer record.

Interactions and viewers CSV columns

An interactions export has DATE, VIDEO, NAME, EMAIL, CUSTOM_ID, PHONE, PROMPT_TYPE, PROMPT, TYPE, VALUE, IS_CORRECT, RESPONSE TIME, VIEW_ID, ID and VIEWER_ID, with one row for each answer or click.

A viewers export has CREATED_AT, NAME, EMAIL, PHONE, CUSTOM_ID, VIEWS, INTERACTIONS, and engagement and view time, as text and in seconds.

Extra columns

When you select Include Interactions, Variables, and Location, the file adds one column for each question or interaction (titled with its text), one column for each variable, and the precise location fields. An answer cell holds the answer. A click cell holds CLICK.

API and webhook field names

`id`, `video_id`, `video_token`, `video_title`, `video_duration`: the view and its video.
`started`, `finished`, `elapsed` (engagement seconds), `watched` (seconds of content), `percentage`.
`furthest_point`, `last_point`: in seconds.
`viewer_id`, `viewer_name`, `viewer_email`, `viewer_phone`, `viewer_custom_id`.
`participation`, `correctness`, `prompt_count`, `response_count`, `correct_count`, `wrong_count`, `interaction_count`.
`city`, `region`, `country`, `latitude`, `longitude`, `has_exact_location` and the `postal_` fields from precise location.
`browser`, `screen_width`, `screen_height`, `device_brand`, `device_model`, `device_os`, `url`.
`plink_id`, `tag1` to `tag5`: the personalized link used, if any.
`group_id`, `group_name`, `series_id` (playlist), `variables`.
`interactions` and `responses`: included in view webhooks.

Notes

The custom ID field is `viewer_custom_id`. Older guides called it `viewer_custom`. City, region and country come from the network address unless the viewer shared a precise location, so treat them as approximate.