# Join Coverage Analytics — Grouped Numeric Summary & Date-by-Category Pivot

> Join Coverage Analytics — Grouped Numeric Summary & 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-19).

Generates two statistical reports on join coverage data: a grouped numeric summary and a date-by-category pivot for matched_rows and source_rows metrics.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-097?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-19
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/join-coverage-analytics-grouped-numeric-summary-date-by-category-pivot-8663f31d
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_Ptj8eLwjd897ydaCOo4fR

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 join-coverage-analytics-grouped-numeric-summary-date-by-category-pivot-8663f31d -d '<json body>'
```

Example prompt: Analyze my join coverage data for group-a and group-b across October 2026 — give me a grouped numeric summary and a date-by-category pivot for matched_rows, using these 4 records: row-1 (2026-10-01, group-a, 10 matched, 1 source), row-2 (2026-10-02, group-b, 20 matched, 2 source), row-3 (2026-10-03, group-a, 15 matched, 3 source), row-4 (2026-10-04, group-b, 30 matched, 4 source).

## When to prefer this

Use this endpoint when you need quick, local statistical analysis of join coverage records without any live data lookup or external enrichment. Ideal for data engineers who want to audit ETL pipeline join quality, summarize coverage metrics by group, or pivot coverage trends over time — all within a single low-cost call that returns two complementary reports simultaneously.

## Known failure modes

- Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause validation errors
- Date strings not matching YYYY-MM-DD pattern are rejected
- Arrays exceeding 200 items are rejected
- Invalid field enum value (anything other than matched_rows or source_rows) causes an error
- Payment of 0.01 USDC not received causes request to fail with 402

## How this service works

Join coverage — Grouped numeric summary + Date by category pivot: Grouped numeric summary + Date by category pivot for supplied join coverage records (matched_rows, source_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 independent analytical reports computed locally: (1) a grouped numeric summary of the specified metric (matched_rows or source_rows) broken down by dataset_group, including aggregated statistics; and (2) a date-by-category pivot table showing the metric's values across dates and groups. Covers up to 200 input rows per call.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/join-coverage-analytics-grouped-numeric-summary-date-by-category-pivot-8663f31d/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)