OpenAI Usage

A set of scripts for querying users in an OpenAI organization, downloading user usage to csv, and plotting cost over time.

External resources: Pandas, Matplotlib

Tested on Mac OS 12.6.7 with Python 3.10.9

To use, create .env file at root with the following information:

• openai_org_id - can find here - required
• openai_api_key - API key of a user with owner privileges in the org - required
• data_dir - path to your data directory - optional
• finetune_models - list of text strings that are names of any finetune models your organization uses - optional
• date_range - list of text strings for dates to get usage from in the format of YYYY-MM-DD - optional

After your .env file is setup:

• Run python openai_usage.py to get the users in your org and then download their data for specified date_range OR yesterday
• Run python openai_analysis.py to clean up the usage data, attach cost values, and plot per user costs

Credit to this thread for kickstarting the process of exposing the less well documented OpenAI API usage endpoints.