With each submission to an Activity, a set of metadata will be captured along with the entered data. These data are intended to support the ability to answer specific questions about the Activity submissions, such as the average amount of time to complete an Activity, who last interacted with the Activity, etc.

The standard set of metadata variables for all activities are as follows:

  • DATSTAT.SESSIONID: The session ID is the unique ID generated by the system that is used to reference a specific session.
  • DATSTAT.PARTICIPANTID: The participant ID is the unique ID for the participant.
  • DATSTAT.STARTDATETIME: The start date/time is the date and time the session was first started.
  • DATSTAT.LASTMODIFIEDDATETIME: The last modified date/time is the date and time of the last time the Activity was interacted with through import or by the participant/user.
  • DATSTAT.LASTMODIFIEDBYID: The last modified by ID is the unique ID of the participant/user of the participant/user to last modify the session.
  • DATSTAT.ELAPSEDTIME: The elapsed time is the total number of minutes the participant/user spent in the Activity, populated by a JavaScript timer.
  • DATSTAT.SUBMISSIONTYPE: Shows whether the session was submitted by a participant, user, or imported.
  • DATSTAT.SUBMISSIONSTATUS: The submission status of the session (Partial, Submitted, Terminated).
  • DATSTAT.SUBMITDATETIME: The submit date/time if the date and time the session was first submitted.
  • DATSTAT.LANGUAGE: The language in which the survey was submitted.
  • DATSTAT.ACTIVITYVERSIONID: The activity version ID is a unique ID of the activity version in which the survey was submitted.
  • DATSTAT.BROWSER: The browser is the user agent string captured from the participants web browser from which the session was submitted (I.E., Chrome, Firefox, Safari, etc.).
  • DATSTAT.PARTICIPANTTASKID: The participant task ID is the unique ID of the participant instance of the task associated to the Activity.
  • DATSTAT.SITEID: The site ID is the unique ID of the site at which the Activity data was collected (i.e. the site the participant is assigned to at the time of submission).
  • DATSTAT.PERCENTCOMPLETEOFTOTAL: The percent complete of total questions is the number answered divided by the total number of questions (not including the Internals) multiplied by 100.
  • DATSTAT.PERCENTCOMPLETEOFELIGIBLE: The percent complete of eligible questions is the number answered divided by the number eligible multiplied by 100.
  • DATSTAT.NUMELIGIBLE: The number eligible is a count of the number of questions that a participant could have seen based on show-if logic.
  • DATSTAT.QUESTIONSPRESENTED: The questions presented is a count of the total number of questions shown to the participant/user at any point during the Activity.
  • DATSTAT.NUMANSWERED: The number answered is a count of the number of eligible questions that have values.
  • DATSTAT.NUMUNANSWERED: The number unanswered is a count of the number of eligible questions that do not have values.
  • DATSTAT.NUMNOTPRESENTED: The number not presented is a count of the number of questions the participant did not see due to show-if logic (not including, for partial sessions, the questions on pages the participant has not yet reached).
  • DATSTAT.AVERAGETIMEPERPAGE: The average time per page is the average time in minutes the participant/user spent on each page visited in the Activity, populated by JavaScript.
  • DATSTAT.LASTQUESTIONSEEN: The last question seen is the variable name of the last question on the last page with which the participant/user interacted.
  • DATSTAT.WORKFLOWID:  The workflow ID in the unique ID of the workflow with which the Activity is associated.
  • DATSTAT.STEPID: The step ID is the unique ID of the step associated to the Activity.
  • DATSTAT.TASKID: The task ID is the unique ID of the task with which the Activity is associated.
  • DATSTAT.INSTANCE: The instance number of the Activity.
  • DATSTAT.LASTMODIFIEDBYTYPE: The last modified by type indicates whether the type of the last participant/user to modify the session.