# Join Coverage Analytics: Exact Row Deduplication + Secondary-Measure Weighted Mean

> Join Coverage Analytics: Exact Row Deduplication + Secondary-Measure Weighted Mean 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-11).

Deduplicates join coverage records by exact row and computes a secondary-measure weighted mean over matched_rows and source_rows fields, returning two analytical reports for up to 200 supplied rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-051?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-11
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/join-coverage-analytics-exact-row-deduplication-secondary-measure-da24e1fc
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_2s9gCwkoEAAKdP1tiExzf

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-exact-row-deduplication-secondary-measure-da24e1fc -d '<json body>'
```

Example prompt: I have 4 join coverage records for groups 'group-a' and 'group-b' dated 2026-10-01 through 2026-10-04 — can you deduplicate them exactly and give me the weighted mean for the matched_rows field? The rows are: row-1 (source=1, matched=10), row-2 (source=2, matched=20), row-3 (source=3, matched=15), row-4 (source=4, matched=30).

## When to prefer this

Choose this endpoint when you have up to 200 join coverage records (matched_rows, source_rows) and need both exact row deduplication and a weighted mean aggregation in a single paid call. It is ideal for data engineers auditing ETL pipeline join quality, reconciling matched vs. source row counts across dataset groups, or producing summary statistics without any external data lookups or model predictions. At $0.01 USDC per call yielding two reports, it is cost-effective for lightweight analytical needs on supplied data.

## Known failure modes

- More than 200 rows submitted — endpoint rejects input exceeding maxItems limit
- Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — validation error
- Date field not matching YYYY-MM-DD pattern — schema validation failure
- Null or out-of-range numeric values for matched_rows or source_rows — may produce null in weighted mean
- Invalid field enum value (not 'matched_rows' or 'source_rows') — rejected by schema
- Empty rows array (minItems: 1 not met) — validation error

## How this service works

Join coverage — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean 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 analytical reports: (1) the exactly deduplicated set of join coverage rows, and (2) the weighted mean of the specified secondary measure (matched_rows or source_rows) computed across the supplied records. Both reports are produced locally using shared analytical engines 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-analytics-exact-row-deduplication-secondary-measure-da24e1fc/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)