Interactive Demo | AI Analytics

AI Analytics Dashboard for Agencies

A client reporting dashboard that combines social metrics, trend charts, API sync status, AI-written monthly insight summaries, and a recommendation queue.

Performance Trend

Reach and engagement by week

Synced

AI Monthly Summary

What changed and what to do next

Claude summary

Channel Breakdown

Platform contribution

Recommendation Queue

Actions ready for review

Data Pipeline

API sync and warehouse status

Healthy

Client Report Package

What the agency can hand to a client

Implementation Pattern

What this proves technically.

The page is static for the portfolio, but the product shape mirrors a real agency analytics build: API ingestion, SQL models, chart-ready facts, LLM summary generation, and reviewable client outputs.

Metric fact model

select
  client_id,
  report_month,
  channel,
  sum(reach) as reach,
  sum(engagements) as engagements,
  sum(clicks) as clicks,
  safe_divide(sum(engagements), sum(reach)) as engagement_rate
from social_platform_events
group by 1, 2, 3;

AI summary contract

{
  "client": "Maven Skincare",
  "period": "June 2026",
  "inputs": ["kpis", "channel_mix", "top_posts"],
  "output_schema": {
    "summary": "string",
    "risks": ["string"],
    "recommendations": ["string"]
  }
}