Schema Discover Billing

{
  "metadata": {
    "report_date": "2026-02-24",
    "project_directory": "/path/to/project",
    "billing_source": "gcp-billing-export.csv",
    "billing_period": "2026-01"
  },
  "summary": {
    "total_monthly_spend": 2450.00,
    "service_count": 8,
    "currency": "USD"
  },
  "services": [
    {
      "gcp_service": "Cloud Run",
      "gcp_service_type": "google_cloud_run_service",
      "monthly_cost": 450.00,
      "percentage_of_total": 0.18,
      "top_skus": [
        {
          "sku_description": "Cloud Run - CPU Allocation Time",
          "monthly_cost": 300.00
        },
        {
          "sku_description": "Cloud Run - Memory Allocation Time",
          "monthly_cost": 150.00
        }
      ],
      "ai_signals": []
    },
    {
      "gcp_service": "Cloud SQL",
      "gcp_service_type": "google_sql_database_instance",
      "monthly_cost": 800.00,
      "percentage_of_total": 0.33,
      "top_skus": [
        {
          "sku_description": "Cloud SQL for PostgreSQL - DB custom CORE",
          "monthly_cost": 500.00
        },
        {
          "sku_description": "Cloud SQL for PostgreSQL - DB custom RAM",
          "monthly_cost": 300.00
        }
      ],
      "ai_signals": []
    },
    {
      "gcp_service": "Vertex AI",
      "gcp_service_type": "google_vertex_ai_endpoint",
      "monthly_cost": 600.00,
      "percentage_of_total": 0.24,
      "top_skus": [
        {
          "sku_description": "Vertex AI Prediction - Online Prediction",
          "monthly_cost": 400.00
        },
        {
          "sku_description": "Generative AI - Gemini Pro Input Tokens",
          "monthly_cost": 200.00
        }
      ],
      "ai_signals": ["vertex_ai", "generative_ai"]
    }
  ],
  "commitments": {
    "has_active_cuds": true,
    "total_monthly_commitment_fees": 150.00,
    "total_monthly_cud_credits": -120.00,
    "effective_discount_percent": 8.2,
    "details": [
      {
        "type": "resource_based",
        "term": "1_year",
        "covered_services": ["Compute Engine"],
        "region": "us-central1",
        "monthly_fee": 75.00,
        "sku_description": "Commitment v1: E2 Cpu in Americas for 1 Year"
      },
      {
        "type": "resource_based",
        "term": "1_year",
        "covered_services": ["Compute Engine"],
        "region": "us-central1",
        "monthly_fee": 75.00,
        "sku_description": "Commitment v1: E2 Ram in Americas for 1 Year"
      }
    ]
  },
  "cost_basis": {
    "uses_list_price": true,
    "total_at_list": 2450.00,
    "total_net_of_discounts": 2280.00,
    "discount_breakdown": {
      "committed_usage_discount": -120.00,
      "sustained_usage_discount": -50.00,
      "free_tier": 0.00
    }
  },
  "ai_signals": {
    "detected": true,
    "confidence": 0.85,
    "services": ["Vertex AI"]
  }
}