# ES Business Analytics cURL Examples (v1)

Use env vars:
- `ES_URL`
- `ES_API_KEY`
- `ES_INDEX=customer_subscription_v1`

## Revenue by package (nested terms)
```bash
curl -sS -H "Authorization: ApiKey $ES_API_KEY" "$ES_URL/$ES_INDEX/_search" \
  -H 'Content-Type: application/json' -d '{
  "size": 0,
  "query": {"bool": {"must": [{"term": {"app_id": 1004}}]}},
  "aggs": {
    "orders_nested": {
      "nested": {"path": "orders"},
      "aggs": {
        "packages": {
          "terms": {"field": "orders.sms_package_id", "size": 20},
          "aggs": {"revenue": {"sum": {"field": "orders.price"}}}
        }
      }
    }
  }
}'
```