Claude spend template

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). 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 Anthropic Console 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.¹

1Anthropic does not share user or department data. The per-user cost table identifies each user as a USER_ID_HASH. To populate the By department, By job title, and Detailed spend by department 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 input table with the same shape, keeping the column names identical so the join and elements continue to work.

Create a workbook from the template

To create a workbook from this template:

Go to Home > Templates, then select the Claude Spend template to review its details.
Click Use template. The template opens as an exploration named after the template using sample data.
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.
In the Filters menu, set the Date Range to scope every page to the period you care about.
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.

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