{"uid":"cap_kiBMMzk8ZjTy0uaNTkyjt","slug":"join-coverage-analytics-record-quality-audit-string-normalisation-9232ea1d","name":"Join Coverage Analytics: Record Quality Audit, String Normalisation & Weighted Mean","description":"Join coverage — Record quality audit + String normalisation + Secondary-measure weighted mean: Record quality audit + String normalisation + Secondary-measure weighted mean 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-205?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_WYHgR8SRpR0rdKj-_SxDm","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 on join coverage data (matched_rows, source_rows): a record quality audit, string normalisation, and a secondary-measure weighted mean — all offline, up to 200 rows.","exampleAgentPrompt":"Can you run the three join coverage reports — record quality audit, string normalisation, and weighted mean for matched_rows — on these rows: [{\"row_id\":\"r1\",\"dataset_group\":\"group-a\",\"date\":\"2025-01-10\",\"matched_rows\":50,\"source_rows\":200},{\"row_id\":\"r2\",\"dataset_group\":\"group-b\",\"date\":\"2025-01-11\",\"matched_rows\":30,\"source_rows\":150}]?","exampleUseCases":[{"title":"ETL pipeline join quality check","prompt":"I have 80 rows from my nightly ETL run with matched_rows and source_rows counts per dataset group — can you run a record quality audit, string normalisation, and weighted mean for matched_rows on all of them so I can spot any data issues?"},{"title":"Dataset group string cleanup audit","prompt":"My join coverage export has inconsistent dataset_group labels across 120 rows — can you run the string normalisation report alongside the quality audit and weighted mean for source_rows to help me clean things up?"},{"title":"Join coverage weighted mean for reporting","prompt":"For my weekly data pipeline report, can you compute the secondary-measure weighted mean for matched_rows across these 40 join coverage records and also run the quality audit and string normalisation at the same time?"}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging issues in the supplied join coverage records, (2) string normalisation results for text fields such as dataset_group, and (3) a weighted mean computed over the chosen secondary measure (matched_rows or source_rows). All results are derived locally from the submitted data 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 rejection","Invalid date format (not YYYY-MM-DD) fails pattern validation","Numeric values outside ±1,000,000,000,000 are rejected","Empty rows array is not accepted (minItems: 1)","Payment of 0.01 USDC must be provided; missing payment returns 402"],"whenToPreferThis":"Choose this endpoint when you need three simultaneous analytical reports — quality audit, string normalisation, and weighted mean — on join coverage data in a single cost-efficient call. Ideal for ETL monitoring, data pipeline QA, or batch auditing of matched vs source row metrics where no live lookups or external predictions are required. Best for datasets up to 200 rows processed in one shot.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:46.083Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-record-quality-audit-string-normalisation-9232ea1d"}