{"uid":"cap_Q7EK_om4QdL8ZHGjz_4vC","slug":"join-coverage-analytics-record-quality-audit-grouped-numeric-summary-5a27d89c","name":"Join Coverage Analytics — Record Quality Audit & Grouped Numeric Summary","description":"Join coverage — Record quality audit + Grouped numeric summary: Record quality audit + Grouped numeric summary 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-005?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_mmbyIMkIec6HD5ovirNFH","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 two local analytical reports on join coverage data: a record quality audit and a grouped numeric summary of matched_rows or source_rows, for up to 200 rows.","exampleAgentPrompt":"Can you run a record quality audit and a grouped numeric summary on my join coverage data — here are 4 rows with row_id, dataset_group, date, matched_rows, and source_rows — and summarize the matched_rows field by group?","exampleUseCases":[{"title":"ETL join quality check","prompt":"I just ran an ETL pipeline and have 50 join coverage records with matched_rows and source_rows. Can you audit their record quality and give me a grouped numeric summary of matched_rows broken down by dataset_group?"},{"title":"Data team daily join report","prompt":"Here are today's join coverage rows across groups A and B — can you run both the record quality audit and the grouped summary on source_rows so I can see where data is dropping off?"},{"title":"Spot-check join completeness before reporting","prompt":"Before I publish this week's report, can you audit these 30 join coverage records for quality issues and also give me a grouped summary of matched_rows by dataset group and date?"}],"resultDescription":"Returns two independent analytical reports: (1) a record quality audit flagging missing, null, or out-of-range values per row, and (2) a grouped numeric summary (e.g. count, min, max, mean) of the selected field (matched_rows or source_rows) aggregated by dataset_group. All computation is performed locally with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) causes row-level rejection","Invalid date format (not YYYY-MM-DD) fails pattern validation","Numeric values outside ±1,000,000,000,000 are rejected","Empty rows array returns an error","Invalid field enum value (not matched_rows or source_rows) causes request failure"],"whenToPreferThis":"Choose this endpoint when you have up to 200 join coverage records with matched_rows and source_rows and need both a data quality audit and a grouped numeric summary in a single paid call. It is ideal for data engineers and analysts who want fast, local analytical results without any external API calls, predictions, or professional assessments. Prefer this over general analytics APIs when your data fits the join coverage schema (row_id, dataset_group, date, matched_rows, source_rows) and you need two reports for a flat $0.01 fee.","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-grouped-numeric-summary-5a27d89c"}