{"uid":"cap_XZHgydyBymCrWlE8dg-rk","slug":"join-coverage-analytics-adjacent-row-changes-keyed-dataset-comparison-d7b09665","name":"Join Coverage Analytics — Adjacent Row Changes + Keyed Dataset Comparison","description":"Join coverage — Adjacent row changes + Keyed dataset comparison: Adjacent row changes + Keyed dataset comparison 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.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-161?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"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"},"other":{"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":21,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":17,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":33,"dataset_group":"group-b"}],"maxItems":200,"minItems":0}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_997-tbProHeBVgIdKW6O5","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Analyzes join coverage data with two independent reports: sequential adjacent-row change detection and keyed dataset comparison, across up to 200 rows of matched_rows/source_rows data.","exampleAgentPrompt":"I have two snapshots of join coverage data — a baseline and an updated one, each with row_id, dataset_group, date, matched_rows, and source_rows — can you run the adjacent row change analysis and keyed dataset comparison on matched_rows across both, up to 200 rows each?","exampleUseCases":[{"title":"ETL pipeline join drift detection","prompt":"I ran my ETL pipeline twice this week and want to know if the matched_rows counts changed significantly between consecutive rows — can you run the adjacent row change report on my join coverage data using the matched_rows field? Here are two datasets: last Monday's and this Monday's runs, grouped by dataset_group."},{"title":"Snapshot diff for data reconciliation","prompt":"I have a before and after snapshot of our join coverage table — around 150 rows each with row_id, date, dataset_group, matched_rows, and source_rows — can you do a keyed dataset comparison on source_rows to find which keys changed between the two?"},{"title":"Daily join quality audit","prompt":"Our data team needs to audit today's join coverage results — I have 80 rows tagged by dataset_group and date with matched_rows and source_rows values. Can you run both the adjacent row change detection and the keyed dataset comparison reports on matched_rows so I can spot any anomalies?"}],"resultDescription":"Returns two independent analytical reports: (1) an adjacent row change report showing sequential deltas in the chosen field (matched_rows or source_rows) across the primary dataset rows, and (2) a keyed dataset comparison report diffing the primary and secondary dataset by row_id and dataset_group keys, highlighting value differences in the selected field. No external lookups or predictions are made; all analysis is local and deterministic.","failureModes":["Fewer than 1 row supplied — minItems violation returns validation error","More than 200 rows supplied — maxItems violation rejected","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) causes schema validation failure","Invalid date format (not YYYY-MM-DD) triggers pattern validation error","Numeric values outside ±1,000,000,000,000 range rejected","field enum value not 'matched_rows' or 'source_rows' causes rejection","Payment not attached or insufficient (must be 0.01 USDC via x402) results in 402 response"],"whenToPreferThis":"Choose this endpoint when you need two complementary join coverage analyses in a single paid call: sequential adjacent-row change detection (useful for time-series or ordered pipeline runs) AND a keyed cross-dataset diff (useful for before/after comparisons). Prefer this over single-report variants when both analyses are needed simultaneously to reduce cost and latency. Best suited for data engineers auditing ETL join quality, reconciling dataset snapshots, or monitoring match rate drift over time. Not appropriate for live lookups, ML predictions, or data with more than 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:54:19.411Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-adjacent-row-changes-keyed-dataset-comparison-d7b09665"}