AI Analyst

The AI Analyst answers questions about your e-commerce data in plain English. Every answer comes from SQL run against your SourceMedium warehouse, and you can read that SQL. Pick the surface that fits how you work.

Slack AI Analyst

Mention @SourceMedium or DM the bot. SourceMedium writes the SQL and replies with an answer, a table, the query, a CSV, and a chart when one helps.Pick this if your team already works in Slack and wants answers everyone can read and review.

Connected assistant

Connect ChatGPT, Claude, or any other MCP-capable assistant to SourceMedium’s read-only endpoint.Pick this if you want SourceMedium data inside the assistant you already use.

Agent skills

Installable skills that teach a coding agent SourceMedium’s tables, SQL patterns, and result checks.Pick this if you have BigQuery access and want an agent to query the warehouse, build dashboards, or run pipelines of your own.

What you can ask, and what comes back

The table below describes the Slack analyst. A connected assistant or agent skill returns query results inside its own client.

Question type	Example	What you get back
Specific metric	”What was revenue last week by channel?”	A written answer, a table, the SQL, a CSV, and a chart when it helps
Raw data pull	”Pull order ID, order date, UTM source, and revenue for last week”	The rows as a table preview and a CSV, with a short confirmation of what was pulled
Open-ended question	”How can we improve marketing performance?”	Deep Analysis: your question plus one related strategic question, combined into a single answer
Definition or schema	”What is LTV?” or “Which table has order data?”	A written explanation with links to the relevant docs
Data or attribution health	”How is my data health?”	A report on table freshness and UTM coverage
Follow-up in the same thread	”Break that down by month”	A new answer that builds on what the thread already found

The Slack analyst covers orders, refunds and returns, customers and customer analytics, and marketing. It also covers email and SMS, flows, web analytics, attribution and multi-touch attribution, attribution quality, subscriptions, inventory, customer support, and zero-party attribution. Start with Setup, then Asking questions.

Getting Started

Slack AI Analyst

Connected Assistants

Agent Skills

Reference

Slack AI Analyst

Connected assistant

Agent skills

What you can ask, and what comes back

Slack AI Analyst

Connected assistant

Agent skills

​What you can ask, and what comes back

What you can ask, and what comes back