Video Analytics with AI Reporting

Ask Claude to deploy a complete Open Analytics solution. This will create and connect multiple services:

> Deploy an Open Analytics solution for video analytics

Claude will provision the following interconnected services:

• Eventsink — HTTP endpoint to receive analytics events
• Queue — Message queue to buffer incoming events
• Worker — Processes events and writes to database
• ClickHouse — Column-oriented database for analytics

Once the deployment is complete, ask Claude for the Eventsink URL:

> What is the Eventsink URL for my analytics pipeline?

Verify your pipeline is working using the analytics demo site:

On the demo site:

1. Paste your Eventsink URL in the configuration field
2. Play the demo video
3. Watch as analytics events are submitted to your pipeline

Now set up n8n for workflow automation. Ask Claude to create both n8n and its task runner:

> Create an n8n instance with task runner for workflow automation

Claude will deploy n8n (a powerful workflow automation tool) and configure the task runner for executing workflows.

Open n8n and create a new workflow with an AI agent that generates daily reports. The workflow should:

1. Schedule Trigger — Run daily at your preferred time
2. ClickHouse Query — Fetch viewing statistics
3. AI Agent — Analyze data and generate report
4. Output — Send report via email, Slack, or webhook

For the ClickHouse query, use something like:

SELECT
  session_id,
  MAX(position / duration) as max_progress
FROM epas_epasdemo
WHERE timestamp >= today() - 1
  AND duration > 0
GROUP BY session_id
HAVING max_progress >= 0.9

This query calculates the watch progress (position / duration) and finds all sessions where users watched at least 90% of the video.

In the n8n workflow, add an AI Agent node and configure it to analyze the viewing data. Use a prompt like:

Analyze this video viewing data and create a daily report.
Include:
- Total number of viewers who watched 90%+ of the video
- Comparison to previous day if available
- Any notable trends or insights
- Recommendations for content improvement

Connect your preferred AI provider (OpenAI, Anthropic, etc.) in n8n credentials.

Configure the Schedule Trigger to run daily:

1. Set the trigger to "Cron" mode
2. Configure for daily execution (e.g., 0 9 * * * for 9am)
3. Save and activate the workflow