> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sourcemedium.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Claude and ChatGPT dashboards

> Build a live dashboard on your SourceMedium data in Claude or ChatGPT, through your own SourceMedium connection. No warehouse key.

Claude and ChatGPT can each build a dashboard from a prompt and host it in your own Claude or ChatGPT account. Charts read SourceMedium through the connector, so they use your workspace's metric definitions and you never paste a BigQuery credential. Everyone who opens one reads through their own SourceMedium connection and sees only what they already can.

On **Dashboards & Apps**, these are **Claude Dashboard** and **ChatGPT Dashboard**. On Claude Dashboard, **Set up** opens the connection steps on **AI Agents**. On ChatGPT Dashboard, it opens the steps below, starting with the workspace plugin and the server URL to copy. Once you connect, the row shows **Connected**, and **Manage** has the steps and prompts on this page.

> [!WARNING]
>
> When you connect SourceMedium to an AI service, queries and the resulting data may be sent to the AI provider you choose. Ask for totals and trends, not customer contact, address, or other direct personal data, unless it is necessary and authorized for your use case.

## Before you start

Connect SourceMedium to the agent you will build in: follow [Connect your own agent](https://docs.sourcemedium.com/docs/ai-analyst/connect-an-ai-assistant.md), or choose **Set up** on Claude Dashboard in **Dashboards & Apps**. Any workspace member can connect, with their own SourceMedium sign-in. A ChatGPT Dashboard needs SourceMedium added as a workspace plugin instead: **Set up** on its tile has those steps, also below.

## Claude Dashboard

Claude builds it with [Claude Data](https://support.claude.com/en/articles/17454700-get-started-with-claude-data), on Claude's paid plans. Chat works on every plan.

**1. Ask for a dashboard**

In Claude, open **Artifacts**, choose **Data**, and say what you want to see and how often to refresh it. Asking in any chat works too.

**2. Check, refine and share**

Open a chart's query to see how it was counted, ask Claude for changes, then **Share** it.

* **Where it lives:** your Claude account. Claude refreshes it through the SourceMedium connector as often as you ask.
* **Who can open it:** whoever you share it with in Claude. Each needs their own SourceMedium connection, unless you turn on Claude's live sharing (beta) for it.
* **What it needs:** on Team or Enterprise, an Owner may first need to turn on Claude Data (**Organization settings → Artifacts**) and artifact connectors (**Organization settings → Capabilities**).

## ChatGPT Dashboard

ChatGPT builds and hosts it as a website with [ChatGPT Sites](https://learn.chatgpt.com/docs/sites), in public beta on eligible Plus, Pro, Business, Enterprise and Edu plans. Hosting uses your plan's Sites allowance, and live data needs a Business, Enterprise or Edu workspace.

> [!NOTE]
>
> A SourceMedium connection added only to your own ChatGPT account (**Plugins → Add custom MCP server**) works in chat, but a Site can't use it: the Site's sign-in lists SourceMedium as not available. A Site reads SourceMedium through a workspace plugin.

**1. Add SourceMedium as a workspace plugin**

A ChatGPT workspace admin opens the workspace's admin settings and chooses **Plugins → Add → Create MCP plugin**. Name it SourceMedium, paste the server URL that **Set up** on ChatGPT Dashboard shows (also on **AI Agents**), keep **OAuth**, and sign in to SourceMedium when asked. Then choose **Review app**, review its tools and risks, and **Publish**. **Allow site visitors to use this plugin** is on by default; leave it on.

**2. Ask for a website**

In ChatGPT on the web or desktop, mention **@Sites** or ask for a website using SourceMedium, and say what you want to see. The prompts below keep it inside your workspace.

**3. Check and refine**

Try it in the preview and check the numbers against SourceMedium. Select **Edit** or ask ChatGPT for changes.

**4. Open it**

On their first visit, each person signs in with ChatGPT, allows the Site to read their SourceMedium connection, and selects **Continue**.

* **Where it lives:** your ChatGPT workspace, as a Site.
* **Who can open it:** people in your ChatGPT workspace. A public Site, or anyone outside the workspace, gets no SourceMedium data. Sharing a Site never shares your own connection.
* **What it needs:** a ChatGPT Business, Enterprise or Edu workspace, SourceMedium added as a workspace plugin, and a Site shared only inside the workspace.

### Keeping it current

Each visitor's own SourceMedium connection loads the data, and **Refresh now**, in the Site's refresh menu, reloads it. Ask for the date the data runs through, so everyone can see how current the numbers are.

The same menu offers **Schedule refresh**, which creates a cloud task. OpenAI says a scheduled task can't use a visitor's connected access, so don't count on it to refresh SourceMedium data in a Site.

### Keeping it private

* Keep the Site shared inside your workspace.
* Let the Site load SourceMedium data through each visitor's connection. Rows saved in a Site's own database are a copy outside SourceMedium's access checks, and the Site's editors can read them. Save only totals, and only when you need them.
* Never paste a password, key or token into a prompt. The Site needs none: each visitor's sign-in is the access.

## Prompts to start from

Copy one into Claude or ChatGPT, then refine it in the same chat.

> [tab] Claude
>
> ```text theme={null}
> Using SourceMedium, build a dashboard of net revenue, orders and new customers by day for the last 30 days, and refresh its data daily.
> ```
>
> ```text theme={null}
> Using SourceMedium, build a dashboard of weekly ad spend, ROAS and CPA by channel for the last 12 weeks, and refresh its data daily.
> ```
>
> ```text theme={null}
> Using SourceMedium, build a dashboard of new and repeat customer orders and net revenue by month for the last 12 months, and refresh its data daily.
> ```

> [tab] ChatGPT
>
> ```text theme={null}
> Using SourceMedium, build a website private to my workspace with a dashboard of net revenue, orders and new customers by day for the last 30 days, and a Refresh button.
> ```
>
> ```text theme={null}
> Using SourceMedium, build a website private to my workspace with a dashboard of weekly ad spend, ROAS and CPA by channel for the last 12 weeks, and a Refresh button.
> ```
>
> ```text theme={null}
> Using SourceMedium, build a website private to my workspace with a dashboard of new and repeat customer orders and net revenue by month for the last 12 months, and a Refresh button.
> ```

Ask for more in the same chat: another chart, a filter by store or channel, a comparison with the previous period, or a layout that fits a phone. Ask which metric definition a chart uses, and for its query, whenever a number surprises you.

## Vendor guides

* Anthropic: [Get started with Claude Data](https://support.claude.com/en/articles/17454700-get-started-with-claude-data)
* OpenAI: [ChatGPT Sites](https://learn.chatgpt.com/docs/sites), [Data and connections](https://learn.chatgpt.com/docs/sites/data-and-connections), [Publish and share](https://learn.chatgpt.com/docs/sites/publishing-and-sharing)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.