FCT_ENGAGEMENT_RECORD_STORE_ACTIVITY_SEARCHED relates to platform search activity. This is a standalone table
.png?sv=2022-11-02&spr=https&st=2026-03-19T15%3A24%3A46Z&se=2026-03-19T15%3A35%3A46Z&sr=c&sp=r&sig=jcuVCBkdffqbgzZl2G%2BcBzks%2BF%2FWNMkkukWmWXJWhsA%3D)
While this is an anonymised data set (meaning User ID is not included), other data sets that contain User ID may be linked to this data by Activity ID
Only searches for users with the ‘learner’ role are included
Blank/null/* search terms are excluded from this data set
Dead searches are referred to as Zero-Results Searches in Thrive dashboards
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Activity Date | DATE | Date of the search | 2025-01-01 | |
Activity ID | VARCHAR(16777216) | Identifier for the search activity | 123a12b3cd4e5f67g890h1ij | |
Activity Time | VARCHAR(16777216) | Time of the search | 00:00:00 | |
Activity Timestamp | TIMESTAMP_NTZ(9) | Timestamp of the search | 2025-01-01T00:00:00.000+0000 | |
Activity Type | VARCHAR(16777216) | The type of activity which occurred (searched) | searched | |
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 | |
Is Dead Search | NUMBER(1,0) | A search which returned no results (1 = Yes, 0 = No) | 1, 0 | 1 |
Result Bucket | VARCHAR(15) | Categorises each search based upon the number of search results returned | (0) Zero-Result, (<10) Under 10, (<20) Under 20, (<30) Under 30, (<40) Under 40, (<50) Under 50, (>50) Over 50 | (0) Zero-Result |
Search Activity Origin | VARCHAR(16777216) | Where the search originated from | mobile-app, web, null | mobile-app |
Search Results | NUMBER(38,0) | The number of results returned for the search | 12 | |
Search Term | VARCHAR(16777216) | The search term entered in Thrive, this is normalised so will be in lowercase and trimmed | what discount can I offer? | |
Searches | NUMBER(1,0) | The number of searches | 1, 0 | 1 |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 |