EdData Datasets

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
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 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

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