{"uid":"cap_M5TVleSHkp2pgOwRAEwBr","slug":"join-coverage-analytics-record-quality-audit-string-normalisation-e36d9792","name":"Join Coverage Analytics: Record Quality Audit + String Normalisation + Equal-Width Histogram","description":"Join coverage — Record quality audit + String normalisation + Equal-width histogram: Record quality audit + String normalisation + Equal-width histogram 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-202?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"bins":{"type":"integer","default":5,"maximum":30,"minimum":1},"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_REHgGDb2PGrUo4ShRBunA","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 supplied join coverage records (matched_rows, source_rows): a record quality audit, string normalisation, and an equal-width histogram.","exampleAgentPrompt":"Audit the quality of my join coverage dataset, normalise the string fields, and bin the matched_rows into 10 equal-width buckets — here are 4 rows: row-1 on 2026-10-01 in group-a with source_rows=100 and matched_rows=80, row-2 on 2026-10-02 in group-b with source_rows=200 and matched_rows=150, row-3 on 2026-10-03 in group-a with source_rows=50 and matched_rows=45, and row-4 on 2026-10-04 in group-b with source_rows=300 and matched_rows=210.","exampleUseCases":[{"title":"ETL pipeline join quality check","prompt":"I have 6 daily join coverage records from my ETL pipeline across two dataset groups — can you run a record quality audit and flag any nulls or anomalies in the matched_rows and source_rows? Groups are 'sales' and 'inventory', dates run from 2026-11-01 to 2026-11-06, matched rows range from 800 to 1200, source rows range from 1000 to 1500."},{"title":"Histogram of match rates by bin","prompt":"Take these 8 join coverage records and bin the source_rows field into 5 equal-width buckets so I can see the distribution — rows span groups 'alpha' and 'beta' from 2026-09-01 to 2026-09-08, with source_rows between 500 and 4000 and matched_rows between 400 and 3800."},{"title":"String normalisation on dataset group labels","prompt":"My join coverage data has inconsistent dataset_group labels and I want them normalised — can you run the string normalisation report on these 5 records? Rows are from 2026-12-01 to 2026-12-05, groups include ' Group A ', 'group-b', 'GROUP_C', and matched_rows and source_rows are all valid integers between 100 and 900."}],"resultDescription":"Returns three independent analytical reports for the supplied join coverage rows: (1) a record quality audit flagging nulls, out-of-range values, and data issues in matched_rows and source_rows; (2) a string normalisation report on text fields like dataset_group; and (3) an equal-width histogram binning the chosen numeric field (matched_rows or source_rows) into the specified number of bins (1–30, default 5). All analysis is performed locally with no external lookups.","failureModes":["Rows array empty or missing — validation error","More than 200 rows supplied — rejected with max-items error","bins value outside 1–30 range — validation error","date field does not match YYYY-MM-DD pattern — rejected","matched_rows or source_rows outside ±1,000,000,000,000 — rejected","row_id missing or empty string — validation error","Payment not completed — 402 response, no report generated"],"whenToPreferThis":"Choose this endpoint when you need a combined data quality audit, string normalisation, and histogram for join coverage data (matched_rows, source_rows) in a single low-cost call. It is ideal for data engineers profiling ETL join outputs, QA workflows checking match completeness, or analysts exploring the distribution of join rates across dataset groups. Best suited for small-to-medium batches (up to 200 rows) where all three report types are needed together without external enrichment or prediction.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:47.536Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-record-quality-audit-string-normalisation-e36d9792"}