• TOTALS
  • AVERAGES
  • COUNTS
  • HUMAN

How to run data aggregations with your AI

Connect Keen to your AI client once. After that, you can query your event data using natural language.

Ask AI about this page

Short answer

How can I aggregate Keen data using AI?

Your AI client uses specific tools to calculate totals, averages, and counts from your Keen event collections. You just ask for the numbers, and the AI handles the math. You'll get the specific metrics you need without writing code.

Data outcomes

What you get from your queries

The AI processes your event streams into these specific results.

TOTALS

Summed values

The AI adds up numeric properties across your events. This gives you totals for things like revenue or points.

AVERAGES

Mean metrics

It calculates the average for any numeric property. You can quickly find mean session lengths or order values.

COUNTS

Event volume

The AI counts how many times events happened or how many unique users showed up. It turns raw logs into counts.

HUMAN

Your interpretation

The AI provides the raw numbers. You decide what those numbers mean for your business or project.

The workflow

What your AI does when you ask a question.

The AI maps your request to the right data operation.

  1. Count occurrences

    The AI determines how many times a specific event has triggered in your collection.

    count_events

  2. Calculate sums

    It pulls numeric property values to find the total sum for a specific metric.

    sum_property

  3. Compute averages

    The AI finds the mean value for a property across your event data.

    average_property

  4. Identify unique items

    It counts or lists distinct values, like unique user IDs or device types.

    count_uniqueselect_unique

Try it

Copy these to start.

Paste these into your chat to test the connection.

Starting points

Replace the bracketed text with your actual Keen collection names and property keys.

Keen Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_EmKj2WUExWJ6m1N7u6wrgOcjAX3XgobRZ64OQACk/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Keen capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "keen-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_EmKj2WUExWJ6m1N7u6wrgOcjAX3XgobRZ64OQACk/mcp"
    }
  }
}
Copy into chat04

  • How many [event_name] events happened in the last hour?

  • What is the average [property_name] for [event_name]?

  • Sum the [revenue_property] for all [event_name] events.

  • How many unique [user_id] are in the [event_name] collection?

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect Keen once, then ask.

Connect your account in one step. Your login details stay encrypted on our side, and you can start querying immediately.

Connect Keen to your AI

FAQ

How the aggregator behaves

  • 01

    Can the AI change my Keen data?

    No. The AI can only read and aggregate data. It cannot delete or modify any events in your collections.

  • 02

    Can I use this to add new properties to my events?

    No. The tools only work with properties that already exist in your Keen data.

  • 03

    Can the AI export these results to a CSV?

    No. The AI provides the calculated numbers directly in your chat interface.

  • 04

    Can I count unique users?

    Yes. You can ask the AI to count unique values for any property, such as a user ID.

  • 05

    Does the AI need to write SQL to get these answers?

    No. You use natural language, and the AI handles the underlying data operations.

  • More questions about Keen? See everything the Keen Connector can do

Connect Keen to Claude, Cursor, ChatGPT & more