EdCast

EdCast Product Documentation

Welcome to the EdCast product hub. You'll find comprehensive guides and documentation to help you start working with the EdCast analytics and integrations offerings.

User Documentation

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

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

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

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

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

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

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

channel_name

String

Name 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

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

Updated about a month ago

EdData


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.


© 2020 EdCast Inc.