How do I export AI spend to my FinOps platform?

Download a FOCUS 1.1 CSV from the Cognocient dashboard or pull it via API. Load it into Apptio, CloudZero, Spot, or any FinOps tool that supports FOCUS — no schema mapping required.

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 1.1 export from the dashboard

Go to Dashboard → Reports → Export → FOCUS 1.1:

Select the date range (e.g., last month)
Choose format: CSV (for FinOps platforms) or JSON (for data warehouses)
Click Download

The file is ready immediately.

Step 2 — Load into your FinOps platform

Platform	How to ingest
Apptio Cloudability	Settings → Custom Data Sources → Upload FOCUS file → map on `BillingAccountId`
CloudZero	Integrations → Custom Dimensions → Upload CSV — AI cost dimensions align with FOCUS column names
Spot by NetApp	Eco → Cost Sources → Add Source → FOCUS 1.0+ compatible upload
AWS Cost Explorer	The FOCUS export maps to CUR 2.0 format — load via S3 + Cost and Usage Report ingestion
Azure Cost Management	ActualCost + FOCUS columns — ingest via Azure Storage → Cost Management export
Snowflake / BigQuery / Redshift	Load the CSV/JSON directly — join on `BillingAccountId` + `BillingPeriodStart`

If you use Apptio Cloudability or CloudZero, ingest the file as a "custom spend source." AI spend will appear alongside your cloud costs with full drill-down by department, feature, and model — no schema transformation needed.

Step 3 — Automate with the API (for monthly pipelines)

Pull the export programmatically so your pipeline doesn't require a manual step:

# CSV export — for FinOps platforms
curl "https://api.cognocient.com/api/exports/focus?from=2026-05-01&to=2026-05-31" \
  -H "Authorization: Bearer sk-cog-YOUR-PROXY-KEY" \
  -o cognocient-may-2026.csv
 
# JSON export — for data warehouses
curl "https://api.cognocient.com/api/exports/focus?from=2026-05-01&to=2026-05-31&format=json" \
  -H "Authorization: Bearer sk-cog-YOUR-PROXY-KEY" \
  -o cognocient-may-2026.json

Schedule this as a monthly cron job (run on the 2nd of each month, pulling the prior month's data):

import httpx
from datetime import date, timedelta
from dateutil.relativedelta import relativedelta
 
def export_last_month():
    today = date.today()
    first_of_this_month = today.replace(day=1)
    first_of_last_month = first_of_this_month - relativedelta(months=1)
    last_of_last_month  = first_of_this_month - timedelta(days=1)
 
    resp = httpx.get(
        "https://api.cognocient.com/api/exports/focus",
        headers={"Authorization": f"Bearer {COGNOCIENT_KEY}"},
        params={
            "from":   first_of_last_month.isoformat(),
            "to":     last_of_last_month.isoformat(),
            "format": "csv",
        },
    )
    resp.raise_for_status()
 
    filename = f"cognocient-{first_of_last_month.strftime('%Y-%m')}.csv"
    with open(filename, "wb") as f:
        f.write(resp.content)
 
    return filename

Step 4 — Key FOCUS columns for FinOps reconciliation

FOCUS column	What it contains	FinOps use
`ProviderName`	`openai` / `anthropic` / `google`	Filter by AI provider
`ServiceName`	Model name (`gpt-4o-mini`, `claude-sonnet-4-6`)	Cost by model
`SubAccountName`	`X-Cost-Department` value	Department chargeback
`BilledCost`	Actual API cost in USD	Join against cloud billing
`Tags/x-cost-feature`	Feature name	Per-feature cost drilling
`Tags/x-cost-department`	Department	Chargeback allocation
`Tags/x-cog-classification`	`investment` or `waste`	ROI vs. waste split

Step 5 — Reconcile AI spend against cloud billing

To get a unified view of all infrastructure + AI spend:

Download Cognocient 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 by Tags/x-cost-department to generate per-department chargebacks that include both cloud and AI spend on one line

Step 1 — Download a FOCUS 1.1 export from the dashboard

Step 2 — Load into your FinOps platform

Step 3 — Automate with the API (for monthly pipelines)

Step 4 — Key FOCUS columns for FinOps reconciliation

Step 5 — Reconcile AI spend against cloud billing

On this page