# Join Coverage — Record Quality Audit + Daily Sum Series

> Join Coverage — Record Quality Audit + Daily Sum Series 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).

Runs two local analytical reports on join coverage data: a record quality audit and a daily sum series for matched_rows or source_rows, over up to 200 supplied rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-009?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-record-quality-audit-daily-sum-series-b64970f8
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap__KH0ZwsS35m7TSAHUiZgX

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-record-quality-audit-daily-sum-series-b64970f8 -d '<json body>'
```

Example prompt: Run a record quality audit and daily sum series on my join coverage data — I have rows with dataset groups 'sales' and 'returns', dates from 2024-01-01 to 2024-01-07, matched_rows and source_rows filled in, and I want to analyze the matched_rows field. Up to 50 rows total.

## When to prefer this

Choose this endpoint when you need both a data quality audit and a daily aggregation summary for join coverage records in a single $0.01 call, without requiring any external data lookups or live connections. It is best suited for batch validation of ETL join outputs, pipeline QA gates, or exploratory analysis of matched vs source row counts over time for up to 200 rows.

## Known failure modes

- Exceeding 200 rows returns a validation error
- Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause row-level rejection
- Invalid date format (not YYYY-MM-DD) triggers schema validation failure
- Numeric values outside ±1,000,000,000,000 are rejected
- Empty rows array returns an error
- Payment of 0.01 USDC required per call; missing payment results in 402 response

## How this service works

Join coverage — Record quality audit + Daily sum series: Record quality audit + Daily sum series 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: (1) a record quality audit flagging issues such as nulls, out-of-range values, or anomalies in the supplied join coverage rows; and (2) a daily sum series aggregating the selected field (matched_rows or source_rows) by date. Both reports are computed locally from the 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",
     "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-record-quality-audit-daily-sum-series-b64970f8/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)