Integration Basics

  • One integration per OpenAI organisation – each org ID needs its own connector
  • New uploads for a month replace any previous data for that month
  • Data appears in Pelanor within ≈ 12 hours of upload

Integration Methods

  1. In-Platform Integrationcoming soon
  2. API Integration – programmatic uploads
    API Docs (US Environment) | API Docs (EU Environment)

Exporting OpenAI Usage Data

1

Log in to OpenAI

Use the organisation you want to integrate.

2

Navigate to Usage

Go to Usage from the side navigation.

3

Select billing range

Pick the date range for the billing month.

4

Click Export

Use the Export button in the top-right.

5

Configure export modal

  • Tab: Cost data (not Activity data)
  • Group by → Line Item
  • File format → CSV
  • Confirm Start / End dates
  • Time interval → 1 day
6

Download

Click Download and save the file unmodified.

Use the CSV exactly as downloaded from OpenAI.
Any structure/content changes will cause the import to fail.


Required Data Fields

Field NameDescriptionFormat / Example
start_timeBeginning of the usage periodUnix timestamp 1716153600
end_timeEnd of the usage periodUnix timestamp
amount_valueCost of the usageFloat
amount_currencyCurrency codeCurrently only USD supported
line_itemService description"gpt-4o-2024-08-06, input"
project_idProject identifierString
organization_idOrganisation identifierString
project_nameProject nameString
organization_nameOrganisation nameString

Validation & Processing

Pelanor verifies:

  • organization_id matches the integration settings
  • Required fields are present and correctly formatted
  • Processing completes within ~12 hours

Troubleshooting

IssueWhat to Check
Data not appearingWas the file uploaded successfully? Is organization_id correct?
Upload errorsWas Cost data exported (not Activity data)?
Format issuesIs the uploaded file the unmodified CSV from OpenAI?
Date-range problemsDoes the file cover the entire billing month?

After Integration

  • Compare OpenAI spend to other cloud costs
  • Track efficiency using Unit Cost Analysis
  • Build dashboards with OpenAI metrics
  • Set alerts for spending anomalies