OpenChat users can send messages to each other containing tokens such as ICP. Users can upgrade to Diamond membership to have access to extra or enhanced features.

OpenChat is a chat application running end-to-end on the Internet Computer blockchain.

CHAT tokenholders own and govern the protocol.

github

twitter

website

Social

OpenChat

# OpenChat Active groups (daily) Methodology

## 1. Overview

The `active_groups_daily` metric measures the number of unique OpenChat groups that had at least one engagement activity on a given day. This metric tracks group-level activity on the OpenChat social platform built on the Internet Computer blockchain. The calculation counts distinct group chat IDs that received messages, edits, reactions, or tips within each daily period, providing insights into the platform's active group engagement.

## 2. Data sources

- **OpenChat platform events**: Raw event logs from OpenChat's v4 events API containing user interactions across the social platform
- **Internet Computer blockchain data**: Underlying blockchain infrastructure supporting the OpenChat decentralized social platform
- **Event payload data**: JSON-structured metadata within events containing chat identifiers, types, and interaction details

## 3. Step-by-step calculation

### Component A: Event deduplication and filtering
- **Purpose**: Clean and filter raw OpenChat events to focus on engagement activities
- **Logic**: Raw OpenChat events are deduplicated using a combination of timestamp, user identifier, event name, source, and JSON payload content. The deduplication process uses row numbering to keep only the first occurrence of identical events. The process then filters for four specific engagement event types that indicate active group participation: `message_sent`, `message_edited`, `reaction_added`, and `message_tipped`
- **Key fields**: Event `timestamp`, `name` (event type), `user` identifier, `source` system, and `payload` (JSON metadata)

### Component B: Chat metadata extraction and daily aggregation
- **Purpose**: Extract chat-specific information and prepare data for group filtering
- **Logic**: From the filtered engagement events, the system extracts `chat_id` and `chat_type` from the JSON payload structure. Timestamps are truncated to daily boundaries using day-level granularity. The process assigns fixed metadata values including market sector ('social'), business segment ('social'), and chain identifier ('internetcomputer') to categorize the data appropriately
- **Key fields**: `chat_id` (unique chat identifier), `chat_type` (group vs other chat types), daily `timestamp` boundaries

### Component C: Group activity isolation
- **Purpose**: Filter chat activities to focus specifically on group interactions
- **Logic**: The system filters the processed chat activities to include only records where `chat_type` equals 'group', effectively isolating group-based interactions from other chat types like direct messages or channels
- **Key fields**: `chat_type` filter criterion, retained `chat_id` for group chats only

### Final aggregation
- **Combining components**: The filtered group activities are aggregated using distinct count operations on `chat_id` values, grouped by daily timestamp boundaries
- **Dimensional breakdowns**: Three separate aggregations are performed: by project tag (overall platform level), by product identifier, and by chain identifier, with null values used for non-applicable dimensions
- **Time aggregation**: Daily boundaries are established by truncating timestamps to day level, ensuring consistent 24-hour periods for counting
- **Final calculation**: The metric value represents the count of unique group chat IDs that had at least one engagement activity (message, edit, reaction, or tip) within each daily period, aggregated across the specified dimensional breakdowns and processed through schema standardization with zero-filling for days without activity

*This methodology was automatically generated by Token Terminal's methodology analyzer.*

Unique active groups over a fixed 24-hour window.

OpenChatCHAT

Active groups (daily)

Active groups (daily)

Competitive landscape