{"uid":"cap_GeVqFIap-fQccKBgwErOj","slug":"record-routing-analytics-quality-audit-deduplication-trailing-mean-7b3e86df","name":"Record Routing Analytics: Quality Audit + Deduplication + Trailing Mean","description":"Record routing — Record quality audit + Exact row deduplication + Trailing mean series: Record quality audit + Exact row deduplication + Trailing mean series for supplied record routing records (accepted_records, rejected_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-19-216?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","accepted_records","rejected_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},"accepted_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"rejected_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","accepted_records":10,"rejected_records":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","accepted_records":20,"rejected_records":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","accepted_records":15,"rejected_records":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","accepted_records":30,"rejected_records":4}],"maxItems":200,"minItems":1},"field":{"enum":["accepted_records","rejected_records"],"type":"string","default":"accepted_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_G6yxCVIbij1uzRzZWID3R","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 record routing data — a quality audit, exact row deduplication, and a trailing mean series — for up to 200 rows of accepted/rejected record counts.","exampleAgentPrompt":"Can you run the three analytics reports — quality audit, exact row deduplication, and trailing mean with a window of 3 — on my record routing data for accepted_records across these rows: 2024-01-01 group-a 100 accepted 5 rejected, 2024-01-02 group-b 200 accepted 10 rejected, 2024-01-01 group-a 100 accepted 5 rejected?","exampleUseCases":[{"title":"Daily pipeline data quality check","prompt":"I have a week's worth of record routing data with accepted and rejected counts per dataset group — can you run the quality audit, deduplication, and a trailing mean series with window 7 on the accepted_records field to see if anything looks off?"},{"title":"Duplicate row detection in routing logs","prompt":"My record routing logs might have duplicate entries — please run the exact row deduplication report on these 50 rows of accepted and rejected record counts so I can clean up the dataset before loading it."},{"title":"Rolling rejection rate trend analysis","prompt":"Can you compute a trailing mean series with a window of 5 for rejected_records across my record routing data from last month, grouped by dataset_group, so I can see if rejection rates are trending up?"}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging anomalies or issues in the supplied rows, (2) an exact row deduplication report identifying and listing duplicate rows, and (3) a trailing mean series showing rolling averages for the selected field (accepted_records or rejected_records) over the specified window. All analysis is performed locally on the submitted data with no external lookups.","failureModes":["Submitting more than 200 rows returns a validation error","Missing required fields (row_id, date, accepted_records, rejected_records) causes rejection","Invalid date format (not YYYY-MM-DD) fails schema validation","Window size less than 2 or greater than 200 is rejected","Empty rows array fails minItems constraint","Payment of 0.01 USDC not included results in 402 response"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, low-cost ($0.01) batch analysis of record routing data that combines three complementary reports in a single call — quality auditing, deduplication, and rolling mean computation — without requiring any external data sources or live lookups. Best suited for ETL pipeline monitoring, data quality checks on ingestion logs, or exploratory analysis of routing record batches up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T12:51:49.380Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-quality-audit-deduplication-trailing-mean-7b3e86df"}