> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Claude spend template

> Monitor your organization's Claude Enterprise (Anthropic) spend and usage with an executive cost overview, adoption metrics, and skill and connector usage details.

You can use the Claude spend template to monitor your organization's Claude Enterprise (Anthropic) spend and usage. If your Claude Enterprise cost and usage data is stored in a data platform connected to Sigma, you can use the Claude spend template to review an executive cost overview, adoption metrics, and details about skill and connector usage.

The template is set up with sample data, so you can explore the analysis before you connect your own data.

## System and user requirements

The ability to use the Claude spend template requires the following:

* You must be assigned an account type with the **Create, edit, and publish workbooks** permission enabled.
* To use your own data, your organization must be connected to a data platform containing your Anthropic Analytics tables (see [Data sources](#data-sources)). Otherwise, you can use the template with the provided sample data.
* To use the department and job title views, you must supply a users table that maps each user to a department and job title.

## Data sources

The template expects data from a set of Anthropic Analytics tables, which cover Claude Enterprise usage only. The template uses sample tables in the Sigma Sample Connection, but you can change the source to your organization's own data if it exists in your data platform.

Export the Anthropic usage data from the <a href="https://console.anthropic.com/" target="_blank">Anthropic Console</a> and load it into your data platform.

The Claude spend template expects the data in the following structure:

| Table                                                              | Details                                                                                                  |
| ------------------------------------------------------------------ | -------------------------------------------------------------------------------------------------------- |
| `ANTHROPIC_ANALYTICS_ORG_COST_REPORT` (or `ANTHROPIC_COST_REPORT`) | Organization-level cost in USD. Used for Executive overview spend KPIs and trends.                       |
| `ANTHROPIC_ANALYTICS_ORG_USAGE_REPORT`                             | Organization-level usage (tokens and requests).                                                          |
| `ANTHROPIC_ANALYTICS_USER_COST_REPORT`                             | Per-user cost, keyed by `USER_ID_HASH`. Used for cost-per-user and the department and job-title details. |
| `ANTHROPIC_ANALYTICS_USERS_DAILY`                                  | Daily active users. Used for adoption, seat utilization, and monthly active users.                       |
| `ANTHROPIC_ANALYTICS_SKILLS_DAILY`                                 | Skill usage. Used for the Skills and connectors page.                                                    |
| `ANTHROPIC_ANALYTICS_CONNECTORS_DAILY`                             | Connector usage. Used for the Skills and connectors page.                                                |
| `ANTHROPIC_ANALYTICS_SUMMARIES`                                    | Supports summary rows.                                                                                   |
| Your users table                                                   | Join to `ANTHROPIC_ANALYTICS_USER_COST_REPORT` to add user and department-level detail.<sup>1</sup>      |

<p class="footnote">
  1

  Anthropic does not share user or department data. The per-user cost table identifies each user as a <code>USER\_ID\_HASH</code>. To populate the <strong>By department</strong>, <strong>By job title</strong>, and <strong>Detailed spend by department</strong> views, replace the sample users table in the template with a users table of your own. You can change the source to your table, or load your users into an <a href="/docs/intro-to-input-tables">input table</a> with the same shape, keeping the column names identical so the join and elements continue to work.
</p>

## Create a workbook from the template

To create a workbook from this template:

1. Go to **Home** > **Templates**, then select the **Claude Spend** template to review its details.
2. Click **Use template**. The template opens as an [exploration](/docs/ad-hoc-data-explorations) named after the template using sample data.
3. To use your own data, click **Change sources**:

   In the **Swap data sources overview** modal, Sigma attempts to match each source to your own tables. Because the column names match the Anthropic export, most sources match automatically.

   1. To replace a matched source, select the source drop-down menu, then select a new source.
   2. Match the sample users table to your own users table.
   3. Click **Swap now**, then explore the changes to confirm your data looks correct.
4. In the **Filters** menu, set the **Date Range** to scope every page to the period you care about.
5. To create an editable, publishable document, in the document header, click **Save as**, then name and save the workbook.

For more details, see [Create documents from templates](/docs/create-workbooks-from-templates).

## About this template

The template contains four pages, plus a hidden **Data** page for source data. The template also includes a README file to document the purpose of the template, source tables, and setup steps.

### Executive overview

This page answers "How much is Claude Enterprise costing us?" and includes:

* **Monthly spend**, **Monthly tokens**, and **Monthly requests** KPIs, each with a period-over-period change
* **Monthly active users**, **Monthly adoption**, and **Cost per user** KPIs with sparklines
* A stacked bar chart of monthly spend by department
* **Top 5 models by spend**, with a **Show** control for the number of results and a **Spend By** toggle for **Model**, **Token Type**, or **Product**
* **Token mix**, an area chart that splits token usage by input, output, uncached input, cache read input, and cache creation tokens

### Adoption & engagement

This page answers "Who is using Claude Enterprise?" and includes:

* **Seat utilization**, the average share of assigned seats that are active over the period
* **Active users over time** plots average daily, weekly, and monthly active users
* **Detailed spend by department**, a table of total spend, spend per user, and total users by month and department
* **By department** and **By job title** bar charts of total spend to show which teams and roles drive cost

### Skills & connectors

This page answers "Which skills and connectors create the most value?" and includes:

* **Top skills** and **Top connectors** bar charts, sorted by usage
* **Skill usage trend** and **Connectors usage trend** charts over time
* **Skill detail** and **Connector detail** tables, breaking usage into distinct users, chat conversations, Claude Code sessions, Cowork sessions, and Office sessions

## Related resources

* [OpenAI spend template](/docs/openai-spend-template)
* [Snowflake AI spend template](/docs/snowflake-ai-spend-template)
* [Get started with templates](/docs/get-started-with-templates)
* [Create documents from templates](/docs/create-workbooks-from-templates)
* [Create and edit document templates](/docs/create-and-edit-workbook-templates)