{"uid":"cap_blevDkgJ70a0BVP9cUt2l","slug":"join-coverage-analytics-exact-row-deduplication-numeric-row-ordering-e5613210","name":"Join Coverage Analytics — Exact Row Deduplication + Numeric Row Ordering","description":"Join coverage — Exact row deduplication + Numeric row ordering: Exact row deduplication + Numeric row ordering 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-042?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"}}},"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_gpgn-gtpAY9dXOSwCgsDv","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":"Deduplicates exact rows and applies numeric ordering to join coverage records (matched_rows, source_rows) across up to 200 rows, producing 2 analytical reports.","exampleAgentPrompt":"Can you deduplicate and numerically order my join coverage records for the matched_rows field? I have rows like: row-1 on 2026-10-01 with matched_rows=10 and source_rows=1 in group-a, row-2 on 2026-10-02 with matched_rows=20 and source_rows=2 in group-b — run the two local analytical reports on those.","exampleUseCases":[{"title":"ETL pipeline data quality check","prompt":"I've got a set of join coverage rows from our ETL run — can you deduplicate them exactly and give me a numerically ordered report on the matched_rows field? Here are the rows: row-1 on 2024-03-01 matched_rows=50 source_rows=5 group-a, row-2 on 2024-03-02 matched_rows=100 source_rows=10 group-b, row-3 on 2024-03-03 matched_rows=50 source_rows=5 group-a."},{"title":"Dataset group join coverage audit","prompt":"Please run exact row deduplication and numeric ordering on these join coverage records across two dataset groups — I want both analytical reports on source_rows: row-a 2025-01-10 source_rows=200 matched_rows=180 group-x, row-b 2025-01-11 source_rows=200 matched_rows=180 group-x, row-c 2025-01-12 source_rows=150 matched_rows=140 group-y."},{"title":"Monthly coverage reconciliation report","prompt":"I need to reconcile my monthly join coverage data — can you deduplicate the rows and order them numerically by matched_rows? Rows are: rec-1 2025-06-01 matched_rows=300 source_rows=310 group-finance, rec-2 2025-06-02 matched_rows=420 source_rows=425 group-ops, rec-3 2025-06-01 matched_rows=300 source_rows=310 group-finance."}],"resultDescription":"Returns two analytical reports on the supplied join coverage rows: one applying exact row deduplication (identifying and collapsing identical rows) and one applying numeric row ordering on the selected field (matched_rows or source_rows), all computed locally without external lookups or predictions.","failureModes":["More than 200 rows submitted — request exceeds maxItems limit","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","Numeric values exceed allowed range (±1,000,000,000,000) — validation error","Empty rows array (minItems: 1 not met) — request rejected","Invalid field enum value (must be matched_rows or source_rows) — schema error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 join coverage records and need both exact row deduplication and numeric ordering in a single low-cost call ($0.01 USDC for 2 reports). It is ideal for data quality checks, ETL validation, and reconciliation tasks where you supply your own data and need fast, local analytical processing without any external lookups, ML predictions, or live data enrichment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-12T12:50:16.161Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-exact-row-deduplication-numeric-row-ordering-e5613210"}