How do I export AI spend to my FinOps platform?
Download a FOCUS-aligned CSV from the Cognocient AI dashboard or pull it via API. Load it into Apptio, CloudZero, Spot, or any FinOps tool that supports FOCUS.
Goal: AI spend data in your existing FinOps platform — Apptio, CloudZero, Spot, or a data warehouse — so your team sees AI costs alongside cloud costs in one view.
Time: 10 minutes for a manual export. 30 minutes to automate via API.
Step 1 — Download a FOCUS export from the dashboard
On the Reports page or the Chargeback page, find the FOCUS Export card:
- Select the date range (e.g., last month)
- Click Download FOCUS CSV
The file is ready immediately. The export is CSV only, with one row per UTC day for each provider, model and tag combination.
Step 2 — Load into your FinOps platform
| Destination | How to load it |
|---|---|
| FinOps platform (Apptio Cloudability, CloudZero, Spot and others) | Add the CSV as a custom or FOCUS data source, following your platform's own import guide |
| Snowflake / BigQuery / Redshift | Load the CSV directly — join on BillingAccountId + BillingPeriodStart |
Column names follow FOCUS conventions, but we haven't certified the import with any specific platform, so check the column mapping on your first load. Department and feature come through in Tags, and the model in SkuPriceDetails.
Step 3 — Automate with the API (for monthly pipelines)
On the Business plan you can skip this step: a FinOps connector pushes the export to Vantage, CloudZero or S3 daily. The API below is for any other destination.
Pull the export programmatically so your pipeline doesn't require a manual step:
Schedule this as a monthly cron job (run on the 2nd of each month, pulling the prior month's data):
Step 4 — Key FOCUS columns for FinOps reconciliation
| FOCUS column | What it contains | FinOps use |
|---|---|---|
ProviderName | The company billing you: OpenAI, Anthropic, AWS... | Filter by AI provider |
ServiceName | The provider's API product: OpenAI API, Claude API, Amazon Bedrock... | Cost by service |
SkuPriceDetails | JSON with the model (x_ModelId) and its developer | Cost by model |
SkuMeter | Input Tokens, Cache Read Input Tokens, Output Tokens... | Cache savings, input vs. output spend |
BilledCost | Actual API cost in USD | Join against cloud billing |
ConsumedQuantity | Tokens (or images, seconds...) for that meter | Token-level unit economics |
Tags | JSON map of your attribution headers, e.g. {"department":"engineering","feature":"search"} | Per-feature and per-department cost drilling |
Step 5 — Reconcile AI spend against cloud billing
To get a unified view of all infrastructure + AI spend:
- Download Cognocient AI FOCUS export for the billing period
- Download your cloud billing export (AWS CUR / Azure export / GCP BigQuery billing)
- Load both into your data warehouse
- Join on
BillingAccountId+BillingPeriodStart - Filter on the
departmentkey inTagsto generate per-department chargebacks that include both cloud and AI spend on one line
Related articles
Tag Your First AI Call
Add 2 headers to your existing code and see per-feature spend in under 5 minutes.
Set a Monthly Spending Limit
Create a hard budget enforced at the proxy before charges reach your provider bill.
Cut Your AI Bill with One Click
Use AI Advisor recommendations to apply model downgrades and caching without code changes.