{"uid":"cap_fjhM07YCzqpAlWIPR1rJu","slug":"join-coverage-analytics-record-quality-audit-string-normalisation-30b98248","name":"Join Coverage Analytics: Record Quality Audit + String Normalisation + Daily Sum Series","description":"Join coverage — Record quality audit + String normalisation + Daily sum series: Record quality audit + String normalisation + Daily sum series 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-198?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_7ZJH8nrhCrRzY2fx4EkOV","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 daily sum series — up to 200 rows per call.","exampleAgentPrompt":"Can you run the three join coverage analytics reports — record quality audit, string normalisation, and daily sum series — on my dataset rows for groups 'group-a' and 'group-b' from October 2026, analysing the matched_rows field?","exampleUseCases":[{"title":"ETL pipeline join quality check","prompt":"I've got 150 rows of join coverage data from our nightly ETL run for October, with dataset groups 'sales' and 'returns' — can you audit the record quality, normalise any string fields, and give me daily sums for matched_rows?"},{"title":"Coverage gap investigation by group","prompt":"We're seeing unexpected drops in match rates for our 'customers' and 'orders' dataset groups last week. Can you run the record quality audit and daily sum series on these 80 rows using the source_rows field so I can spot the problem days?"},{"title":"Data pipeline monitoring dashboard prep","prompt":"I need to prep daily aggregation and quality metrics for our join coverage dashboard — here are 200 rows across 5 dataset groups from November 2026, please run all three reports on the matched_rows field."}],"resultDescription":"Three independent analytical reports returned for the submitted rows: (1) a record quality audit flagging issues in the supplied join coverage records, (2) a string normalisation report on text fields like row_id and dataset_group, and (3) a daily sum series aggregating the selected numeric field (matched_rows or source_rows) by date — all computed locally with no external lookups.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause validation errors","Date values not matching YYYY-MM-DD pattern will fail schema validation","Null numeric values for both matched_rows and source_rows may reduce audit accuracy","Invalid field enum value (anything other than 'matched_rows' or 'source_rows') causes rejection","Payment of 0.01 USDC not provided or declined blocks execution"],"whenToPreferThis":"Choose this endpoint when you need three bundled analytical reports (quality audit, string normalisation, daily aggregation) on join coverage data in a single cheap call. Ideal for data engineers monitoring ETL pipelines, analysts checking match rates over time, or anyone needing a quick multi-faceted diagnostic on up to 200 rows of joined dataset records without requiring external lookups or live data access.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:43.512Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-record-quality-audit-string-normalisation-30b98248"}