FCT_ENGAGEMENT_RECORD_STORE_ACTIVITY_VIEWED relates to viewed activity within the platform. This could be a content view, space view, user profile view etc. The table can be joined to DIM_CONTENT_SERVICE_CONTENTS on Content ID, many to 1, to show content items which have been viewed. It can also be joined to DIM_USER_SERVICE_USER on User ID, many to 1, to show which users are viewing content, spaces, user profiles etc
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Activity Date | DATE | Date of the viewed activity | 2025-01-01 | |
Activity ID | VARCHAR(16777216) | Identifier for the viewed activity | 123a12b3cd4e5f67g890h1ij | |
Activity Time | VARCHAR(16777216) | Time of the viewed activity | 00:00:00 | |
Activity Timestamp | TIMESTAMP_NTZ(9) | Datetime of the viewed activity | 2025-01-01T00:00:00.000+0000 | |
Content ID | VARCHAR(16777216) | Identifier for the content | 123a12b3cd4e5f67g890h1ij | |
Content Type | VARCHAR(16777216) | Type of content (e.g. - url, file, video etc.) | video | |
Doc Created At | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | |
Doc Updated At | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | |
Duration | NUMBER(38,0) | Duration in seconds of the view | 120 | |
Origin | VARCHAR(16777216) | Where the view originated from | mobile-app, web, null | mobile-app |
Source | VARCHAR(16777216) | Impression for the view (e.g. - feed, campaign, search etc.) | search | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Thrive Role | VARCHAR(16777216) | Users role within the platform | learner, learneradmin, null, administrator | learner |
Thrive Status | VARCHAR(16777216) | Users status on the platform | active, suspended, new, null | active |
User Full Name | VARCHAR(16777216) | User full name | John Smith | |
User ID | VARCHAR(16777216) | Identifier for the user | 123a12b3cd4e5f67g890h1ij | |
Username(Email) | VARCHAR(16777216) | User username(email) | john.smith@emailaddress.com |