Overview

EdData Export:
The insights from the data lake can be exported via data export utility or via AWS Athena API for offline processing. Data from EdData can be downloaded as a CSV file using EdData data export utility or using AWS Athena Client. This utility connects to the Data lake and downloads the data specific to each customer. This utility requires customer specific credentials to download the data.

Authentication and Configuration Details

Authentication and Configuration details will be provided by EdCast support team which should be utilized as parameters in the utility.

Configuration Name

Mandatory

Description

region

Yes

The region name in which your environment is set up.

aws_access_key

Yes

AWS access key
Contact EdCast support for this value

aws_secret_access_key

Yes

AWS secret access key
Contact EdCast support for this value

org_id

Yes

The org ID specific to each customer. Each customer will have access only to their corresponding org Database.

query

Yes

SQL compatible query

filename

Optional

Name of the file and its file type, if the whole path is given the file will be saved in the path accordingly.

env

Yes

The environment name. Contact EdCast support for this value.

s3_bucket

Yes

S3 bucket name
Contact EdCast support for this value

Installation

This python based utility can be installed and run from a Unix or Windows environment. Below are the steps to install and run the utility.

  1. Install python3
  2. Download data export utility from the eddata-sdk github repository
  3. This repo includes below 2 files
    • requirements.txt - This files contains the python libraries required by the utility
    • edc_bulk_download.py - This is the data export utility that connects to the data lake and
      downloads the file as CSV
  4. Install the python pre-req libraries using below command
    • pip3 install -r requirements.txt

Command to run

python3 edc_data_export.py --region us-west-2 --query "select * from user_card_performance_reporting_i_v where day='2020-07-04'" --aws_access_key_id <<sample_access_key>> --aws_secret_access_key <<sample_secret_key>> --filename download_data.csv --org_id 300032 --env prod --s3bucket edc-analytics-us-west-2-prod-02

Above command runs and stores the extracted data in CSV format in the download_data.csv.

Sample Queries

Some sample queries that can be used in the utility

  • select * from user_card_performance_reporting_i_v where day=’2020-04-01’
  • select * from user_card_performance_reporting_i_v where day between ‘2020-04-01’ and ‘2020-04- 04’
  • select * from user_card_performance_reporting_i_v where day between ‘2020-04-01’ and ‘2020-04-04’ and user_email=’[email protected]
  • select * from user_card_performance_reporting_i_v where day between ‘2020-04-01’ and ‘2020-04-04’ and user_first_name like ’admin%
  • select * from user_card_performance_reporting_i_v where day between ‘2020-04-01’ and ‘2020-04-04’ and card_tile like ‘admin%’
  • select * from user_assignments_performance_i_v where day between ‘2020-04-01’ and ‘2020-04-04’ and assignment_state=’completed’

There is no output to the utility call, a file will be downloaded locally with the given name.

Best Practices

  • To improve the performance, try breaking the queries into multiple chunks using date filters.
  • The utility supports --help parameter to understand what parameters are used with examples.

Warning and Errors

  • The parameters should match what was given by the Edcast customer support team and are case sensitive, any mismatch would result in error.
  • Utility aborts with error if the query attempts to download more than 1GB of data.

Utility Limitations

  • Only csv format is supported for the output file.
  • Any query which is scanning more than 1GB of data will be aborted - the users have to break the query into multiple chunks.

EdData Platform Events

EdCast data analytics platform process and stores below events in the EdData data lake.

Event Name

Object

Trigger

Comments

card_liked

Cards

When user likes a card

card_marked_as_complete

Cards

When user "mark as complete" a card

card_shared

Cards

When a user shares a card with others

card_comment_created

Cards

When a card comment is created

card_bookmarked

Cards

When card is bookmarked

card_deleted

Cards

When a card is deleted/removed from the platform

card_viewed

Cards

When user views a card

card_source_visited

Cards

When user views the link on the card

card_assigned

Cards

When user assigns a card to another user

card_published

Cards

When a card is published

card_added_to_channel

Cards

When an user adds a card to a channel

card_removed_from_channel

Cards

When user removes a card from a channel

card_created

Cards

When a card is created on the platform

card_added_to_pathway

Cards

Card added to pathway

card_removed_from_pathway

Cards

When user removes a card from a pathway

card_added_to_journey

Cards

Card added to journey

card_removed_from_journey

Cards

When user removes a card from a journey

card_poll_response_created

Cards

When user selects an option in a poll

card_quiz_response_created

Cards

When a user provides a response on a quiz card

card_unliked

Cards

When user unlike a card (Removed like)

card_marked_as_uncomplete

Cards

When user "mark as uncomplete" a card

card_unbookmarked

Cards

When a card is unbookmarked (Removed bookmark)

card_comment_deleted

Cards

When a card comment is deleted

card_unassigned

Cards

When a card assignment is removed

card_approved_for_channel

Cards

Card approved for channel

New in EdData 4.0.0

card_created_virtual

Cards

When a card is automatically created

New in EdData 4.0.0

card_created_with_project

Cards

When a project card is created

New in EdData 4.0.0

card_created_with_training

Cards

When a VILT card is created

New in EdData 4.0.0

card_dismissed

Cards

When a card is dismissed so that it won't be visible

New in EdData 4.0.0

card_edited

Cards

When a card is edited by user

New in EdData 4.0.0

card_edited_with_training

Cards

When a VILT card is edited

New in EdData 4.0.0

card_quiz_attempt_response_created

Cards

When user attempts the quiz

New in EdData 4.0.0

card_quiz_attempt_response_edited

Cards

When user attempts the quiz again

New in EdData 4.0.0

card_quiz_created

Cards

When multiple questions quiz card is created

New in EdData 4.0.0

card_quiz_edited

Cards

When multiple questions quiz card is edited

New in EdData 4.0.0

card_quiz_question_created

Cards

When quiz question is created

New in EdData 4.0.0

card_quiz_question_deleted

Cards

When quiz question is deleted

New in EdData 4.0.0

card_quiz_question_edited

Cards

When quiz question is edited

New in EdData 4.0.0

card_quiz_question_option_created

Cards

When quiz question option is created

New in EdData 4.0.0

card_quiz_question_option_deleted

Cards

When quiz question option is deleted

New in EdData 4.0.0

card_quiz_question_option_edited

Cards

When quiz question option is edited

New in EdData 4.0.0

card_quiz_question_response_created

Cards

When user saves the quiz response

New in EdData 4.0.0

card_quiz_question_response_edited

Cards

When user edits the quiz response

New in EdData 4.0.0

card_quiz_report_download

Cards

When author of the quiz card downloads the report

New in EdData 4.0.0

card_rejected_for_channel

Cards

When a card is rejected for a channel

New in EdData 4.0.0

card_relevance_rated

Cards

When user adds relevance rating to a card

New in EdData 4.0.0

card_scorm_completed

Cards

When user has completed scorm card

New in EdData 4.0.0

card_scorm_started

Cards

When user is registering on scorm cloud for the given scorm course

New in EdData 4.0.0

card_submission_created

Cards

When a project submission is created

New in EdData 4.0.0

card_submission_deleted

Cards

When a project submission is deleted

New in EdData 4.0.0

card_submission_grade_edited

Cards

When submission grade is edited

New in EdData 4.0.0

card_submission_graded

Cards

When the author grades the submission

New in EdData 4.0.0

card_training_registered

Cards

When the user registers for the training

New in EdData 4.0.0

card_training_registration_approved

Cards

When the author approves the registration

New in EdData 4.0.0

card_training_registration_denied

Cards

When the author denies the registration

New in EdData 4.0.0

card_training_unregistered

Cards

When the user unregisters for the training

New in EdData 4.0.0

card_unshared

Cards

When a card is unshared

New in EdData 4.0.0

card_video_stream_downloaded

Cards

When a livestream/Video Card is downloaded

New in EdData 4.0.0

card_video_stream_previewed

Cards

When a livestream/Video Card is previewed

New in EdData 4.0.0

card_video_stream_started_viewing

Cards

When a user starts viewing a livestream/Video Card

New in EdData 4.0.0

card_video_stream_stopped_viewing

Cards

When a user stops viewing a livestream/Video Card

New in EdData 4.0.0

user_expertise_topic_added

Users

A user adds an entry to their "expertise skills" list

user_expertise_topic_removed

Users

A user removes an entry from their "expertise skills" list

user_activity_window_started

Users

A user lands on the platform

user_badge_shared_on_social

Users

A user shares the badge on social media

user_logged_in

Users

user_logged_in

user_profile_visited

Users

A user views the profile of another user.

user_created

Users

A user registers or gets registered by an admin

user_badge_completed

Users

A user achieves a badge

New in EdData 4.0.0

user_deleted

Users

A user is deleted

New in EdData 4.0.0

user_edited

Users

Some attribute of a user is changed

New in EdData 4.0.0

user_followed

Users

A user followed by another user

New in EdData 4.0.0

user_interest_topic_added

Users

A user adds an entry to their "interest topic" list

New in EdData 4.0.0

user_interest_topic_removed

Users

A user removes an entry to their "interest topic" list

New in EdData 4.0.0

user_manager_assigned

Users

When user is assigned a manager

New in EdData 4.0.0

user_manager_edited

Users

When manager is changed for a given user

New in EdData 4.0.0

user_manager_unassigned

Users

When manager is removed for a given user

New in EdData 4.0.0

user_occupation_added

Users

When user adds current occupation under profile page

New in EdData 4.0.0

user_onboarding_completed

Users

A user completes onboarding

New in EdData 4.0.0

user_onboarding_started

Users

A user started with onboarding

New in EdData 4.0.0

user_role_added

Users

A user role is added

New in EdData 4.0.0

user_role_removed

Users

A user role is removed

New in EdData 4.0.0

user_skill_assessed

Users

When skills are assessed by the peers

New in EdData 4.0.0

user_skill_created

Users

A user skill is added

New in EdData 4.0.0

user_skill_deleted

Users

A user skill is removed

New in EdData 4.0.0

user_skill_edited

Users

A user skill attributes are changed

New in EdData 4.0.0

user_suspended

Users

A user is suspended

New in EdData 4.0.0

user_unfollowed

Users

A user unfollowed by another user

New in EdData 4.0.0

user_unsuspended

Users

A user is unsuspended

New in EdData 4.0.0

group_created

Groups

When a group is created

group_visited

Groups

When a user visits a group

group_user_added

Groups

When a user is added to a group

group_user_removed

Groups

When a user is removed from a group

group_card_assigned

Groups

When a group is assigned a card

New in EdData 4.0.0

group_channel_followed

Groups

When a group follows a channel

New in EdData 4.0.0

group_channel_unfollowed

Groups

When a group unfollows a channel

New in EdData 4.0.0

group_deleted

Groups

When a group is deleted

New in EdData 4.0.0

group_edited

Groups

When a group is edited

New in EdData 4.0.0

group_user_edited

Groups

When a user role is edited in a group

New in EdData 4.0.0

channel_created

Channels

When a channel is created on the platform

channel_visited

Channels

When a users visits a channel

channel_curator_added

Channels

When a curator is added to a channel

channel_collaborator_added

Channels

When a collaborator is added to a channel

channel_followed

Channels

When a user follows a channel

channel_unfollowed

Channels

When a user unfollow a channel

channel_added_to_channel_carousel

Channels

When a channel carousel is added to carousal

channel_carousel_created

Channels

When a new channel carousel is created

New in EdData 4.0.0

channel_carousel_deleted

Channels

When a new channel carousel is deleted

New in EdData 4.0.0

channel_carousel_disabled

Channels

When a channel carousel is disabled

New in EdData 4.0.0

channel_carousel_edited

Channels

When a channel carousel is edited

New in EdData 4.0.0

channel_carousel_enabled

Channels

When a channel carousel is enabled

New in EdData 4.0.0

channel_collaborator_removed

Channels

When a collaborator is removed from the channel

New in EdData 4.0.0

channel_curator_removed

Channels

When a curator is removed from a channel

New in EdData 4.0.0

channel_deleted

Channels

When a channel is deleted from the platform

New in EdData 4.0.0

channel_ecl_source_added

Channels

When ECL is added as a source for a channel

New in EdData 4.0.0

channel_ecl_source_removed

Channels

When ECL is removed as a source from a channel

New in EdData 4.0.0

channel_edited

Channels

When a channel is edited

New in EdData 4.0.0

channel_promoted

Channels

When a channel is promoted

New in EdData 4.0.0

channel_removed_from_channel_carousel

Channels

When a channel is removed from carousal

New in EdData 4.0.0

EdData Data Sets

  • user_card_performance_reporting_i_v
  • group_performance_reporting_i_v
  • channel_performance_reporting_i_v
  • group_assignments_performance_i_v
  • user_assignments_performance_i_v
  • searches_fact_i_v

Users and Content

(user_card_performance_reporting_i_v)

User and content activity data based on user’s interactions on platform cards tracked as events (all events starting with card_) and each event capturing the following attributes.

Attribute Name

Data Type

Description

event_time

Timestamp

Time the event occurred in UTC

card_id

INT

Unique identifier of the card

team_id

INT

Unique identifier of the group

team_name

STRING

Name of the group

card_created_at

Timestamp

Time the card created in UTC

card_source_name

String

Source of the card. Example: USG (User Generated), Go1 etc

user_handle

String

Unique handle of the user

shared_to_user_handle

String

This field is populated for shared_to_cards or shared_to_group events

group_user_handle

String

Unique handle of the user. This fields gets populated for group related events

card_author_handle

String

Unique handle of the card author. This fields gets populated for card related events

followed_user_handle

String

Unique handle of the followed user. Populated for user_followed event.

follower_user_handle

String

Unique handle of the following user. Populated for user_following event.

card_author_id

INT

Unique identifier of the card author

event

String

Name of the event

user_id

INT

Unique identifier of the user

platform

String

Platform from where the event generated - web or mobile

shared_to_user_id

INT

Unique identifier of the shared user

group_user_id

INT

Unique identifier of the group user

is_user_generated

INT

Card creation mode

comment_id

INT

Unique identifier of the comment

follower_id

INT

Unique identifier of the followed user

followed_user_id

INT

Unique identifier of the follower

channel_id

INT

Unique identifier of the channel

title

String

Title of the card

card_message

String

Message of the card

card_type

String

Type of card - Media, Journey, Pathway etc

card_level

String

Card level

card_state

String

Card State

duration

String

Duration spent by users

user_first_name

String

First name of the user

user_name

String

Unique handle for the user

user_last_name

String

Last name of the user

user_organization_role

String

User role - admin or member

shared_to_user_organization_role

String

Role of the shared to user - admin or member

group_user_organization_role

String

Role of the group user - admin or member

card_author_organization_role

String

Role of the card author - admin or member

followed_user_organization_role

String

Role of the followed user - admin or member

follower_user_organization_role

String

Role of the follower user - admin or member

user_email

String

Email of the user

user_last_sign_in_at

String

Last sign in time of the user

card_author_first_name

String

First name of the card author

card_author_last_name

String

Last name of the card author

card_author_email

String

Email of the card author

followed_user_first_name

String

First name of the followed user

followed_user_last_name

String

Last name of the followed user

followed_user_email

String

Email of the followed user

follower_user_first_name

String

First name of the follower user

follower_user_last_name

String

Last name of the follower user

follower_user_email

String

Email of the follower user

shared_to_user_first_name

String

First name of the shared to user

shared_to_user_last_name

String

Last name of the shared to user

shared_to_user_email

String

Email of the shared to user

group_user_first_name

String

First name of the group user

group_user_last_name

String

Last name of the group user

group_user_email

String

Email of the group user

comment_message

String

Comment message given by the user

comment_type

String

Type of the comment

channel_label

String

Channel label given by the user

channel_is_private

boolean

Flag to identify whether the channel is private or public

channel_visible

boolean

Flag to identify whether the channel is visible or invisible

channel_description

String

Channel description given by the user

yr

String

Event time year :Ex: 2020

month

String

Event time month. Ex: 03

day

String

Event time day. Ex: 2020-03-03

time

timestamp

assigned_to_user_id

INT

assigned_to_user_first_name

String

assigned_to_user_last_name

String

assigned_to_user_email

String

assigned_to_user_handle

String

assigned_to_user_organization_role

String

collaborator_id

INT

collaborator_user_first_name

String

collaborator_user_last_name

String

collaborator_user_email

String

collaborator_user_handle

String

collaborator_user_organization_role

String

channel_follower_id

INT

channel_follower_user_first_name

String

channel_follower_user_last_name

String

channel_follower_user_email

String

channel_follower_user_handle

String

channel_follower_user_organization_role

String

curator_id

INT

curator_user_first_name

String

curator_user_last_name

String

curator_user_email

String

curator_user_handle

String

curator_user_organization_role

String

standard_type

String

org_id_s

INT

org_id

INT

topic_id

String

topic_label

String

topic_name

String

pathway_id

String

pathway_name

String

journey_id

String

journey_name

String

poll_option_id

INT

poll_option_label

String

quiz_option_id

String

quiz_option_label

String

is_correct

String

card_subtype

String

card_resource_url

String

ecl_id

String

is_card_promoted

String

is_live_stream

String

card_duration

INT

attributes

String

user_agent

String

user_exclude_from_leaderboard

Boolean

user_created_at

Timestamp

user_status

String

user_sign_in_count

INT

card_deleted_at

Timestamp

card_is_paid

Boolean

card_is_public

Boolean

created_user_id

INT

suspended_user_id

INT

badge_id

String

badge_type

String

badge_title

String

completion_type

String

conferencing_tool

String

grade_range

String

grader_type

String

grading_system

String

last_registration_date

Timestamp

project_card_submission

String

project_card_submission_id

String

referer

String

registration_limit

INT

registration_type

String

request_id

String

submitter_type

String

training_registration_id

String

training_registration_state

String

quiz_attempt_id

String

quiz_attempt_passed

String

quiz_id

String

quiz_option_is_correct

String

quiz_passing_criteria

String

quiz_question_attempt_id

String

quiz_question_attempt_passed

String

quiz_question_id

String

quiz_question_label

String

quiz_questions_passed_count

String

quiz_reanswerable

String

is_system_generated

String

time_zone

String

start_date

Timestamp

end_date

Timestamp

card_hidden

Boolean

readable_card_type

INT

card_slug

String

event_recorder

String

is_admin_request

String

onboarding_status

String

org_hostname

String

platform_version_number

String

sign_in_ip

String

user_org_uid

String

user_role

String

domain_id

String

domain_label

String

domain_name

String

member_user_id

INT

controller_action

String

visited_profile_user_id

String

upload_mode

String

user_onboarding_current_step

String

user_onboarding_id

String

user_onboarding_status

String

average_rating

Float

card_bookmark_id

String

is_channel_featured

String

is_channel_public

String

org_name

String

changed_column

String

new_val

String

old_val

String

analytics_version

String

scorm_attempts

String

scorm_course_id

String

scorm_registration_completion

String

scorm_registration_success

String

scorm_score

Float

scorm_total_seconds_tracked

Float

scorm_user_id

INT

skill_id

String

skill_name

String

job_family

String

job_role

String

skill_category

String

skill_level_rated

String

occupation_id

String

occupation_name

String

occupation_category

String

is_channel_curated

String

is_ecl_enabled

String

edited_user_id

INT

is_open_source_content

String

external_id

String

Unique external id of card

channel_card_user_id

String

ecl_source_id

String

card_rating

INT

skill_credential

String

skill_level

String

manager_user_id

INT

removed_role

String

added_role

String

skill_description

String

channel_carousel_creator_id

INT

is_channel_carousel_enabled

String

channel_carousel_display_name

String

channel_carousel_id

INT

channel_carousel_slug

String

impersonator_id

String

minute

INT

deleted_user_id

INT

time_string

String

hour

String

Groups

(group_performance_reporting_i_v)

Group activities data based on group events (starting with group_) triggered by users, cards, or system.

Attribute Name

Data Type

Description

event_time

Timestamp

Time the event occurred in UTC

card_id

INT

Unique identifier of the card

team_id

INT

Unique identifier of the group

team_name

String

Name of the group

card_created_at

Timestamp

Time the card created in UTC

card_source_name

String

Source of the card. Example: USG (User Generated), Go1 etc

user_handle

String

Unique handle of the user

shared_to_user_handle

String

This field is populated for shared_to_cards or shared_to_group events

group_user_handle

String

Unique handle of the user. This fields gets populated for group related events

card_author_handle

String

Unique handle of the card author. This fields gets populated for card related events

followed_user_handle

String

Unique handle of the followed user. Populated for user_followed event

follower_user_handle

String

Unique handle of the following user. Populated for user_following event

card_author_id

INT

Unique identifier of the card author

event

String

Name of the event

user_id

INT

Unique identifier of the user

platform

String

Platform from where the event generated - web or mobile

shared_to_user_id

INT

Unique identifier of the shared user

group_user_id

INT

Unique identifier of the group user

is_user_generated

INT

Card creation mode

comment_id

INT

Unique identifier of the comment

follower_id

INT

Unique identifier of the followed user

followed_user_id

INT

Unique identifier of the follower

channel_id

INT

Unique identifier of the channel

title

String

Title of the card

card_message

String

Message of the card

card_type

String

Type of card - Media, Journey, Pathway etc

card_level

String

Card level

card_state

String

Card State

duration

String

Duration spent by users

user_first_name

String

First name of the user

user_name

String

Unique handle for the user

user_last_name

String

Last name of the user

user_organization_role

String

User role - admin or member

shared_to_user_organization_role

String

Role of the shared to user - admin or member

group_user_organization_role

String

Role of the group user - admin or member

card_author_organization_role

String

Role of the card author - admin or member

followed_user_organization_role

String

Role of the followed user - admin or member

follower_user_organization_role

String

Role of the follower user - admin or member

user_email

String

Email of the user

user_last_sign_in_at

String

Last sign in time of the user

card_author_first_name

String

First name of the card author

card_author_last_name

String

Last name of the card author

card_author_email

String

Email of the card author

followed_user_first_name

String

First name of the followed user

followed_user_last_name

String

Last name of the followed user

followed_user_email

String

Email of the followed user

follower_user_first_name

String

First name of the follower user

follower_user_last_name

String

Last name of the follower user

follower_user_email

String

Email of the follower user

shared_to_user_first_name

String

First name of the shared to user

shared_to_user_last_name

String

Last name of the shared to user

shared_to_user_email

String

Email of the shared to user

group_user_first_name

String

First name of the group user

group_user_last_name

String

Last name of the group user

group_user_email

String

Email of the group user

comment_message

String

Comment message given by the user

comment_type

String

Type of the comment

channel_label

String

Channel label given by the user

channel_is_private

boolean

Flag to identify whether the channel is private or public

channel_visible

boolean

Flag to identify whether the channel is visible or invisible

channel_description

String

Channel description given by the user

yr

String

Event time year :Ex: 2020

month

String

Event time month. Ex: 03

day

String

Event time day. Ex: 2020-03-03

time

Timestamp

assigned_to_user_id

INT

assigned_to_user_first_name

String

assigned_to_user_last_name

String

assigned_to_user_email

String

assigned_to_user_handle

String

assigned_to_user_organization_role

String

event_team_id

INT

group_user_role

String

team_name

String

comment_message

String

channel_label

String

channel_is_private

Boolean

channel_visible

Boolean

channel_description

String

org_id_s

INT

org_id

INT

record_insert_time

String

topic_id

String

topic_label

String

topic_name

String

pathway_id

String

pathway_name

String

journey_id

String

journey_name

String

poll_option_id

INT

poll_option_label

String

quiz_option_id

String

quiz_option_label

String

is_correct

String

user_agent

String

completion_type

String

conferencing_tool

String

grade_range

String

grader_type

String

grading_system

String

last_registration_date

Timestamp

project_card_submission

String

project_card_submission_id

String

referer

String

registration_limit

INT

registration_type

String

request_id

String

submitter_type

String

training_registration_id

String

training_registration_state

String

quiz_attempt_id

String

quiz_attempt_passed

String

quiz_id

String

quiz_option_is_correct

String

quiz_passing_criteria

String

quiz_question_attempt_id

String

quiz_question_attempt_passed

String

quiz_question_id

String

quiz_question_label

String

quiz_questions_passed_count

String

quiz_reanswerable

String

is_system_generated

String

time_zone

String

start_date

Timestamp

end_date

Timestamp

card_hidden

Boolean

readable_card_type

INT

card_slug

String

event_recorder

String

is_admin_request

String

onboarding_status

String

org_hostname

String

platform_version_number

String

sign_in_ip

String

user_org_uid

String

user_role

String

domain_id

String

domain_label

String

domain_name

String

member_user_id

INT

controller_action

String

visited_profile_user_id

String

upload_mode

String

user_onboarding_current_step

String

user_onboarding_id

String

user_onboarding_status

String

average_rating

Float

card_bookmark_id

String

is_channel_featured

String

is_channel_public

String

org_name

String

changed_column

String

new_val

String

old_val

String

analytics_version

String

scorm_attempts

String

scorm_course_id

String

scorm_registration_completion

String

scorm_registration_success

String

scorm_score

Float

scorm_total_seconds_tracked

Float

scorm_user_id

INT

skill_id

String

skill_name

String

job_family

String

job_role

String

skill_category

String

skill_level_rated

String

occupation_id

String

occupation_name

String

occupation_category

String

attributes

String

badge_id

String

badge_type

String

badge_title

String

card_deleted_at

Timestamp

card_duration

INT

card_is_paid

Boolean

card_is_public

Boolean

card_subtype

String

card_resource_url

String

channel_follower_id

INT

channel_follower_user_first_name

String

channel_follower_user_last_name

String

channel_follower_user_email

String

channel_follower_user_handle

String

channel_follower_user_organization_role

String

collaborator_id

INT

collaborator_user_first_name

String

collaborator_user_last_name

String

collaborator_user_email

String

collaborator_user_handle

String

collaborator_user_organization_role

String

created_user_id

INT

curator_id

INT

curator_user_first_name

String

curator_user_last_name

String

curator_user_email

String

curator_user_handle

String

curator_user_organization_role

String

ecl_id

String

is_card_promoted

String

is_live_stream

String

suspended_user_id

INT

user_exclude_from_leaderboard

Boolean

user_created_at

Timestamp

user_status

String

user_sign_in_count

INT

is_channel_curated

String

is_ecl_enabled

String

edited_user_id

INT

is_open_source_content

String

external_id

String

channel_card_user_id

String

ecl_source_id

String

card_rating

INT

skill_credential

String

skill_level

String

manager_user_id

INT

removed_role

String

added_role

String

skill_description

String

channel_carousel_creator_id

INT

is_channel_carousel_enabled

String

channel_carousel_display_name

String

channel_carousel_id

INT

channel_carousel_slug

String

impersonator_id

String

minute

INT

deleted_user_id

INT

time_string

String

hour

String

Assignments (Users)

(user_assignments_performance_i_v)

Assignment data based on card assignment events related to individual assignments triggered by users or system (external LMS)

Attribute Name

Data Type

Description

card_id

INT

Unique identifier of the card

title

String

Title of the card

card_source_name

String

Source of the card. Example: USG (User Generated), Go1 etc

duration

String

Time spent by users on a card

card_type

String

Type of card - Media, Journey, Pathway etc

card_level

String

Card level

card_author_name

String

Full name of the card author

assignor_name

String

Full name of the assignor

assignor_id

INT

Unique identifier of the assignor

assigned_user_id

INT

Unique identifier of the assigned user

assigned_user_full_name

String

Assigned user full name

assigned_user_handle

String

Assigned user handle

assignor_handle

String

Assignor handle

assignment_state

String

Assignment state - Pending / Inprogress / Completed

time_assignment_started

Timestamp

Assignment start time

time_completed

Timestamp

Assignment completion time

assignment_due_date

Timestamp

Assignment due date

time_assignment_created

Timestamp

Assignment creation time

yr

String

Event time year :Ex: 2020

month

String

Event time month. Ex: 03

day

String

Event time day. Ex: 2020-03-03

Assignments (Groups)

(group_assignments_performance_i_v)

Assignment data based on card assignment events related to group assignments triggered by users or system (external LMS)

Attribute Name

Data Type

Description

event_time

Timestamp

Time the event occurred in UTC

card_id

INT

Unique identifier of the card

card_source_name

String

Source of the card. Example: USG (User Generated), Go1 etc

title

String

Title of the card

card_type

String

Type of card - Media, Journey, Pathway etc

card_level

String

Card level

card_author_full_name

String

Full name of the card author

assignor_name

String

Name of the assignor

assignor_id

INT

Unique identifier of the assignor

group_id

INT

Unique identifier of the group

team_name

String

Name of the group given by the user

assigned_user_id

INT

Unique identifier of the assigned user

assigned_user_full_name

String

Assigned user full name

assigned_user_handle

String

Assigned user handle

assignor_handle

String

Assignor’s handle

assignment_state

String

Assignment state - Pending/Inprogress/Completed

time_assignment_started

Timestamp

Assignment start time

time_completed

Timestamp

Assignment completion time

assignment_due_date

Timestamp

Assignment due date

time_assignment_created

Timestamp

Assignment creation time

yr

String

Event time year :Ex: 2020

month

String

Event time month. Ex: 03

day

String

Event time day. Ex: 2020-03-03

Channels

(channel_performance_reporting_i_v)

Channels activities data based on channel events (starting with channel_) triggered by users, cards, or system

Attribute Name

Data Type

Description

event_time

Timestamp

Time the event occurred in UTC

channel_id

INT

Unique identifier of the Channel

card_id

INT

Unique identifier of the card

card_created_at

Timestamp

Time the card created in UTC

card_source_name

String

Source of the card. Example: USG (User Generated), Go1 etc

user_handle

String

Unique handle of the user

shared_to_user_handle

String

This field is populated for shared_to_cards or shared_to_group events

group_user_handle

String

Unique handle of the user. This fields gets populated for group related events

card_author_handle

String

Unique handle of the card author. This fields gets populated for card related events

followed_user_handle

String

Unique handle of the followed user. Populated for user_followed event

follower_user_handle

String

Unique handle of the following user. Populated for user_following event

card_author_id

INT

Unique identifier of the card author

event

String

Name of the event

user_id

INT

Unique identifier of the user

platform

String

Platform from where the event generated - web or mobile

shared_to_user_id

INT

Unique identifier of the shared user

team_id

INT

Unique identifier of the group

group_user_id

INT

Unique identifier of the group user

is_user_generated

INT

Card creation mode

comment_id

INT

Unique identifier of the comment

follower_id

INT

Unique identifier of the followed user

followed_user_id

INT

Unique identifier of the follower

channel_id

INT

Unique identifier of the channel

title

String

Title of the card

card_message

String

Message of the card

card_type

String

Type of card - Media, Journey, Pathway etc

card_level

String

Card level

card_state

String

Card State

duration

String

Duration spent by users

user_first_name

String

First name of the user

user_name

String

Unique handle for the user

user_last_name

String

Last name of the user

user_organization_role

String

User role - admin or member

shared_to_user_organization_role

String

Role of the shared to user - admin or member

group_user_organization_role

String

Role of the group user - admin or member

card_author_organization_role

String

Role of the card author - admin or member

followed_user_organization_role

String

Role of the followed user - admin or member

follower_user_organization_role

String

Role of the follower user - admin or member

user_email

String

Email of the user

user_last_sign_in_at

String

Last sign in time of the user

card_author_first_name

String

First name of the card author

card_author_last_name

String

Last name of the card author

card_author_email

String

Email of the card author

followed_user_first_name

String

First name of the followed user

followed_user_last_name

String

Last name of the followed user

followed_user_email

String

Email of the followed user

follower_user_first_name

String

First name of the follower user

follower_user_last_name

String

Last name of the follower user

follower_user_email

String

Email of the follower user

shared_to_user_first_name

String

First name of the shared to user

shared_to_user_last_name

String

Last name of the shared to user

shared_to_user_email

String

Email of the shared to user

comment_message

String

Comment message given by the user

comment_type

String

Type of the comment

channel_label

String

Channel label given by the user

channel_is_private

boolean

Flag to identify whether the channel is private or public

channel_visible

boolean

Flag to identify whether the channel is visible or invisible

channel_description

String

Channel description given by the user

yr

String

Event time year :Ex: 2020

month

String

Event time month. Ex: 03

day

String

Event time day. Ex: 2020-03-03

time

String

assigned_to_user_id

INT

assigned_to_user_first_name

String

assigned_to_user_last_name

String

assigned_to_user_email

String

assigned_to_user_handle

String

assigned_to_user_organization_role

String

collaborator_id

INT

collaborator_user_first_name

String

collaborator_user_last_name

String

collaborator_user_email

String

collaborator_user_handle

String

collaborator_user_organization_role

String

channel_follower_id

INT

channel_follower_user_first_name

String

channel_follower_user_last_name

String

channel_follower_user_email

String

channel_follower_user_handle

String

channel_follower_user_organization_role

String

curator_id

INT

curator_user_first_name

String

curator_user_last_name

String

curator_user_email

String

curator_user_handle

String

curator_user_organization_role

String

event_channel_id

INT

standard_type

String

group_user_first_name

String

group_user_last_name

String

group_user_email

String

team_name

String

org_id_s

INT

org_id

INT

record_insert_time

String

topic_id

String

topic_label

String

topic_name

String

pathway_id

String

pathway_name

String

journey_id

String

journey_name

String

poll_option_id

INT

poll_option_label

String

quiz_option_id

String

quiz_option_label

String

is_correct

String

user_agent

String

is_channel_curated

String

is_ecl_enabled

String

completion_type

String

conferencing_tool

String

grade_range

String

grader_type

String

grading_system

String

last_registration_date

Timestamp

project_card_submission

String

project_card_submission_id

String

referer

String

registration_limit

INT

registration_type

String

request_id

String

submitter_type

String

training_registration_id

String

training_registration_state

String

quiz_attempt_id

String

quiz_attempt_passed

String

quiz_id

String

quiz_option_is_correct

String

quiz_passing_criteria

String

quiz_question_attempt_id

String

quiz_question_attempt_passed

String

quiz_question_id

String

quiz_question_label

String

quiz_questions_passed_count

String

quiz_reanswerable

String

is_system_generated

String

time_zone

String

start_date

Timestamp

end_date

Timestamp

card_hidden

Boolean

readable_card_type

INT

card_slug

String

event_recorder

String

is_admin_request

String

onboarding_status

String

org_hostname

String

platform_version_number

String

sign_in_ip

String

user_org_uid

String

user_role

String

domain_id

String

domain_label

String

domain_name

String

member_user_id

INT

controller_action

String

visited_profile_user_id

String

upload_mode

String

user_onboarding_current_step

String

user_onboarding_id

String

user_onboarding_status

String

average_rating

Float

card_bookmark_id

String

is_channel_featured

String

is_channel_public

String

org_name

String

changed_column

String

new_val

String

old_val

String

analytics_version

String

scorm_attempts

String

scorm_course_id

String

scorm_registration_completion

String

scorm_registration_success

String

scorm_score

Float

scorm_total_seconds_tracked

Float

scorm_user_id

INT

skill_id

String

skill_name

String

job_family

String

job_role

String

skill_category

String

skill_level_rated

String

occupation_id

String

occupation_name

String

occupation_category

String

attributes

String

badge_id

String

badge_type

String

badge_title

String

card_deleted_at

Timestamp

card_duration

INT

card_is_paid

Boolean

card_is_public

Boolean

card_subtype

String

card_resource_url

String

created_user_id

INT

ecl_id

String

group_user_role

String

is_card_promoted

String

is_live_stream

String

suspended_user_id

INT

user_exclude_from_leaderboard

Boolean

user_created_at

Timestamp

user_status

String

user_sign_in_count

INT

edited_user_id

INT

is_open_source_content

String

external_id

String

channel_card_user_id

String

ecl_source_id

String

card_rating

INT

skill_credential

String

skill_level

String

manager_user_id

INT

removed_role

String

added_role

String

skill_description

String

channel_carousel_creator_id

INT

is_channel_carousel_enabled

String

channel_carousel_display_name

String

channel_carousel_id

INT

channel_carousel_slug

String

impersonator_id

String

minute

INT

deleted_user_id

INT

time_string

String

hour

String

Searches

(searches_fact_i_v)

Search activities

Attribute Name

Data Type

Description

time

Timestamp

_user_id

INT

analytics_version

String

event_recorder

String

event_time

bigint

is_admin_request

String

is_system_generated

String

org_hostname

String

platform

String

results_count

INT

search_query

String

user_agent

String

user_id

INT

Unique identifier of the user

platform_version_number

String

event

String

Name of the event

org_id_s

INT

record_insert_time

String

impersonator_id

String

yr

String

Event time year :Ex: 2020

month

String

Event time month. Ex: 03

day

String

Event time day. Ex: 2020-03-03

hour

String

time_string

String