# Interview Transcripts — Trailing Mean Series + Date by Category Pivot

> Interview Transcripts — 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-24).

Computes a trailing mean time series and a date-by-category pivot table for supplied interview transcript records (transcript_words, audio_minutes).

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-news-12-152?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-24
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/interview-transcripts-trailing-mean-series-date-by-category-pivot-ef55de01
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_iwzJLDpZQTupol-WdfBhV

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 interview-transcripts-trailing-mean-series-date-by-category-pivot-ef55de01 -d '<json body>'
```

Example prompt: Can you run a trailing mean series and date-by-category pivot on my interview transcript data — I have 4 rows with fields row_id, channel_group, date, transcript_words, and audio_minutes — use a window size of 2 and analyze transcript_words?

## When to prefer this

Choose this endpoint when you have up to 200 interview transcript records with date, channel group, and numeric metrics (word count or audio minutes), and need both a rolling/trailing mean time series AND a date-by-category pivot in a single low-cost call ($0.01 USDC). Prefer this over general analytics tools when you want two bundled reports from your own supplied data without any external lookups or predictions.

## Known failure modes

- Fewer than 1 row supplied — minimum 1 row required
- More than 200 rows supplied — hard limit of 200 rows per call
- Window size larger than number of rows — trailing mean may produce sparse or empty results
- Invalid date format (must be YYYY-MM-DD) — validation error on date field
- Null or missing numeric values for transcript_words or audio_minutes — may produce incomplete series
- Invalid field enum value — only 'transcript_words' or 'audio_minutes' accepted

## How this service works

Interview transcripts — Trailing mean series + Date by category pivot: Trailing mean series + Date by category pivot for supplied interview transcripts records (transcript_words, audio_minutes). 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 mean time series smoothing the selected metric (transcript_words or audio_minutes) over the specified window, and (2) a date-by-category pivot table cross-tabulating values by date and channel_group — both computed locally from the supplied rows with no external data access.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/interview-transcripts-trailing-mean-series-date-by-category-pivot-ef55de01/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)