👑PROMPTKINGFOCUS 1.4 Conformance

FOCUS 1.4 · FinOps Open Cost & Usage Specification

FOCUS 1.4 Conformance
& Power BI Field Mapping

PromptKing exports native FOCUS 1.4 conformant AI billing data. Download standard FOCUS CSV or JSON and load it directly into Power BI, Tableau, or Snowflake — no custom ETL required. A FOCUS 1.3 legacy export remains available for pipelines mid-implementation.

Ratified at FinOps X 2026 · San Diego · June 4, 2026

FOCUS 1.4 — ratified at FinOps X 2026 — extends the open billing standard to AI token economics. PromptKing exports conformant FOCUS 1.4 datasets across every connected AI vendor: token quantities, service categorization, and effective cost, normalized into the industry's common language.

With the Linux Foundation's Tokenomics Foundation now co-funding the FOCUS token-economics expansion, token-level cost data is becoming the industry's shared dialect. PromptKing speaks it natively.

✅

FOCUS 1.4 Conformant — token economics columns mapped or conformantly null

Spec: focus.finops.org/focus-specification/ · Conformance file: /focus-conformance.json · FOCUS 1.3 legacy export: ?spec=1.3

↓ Download 1.4 CSV↓ Download 1.4 JSON↓ 1.3 legacy CSV

Conformance Declaration

FieldValue
schema_version
1.4.0 (default) · 1.3.0 (legacy)
spec_url
https://focus.finops.org/focus-specification/
export_endpoint
https://www.promptking32.com/api/v1/focus-export
export_formats
CSV, JSON
version_selector
?spec=1.4 (default) · ?spec=1.3 (legacy pipelines)
conformance_date
2026-06-09 (FOCUS 1.4 ratified June 4, 2026 at FinOps X)
custom_columns
x_AIModel, x_AIVendor, x_InputTokens, x_OutputTokens, x_CachedTokens, x_PlanType, x_UtilisationPct, x_IsAgentic, x_GLCode, x_CostCentre, x_Department, x_ProjectCode, x_BusinessUnit, x_ServiceNowCI, x_ServiceNowCostCentre, x_JiraProject, x_JiraTeam

Power BI — 4-Step Quick Start

1

Download the FOCUS CSV

Click "Download 1.4 CSV" above or navigate to /api/v1/focus-export?format=csv&period=30d&spec=1.4. Save the file locally.

2

Load into Power BI

Open Power BI Desktop → Get Data → Text/CSV → select the file. Use "Detect data types" — Power BI will auto-type dates, decimals, and booleans from the column names.

3

Set column types

BillingPeriodStart / BillingPeriodEnd → Date. BilledCost / EffectiveCost / ListCost → Decimal. x_IsAgentic → True/False. x_UtilisationPct → Decimal (0–1).

4

Create the CFO summary page

Add: Card visual (Total AI Spend = SUM[BilledCost]), Donut chart (BilledCost by ServiceProviderName), Table (SubAccountName, x_PlanType, BilledCost, x_UtilisationPct), Filter (ChargeCategory = "Purchase") for seat analysis.

Power BI DAX Measures — Copy & Paste

Create these measures in Power BI (Modeling → New Measure). Assumes your table is named FOCUS.

Total AI SpendTotal cost card on summary page
Total AI Spend = SUM('FOCUS'[BilledCost])
Effective CostAfter-discount spend — use for ROI numerator
Effective Cost = SUM('FOCUS'[EffectiveCost])
Token EfficiencyProxy for prompt quality — higher = more efficient
Token Efficiency = DIVIDE(SUM('FOCUS'[x_OutputTokens]), SUM('FOCUS'[x_InputTokens]))
Ghost SeatsGhost seat count for CFO report KPI card
Ghost Seats = CALCULATE(COUNTROWS('FOCUS'), 'FOCUS'[x_UtilisationPct] < 0.2, 'FOCUS'[ChargeCategory] = "Purchase")
Agentic Cost ShareJune 15 programmatic risk — flag if >40%
Agentic % = DIVIDE(CALCULATE(SUM('FOCUS'[BilledCost]), 'FOCUS'[x_IsAgentic] = TRUE()), SUM('FOCUS'[BilledCost]))
Savings AvailableRecoverable spend from ghost seats
Savings Available = CALCULATE(SUM('FOCUS'[ListCost]) - SUM('FOCUS'[BilledCost]), 'FOCUS'[x_UtilisationPct] < 0.2)

Core FOCUS 1.4 Columns — Cost and Usage Dataset

FOCUS 1.4's supplemental datasets (Invoice Detail, Billing Period, expanded Contract Commitment) are optional and not yet emitted — the Cost and Usage dataset below is the conformance surface for AI subscription billing. Columns with no data source in our schema are emitted null, which is conformant per FOCUS rules.

ColumnData TypeRequiredPower BIDescription & Usage
BillingAccountIdString✓ YesTextPromptKing org ID — use as slicer for multi-tenant environments
BillingAccountNameString✓ YesTextOrganisation name. Maps to customer name in BI dimensions.
BillingCurrencyString✓ YesTextAlways "USD" in current version.
BillingPeriodStartDateTime✓ YesDatePeriod start. Format: YYYY-MM-DD. Use as date axis in trend charts.
BillingPeriodEndDateTime✓ YesDatePeriod end. Pair with BillingPeriodStart for range filters.
ChargeCategoryString✓ YesText"Usage" (token consumption) or "Purchase" (seat subscription). Filter to "Usage" for token analysis.
BilledCostDecimal✓ YesDecimalActual cost charged. Primary cost measure — SUM for total spend.
EffectiveCostDecimal✓ YesDecimalCost after discounts and credits. Use for ROI calculations.
ListCostDecimal✓ YesDecimalList price before any discounts. Per 1.4 rules, equals ListUnitPrice × PricingQuantity. Compare to BilledCost to surface savings.
ListUnitPriceDecimal✓ YesDecimalPer-unit list price (per token for Usage, per seat for Purchase).
PricingCategoryString✓ YesText"Committed" (subscription), "On-Demand" (API), "Dynamic" (GitHub AI Credits).
PricingQuantityDecimal✓ YesDecimalTokens for Usage rows, seat count (1) for Purchase rows.
PricingUnitString✓ YesText"token" for API usage, "seat" for subscriptions.
ConsumedQuantityDecimalOptionalDecimalFOCUS 1.4 consumption column — total tokens (input + output) from per-seat telemetry. Use for token-economics efficiency analysis.
ConsumedUnitStringOptionalText"tokens" for AI usage rows — the 1.4 token-economics consumption unit.
ServiceNameString✓ YesTextModel name (e.g. "claude-sonnet-4-6") or plan name (e.g. "Claude Max 5×").
ServiceCategoryString✓ YesText"AI and Machine Learning", "Developer Tools", or "Business Applications".
ServiceProviderNameString✓ YesTextVendor name: "Anthropic", "GitHub", "Microsoft", "Google", "Amazon Web Services", "IBM".
HostProviderNameStringOptionalTextProvider the service is deployed on. Distinguishes GitHub Copilot (host: Microsoft) and Bedrock-served models (host: AWS) from the selling vendor.
CommitmentProgramEligibilityDetailsStringOptionalTextNew in FOCUS 1.4 — commitment programs a charge qualifies for. Emitted null: AI subscription seats have no commitment-program data source yet (conformant per spec).
SubAccountIdStringOptionalTextSeat ID — enables seat-level drill-down in BI reports.
SubAccountNameStringOptionalTextSeat display name — human-readable label for BI tables.
Tags/departmentStringOptionalTextDepartment tag — use as slicer for department chargeback reports.

Custom AI Columns (x_ prefix — FOCUS extensibility)

Per FOCUS extensibility guidelines, custom columns use the x_ prefix. FOCUS 1.4 keeps one row per charge for AI token economics — input, output, and cached token splits ride as x_ extension columns. These expose AI-specific dimensions not in the core spec — ghost seat detection, agentic usage flagging, and model-level cost attribution.

ColumnData TypeRequiredPower BIDescription & Usage
x_AIModelStringOptionalTextSpecific model identifier (e.g. "claude-sonnet-4-6"). Use to filter by model in cost analysis.
x_AIVendorStringOptionalTextNormalised vendor key: "anthropic", "github", "microsoft", "google", "watsonx". Use for cross-vendor comparison.
x_InputTokensIntegerOptionalWholeInput tokens consumed. Use to calculate prompt cost separately from completion cost.
x_OutputTokensIntegerOptionalWholeOutput tokens generated. Typically more expensive — track separately.
x_CachedTokensIntegerOptionalWholePrompt-cache token count — explains lower-than-list effective cost. Currently null: per-seat cache telemetry lands in a later release (conformant null per FOCUS rules).
x_PlanTypeStringOptionalText"pro", "max_5x", "max_20x" for Claude; "business", "enterprise" for Copilot. Use for plan tier analysis.
x_UtilisationPctDecimalOptionalDecimalSeat utilisation rate 0–1. Filter to <0.2 to find ghost seats in Power BI.
x_IsAgenticBooleanOptionalTrue/FalseTrue when usage is from Agent SDK or claude -p (programmatic). Filter to true to isolate agentic cost.
x_GLCodeStringOptionalTextGeneral ledger account code (e.g. "6200-AI-TOOLS"). Maps to SAP HANA GL account, Oracle COA, Workday spend category. Use for finance system reconciliation.
x_CostCentreStringOptionalTextFinance cost centre code (e.g. "CC-ENG-001"). Maps to Apptio TBM cost centre, SAP CO module. Use for chargeback and showback reporting.
x_DepartmentStringOptionalTextHuman-readable department name. Use as slicer for department-level showback in CFO reports.
x_ProjectCodeStringOptionalTextProject or initiative code for AI spend attribution. Maps to Jira project key or ServiceNow project sys_id.
x_BusinessUnitStringOptionalTextBusiness unit code for enterprise chargeback. Use to roll up AI spend by BU in board-level reporting.
x_ServiceNowCIStringOptionalTextServiceNow CMDB Configuration Item name or sys_id. Surfaces AI seat as a software asset in ServiceNow SAM/ITAM modules.
x_ServiceNowCostCentreStringOptionalTextServiceNow cost centre reference. Links AI spend to the ServiceNow cost_centre table for ITSM chargeback workflows.
x_JiraProjectStringOptionalTextJira project key (e.g. "ENG", "DATA", "OPS"). Links AI spend to engineering work for team-level attribution.
x_JiraTeamStringOptionalTextJira team or squad name. Use for squad-level chargeback when multiple teams share a Jira project.

Tableau & Snowflake

Tableau Desktop

  • →Connect → Text File → select FOCUS CSV
  • →Date columns (BillingPeriodStart/End) auto-detect as Date
  • →Create a Vendor Spend dashboard: Rows = ServiceProviderName, Columns = MEASURE(BilledCost)
  • →Add filter: ChargeCategory = "Purchase" for seat-level view
  • →x_UtilisationPct < 0.2 filter surfaces ghost seats instantly

Snowflake / Data Warehouse

  • →Load FOCUS JSON via Snowflake COPY INTO from stage
  • →Schema: all numeric columns as FLOAT, dates as DATE, booleans as BOOLEAN
  • →x_ columns map to AI-specific dimension tables
  • →JOIN on SubAccountId for seat-level enrichment from HR/identity systems
  • →Recommended: partition by BillingPeriodStart for query performance

Ready to connect your AI vendors?

Connect Anthropic, GitHub Copilot, Google Workspace, M365, Bedrock, or Watsonx — and export live FOCUS data to your BI stack in minutes.

Get in touch →Enterprise export inquiry →
👑 PromptKing Inc. · Ontario Business Corporation · info@promptking32.comFOCUS 1.4 Conformance · Last reviewed: June 2026