Skip to main content

Cogniss Export Data Dictionary

The go-to reference to understand each data point exported from Cogniss Insights

Raymond Gerardino avatar
Written by Raymond Gerardino
Updated over 9 months ago

Introduction

Within the Cogniss system, app admins have the capability to conduct data exports through Cogniss Insights, with the exported data available in CSV format.

The data that can be downloaded can be divided into 3 different categories. These are


User Data

Models are created to contain information about a specific User, some properties of which can be set/modified by the User themselves.

Contains platform-wide data about a Cogniss User.

Property name

Property type

Description

user_id

String

db system generated ID (key) in the Cogniss system, this ID will be a secondary ID in all user responses

displayName

String

The User's publicly visible name. (Not provided for anonymous exports)

username

String

The User's login name. (Not provided for anonymous exports)

email

String

The User's email. (Not provided for anonymous exports)

createdAt

DateTime

The UTC date and time the user record was created

lastLogin

DateTime

The UTC date and time the user last logged into the app

archived

Boolean

Whether the user record has been archived (no longer accessible)


Activity Data

Models that are created and updated when your user uses activities within your app. There are 2 types of activity-based data, ActivityResponse and QuestionResponse.

ActivityResponse

Contains data about a User's attempt at an Activity. An ActivityResponse is created every time a user opens the activity. The activity response belongs to the user and is only marked as complete when the user has responded to all the Content Blocks (previously Questions).

Property name

Property type

Description

responseId

String

System-generated ID in the Cogniss system when the activity response id created

userID

String

The userId (key) associated with the user that has created the activity response

subjectId

String

The Subject (key) that is related to the Activity that the user is responding

subjectName

String

The name of the Subject the Activity is located

activityId

String

The UTC date and time the user record was created

activityName

String

The name of the Activity

activityDate

DateTime

The UTC date and time that the response was created

complete

Boolean

0 = The user has not completed the activity

1 = The user has completed the activity

QuestionResponse (ContentBlocks)

Contains data about a user's attempt at a specific question.

Note: this is now called Content Blocks in the system.

The QuestionResponse belongs to the user and it is connected to a specific Content Block (question) via the question_id. In a standard Cogniss survey, QuestionResponses are saved as each page of an Activity is completed.

Property name

Property type

Description

user_id

String

The user (key) that is responding to a question

activity_id

String

The activity (key) that the question response related

topic_name

String

The name of the Topic for which the Question or Content Block is created

correct

Boolean

When available whether the response is correct or not

duration

Number

In seconds the time for the user to make the response

score

Number

The score defined for the option chosen

question_id

String

The Question (key) or Content Block for which the QuestionResponse is created

question_label

String

The name or label of the Question or Content Block

question_response_time

Number

The time in seconds that it took the user to respond to the Question or Content Block

question_response_created

String

The UTC date and time that the user completed their Question Response

question_response

String

The Data Label for the Question or Content Block. Note for questions that may have multiple responses, a separate question_response column is recorded in the export.


System Data

System-generated models that record a User’s progress through an App.


Events

Contains information about an analytics event that was triggered by a front end. Apps can also be configured to add events every time a Behavior successfully completed.

Property name

Property type

Description

user_id

String

The userId connected to the event that occurred.

date

Date

The date the Event was triggered.

type

String

The type of Event that was triggered (NAVIGATION, INTERACTION or CUSTOM).

action

String

A short identifier code for what occurred.

label

String

A user-friendly description of what happened, or further details.


User Data with Voucher information

Models are created to contain information about a specific User, some properties of which can be set/modified by the User themselves.

Contains platform-wide data about a Cogniss User.

*Highlighted denotes the use of voucher codes to access the app. Voucher settings need to be enabled.

Property name

Property type

Description

user_id

String

db system generated ID (key) in the Cogniss system, this ID will be a secondary ID in all user responses

app_id

String

The ID (Key) associated with an App

displayName

String

The user's publicly visible name. (Not provided for anonymous exports)

username

String

The user's login name. (Not provided for anonymous exports)

email

DateTime

The user's email. (Not provided for anonymous exports)

voucher_id

DateTime

The user's email. (Not provided for anonymous exports)

voucher_code

Boolean

The code associated with a voucher

voucher_name

String

The name of the voucher

consumedDate

Date

The date that the voucher was redeemed/consumed by the user.

createdAt

DateTime

The UTC date and time the user record was created

lastLogin

DateTime

The UTC date and time the user last logged into the app

archived

Boolean

Whether the user record has been archived (no longer accessible)

Did this answer your question?