{"uid":"cap_Ih43lGs7bV_cGRplDLqS_","slug":"join-coverage-analytics-record-quality-audit-exact-row-deduplication-8a0f52bf","name":"Join Coverage Analytics: Record Quality Audit + Exact Row Deduplication + Grouped Numeric Summary","description":"Join coverage — Record quality audit + Exact row deduplication + Grouped numeric summary: Record quality audit + Exact row deduplication + Grouped numeric summary 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-211?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_OdlGXTjekqxhZlV_ouEt4","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 local analytical reports on join coverage data (matched_rows, source_rows): a record quality audit, exact row deduplication, and grouped numeric summary — all in a single call for up to 200 rows.","exampleAgentPrompt":"I have a list of up to 200 join coverage records with row_id, dataset_group, date, matched_rows, and source_rows — can you run a record quality audit, exact row deduplication, and a grouped numeric summary on them, focusing on the matched_rows field?","exampleUseCases":[{"title":"ETL pipeline join audit","prompt":"Here are 150 join coverage records from our data pipeline — each has a row_id, dataset_group, date, matched_rows, and source_rows. Can you run a record quality audit, deduplicate any exact duplicate rows, and give me a grouped numeric summary of matched_rows by dataset_group?"},{"title":"Duplicate detection in join output","prompt":"I exported 80 rows of join coverage data with columns row_id, dataset_group, date, matched_rows, and source_rows. Can you find all exact duplicate rows, flag any record quality issues, and summarize source_rows by group?"},{"title":"Data quality check before reporting","prompt":"Before I send our weekly join coverage report, can you audit these 60 records for quality issues, remove duplicates, and give me a grouped numeric breakdown of matched_rows across the dataset groups? Each row has row_id, dataset_group, date, matched_rows, and source_rows."}],"resultDescription":"Returns three independent reports in a single response: (1) a record quality audit flagging issues like missing or out-of-range values in the supplied rows, (2) an exact row deduplication report identifying and removing duplicate records, and (3) a grouped numeric summary (e.g. count, sum, mean) of the selected numeric field (matched_rows or source_rows) broken down by dataset_group. All analysis is performed locally on the supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — minimum of 1 row required","More than 200 rows submitted — exceeds maximum row limit","Invalid date format (not YYYY-MM-DD) causes row rejection","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) causes validation error","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) rejected","Invalid field enum value (must be 'matched_rows' or 'source_rows')"],"whenToPreferThis":"Choose this endpoint when you need all three analytical operations — record quality audit, exact deduplication, and grouped numeric summary — applied to join coverage data in a single low-cost call. It is ideal for ETL validation workflows where you want to check data completeness, remove duplicates, and summarize join metrics by group before downstream reporting. Prefer it over separate single-purpose tools when your dataset fits within 200 rows and you want bundled analytics at a fixed cost of $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T00:56:13.967Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-record-quality-audit-exact-row-deduplication-8a0f52bf"}