{"uid":"cap_wrI2yt0DPUua7HKFJe2xy","slug":"data-freshness-analytics-record-quality-audit-string-normalisation-0e983b77","name":"Data Freshness Analytics: Record Quality Audit + String Normalisation + Trailing Mean Series","description":"Data freshness — Record quality audit + String normalisation + Trailing mean series: Record quality audit + String normalisation + Trailing mean series for supplied data freshness records (age_minutes, record_count). 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-06-199?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","age_minutes","record_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"age_minutes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"record_count":{"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","age_minutes":10,"record_count":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","age_minutes":20,"record_count":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","age_minutes":15,"record_count":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","age_minutes":30,"record_count":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["age_minutes","record_count"],"type":"string","default":"age_minutes"},"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_yTSgEPSitbDRHm8tTpHWh","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 (record quality audit, string normalisation, and trailing mean series) on up to 200 data freshness rows containing age_minutes and record_count fields.","exampleAgentPrompt":"Can you run a record quality audit, string normalisation, and trailing mean series (window of 3) on my data freshness records for age_minutes? Here are my rows: row-1 on 2026-10-01 with age_minutes=10, record_count=5, group-a; row-2 on 2026-10-02 with age_minutes=20, record_count=8, group-b; row-3 on 2026-10-03 with age_minutes=15, record_count=3, group-a.","exampleUseCases":[{"title":"Pipeline freshness quality check","prompt":"I have 50 rows of data freshness logs with date, age_minutes, record_count, and dataset_group. Can you audit the record quality, normalize any string fields, and compute a trailing mean over age_minutes with a window of 5?"},{"title":"Rolling average for staleness monitoring","prompt":"Run a trailing mean series with a window of 4 on my record_count field for these data freshness records, and also include the record quality audit and string normalisation reports. I'll send you the rows now."},{"title":"Dataset group string cleanup and QA","prompt":"I've got about 80 data freshness rows across several dataset groups and I'm worried the group names might be inconsistent. Can you run string normalisation plus a record quality audit and a trailing mean on age_minutes with a window of 3?"}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit identifying data issues in the submitted rows, (2) a string normalisation report for categorical/string fields like dataset_group, and (3) a trailing mean series computed over the selected numeric field (age_minutes or record_count) using the specified window size — all derived purely from the submitted data with no external lookups.","failureModes":["More than 200 rows submitted — returns an error as the maximum batch size is exceeded","Missing required fields (row_id, date, age_minutes, record_count, dataset_group) on any row — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Window size outside 2–200 range — rejected by schema","Field value outside allowed numeric range — schema rejection","Empty rows array — minimum 1 item required"],"whenToPreferThis":"Choose this endpoint when you need three bundled analytical reports (quality audit, string normalisation, trailing mean) on data freshness records without any external data sources or live lookups. It is ideal for offline/batch analytical workflows on pipeline metadata, data staleness logs, or ETL freshness tracking where cost efficiency matters ($0.01 for all three reports on up to 200 rows). Prefer alternatives if you need predictions, external data enrichment, or more than 200 rows per call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:45.786Z","isFirstParty":false,"canonicalSlug":"data-freshness-analytics-record-quality-audit-string-normalisation-0e983b77"}