v0.4.0: Cost Comparison Analysis & SpendLogs Support

🚀 Major Features

Cost Comparison Analysis

• New comprehensive cost comparison between SpendLogs and user tables in ll2cz analyze spend
• Side-by-side metrics comparison: spend, tokens, requests, models, providers
• Date range coverage analysis showing data gaps and overlaps
• Provider and model coverage analysis identifying source-specific data
• Automated discrepancy classification: minimal/minor/moderate/major with actionable explanations

SpendLogs Support

• New --source option for analyze data and transmit commands supporting 'usertable' and 'logs'
• SpendLogs data access methods with organization enrichment
• Transaction-level analysis alongside existing daily aggregated data

Centralized Data Processing

• New DataProcessor class consolidating CZRN/CBF generation logic
• Eliminated code duplication across CZRN generation, CBF transformation, and analysis
• Source-aware field mapping with consistent transformations
• Enhanced error tracking and field analysis improvements

🔧 Technical Improvements

Transmission Fixes

• Fixed timestamp processing for datetime objects in CloudZero transmission
• Added Decimal serialization support for PostgreSQL numeric types
• Fixed resource/id construction consistency between data sources
• Added model_family tag extraction for all transmission use cases

Code Quality

• All linting issues resolved and tests passing
• Comprehensive error tracking with detailed field analysis
• Enhanced field mapping analysis with source-aware transformations

📊 Cost Comparison Features

The new cost comparison analysis provides:

1. Metrics Comparison Table

   • Total spend, records, providers, models
   • Request volumes and token usage
   • Average cost per request/token
   • Percentage differences with color coding

2. Date Coverage Analysis

   • Date ranges for each data source
   • Gap identification and overlap analysis
   • Days covered comparison

3. Provider & Model Coverage

   • Common providers/models between sources
   • Source-specific data identification
   • Coverage gap analysis

4. Discrepancy Classification

   • Automated severity assessment
   • Actionable explanations for differences
   • Potential causes and remediation guidance

📦 Installation

pip install ll2cz==0.4.0

🔗 Links

• PyPI: https://pypi.org/project/ll2cz/0.4.0/
• Documentation: See README.md for usage examples
• Issues: https://github.com/Cloudzero/cloudzero-litellm-etl/issues

🙏 What's Next

This release significantly enhances data analysis capabilities and provides better visibility into cost discrepancies between different LiteLLM data sources. Future releases will continue to improve analysis features and data source support.