Service Integrations
OpenAI
Import OpenAI billing data into Pelanor to see AI-related spend alongside the rest of your cloud bill.
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
- In-Platform Integration – coming soon
- 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.
Any structure/content changes will cause the import to fail.
Required Data Fields
| Field Name | Description | Format / Example |
|---|---|---|
start_time | Beginning of the usage period | Unix timestamp 1716153600 |
end_time | End of the usage period | Unix timestamp |
amount_value | Cost of the usage | Float |
amount_currency | Currency code | Currently only USD supported |
line_item | Service description | "gpt-4o-2024-08-06, input" |
project_id | Project identifier | String |
organization_id | Organisation identifier | String |
project_name | Project name | String |
organization_name | Organisation name | String |
Validation & Processing
Pelanor verifies:organization_idmatches the integration settings- Required fields are present and correctly formatted
- Processing completes within ~12 hours
Troubleshooting
| Issue | What to Check |
|---|---|
| Data not appearing | Was the file uploaded successfully? Is organization_id correct? |
| Upload errors | Was Cost data exported (not Activity data)? |
| Format issues | Is the uploaded file the unmodified CSV from OpenAI? |
| Date-range problems | Does 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