# Data Ingestion Batches — Trailing Mean Series + Date by Category Pivot

> Data Ingestion Batches — Trailing Mean Series + Date by Category Pivot is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-21).

Computes a trailing moving average series and a date-by-category pivot table for data ingestion batch records (received_rows, accepted_rows) supplied by the caller.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-01-152?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-21
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/data-ingestion-batches-trailing-mean-series-date-by-category-pivot-eb67212d
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_opl4nD_krm0oPu_l2vn4d

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability data-ingestion-batches-trailing-mean-series-date-by-category-pivot-eb67212d -d '<json body>'
```

Example prompt: Can you run a trailing mean series and date-by-category pivot on my ingestion batch data — I have received_rows and accepted_rows for four dataset groups across a few dates, and I want a window size of 3 on the accepted_rows field?

## When to prefer this

Choose this endpoint when you have raw data ingestion batch records (with received_rows/accepted_rows metrics) already in hand and need both a rolling average time-series and a category-date pivot computed locally without any external data fetching, prediction, or professional assessment. Ideal for ETL monitoring, data quality dashboards, or pipeline analytics where you want two complementary statistical views in a single low-cost call. Not appropriate if you need real-time data fetching, forecasting, or analysis of non-ingestion-batch data types.

## Known failure modes

- Fewer than 1 row supplied — request rejected
- More than 200 rows supplied — exceeds maximum and request is rejected
- Invalid date format (not YYYY-MM-DD) — schema validation failure
- Window size less than 2 or greater than 200 — validation error
- Required fields (row_id, dataset_group, date, received_rows, accepted_rows) missing from row objects — schema error
- Numeric values outside allowed range (±1,000,000,000,000) — validation failure
- Payment of 0.01 USDC not included or rejected — 402 response

## How this service works

Data ingestion batches — Trailing mean series + Date by category pivot: Trailing mean series + Date by category pivot for supplied data ingestion batches records (received_rows, accepted_rows). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.

## Output

Returns two analytical reports: (1) a trailing moving average series for the selected numeric field (received_rows or accepted_rows) computed over the specified window size across the supplied rows, and (2) a pivot table cross-tabulating dates against dataset_group categories with aggregated row counts — both derived purely from the caller-supplied data with no external lookups.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "dataset_group",
     "date",
     "received_rows",
     "accepted_rows"
    ],
    "properties": {
     "date": {
      "type": "string",
      "default": "",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "maxLength": 10
     },
     "row_id": {
      "type": "string",
      "default": "",
      "maxLength": 80,
      "minLength": 1
     },
     "accepted_rows": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "dataset_group": {
      "type": "string",
      "default": "",
      "maxLength": 80
     },
     "received_rows": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "row_id": "row-1",
     "accepted_rows": 1,
     "dataset_group": "group-a",
     "received_rows": 10
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "accepted_rows": 2,
     "dataset_group": "group-b",
     "received_rows": 20
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "accepted_rows": 3,
     "dataset_group": "group-a",
     "received_rows": 15
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "accepted_rows": 4,
     "dataset_group": "group-b",
     "received_rows": 30
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "received_rows",
    "accepted_rows"
   ],
   "type": "string",
   "default": "received_rows"
  },
  "window": {
   "type": "integer",
   "default": 2,
   "maximum": 200,
   "minimum": 2
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/data-ingestion-batches-trailing-mean-series-date-by-category-pivot-eb67212d/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from market.datapackvibe.com](https://www.zero.xyz/host/market.datapackvibe.com/llms.txt)