Integration Basics

  • One integration per billing account / org ID – create a separate integration for each account
  • Data appears in Pelanor dashboards within ≈ 12 hours of upload
  • New data for a given month overwrites any previous uploads for that month

Integration Methods

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

CSV Format Requirements

Required fields

FieldDescriptionFormat
usage_dateDate when the usage occurredYYYY-MM-DD
costCost in USDNumeric (12.50)

Optional fields (improve data organisation)

FieldDescriptionShows as*
service_nameName of the servicevendor name
usage_typeType of usageCustom
usage_subcategorySub-category of usageCustom
usage_categoryCategory of usageCustom
payment_kindKind of paymentOn Demand
resource_idResource identifierservice_name or vendor
resource_nameFriendly resource nameservice_name or vendor
subaccountSub-account identifierNone
tag:{key_name}Custom tags(not displayed)
regionRegion informationNone
availability_zoneAvailability ZoneNone
consumptionQuantity consumed
consumption_typeType of consumption †Other

Allowed consumption_type values
Data Transferred, Data Processed, CPU Core Hours, Storage, Requests, Item Count, Usage Hours, Other


Creating Your CSV

1

Start with required fields

Begin with usage_date and cost columns.

2

Add optional fields

Add any other columns that improve your categorization and filtering.

3

Format values

Dates must use the YYYY-MM-DD format (e.g., 2025-05-01).
Costs must be numeric—don’t include currency symbols.

4

Save the file

Save the file as a .csv.


Data Validation

Pelanor verifies that:

  • The file is valid CSV
  • usage_date and cost are present
  • Values follow expected formats
  • consumption_type values (if included) are valid

If any issues are found, Pelanor returns a clear error so you can fix the file.


After Integration

  • Analyse these costs alongside your cloud providers
  • Filter / group by any column you uploaded
  • Build dashboards including custom-vendor spend
  • Create alerts for unusual spending patterns