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-01-30T18%3A10%3A10Z&se=2026-01-30T18%3A21%3A10Z&sr=c&sp=r&sig=jPI16qAe7IoWF5q%2BYO1A3o0jISUMyzn3QrJ3BniKOCI%3D)
This is an anonomysided data set (user id is not included)
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 | 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 |