{"uid":"cap_FV7dD5k3mjWZT2pvqA6Vb","slug":"schema-conformity-analytics-record-quality-audit-string-normalisation-fea61bc6","name":"Schema Conformity Analytics: Record Quality Audit + String Normalisation + Trailing Mean Series","description":"Schema conformity — Record quality audit + String normalisation + Trailing mean series: Record quality audit + String normalisation + Trailing mean series for supplied schema conformity records (valid_records, checked_records). 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-02-199?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","valid_records","checked_records"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"valid_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"checked_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","valid_records":10,"checked_records":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","valid_records":20,"checked_records":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","valid_records":15,"checked_records":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","valid_records":30,"checked_records":4}],"maxItems":200,"minItems":1},"field":{"enum":["valid_records","checked_records"],"type":"string","default":"valid_records"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_Ow8LreK4eCbgjY7VIiyvO","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 analytics reports on schema conformity data — a record quality audit, string normalisation, and a trailing mean series — for up to 200 rows of valid/checked record counts.","exampleAgentPrompt":"Run a record quality audit, string normalisation, and trailing mean series (window of 3) on my schema conformity data for the valid_records field — here are 5 rows: row-1 on 2026-10-01 group-a with 100 valid and 110 checked, row-2 on 2026-10-02 group-b with 95 valid and 105 checked, row-3 on 2026-10-03 group-a with 88 valid and 100 checked, row-4 on 2026-10-04 group-b with 120 valid and 130 checked, row-5 on 2026-10-05 group-a with 110 valid and 115 checked.","exampleUseCases":[{"title":"Daily pipeline data quality review","prompt":"I have 10 days of schema conformity records for my ETL pipeline — run all three reports (quality audit, string normalisation, and trailing mean with window 2) on the checked_records field so I can see where data quality is slipping."},{"title":"Rolling average for compliance reporting","prompt":"Can you compute a trailing mean series with a window of 5 over my valid_records data across these 50 schema conformity rows? I need the rolling average trend for my monthly compliance report."},{"title":"Dataset group string normalisation audit","prompt":"Some of our dataset_group labels are inconsistently formatted — run the record quality audit and string normalisation reports on these 30 rows of schema conformity data so I can clean up the naming before we publish the dashboard."}],"resultDescription":"Three independent analytical reports: (1) a record quality audit summarising completeness and validity of the supplied rows, (2) a string normalisation report on text fields like dataset_group, and (3) a trailing mean series for the selected numeric field (valid_records or checked_records) computed over the specified window size. All reports are generated locally from the supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — minimum 1 row required","More than 200 rows supplied — exceeds maxItems limit","Missing required fields (row_id, date, valid_records, checked_records) on any row","Date field not matching YYYY-MM-DD pattern — validation error","Window parameter outside 2–200 range","Field enum value not one of 'valid_records' or 'checked_records'","Payment not provided or insufficient — x402 payment required at $0.01 USDC"],"whenToPreferThis":"Choose this endpoint when you need three combined analytics reports — record quality audit, string normalisation, and trailing mean series — on schema conformity data in a single low-cost call. Ideal for data engineers auditing ETL pipeline quality, analysts computing rolling averages over validation metrics, or teams needing lightweight local analytics without external API dependencies. Best suited for datasets up to 200 rows where all three report types are needed together at minimal cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-14T00:37:14.905Z","isFirstParty":false,"canonicalSlug":"schema-conformity-analytics-record-quality-audit-string-normalisation-fea61bc6"}