systemprompt-analytics 0.2.1

pub mod cli;
mod engagement;
mod events;
mod fingerprint;
mod funnel;

#[allow(unused_imports)]
pub use cli::*;
pub use engagement::{CreateEngagementEventInput, EngagementEvent, EngagementOptionalMetrics};
pub use events::{
    AnalyticsEventBatchResponse, AnalyticsEventCreated, AnalyticsEventType, ConversionEventData,
    CreateAnalyticsEventBatchInput, CreateAnalyticsEventInput, EngagementEventData,
    LinkClickEventData, ScrollEventData,
};
pub use fingerprint::{FingerprintAnalysisResult, FingerprintReputation, FlagReason};
pub use funnel::{
    CreateFunnelInput, CreateFunnelStepInput, Funnel, FunnelMatchType, FunnelProgress, FunnelStats,
    FunnelStep, FunnelStepStats, FunnelWithSteps,
};

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

#[derive(Debug, Clone, Copy, Serialize, Deserialize, FromRow)]
pub struct UserMetricsWithTrends {
    #[serde(rename = "users_24h")]
    pub count_24h: i64,
    #[serde(rename = "users_7d")]
    pub count_7d: i64,
    #[serde(rename = "users_30d")]
    pub count_30d: i64,
    #[serde(rename = "users_prev_24h")]
    pub prev_24h: i64,
    #[serde(rename = "users_prev_7d")]
    pub prev_7d: i64,
    #[serde(rename = "users_prev_30d")]
    pub prev_30d: i64,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct RecentConversation {
    pub context_id: ContextId,
    pub agent_name: String,
    pub user_name: String,
    pub status: String,
    pub message_count: i64,
    pub started_at: DateTime<Utc>,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct ContentStat {
    pub title: String,
    pub slug: String,
    pub views_5m: i64,
    pub views_1h: i64,
    pub views_1d: i64,
    pub views_7d: i64,
    pub views_30d: i64,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct AnalyticsSession {
    pub session_id: SessionId,
    pub user_id: Option<UserId>,
    pub fingerprint_hash: Option<String>,
    pub ip_address: Option<String>,
    pub user_agent: Option<String>,
    pub device_type: Option<String>,
    pub browser: Option<String>,
    pub os: Option<String>,
    pub country: Option<String>,
    pub city: Option<String>,
    pub referrer_url: Option<String>,
    pub utm_source: Option<String>,
    pub utm_medium: Option<String>,
    pub utm_campaign: Option<String>,
    pub is_bot: bool,
    pub is_scanner: Option<bool>,
    pub is_behavioral_bot: Option<bool>,
    pub behavioral_bot_reason: Option<String>,
    pub started_at: Option<DateTime<Utc>>,
    pub last_activity_at: Option<DateTime<Utc>>,
    pub ended_at: Option<DateTime<Utc>>,
    pub request_count: Option<i32>,
    pub task_count: Option<i32>,
    pub ai_request_count: Option<i32>,
    pub message_count: Option<i32>,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct AnalyticsEvent {
    // SQLx: analytics event primary key (text column, no typed ID defined)
    pub id: String,
    pub event_type: String,
    pub event_category: String,
    pub severity: String,
    pub user_id: UserId,
    pub session_id: Option<SessionId>,
    pub message: Option<String>,
    pub metadata: Option<String>,
    pub timestamp: DateTime<Utc>,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct ErrorSummary {
    pub error_type: String,
    pub count: i64,
    pub last_occurred: DateTime<Utc>,
    pub sample_message: Option<String>,
}

#[derive(Debug, Clone, Copy, Serialize, Deserialize, FromRow)]
pub struct PlatformOverview {
    pub total_users: i64,
    pub active_users_24h: i64,
    pub active_users_7d: i64,
    pub total_sessions: i64,
    pub active_sessions: i64,
    pub total_contexts: i64,
    pub total_tasks: i64,
    pub total_ai_requests: i64,
}

#[derive(Debug, Clone, Copy, Serialize, Deserialize, FromRow)]
pub struct CostOverview {
    pub total_cost: f64,
    pub cost_24h: f64,
    pub cost_7d: f64,
    pub cost_30d: f64,
    pub avg_cost_per_request: f64,
}

#[derive(Debug, Clone, Copy, Serialize, Deserialize, FromRow)]
pub struct ActivityTrend {
    pub date: DateTime<Utc>,
    pub sessions: i64,
    pub contexts: i64,
    pub tasks: i64,
    pub ai_requests: i64,
    pub tool_executions: i64,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct TopUser {
    pub user_id: UserId,
    pub user_name: String,
    pub session_count: i64,
    pub task_count: i64,
    pub ai_request_count: i64,
    pub total_cost: f64,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct TopAgent {
    pub agent_name: String,
    pub task_count: i64,
    pub success_rate: f64,
    pub avg_duration_ms: i64,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct TopTool {
    pub tool_name: String,
    pub execution_count: i64,
    pub success_rate: f64,
    pub avg_duration_ms: i64,
}

#[derive(Debug, Clone, Copy, Serialize, Deserialize, FromRow)]
pub struct TrafficSummary {
    pub total_sessions: i64,
    pub unique_visitors: i64,
    pub page_views: i64,
    pub avg_session_duration_seconds: f64,
    pub bounce_rate: f64,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct TrafficSource {
    pub source: String,
    pub sessions: i64,
    pub percentage: f64,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct DeviceBreakdown {
    pub device_type: String,
    pub count: i64,
    pub percentage: f64,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct BrowserBreakdown {
    pub browser: String,
    pub count: i64,
    pub percentage: f64,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct GeographicBreakdown {
    pub country: String,
    pub count: i64,
    pub percentage: f64,
}

#[derive(Debug, Clone, Copy, Default, Serialize, Deserialize, FromRow)]
pub struct BotTrafficStats {
    pub total_requests: i64,
    pub bot_requests: i64,
    pub human_requests: i64,
    pub bot_percentage: f64,
}

#[derive(Debug, Clone, Copy, Serialize, Deserialize, FromRow)]
pub struct ConversationSummary {
    pub total_conversations: i64,
    pub active_conversations: i64,
    pub completed_conversations: i64,
    pub avg_messages_per_conversation: f64,
    pub avg_duration_minutes: f64,
}

#[derive(Debug, Clone, Copy, Serialize, Deserialize, FromRow)]
pub struct ConversationTrend {
    pub date: DateTime<Utc>,
    pub new_conversations: i64,
    pub completed_conversations: i64,
    pub total_messages: i64,
}

#[derive(Debug, Clone, Serialize, Deserialize, FromRow)]
pub struct ConversationByAgent {
    pub agent_name: String,
    pub conversation_count: i64,
    pub avg_messages: f64,
    pub success_rate: f64,
}