{"uid":"cap_hAeLbn7H0OLWtajgUs8W0","slug":"join-coverage-analytics-record-quality-audit-exact-row-deduplication-41759305","name":"Join Coverage Analytics — Record Quality Audit, Exact Row Deduplication & Numeric Distribution","description":"Join coverage — Record quality audit + Exact row deduplication + Numeric distribution: Record quality audit + Exact row deduplication + Numeric distribution 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-210?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_kJA3nix271k-5dvIvIHRp","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":"Runs three analytical reports (record quality audit, exact row deduplication, and numeric distribution) on up to 200 join coverage records containing matched_rows and source_rows fields.","exampleAgentPrompt":"Can you run a record quality audit, exact deduplication check, and numeric distribution on these join coverage records — here are up to 50 rows with matched_rows and source_rows values grouped by dataset_group — and analyze the matched_rows field specifically?","exampleUseCases":[{"title":"ETL pipeline join quality check","prompt":"I have 120 rows from my ETL pipeline with matched_rows and source_rows per dataset group and date — can you run all three reports (quality audit, deduplication, and numeric distribution) on them and focus the distribution on matched_rows?"},{"title":"Detecting duplicate join coverage records","prompt":"I suspect some of my join coverage records are duplicates — can you run exact row deduplication on these 80 records with row_id, dataset_group, date, matched_rows, and source_rows and tell me which rows repeat?"},{"title":"Profiling source row counts across groups","prompt":"I want to understand the spread of source_rows values across my dataset groups — please run a record quality audit and numeric distribution on these 60 join coverage records, analyzing the source_rows field."}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit identifying missing, null, or malformed values across the supplied rows; (2) an exact row deduplication report listing duplicate records; and (3) a numeric distribution summary (e.g. min, max, mean, percentiles) for the selected numeric field (matched_rows or source_rows). All analysis is performed locally on the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema rejection","Numeric values outside allowed range (-1T to +1T) may be rejected","Empty rows array returns error"],"whenToPreferThis":"Choose this endpoint when you need three combined analytical reports — quality audit, deduplication, and numeric distribution — on join coverage data (matched_rows and source_rows) in a single low-cost call. Ideal for data engineers validating ETL join outputs, QA pipelines profiling dataset coverage metrics, or analysts checking for duplicate records before downstream processing. Best when your dataset fits within 200 rows and you want all three reports at once for $0.01 USDC rather than calling separate endpoints.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:39.602Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-record-quality-audit-exact-row-deduplication-41759305"}