Learn how to prepare your AI usage data for analysis.
Simple format. Instant insights.
Your CSV must include these three essential columns
Text (required)
The AI model name (e.g., "gpt-4", "claude-3-opus", "gemini-pro")
Number (required)
Number of input tokens used
Number (required)
Number of output tokens generated
Text (optional)
Team or department name. If not provided, we auto-generate from API key, email, or customer ID.
Don't have a team column? We can auto-generate it from:
Maps unique API keys to teams (Team-A, Team-B, etc.)
Extracts team from email domain (john@marketing.com → Marketing)
Creates team names from customer IDs (Customer-123, Customer-456)
We support all major AI providers with up-to-date pricing
Three ways to structure your data
With auto-team mapping from API key
model,prompt_tokens,completion_tokens,api_key gpt-4,150,250,sk_prod_123 gpt-3.5-turbo,50,100,sk_prod_456 claude-3-opus,200,300,sk_prod_123
Direct team attribution
model,prompt_tokens,completion_tokens,team gpt-4,150,250,marketing gpt-3.5-turbo,50,100,engineering claude-3-opus,200,300,data_science
Extracts team from email
model,prompt_tokens,completion_tokens,user_email gpt-4,150,250,john@marketing.example.com gpt-3.5-turbo,50,100,jane@eng.example.com gemini-pro,75,150,bob@data.example.com
Follow these guidelines for accurate analysis
Your analysis will include:
Download a template CSV file or upload your data directly
Questions? Contact Support
Max file: 10MB • Max rows: 100,000 • Supported formats: CSV