Data Exports

CICosts allows you to export your cost data for external analysis, reporting, and integration with other tools.

Export Formats

CSV Export

Export data as comma-separated values:

• Opens in Excel, Google Sheets, Numbers
• Easy to analyze with pivot tables
• Simple to share with stakeholders

Example CSV Output:

date,repository,workflow,job,runner,duration_minutes,cost
2024-01-15,api-service,ci.yml,build,ubuntu-latest-8-core,12,$0.38
2024-01-15,api-service,ci.yml,test,ubuntu-latest-4-core,8,$0.13
2024-01-15,api-service,ci.yml,deploy,ubuntu-latest-2-core,3,$0.02

JSON Export

Export data as structured JSON:

• Easy to parse programmatically
• Preserves data types
• Good for API integrations

Example JSON Output:

{
  "export_date": "2024-01-15T12:00:00Z",
  "date_range": {
    "start": "2024-01-01",
    "end": "2024-01-15"
  },
  "summary": {
    "total_cost": 1234.56,
    "total_runs": 789,
    "total_minutes": 15678
  },
  "data": [
    {
      "date": "2024-01-15",
      "repository": "api-service",
      "workflow": "ci.yml",
      "runs": 45,
      "cost": 123.45
    }
  ]
}

What You Can Export

Cost Summary

High-level overview of spending:

Field	Description
Total Cost	Sum of all costs
Total Runs	Number of workflow runs
Total Minutes	Billable minutes used
Average Cost/Run	Mean cost per workflow run

Detailed Breakdown

Granular data per run:

Field	Description
Date	When the run occurred
Repository	Repository name
Workflow	Workflow file name
Run ID	GitHub run identifier
Jobs	List of jobs in the run
Duration	Total runtime in minutes
Cost	Calculated cost

Aggregated Views

Pre-aggregated exports:

• By Repository: Costs grouped by repo
• By Workflow: Costs grouped by workflow
• By Runner: Costs grouped by runner type
• By Day/Week/Month: Time-series aggregations

How to Export

From Dashboard

1. Navigate to the view you want to export
2. Click the Export button
3. Choose format (CSV or JSON)
4. Select what to include
5. Download the file

From Reports

If you have scheduled reports (Pro+):

1. Go to Settings → Reports
2. Find your report
3. Click Download Latest
4. Or configure automatic email delivery

Via API

Use the CICosts API for programmatic exports:

curl -H "Authorization: Bearer YOUR_API_KEY" \
  "https://api.cicosts.dev/v1/costs/export?format=csv&start=2024-01-01&end=2024-01-31"

Export Filters

Date Range

Select the time period for export:

• Preset ranges (Today, This Week, This Month)
• Custom start and end dates
• Rolling periods (Last 30 days)

Scope

Filter by scope:

• All organizations
• Specific organization
• Specific repository
• Specific workflow

Granularity

Choose data granularity:

• Summary: Totals only
• Daily: Day-by-day breakdown
• Per-Run: Individual workflow runs
• Per-Job: Job-level details

Use Cases

Financial Reporting

Export monthly costs for budget tracking:

1. Select the month
2. Choose "By Repository" grouping
3. Export as CSV
4. Import into your finance system

Client Billing

Generate client invoices:

1. Select client organization
2. Set billing period
3. Export with cost details
4. Attach to invoice

Trend Analysis

Analyze costs in external tools:

1. Export 6+ months of data
2. Import into Excel/Sheets
3. Create pivot tables
4. Build visualizations

Data Warehouse

Load into your data warehouse:

1. Export as JSON via API
2. Transform with ETL tools
3. Load into BigQuery/Snowflake
4. Join with other business data

Scheduled Exports (Pro+)

Automate regular exports:

Email Delivery

1. Go to Settings → Reports
2. Click Create Report
3. Configure:
   • Frequency (daily, weekly, monthly)
   • Format (CSV or JSON)
   • Recipients
4. Save

Webhook Delivery

Push exports to your systems:

1. Configure a webhook endpoint
2. CICosts posts data on schedule
3. Your system processes the data

Data Limits

Export Limits

Plan	Max Rows	Max Date Range
Free	10,000	30 days
Pro	100,000	1 year
Team	500,000	1 year

Rate Limits

• Web exports: 10 per hour
• API exports: 60 per hour (Pro+)

Large Exports

For very large exports:

1. Request via API with pagination
2. Or request a bulk export (processed async)
3. Download link sent via email

Privacy and Security

Data Included

Exports include:

• Repository names
• Workflow names
• Cost and timing data
• Job names

Exports do not include:

• Source code
• Secrets or variables
• Personal user data
• GitHub tokens

Export Audit

All exports are logged:

• Who exported
• When
• What data
• Download count

---

See also: API Reference →