---
title: "FCT_ENGAGEMENT_RECORD_STORE_ACTIVITY_SEARCHED"
slug: "fct-engagement-record-store-activity-searched"
updated: 2026-10-08T14:26:01Z
published: 2026-10-08T14:26:01Z
canonical: "docs.thrivelearning.com/fct-engagement-record-store-activity-searched"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.thrivelearning.com/llms.txt
> Use this file to discover all available pages before exploring further.

# FCT_ENGAGEMENT_RECORD_STORE_ACTIVITY_SEARCHED

> [!NOTE]
> FCT_ENGAGEMENT_RECORD_STORE_ACTIVITY_SEARCHED relates to platform search activity. This is a standalone table
> 
> ![](https://cdn.document360.io/3a0609fb-d96c-4ce1-aabe-d9338fb1e858/Images/Documentation/image(619).png?sv=2026-02-06&spr=https&st=2026-11-05T20%3A05%3A15Z&se=2026-11-05T21%3A05%3A15Z&sr=c&sp=r&sig=fgsTBZcFDT9lfrDRf2L3mlJ1O%2F%2BTUmgfl5oMIpwulIY%3D)

> [!WARNING]
> 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) 50 or more | (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 |