{"uid":"cap_CHkGAdvjOOpqnr_Zn9FF3","slug":"join-coverage-analytics-record-quality-audit-exact-row-deduplication-04fb45b5","name":"Join Coverage Analytics: Record Quality Audit, Exact Row Deduplication, and Numeric Interval Filter","description":"Join coverage — Record quality audit + Exact row deduplication + Numeric interval filter: Record quality audit + Exact row deduplication + Numeric interval filter for supplied join coverage records (matched_rows, source_rows). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-214?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"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_6BsxngtGD9KTk9EfEu9vd","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":"Performs three local analytical reports on join coverage data — record quality audit, exact row deduplication, and numeric interval filtering — on up to 200 rows of matched_rows/source_rows data.","exampleAgentPrompt":"Can you run a record quality audit, exact row deduplication, and numeric interval filter on my join coverage data? I have rows with matched_rows and source_rows fields — filter on matched_rows between 0 and 100, and here are my rows: row-1 (group-a, 2026-10-01, source_rows=1, matched_rows=10), row-2 (group-b, 2026-10-02, source_rows=2, matched_rows=20), row-3 (group-a, 2026-10-03, source_rows=3, matched_rows=15).","exampleUseCases":[{"title":"Deduplicating join coverage before pipeline load","prompt":"I've got 150 rows of join coverage records with matched_rows and source_rows values — can you run an exact row deduplication plus a record quality audit on them before I load them into the pipeline? Filter matched_rows between 0 and 500."},{"title":"Validating match rates across dataset groups","prompt":"Can you audit the quality of my join coverage records across group-a and group-b, filter source_rows between 1 and 1000, and flag any duplicate rows? I have about 80 rows dated from 2026-10-01 through 2026-10-31."},{"title":"Range-filtering low match coverage rows","prompt":"I want to isolate join coverage rows where matched_rows falls between 5 and 50 — can you run the interval filter, deduplicate the result, and give me a quality audit? My dataset has rows across three groups with dates in Q4 2026."}],"resultDescription":"Returns three independent analytical reports for the supplied join coverage rows: (1) a record quality audit flagging missing, malformed, or suspect values; (2) an exact row deduplication report identifying and removing duplicate records; and (3) a numeric interval filter report returning only rows where the selected field (matched_rows or source_rows) falls within the specified minimum/maximum range. All processing is local with no external lookups.","failureModes":["Submitting more than 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) causes rejection","Invalid date format (not YYYY-MM-DD) fails pattern validation","Numeric values outside ±1,000,000,000,000 are rejected","Minimum greater than maximum may produce an empty interval filter result","Empty rows array (minItems: 1 not met) causes an error"],"whenToPreferThis":"Choose this endpoint when you have join coverage data (matched_rows and source_rows per row) and need all three of: a record quality audit, exact deduplication, and numeric range filtering in a single low-cost call. It is ideal for data engineering pipelines that need lightweight, local analytical checks without any external data lookups, predictions, or live APIs. Best for datasets up to 200 rows where cost efficiency ($0.01 for three reports) matters.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:19:34.215Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-record-quality-audit-exact-row-deduplication-04fb45b5"}