{"uid":"cap_E3wvlFWGmU9SYpGnp6tMa","slug":"join-coverage-analytics-record-quality-audit-string-normalisation-0a538bca","name":"Join Coverage Analytics — Record Quality Audit, String Normalisation & Keyed Dataset Comparison","description":"Join coverage — Record quality audit + String normalisation + Keyed dataset comparison: Record quality audit + String normalisation + Keyed dataset comparison 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-207?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},"other":{"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":21,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":17,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":33,"dataset_group":"group-b"}],"maxItems":200,"minItems":0}}},"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_pI2k_uoylfHCZE5Kj1-6z","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, string normalisation, and keyed dataset comparison for up to 200 rows.","exampleAgentPrompt":"Can you audit the quality of my join coverage records and compare two datasets — the primary has rows for group-a and group-b from 2026-10-01 to 2026-10-04 with matched_rows of 10, 20, 15, 30 and source_rows of 1, 2, 3, 4, and the comparison dataset has the same rows but with matched_rows of 10, 21, 17, 33? I want all three reports: record quality audit, string normalisation, and keyed dataset comparison.","exampleUseCases":[{"title":"ETL pipeline join coverage validation","prompt":"I've got two snapshots of my ETL join results — the original run has matched_rows of 500, 620, 410 and source_rows of 550, 650, 450 for groups alpha, beta, gamma on 2025-01-10 to 2025-01-12, and the reprocessed run has matched_rows of 510, 618, 412 for the same groups and dates. Can you run the full quality audit, string normalisation, and keyed comparison on both datasets to flag any discrepancies?"},{"title":"Data warehouse match rate anomaly check","prompt":"Run a record quality audit on my warehouse join coverage data — I have 8 rows across two dataset groups called 'orders_v2' and 'returns_v2' dated from 2024-06-01 to 2024-06-08, with matched_rows ranging from 1000 to 8500 and source_rows from 1100 to 9000. I want to see if there are any quality issues or string normalisation problems in the group labels."},{"title":"Before-and-after join coverage comparison","prompt":"Compare my before and after join coverage datasets from last quarter — the 'before' set has 4 rows for dataset_group 'sales' with matched_rows 300, 450, 200, 380 and source_rows 320, 470, 210, 400, and the 'after' set has the same structure but matched_rows are 310, 448, 205, 390. Give me all three analytical reports including the keyed dataset comparison."}],"resultDescription":"Three independent analytical reports generated from the supplied join coverage data: (1) a record quality audit flagging missing values, nulls, and out-of-range figures in matched_rows and source_rows; (2) a string normalisation report on dataset_group and row_id fields; (3) a keyed dataset comparison between the primary and secondary row arrays, highlighting value differences by row_id and dataset_group. All computed locally with no external lookups.","failureModes":["More than 200 rows submitted — endpoint rejects with validation error","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — schema validation failure","Invalid date format (not YYYY-MM-DD) — pattern validation error","matched_rows or source_rows outside allowed numeric range — validation rejection","Empty rows array — minItems constraint violation","Malformed JSON body — parse error"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, low-cost ($0.01 USDC) batch analytical pass on join coverage data without relying on external lookups or live data connections. It is ideal when you have two versions of the same keyed dataset and want simultaneous quality auditing, string normalisation, and value-level comparison in one call. Prefer it over bespoke scripts when you need repeatable, structured reports for up to 200 rows of join coverage metrics across dataset groups and dates.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:19:41.348Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-record-quality-audit-string-normalisation-0a538bca"}