systemprompt-analytics 0.1.18

Analytics module for systemprompt.io - session tracking, metrics, and reporting
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

use chrono::{DateTime, Utc};
use serde::{Deserialize, Serialize};
use sqlx::FromRow;
use systemprompt_identifiers::{SessionId, UserId};

#[derive(Debug, Clone, Copy, Serialize, Deserialize, FromRow)]
pub struct SessionStatsRow {
    pub total_sessions: i64,
    pub unique_users: i64,
    pub avg_duration: Option<f64>,
    pub avg_requests: Option<f64>,
    pub conversions: i64,
}

#[derive(Debug, Clone, Copy, Serialize, Deserialize, FromRow)]
pub struct ActiveSessionCountRow {
    pub count: i64,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct LiveSessionRow {
    pub session_id: SessionId,
    pub user_type: Option<String>,
    pub started_at: DateTime<Utc>,
    pub duration_seconds: Option<i32>,
    pub request_count: Option<i32>,
    pub last_activity_at: DateTime<Utc>,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct SessionTrendRow {
    pub started_at: DateTime<Utc>,
    pub user_id: Option<UserId>,
    pub duration_seconds: Option<i32>,
}