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 Total user time online Methodology

## 1. Overview

User online time measures the total time users spend actively online on the OpenChat platform, calculated in milliseconds per day. This metric provides insights into user engagement and platform activity levels. The calculation aggregates `user_online` events from the OpenChat platform, where each event represents one minute of user activity, and converts the total count to milliseconds for daily reporting.

## 2. Data sources

- **OpenChat platform events**: Event logs from the OpenChat social platform running on the Internet Computer blockchain, containing user activity data including online presence events
- **Event metadata**: Platform-generated events with timestamps, event types, user identifiers, and activity payloads

## 3. Step-by-step calculation

### Component A: Event deduplication and preparation
- **Purpose**: Clean and deduplicate raw OpenChat platform events
- **Logic**: Raw events from the OpenChat platform are processed to remove exact duplicates. Events are deduplicated using a combination of `timestamp`, `user` identifier, event `name`, `source`, and `payload` content. A row number is assigned to each unique combination, and only the first occurrence (row_number = 1) is retained to ensure data quality
- **Key fields**: Essential fields include `timestamp` for timing, `name` for event type identification, `user` for user identification, `source` for event origin, and `payload` for additional event data

### Component B: Online time event filtering and aggregation
- **Purpose**: Calculate daily user online time from activity events
- **Logic**: From the cleaned events, only events with `name` equal to 'user_online' are selected. These events represent user online activity periods. The events are then grouped by day (using timestamp truncation to daily boundaries) and counted. Each `user_online` event represents exactly one minute of user activity, so the count is multiplied by 60 seconds and then by 1000 to convert to milliseconds
- **Key fields**: The calculation uses `timestamp` for daily grouping, `name` for filtering to 'user_online' events, and produces `user_online_time` as the final metric value in milliseconds

### Final aggregation
- **Combining components**: The deduplicated events flow directly into the aggregation step where `user_online` events are counted per day
- **Time aggregation**: Events are aggregated to daily boundaries using timestamp truncation, ensuring consistent daily reporting periods
- **Currency conversion**: Not applicable - this metric measures time duration rather than financial value
- **Final calculation**: Total daily user online time equals the count of `user_online` events multiplied by 60,000 milliseconds (60 seconds × 1000 milliseconds per event representing one minute of activity). The result is standardized with social market sector classification and Internet Computer chain identification, with gap-filling applied to ensure continuous daily data series.

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

OpenChatCHAT

Total user time online

Total user time online

Competitive landscape