Analytics documentation has been updated and moved to the new location: https://help.csod.com/lxp/Content/Resources/Homepage/Homepage.htm

Overview

The insights from the data lake can be downloaded as a CSV file using EdData data export utility or using AWS Athena Client / GCP Bigquery 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, currently supported Cloud Providers :


Terms & Conditions

By Agreeing,

  • I hereby confirm that I will not include the credentials/JSONS/Keys in any Public Repository. If found I will be the sole responsible person and any action that might follow
  • I hereby confirm that I will not disclose the credentials/JSONS/Keys to other internal/external people

Authentication and Configuration Details

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

EdData Export - AWS

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
Configuration NameMandatoryDescription
regionYesThe region name in which your environment is set up.
aws_access_keyYesAWS access key
Contact EdCast support for this value
aws_secret_access_keyYesAWS secret access key
Contact EdCast support for this value
org_idYesThe org ID specific to each customer. Each customer will have access only to their corresponding org Database.
query YesSQL compatible query
filenameOptionalName of the file and its file type, if the whole path is given the file will be saved in the path accordingly.
envYesThe environment name. Contact EdCast support for this value.
s3_bucketYesS3 bucket name
Contact EdCast support for this value

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.


EdData Export - GCP

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. Download below 2 files
    a. gcp_requirements.txt - This files contains the python libraries required by the utility
    b. edc_data_export.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
    a. pip3 install -r gcp_requirements.txt

Command to run

python3 edc_data_export.py \
	    --provider gcp \ 
	    --cred_file $SERVICE_ACCOUNT_JSON \
	    --query "select * from edc_prod_analytics_customer_$ORG_ID.$TABLE_NAME" \ 
	    --filename output.csv
Configuration NameMandatoryDescription
--providerYesgcp
--cred_fileYesAbsolute path to the credentials json file

Contact EdCast support for this value
--queryYesSQL compatible query is ran with dataset name

edc_prod_analytics_customer$ORGID
[$ORG_ID - Contact EdCast support for this value]
--filenameNoName of the file and its file type, if the whole path is given the file will be saved in the path accordingly.

The output file will be downloaded locally with the given name provided through --filename argument.

Sample Queries for GCP

Some sample queries that can be referred.

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

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 NameObjectTriggerComments
card_likedCardsWhen user likes a card
card_marked_as_completeCardsWhen user "mark as complete" a card
card_sharedCardsWhen a user shares a card with others
card_comment_createdCardsWhen a card comment is created
card_bookmarkedCardsWhen card is bookmarked
card_deletedCardsWhen a card is deleted/removed from the platform
card_viewedCardsWhen user views a card
card_source_visitedCardsWhen user views the link on the card
card_assignedCardsWhen user assigns a card to another user
card_publishedCardsWhen a card is published
card_added_to_channelCardsWhen an user adds a card to a channel
card_removed_from_channelCardsWhen user removes a card from a channel
card_createdCardsWhen a card is created on the platform
card_added_to_pathwayCardsCard added to pathway
card_removed_from_pathwayCardsWhen user removes a card from a pathway
card_added_to_journeyCardsCard added to journey
card_removed_from_journeyCardsWhen user removes a card from a journey
card_poll_response_createdCardsWhen user selects an option in a poll
card_quiz_response_createdCardsWhen a user provides a response on a quiz card
card_unlikedCardsWhen user unlike a card (Removed like)
card_marked_as_uncompleteCardsWhen user "mark as uncomplete" a card
card_unbookmarkedCardsWhen a card is unbookmarked (Removed bookmark)
card_comment_deletedCardsWhen a card comment is deleted
card_unassignedCardsWhen a card assignment is removed
card_approved_for_channelCardsCard approved for channelNew in EdData 4.0.0
card_created_virtualCardsWhen a card is automatically createdNew in EdData 4.0.0
card_created_with_projectCardsWhen a project card is createdNew in EdData 4.0.0
card_created_with_trainingCardsWhen a VILT card is createdNew in EdData 4.0.0
card_dismissedCardsWhen a card is dismissed so that it won't be visibleNew in EdData 4.0.0
card_editedCardsWhen a card is edited by userNew in EdData 4.0.0
card_edited_with_trainingCardsWhen a VILT card is editedNew in EdData 4.0.0
card_quiz_attempt_response_createdCardsWhen user attempts the quizNew in EdData 4.0.0
card_quiz_attempt_response_editedCardsWhen user attempts the quiz againNew in EdData 4.0.0
card_quiz_createdCardsWhen multiple questions quiz card is createdNew in EdData 4.0.0
card_quiz_editedCardsWhen multiple questions quiz card is editedNew in EdData 4.0.0
card_quiz_question_createdCardsWhen quiz question is createdNew in EdData 4.0.0
card_quiz_question_deletedCardsWhen quiz question is deletedNew in EdData 4.0.0
card_quiz_question_editedCardsWhen quiz question is editedNew in EdData 4.0.0
card_quiz_question_option_createdCardsWhen quiz question option is createdNew in EdData 4.0.0
card_quiz_question_option_deletedCardsWhen quiz question option is deletedNew in EdData 4.0.0
card_quiz_question_option_editedCardsWhen quiz question option is editedNew in EdData 4.0.0
card_quiz_question_response_createdCardsWhen user saves the quiz responseNew in EdData 4.0.0
card_quiz_question_response_editedCardsWhen user edits the quiz responseNew in EdData 4.0.0
card_quiz_report_downloadCardsWhen author of the quiz card downloads the reportNew in EdData 4.0.0
card_rejected_for_channelCardsWhen a card is rejected for a channelNew in EdData 4.0.0
card_relevance_ratedCardsWhen user adds relevance rating to a cardNew in EdData 4.0.0
card_scorm_completedCardsWhen user has completed scorm cardNew in EdData 4.0.0
card_scorm_startedCardsWhen user is registering on scorm cloud for the given scorm courseNew in EdData 4.0.0
card_submission_createdCardsWhen a project submission is createdNew in EdData 4.0.0
card_submission_deletedCardsWhen a project submission is deletedNew in EdData 4.0.0
card_submission_grade_editedCardsWhen submission grade is editedNew in EdData 4.0.0
card_submission_gradedCardsWhen the author grades the submissionNew in EdData 4.0.0
card_training_registeredCardsWhen the user registers for the trainingNew in EdData 4.0.0
card_training_registration_approvedCardsWhen the author approves the registrationNew in EdData 4.0.0
card_training_registration_deniedCardsWhen the author denies the registrationNew in EdData 4.0.0
card_training_unregisteredCardsWhen the user unregisters for the trainingNew in EdData 4.0.0
card_unsharedCardsWhen a card is unsharedNew in EdData 4.0.0
card_video_stream_downloadedCardsWhen a livestream/Video Card is downloadedNew in EdData 4.0.0
card_video_stream_previewedCardsWhen a livestream/Video Card is previewedNew in EdData 4.0.0
card_video_stream_started_viewingCardsWhen a user starts viewing a livestream/Video CardNew in EdData 4.0.0
card_video_stream_stopped_viewingCardsWhen a user stops viewing a livestream/Video CardNew in EdData 4.0.0
user_expertise_topic_addedUsersA user adds an entry to their "expertise skills" list
user_expertise_topic_removedUsersA user removes an entry from their "expertise skills" list
user_activity_window_startedUsersA user lands on the platform
user_badge_shared_on_socialUsersA user shares the badge on social media
user_logged_inUsersuser_logged_in
user_profile_visitedUsersA user views the profile of another user.
user_createdUsersA user registers or gets registered by an admin
user_badge_completedUsersA user achieves a badgeNew in EdData 4.0.0
user_deletedUsersA user is deletedNew in EdData 4.0.0
user_editedUsersSome attribute of a user is changedNew in EdData 4.0.0
user_followedUsersA user followed by another userNew in EdData 4.0.0
user_interest_topic_addedUsersA user adds an entry to their "interest topic" listNew in EdData 4.0.0
user_interest_topic_removedUsersA user removes an entry to their "interest topic" listNew in EdData 4.0.0
user_manager_assignedUsersWhen user is assigned a managerNew in EdData 4.0.0
user_manager_editedUsersWhen manager is changed for a given userNew in EdData 4.0.0
user_manager_unassignedUsersWhen manager is removed for a given userNew in EdData 4.0.0
user_occupation_addedUsersWhen user adds current occupation under profile pageNew in EdData 4.0.0
user_onboarding_completedUsersA user completes onboardingNew in EdData 4.0.0
user_onboarding_startedUsersA user started with onboardingNew in EdData 4.0.0
user_role_addedUsersA user role is addedNew in EdData 4.0.0
user_role_removedUsersA user role is removedNew in EdData 4.0.0
user_skill_assessedUsersWhen skills are assessed by the peersNew in EdData 4.0.0
user_skill_createdUsersA user skill is addedNew in EdData 4.0.0
user_skill_deletedUsersA user skill is removedNew in EdData 4.0.0
user_skill_editedUsersA user skill attributes are changedNew in EdData 4.0.0
user_suspendedUsersA user is suspendedNew in EdData 4.0.0
user_unfollowedUsersA user unfollowed by another userNew in EdData 4.0.0
user_unsuspendedUsersA user is unsuspendedNew in EdData 4.0.0
group_createdGroupsWhen a group is created
group_visitedGroupsWhen a user visits a group
group_user_addedGroupsWhen a user is added to a group
group_user_removedGroupsWhen a user is removed from a group
group_card_assignedGroupsWhen a group is assigned a cardNew in EdData 4.0.0
group_channel_followedGroupsWhen a group follows a channelNew in EdData 4.0.0
group_channel_unfollowedGroupsWhen a group unfollows a channelNew in EdData 4.0.0
group_deletedGroupsWhen a group is deletedNew in EdData 4.0.0
group_editedGroupsWhen a group is editedNew in EdData 4.0.0
group_user_editedGroupsWhen a user role is edited in a groupNew in EdData 4.0.0
channel_createdChannelsWhen a channel is created on the platform
channel_visitedChannelsWhen a users visits a channel
channel_curator_addedChannelsWhen a curator is added to a channel
channel_collaborator_addedChannelsWhen a collaborator is added to a channel
channel_followedChannelsWhen a user follows a channel
channel_unfollowedChannelsWhen a user unfollow a channel
channel_added_to_channel_carouselChannelsWhen a channel carousel is added to carousal
channel_carousel_createdChannelsWhen a new channel carousel is createdNew in EdData 4.0.0
channel_carousel_deletedChannelsWhen a new channel carousel is deletedNew in EdData 4.0.0
channel_carousel_disabledChannelsWhen a channel carousel is disabledNew in EdData 4.0.0
channel_carousel_editedChannelsWhen a channel carousel is editedNew in EdData 4.0.0
channel_carousel_enabledChannelsWhen a channel carousel is enabledNew in EdData 4.0.0
channel_collaborator_removedChannelsWhen a collaborator is removed from the channelNew in EdData 4.0.0
channel_curator_removedChannelsWhen a curator is removed from a channelNew in EdData 4.0.0
channel_deletedChannelsWhen a channel is deleted from the platformNew in EdData 4.0.0
channel_ecl_source_addedChannelsWhen ECL is added as a source for a channelNew in EdData 4.0.0
channel_ecl_source_removedChannelsWhen ECL is removed as a source from a channelNew in EdData 4.0.0
channel_editedChannelsWhen a channel is editedNew in EdData 4.0.0
channel_promotedChannelsWhen a channel is promotedNew in EdData 4.0.0
channel_removed_from_channel_carouselChannelsWhen a channel is removed from carousalNew 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 NameData TypeDescription
event_timeTimestampTime the event occurred in UTC
card_idINTUnique identifier of the card
team_idINTUnique identifier of the group
team_nameSTRINGName of the group
card_created_atTimestampTime the card created in UTC
card_source_nameStringSource of the card. Example: USG (User Generated), Go1 etc
user_handleStringUnique handle of the user
shared_to_user_handleStringThis field is populated for shared_to_cards or shared_to_group events
group_user_handleStringUnique handle of the user. This fields gets populated for group related events
card_author_handleStringUnique handle of the card author. This fields gets populated for card related events
followed_user_handleStringUnique handle of the followed user. Populated for user_followed event.
follower_user_handleStringUnique handle of the following user. Populated for user_following event.
card_author_idINTUnique identifier of the card author
eventStringName of the event
user_idINTUnique identifier of the user
platformStringPlatform from where the event generated - web or mobile
shared_to_user_idINTUnique identifier of the shared user
group_user_idINTUnique identifier of the group user
is_user_generatedINTCard creation mode
comment_idINTUnique identifier of the comment
follower_idINTUnique identifier of the followed user
followed_user_idINTUnique identifier of the follower
channel_idINTUnique identifier of the channel
titleStringTitle of the card
card_messageStringMessage of the card
card_typeStringType of card - Media, Journey, Pathway etc
card_levelStringCard level
card_stateStringCard State
durationStringDuration spent by users
user_first_nameStringFirst name of the user
user_nameStringUnique handle for the user
user_last_nameStringLast name of the user
user_organization_roleStringUser role - admin or member
shared_to_user_organization_roleStringRole of the shared to user - admin or member
group_user_organization_roleStringRole of the group user - admin or member
card_author_organization_roleStringRole of the card author - admin or member
followed_user_organization_roleStringRole of the followed user - admin or member
follower_user_organization_roleStringRole of the follower user - admin or member
user_emailStringEmail of the user
user_last_sign_in_atStringLast sign in time of the user
card_author_first_nameStringFirst name of the card author
card_author_last_nameStringLast name of the card author
card_author_emailStringEmail of the card author
followed_user_first_nameStringFirst name of the followed user
followed_user_last_nameStringLast name of the followed user
followed_user_emailStringEmail of the followed user
follower_user_first_nameStringFirst name of the follower user
follower_user_last_nameStringLast name of the follower user
follower_user_emailStringEmail of the follower user
shared_to_user_first_nameStringFirst name of the shared to user
shared_to_user_last_nameStringLast name of the shared to user
shared_to_user_emailStringEmail of the shared to user
group_user_first_nameStringFirst name of the group user
group_user_last_nameStringLast name of the group user
group_user_emailStringEmail of the group user
comment_messageStringComment message given by the user
comment_typeStringType of the comment
channel_labelStringChannel label given by the user
channel_is_privatebooleanFlag to identify whether the channel is private or public
channel_visiblebooleanFlag to identify whether the channel is visible or invisible
channel_descriptionStringChannel description given by the user
yrStringEvent time year :Ex: 2020
monthStringEvent time month. Ex: 03
dayStringEvent time day. Ex: 2020-03-03
timetimestamp
assigned_to_user_idINT
assigned_to_user_first_nameString
assigned_to_user_last_nameString
assigned_to_user_emailString
assigned_to_user_handleString
assigned_to_user_organization_roleString
collaborator_idINT
collaborator_user_first_nameString
collaborator_user_last_nameString
collaborator_user_emailString
collaborator_user_handleString
collaborator_user_organization_roleString
channel_follower_idINT
channel_follower_user_first_nameString
channel_follower_user_last_nameString
channel_follower_user_emailString
channel_follower_user_handleString
channel_follower_user_organization_roleString
curator_idINT
curator_user_first_nameString
curator_user_last_nameString
curator_user_emailString
curator_user_handleString
curator_user_organization_roleString
standard_typeString
org_id_sINT
org_idINT
topic_idString
topic_labelString
topic_nameString
pathway_idString
pathway_nameString
journey_idString
journey_nameString
poll_option_idINT
poll_option_labelString
quiz_option_idString
quiz_option_labelString
is_correctString
card_subtypeString
card_resource_urlString
ecl_idString
is_card_promotedString
is_live_streamString
card_durationINT
attributesString
user_agentString
user_exclude_from_leaderboardBoolean
user_created_atTimestamp
user_statusString
user_sign_in_countINT
card_deleted_atTimestamp
card_is_paidBoolean
card_is_publicBoolean
created_user_idINT
suspended_user_idINT
badge_idString
badge_typeString
badge_titleString
completion_typeString
conferencing_toolString
grade_rangeString
grader_typeString
grading_systemString
last_registration_dateTimestamp
project_card_submissionString
project_card_submission_idString
refererString
registration_limitINT
registration_typeString
request_idString
submitter_typeString
training_registration_idString
training_registration_stateString
quiz_attempt_idString
quiz_attempt_passedString
quiz_idString
quiz_option_is_correctString
quiz_passing_criteriaString
quiz_question_attempt_idString
quiz_question_attempt_passedString
quiz_question_idString
quiz_question_labelString
quiz_questions_passed_countString
quiz_reanswerableString
is_system_generatedString
time_zoneString
start_dateTimestamp
end_dateTimestamp
card_hiddenBoolean
readable_card_typeINT
card_slugString
event_recorderString
is_admin_requestString
onboarding_statusString
org_hostnameString
platform_version_numberString
sign_in_ipString
user_org_uidString
user_roleString
domain_idString
domain_labelString
domain_nameString
member_user_idINT
controller_actionString
visited_profile_user_idString
upload_modeString
user_onboarding_current_stepString
user_onboarding_idString
user_onboarding_statusString
average_ratingFloat
card_bookmark_idString
is_channel_featuredString
is_channel_publicString
org_nameString
changed_columnString
new_valString
old_valString
analytics_versionString
scorm_attemptsString
scorm_course_idString
scorm_registration_completionString
scorm_registration_successString
scorm_scoreFloat
scorm_total_seconds_trackedFloat
scorm_user_idINT
skill_idString
skill_nameString
job_familyString
job_roleString
skill_categoryString
skill_level_ratedString
occupation_idString
occupation_nameString
occupation_categoryString
is_channel_curatedString
is_ecl_enabledString
edited_user_idINT
is_open_source_contentString
external_idStringUnique external id of card
channel_card_user_idString
ecl_source_idString
card_ratingINT
skill_credentialString
skill_levelString
manager_user_idINT
removed_roleString
added_roleString
skill_descriptionString
channel_carousel_creator_idINT
is_channel_carousel_enabledString
channel_carousel_display_nameString
channel_carousel_idINT
channel_carousel_slugString
impersonator_idString
minuteINT
deleted_user_idINT
time_stringString
hourString

Groups

(group_performance_reporting_i_v)

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

Attribute NameData TypeDescription
event_timeTimestampTime the event occurred in UTC
card_idINTUnique identifier of the card
team_idINTUnique identifier of the group
team_nameStringName of the group
card_created_atTimestampTime the card created in UTC
card_source_nameStringSource of the card. Example: USG (User Generated), Go1 etc
user_handleStringUnique handle of the user
shared_to_user_handleStringThis field is populated for shared_to_cards or shared_to_group events
group_user_handleStringUnique handle of the user. This fields gets populated for group related events
card_author_handleStringUnique handle of the card author. This fields gets populated for card related events
followed_user_handleStringUnique handle of the followed user. Populated for user_followed event
follower_user_handleStringUnique handle of the following user. Populated for user_following event
card_author_idINTUnique identifier of the card author
eventStringName of the event
user_idINTUnique identifier of the user
platformStringPlatform from where the event generated - web or mobile
shared_to_user_idINTUnique identifier of the shared user
group_user_idINTUnique identifier of the group user
is_user_generatedINTCard creation mode
comment_idINTUnique identifier of the comment
follower_idINTUnique identifier of the followed user
followed_user_idINTUnique identifier of the follower
channel_idINTUnique identifier of the channel
titleStringTitle of the card
card_messageStringMessage of the card
card_typeStringType of card - Media, Journey, Pathway etc
card_levelStringCard level
card_stateStringCard State
durationStringDuration spent by users
user_first_nameStringFirst name of the user
user_nameStringUnique handle for the user
user_last_nameStringLast name of the user
user_organization_roleStringUser role - admin or member
shared_to_user_organization_roleStringRole of the shared to user - admin or member
group_user_organization_roleStringRole of the group user - admin or member
card_author_organization_roleStringRole of the card author - admin or member
followed_user_organization_roleStringRole of the followed user - admin or member
follower_user_organization_roleStringRole of the follower user - admin or member
user_emailStringEmail of the user
user_last_sign_in_atStringLast sign in time of the user
card_author_first_nameStringFirst name of the card author
card_author_last_nameStringLast name of the card author
card_author_emailStringEmail of the card author
followed_user_first_nameStringFirst name of the followed user
followed_user_last_nameStringLast name of the followed user
followed_user_emailStringEmail of the followed user
follower_user_first_nameStringFirst name of the follower user
follower_user_last_nameStringLast name of the follower user
follower_user_emailStringEmail of the follower user
shared_to_user_first_nameStringFirst name of the shared to user
shared_to_user_last_nameStringLast name of the shared to user
shared_to_user_emailStringEmail of the shared to user
group_user_first_nameStringFirst name of the group user
group_user_last_nameStringLast name of the group user
group_user_emailStringEmail of the group user
comment_messageStringComment message given by the user
comment_typeStringType of the comment
channel_labelStringChannel label given by the user
channel_is_privatebooleanFlag to identify whether the channel is private or public
channel_visiblebooleanFlag to identify whether the channel is visible or invisible
channel_descriptionStringChannel description given by the user
yrStringEvent time year :Ex: 2020
monthStringEvent time month. Ex: 03
dayStringEvent time day. Ex: 2020-03-03
timeTimestamp
assigned_to_user_idINT
assigned_to_user_first_nameString
assigned_to_user_last_nameString
assigned_to_user_emailString
assigned_to_user_handleString
assigned_to_user_organization_roleString
event_team_idINT
group_user_roleString
team_nameString
comment_messageString
channel_labelString
channel_is_privateBoolean
channel_visibleBoolean
channel_descriptionString
org_id_sINT
org_idINT
record_insert_timeString
topic_idString
topic_labelString
topic_nameString
pathway_idString
pathway_nameString
journey_idString
journey_nameString
poll_option_idINT
poll_option_labelString
quiz_option_idString
quiz_option_labelString
is_correctString
user_agentString
completion_typeString
conferencing_toolString
grade_rangeString
grader_typeString
grading_systemString
last_registration_dateTimestamp
project_card_submissionString
project_card_submission_idString
refererString
registration_limitINT
registration_typeString
request_idString
submitter_typeString
training_registration_idString
training_registration_stateString
quiz_attempt_idString
quiz_attempt_passedString
quiz_idString
quiz_option_is_correctString
quiz_passing_criteriaString
quiz_question_attempt_idString
quiz_question_attempt_passedString
quiz_question_idString
quiz_question_labelString
quiz_questions_passed_countString
quiz_reanswerableString
is_system_generatedString
time_zoneString
start_dateTimestamp
end_dateTimestamp
card_hiddenBoolean
readable_card_typeINT
card_slugString
event_recorderString
is_admin_requestString
onboarding_statusString
org_hostnameString
platform_version_numberString
sign_in_ipString
user_org_uidString
user_roleString
domain_idString
domain_labelString
domain_nameString
member_user_idINT
controller_actionString
visited_profile_user_idString
upload_modeString
user_onboarding_current_stepString
user_onboarding_idString
user_onboarding_statusString
average_ratingFloat
card_bookmark_idString
is_channel_featuredString
is_channel_publicString
org_nameString
changed_columnString
new_valString
old_valString
analytics_versionString
scorm_attemptsString
scorm_course_idString
scorm_registration_completionString
scorm_registration_successString
scorm_scoreFloat
scorm_total_seconds_trackedFloat
scorm_user_idINT
skill_idString
skill_nameString
job_familyString
job_roleString
skill_categoryString
skill_level_ratedString
occupation_idString
occupation_nameString
occupation_categoryString
attributesString
badge_idString
badge_typeString
badge_titleString
card_deleted_atTimestamp
card_durationINT
card_is_paidBoolean
card_is_publicBoolean
card_subtypeString
card_resource_urlString
channel_follower_idINT
channel_follower_user_first_nameString
channel_follower_user_last_nameString
channel_follower_user_emailString
channel_follower_user_handleString
channel_follower_user_organization_roleString
collaborator_idINT
collaborator_user_first_nameString
collaborator_user_last_nameString
collaborator_user_emailString
collaborator_user_handleString
collaborator_user_organization_roleString
created_user_idINT
curator_idINT
curator_user_first_nameString
curator_user_last_nameString
curator_user_emailString
curator_user_handleString
curator_user_organization_roleString
ecl_idString
is_card_promotedString
is_live_streamString
suspended_user_idINT
user_exclude_from_leaderboardBoolean
user_created_atTimestamp
user_statusString
user_sign_in_countINT
is_channel_curatedString
is_ecl_enabledString
edited_user_idINT
is_open_source_contentString
external_idString
channel_card_user_idString
ecl_source_idString
card_ratingINT
skill_credentialString
skill_levelString
manager_user_idINT
removed_roleString
added_roleString
skill_descriptionString
channel_carousel_creator_idINT
is_channel_carousel_enabledString
channel_carousel_display_nameString
channel_carousel_idINT
channel_carousel_slugString
impersonator_idString
minuteINT
deleted_user_idINT
time_stringString
hourString

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 NameData TypeDescription
card_idINTUnique identifier of the card
titleStringTitle of the card
card_source_nameStringSource of the card. Example: USG (User Generated), Go1 etc
durationStringTime spent by users on a card
card_typeStringType of card - Media, Journey, Pathway etc
card_levelStringCard level
card_author_nameStringFull name of the card author
assignor_nameStringFull name of the assignor
assignor_idINTUnique identifier of the assignor
assigned_user_idINTUnique identifier of the assigned user
assigned_user_full_nameStringAssigned user full name
assigned_user_handleStringAssigned user handle
assignor_handleStringAssignor handle
assignment_stateStringAssignment state - Pending / Inprogress / Completed
time_assignment_startedTimestampAssignment start time
time_completedTimestampAssignment completion time
assignment_due_dateTimestampAssignment due date
time_assignment_createdTimestampAssignment creation time
yrStringEvent time year :Ex: 2020
monthStringEvent time month. Ex: 03
dayStringEvent 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 NameData TypeDescription
event_timeTimestampTime the event occurred in UTC
card_idINTUnique identifier of the card
card_source_nameStringSource of the card. Example: USG (User Generated), Go1 etc
titleStringTitle of the card
card_typeStringType of card - Media, Journey, Pathway etc
card_levelStringCard level
card_author_full_nameStringFull name of the card author
assignor_nameStringName of the assignor
assignor_idINTUnique identifier of the assignor
group_idINTUnique identifier of the group
team_nameStringName of the group given by the user
assigned_user_idINTUnique identifier of the assigned user
assigned_user_full_nameStringAssigned user full name
assigned_user_handleStringAssigned user handle
assignor_handleStringAssignor’s handle
assignment_stateStringAssignment state - Pending/Inprogress/Completed
time_assignment_startedTimestampAssignment start time
time_completedTimestampAssignment completion time
assignment_due_dateTimestampAssignment due date
time_assignment_createdTimestampAssignment creation time
yrStringEvent time year :Ex: 2020
monthStringEvent time month. Ex: 03
dayStringEvent 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 NameData TypeDescription
event_timeTimestampTime the event occurred in UTC
channel_idINTUnique identifier of the Channel
card_idINTUnique identifier of the card
card_created_atTimestampTime the card created in UTC
card_source_nameStringSource of the card. Example: USG (User Generated), Go1 etc
user_handleStringUnique handle of the user
shared_to_user_handleStringThis field is populated for shared_to_cards or shared_to_group events
group_user_handleStringUnique handle of the user. This fields gets populated for group related events
card_author_handleStringUnique handle of the card author. This fields gets populated for card related events
followed_user_handleStringUnique handle of the followed user. Populated for user_followed event
follower_user_handleStringUnique handle of the following user. Populated for user_following event
card_author_idINTUnique identifier of the card author
eventStringName of the event
user_idINTUnique identifier of the user
platformStringPlatform from where the event generated - web or mobile
shared_to_user_idINTUnique identifier of the shared user
team_idINTUnique identifier of the group
group_user_idINTUnique identifier of the group user
is_user_generatedINTCard creation mode
comment_idINTUnique identifier of the comment
follower_idINTUnique identifier of the followed user
followed_user_idINTUnique identifier of the follower
channel_idINTUnique identifier of the channel
titleStringTitle of the card
card_messageStringMessage of the card
card_typeStringType of card - Media, Journey, Pathway etc
card_levelStringCard level
card_stateStringCard State
durationStringDuration spent by users
user_first_nameStringFirst name of the user
user_nameStringUnique handle for the user
user_last_nameStringLast name of the user
user_organization_roleStringUser role - admin or member
shared_to_user_organization_roleStringRole of the shared to user - admin or member
group_user_organization_roleStringRole of the group user - admin or member
card_author_organization_roleStringRole of the card author - admin or member
followed_user_organization_roleStringRole of the followed user - admin or member
follower_user_organization_roleStringRole of the follower user - admin or member
user_emailStringEmail of the user
user_last_sign_in_atStringLast sign in time of the user
card_author_first_nameStringFirst name of the card author
card_author_last_nameStringLast name of the card author
card_author_emailStringEmail of the card author
followed_user_first_nameStringFirst name of the followed user
followed_user_last_nameStringLast name of the followed user
followed_user_emailStringEmail of the followed user
follower_user_first_nameStringFirst name of the follower user
follower_user_last_nameStringLast name of the follower user
follower_user_emailStringEmail of the follower user
shared_to_user_first_nameStringFirst name of the shared to user
shared_to_user_last_nameStringLast name of the shared to user
shared_to_user_emailStringEmail of the shared to user
comment_messageStringComment message given by the user
comment_typeStringType of the comment
channel_labelStringChannel label given by the user
channel_is_privatebooleanFlag to identify whether the channel is private or public
channel_visiblebooleanFlag to identify whether the channel is visible or invisible
channel_descriptionStringChannel description given by the user
yrStringEvent time year :Ex: 2020
monthStringEvent time month. Ex: 03
dayStringEvent time day. Ex: 2020-03-03
timeString
assigned_to_user_idINT
assigned_to_user_first_nameString
assigned_to_user_last_nameString
assigned_to_user_emailString
assigned_to_user_handleString
assigned_to_user_organization_roleString
collaborator_idINT
collaborator_user_first_nameString
collaborator_user_last_nameString
collaborator_user_emailString
collaborator_user_handleString
collaborator_user_organization_roleString
channel_follower_idINT
channel_follower_user_first_nameString
channel_follower_user_last_nameString
channel_follower_user_emailString
channel_follower_user_handleString
channel_follower_user_organization_roleString
curator_idINT
curator_user_first_nameString
curator_user_last_nameString
curator_user_emailString
curator_user_handleString
curator_user_organization_roleString
event_channel_idINT
standard_typeString
group_user_first_nameString
group_user_last_nameString
group_user_emailString
team_nameString
org_id_sINT
org_idINT
record_insert_timeString
topic_idString
topic_labelString
topic_nameString
pathway_idString
pathway_nameString
journey_idString
journey_nameString
poll_option_idINT
poll_option_labelString
quiz_option_idString
quiz_option_labelString
is_correctString
user_agentString
is_channel_curatedString
is_ecl_enabledString
completion_typeString
conferencing_toolString
grade_rangeString
grader_typeString
grading_systemString
last_registration_dateTimestamp
project_card_submissionString
project_card_submission_idString
refererString
registration_limitINT
registration_typeString
request_idString
submitter_typeString
training_registration_idString
training_registration_stateString
quiz_attempt_idString
quiz_attempt_passedString
quiz_idString
quiz_option_is_correctString
quiz_passing_criteriaString
quiz_question_attempt_idString
quiz_question_attempt_passedString
quiz_question_idString
quiz_question_labelString
quiz_questions_passed_countString
quiz_reanswerableString
is_system_generatedString
time_zoneString
start_dateTimestamp
end_dateTimestamp
card_hiddenBoolean
readable_card_typeINT
card_slugString
event_recorderString
is_admin_requestString
onboarding_statusString
org_hostnameString
platform_version_numberString
sign_in_ipString
user_org_uidString
user_roleString
domain_idString
domain_labelString
domain_nameString
member_user_idINT
controller_actionString
visited_profile_user_idString
upload_modeString
user_onboarding_current_stepString
user_onboarding_idString
user_onboarding_statusString
average_ratingFloat
card_bookmark_idString
is_channel_featuredString
is_channel_publicString
org_nameString
changed_columnString
new_valString
old_valString
analytics_versionString
scorm_attemptsString
scorm_course_idString
scorm_registration_completionString
scorm_registration_successString
scorm_scoreFloat
scorm_total_seconds_trackedFloat
scorm_user_idINT
skill_idString
skill_nameString
job_familyString
job_roleString
skill_categoryString
skill_level_ratedString
occupation_idString
occupation_nameString
occupation_categoryString
attributesString
badge_idString
badge_typeString
badge_titleString
card_deleted_atTimestamp
card_durationINT
card_is_paidBoolean
card_is_publicBoolean
card_subtypeString
card_resource_urlString
created_user_idINT
ecl_idString
group_user_roleString
is_card_promotedString
is_live_streamString
suspended_user_idINT
user_exclude_from_leaderboardBoolean
user_created_atTimestamp
user_statusString
user_sign_in_countINT
edited_user_idINT
is_open_source_contentString
external_idString
channel_card_user_idString
ecl_source_idString
card_ratingINT
skill_credentialString
skill_levelString
manager_user_idINT
removed_roleString
added_roleString
skill_descriptionString
channel_carousel_creator_idINT
is_channel_carousel_enabledString
channel_carousel_display_nameString
channel_carousel_idINT
channel_carousel_slugString
impersonator_idString
minuteINT
deleted_user_idINT
time_stringString
hourString

Searches

(searches_fact_i_v)

Search activities

Attribute NameData TypeDescription
timeTimestamp
_user_idINT
analytics_versionString
event_recorderString
event_timebigint
is_admin_requestString
is_system_generatedString
org_hostnameString
platformString
results_countINT
search_queryString
user_agentString
user_idINTUnique identifier of the user
platform_version_numberString
eventStringName of the event
org_id_sINT
record_insert_timeString
impersonator_idString
yrStringEvent time year :Ex: 2020
monthStringEvent time month. Ex: 03
dayStringEvent time day. Ex: 2020-03-03
hourString
time_stringString

© 2020 EdCast Inc.