Skip to main content
The AI Analyst queries your data in BigQuery through Slack. Before you can use it, your data infrastructure must be in place and your Slack user must be authorized for your SourceMedium tenant.

​
How It Works

Your data flows from connected platforms (Shopify, Google Ads, Meta, GA4, etc.) through the SourceMedium pipeline into your BigQuery warehouse. The AI Analyst and your dashboards both query the same underlying data — they’re just different interfaces.

​
Prerequisites

Before installing the AI Analyst, ensure your SourceMedium data pipeline is set up:
1

Connect Your Data Sources

The AI Analyst queries data from your connected platforms. At minimum, you need:
  • E-commerce platform (Shopify, Amazon Seller Central)
  • Marketing platforms (Google Ads, Meta Ads, etc.)
  • Web analytics (GA4)

All Integrations

See the full list of supported integrations.
2

Verify Data Is Flowing

After connecting integrations, check the connection statuses in your workspace and confirm that your dashboard contains data.If a source needs action, open its connection page for the next step. If the status is unclear, open a support request.
3

Confirm BigQuery Access

The AI Analyst queries the sm_transformed_v2 dataset in your BigQuery project. Your SourceMedium team handles this provisioning — no action needed from you unless you’re self-hosting.

BigQuery Essentials

Learn about your BigQuery data warehouse.
If you’re already using SourceMedium dashboards, your data infrastructure is ready — proceed to Slack installation.

​
Slack Installation

The AI Analyst is delivered as a Slack app called SourceMedium.
In Slack, the bot appears as “SourceMedium” (or “SourceMedium (YourCompany)”). Throughout these docs, we refer to it as the “AI Analyst” to distinguish it from other SourceMedium products.

​
Install URL

The AI Analyst uses a shared SourceMedium Slack app for production installs:
Your SourceMedium tenant is selected from the installing user’s email identity, not from a tenant-specific URL.

​
Installing the App

1

Visit your install URL

Go to https://uni.sourcemedium.com/slack/install
2

Click 'Add to Slack'

You’ll be redirected to Slack’s authorization page.
3

Review permissions

See what the app can access (details below).
4

Authorize

Click “Allow” to complete installation.
5

Start asking questions

Mention the bot in a channel or send it a direct message.
You must be a Slack workspace admin (or have app installation permissions) and your email must match your tenant’s allowed domain or exact allowed-email list.

​
Permissions Requested

When you install the app, Slack shows the permissions being requested:
The bot only sees messages in channels where it’s explicitly added or in direct messages sent to it. It cannot read messages in other channels.

​
After Installation

Once installed:
  1. Invite the bot to a channel: Use /invite @SourceMedium or add it from channel settings
  2. Or use direct messages: Send a DM to the SourceMedium bot for private queries
  3. Ask a question: Type your question in natural language
The bot responds in a thread with your results.
Many teams create a dedicated #analytics or #data-questions channel for queries. This keeps analytics discussions organized and lets the whole team learn from each other’s questions.

​
Access Control

​
Who Can Use It

Slack authentication is used, but workspace membership alone is not enough. The AI Analyst checks the user’s Slack email address against your tenant’s configured access policy:
  • Allowed email domains, such as yourcompany.com
  • Exact allowed emails, useful for approved contractors or shared external partners
The same policy is checked during installation and at runtime when a user asks a question.

​
What Data Is Accessible

The AI Analyst can query all SourceMedium out-of-the-box tables for your tenant:
  • Orders and revenue data
  • Customer information
  • Marketing and ad performance
  • Email and SMS metrics
  • Web analytics events
  • Attribution data
Approved users can query the SourceMedium tables available to your tenant. Customer-managed permissions by table, store, metric, or analytical domain are not yet available.

​
Multi-Store Organizations

If your organization has multiple stores connected to SourceMedium, the AI Analyst sets store scope per thread.
When more than one sm_store_id is available, the AI Analyst prompts you to confirm a store before running analysis. Once confirmed, the thread is locked to that store. Start a new thread to switch stores.sm_store_id is the store identifier SourceMedium uses to keep each store’s data separate. See the Glossary.

Multi-store thread scoping

Learn how store selection works in DMs and channels.

​
Troubleshooting

​
Data Issues

“I’m not seeing recent data”
  • Check Data Health to verify table freshness
  • Data typically refreshes daily; check with your SourceMedium team for your refresh schedule
“The AI doesn’t know about my tables”
  • The AI Analyst only queries SourceMedium out-of-the-box tables
  • Custom tables or views you’ve created in BigQuery are not accessible

​
Installation Issues

“You don’t have permission to install apps” Ask your Slack workspace admin to either:
  • Install the app for you
  • Grant you app installation permissions
“This workspace is not authorized” Your Slack workspace or user account may not be approved for AI Analyst access. Contact your SourceMedium team to verify access for your organization. “Installation denied” or “access denied” The installer or message sender is not currently approved for AI Analyst access. Ask your SourceMedium team to update access if the user should be allowed. Bot not responding after installation
  1. Make sure the bot is invited to the channel you’re messaging in
  2. Try sending a direct message to the bot instead
  3. Check that you’re mentioning the bot correctly (@SourceMedium)

​
Getting Help

If you run into issues during setup, open a support request from your workspace. Include the affected workspace and a description of the issue.

Workspace Guides

Set up your workspace, connect data sources, and manage access.

All Integrations

Complete list of supported data sources.