Analytics

Turn your workflow data into actionable insights. Kiket's analytics stack is configuration-as-code—define queries in YAML, compose dashboards, and let AI surface anomalies.

How Analytics Works

graph LR
    subgraph "Data Flow"
        A[Workflow Events] --> B[Event Store]
        B --> C[dbt Models]
        C --> D[Query Engine]
    end

    subgraph "Outputs"
        D --> E[Dashboards]
        D --> F[Reports]
        D --> G[AI Insights]
    end

    style A fill:#7C3AED,stroke:#fff,color:#fff
    style C fill:#3B82F6,stroke:#fff,color:#fff
    style E fill:#10B981,stroke:#fff,color:#fff
    style F fill:#10B981,stroke:#fff,color:#fff
    style G fill:#10B981,stroke:#fff,color:#fff

Every action in Kiket—issue changes, transitions, comments, AI decisions—flows into the analytics pipeline. dbt models transform raw events into metrics you can query, visualize, and act on.

---

Quick Start

Define a Query

Create .kiket/queries/cycle-time.yaml:

query: cycle_time
description: Average time from backlog to done by priority

sql: |
  SELECT
    priority,
    AVG(EXTRACT(EPOCH FROM (done_at - created_at)) / 3600) as avg_hours
  FROM issue_transitions
  WHERE done_at IS NOT NULL
  GROUP BY priority
  ORDER BY avg_hours DESC

Use in a Dashboard

Create .kiket/dashboards/team-metrics.yaml:

dashboard: team-metrics
name: Team Metrics
layout:
  - row:
    - widget: chart
      query: cycle_time
      type: bar
      title: Cycle Time by Priority

Push to Git—your dashboard appears in Kiket automatically.

---

Key Metrics

Kiket tracks these metrics out of the box:

Metric	Description
Cycle Time	Time from start to completion
Lead Time	Time from creation to completion
Throughput	Issues completed per time period
WIP	Work in progress at any point
Flow Efficiency	Active time vs. wait time
Blocked Time	Time issues spend blocked

---

In This Section

• Dashboards

  Compose dashboards as code and share across teams

  Dashboards

• dbt Pipeline

  How tenant-specific analytics models are built

  dbt pipeline

• Query Definitions

  Author reusable queries in .kiket/queries/

  Queries

• Reports

  Generate and distribute recurring reports

  Reports

• AI Insights

  AI summaries and anomaly detection

  AI insights

• Custom Metrics

  Define custom metrics for your team

  Custom metrics

---

API Reference

Export Usage Data

GET /api/v1/analytics/usage_export

Returns CSV with columns: timestamp, metric, quantity, unit.

Dashboard Tokens

Generate embeddable dashboard tokens:

POST /api/v1/analytics/dashboard_token
{
  "organization_id": 123,
  "dashboard_id": "team-metrics",
  "role": "viewer"  # viewer, editor, admin
}

Query Catalog

List available queries:

GET /api/v1/projects/:id/queries

# Or via CLI
kiket analytics queries <project-id>