{"uid":"cap_-CIuR-ZpdyJdX_y8nZZEd","slug":"time-series-completeness-analytics-quality-audit-string-normalisation-58f0071d","name":"Time Series Completeness Analytics — Quality Audit + String Normalisation + Daily Sum Series","description":"Time series completeness — Record quality audit + String normalisation + Daily sum series: Record quality audit + String normalisation + Daily sum series for supplied time series completeness records (observed_points, expected_points). 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-16-198?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","observed_points","expected_points"],"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},"expected_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"observed_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","expected_points":1,"observed_points":10},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","expected_points":2,"observed_points":20},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","expected_points":3,"observed_points":15},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","expected_points":4,"observed_points":30}],"maxItems":200,"minItems":1},"field":{"enum":["observed_points","expected_points"],"type":"string","default":"observed_points"}}},"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_M2hcslyinnnOmuqn1TkIo","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 daily sum series) on time series completeness data (observed vs expected points) for up to 200 rows.","exampleAgentPrompt":"Audit these time series completeness records for me — I have up to 50 rows with columns row_id, dataset_group, date, observed_points, and expected_points — and give me all three reports: the record quality audit, the string normalisation, and the daily sum series, focusing on the observed_points field.","exampleUseCases":[{"title":"Data pipeline completeness gap detection","prompt":"I've got daily completeness records for my ETL pipeline — each row has a date, a dataset_group, and the observed vs expected data points for that day. Can you run a quality audit on them and also give me the daily sum series so I can see where the biggest gaps are? Here are the 80 rows."},{"title":"Multi-group string normalisation audit","prompt":"My dataset groups have inconsistent naming conventions across these 120 time series completeness records. Can you run the string normalisation report on them alongside the full quality audit so I can clean up the group labels? I'll pass you the rows with row_id, dataset_group, date, observed_points, and expected_points."},{"title":"Weekly completeness summary for monitoring dashboard","prompt":"I need a daily sum series for the expected_points field across all my dataset groups for the past 30 days — here are 30 rows of completeness records. Also run the record quality audit so I know if any rows have issues before I push this to our dashboard."}],"resultDescription":"Returns three independent analytical reports generated from the supplied rows: (1) a record quality audit flagging issues in the completeness data, (2) a string normalisation report cleaning and standardising dataset_group and other string fields, and (3) a daily sum series aggregating observed_points or expected_points totals by date. All analysis is performed locally with no external lookups or predictions.","failureModes":["Exceeding 200 rows returns a validation error","Rows missing required fields (row_id, date, observed_points, expected_points) cause schema rejection","Invalid date format (non-YYYY-MM-DD) triggers pattern validation failure","Numeric values outside ±1,000,000,000,000 bounds cause schema rejection","Empty rows array (minItems:1 violated) returns an error","Malformed JSON body results in a 400-level error"],"whenToPreferThis":"Choose this endpoint when you need batch analytical reporting on time series completeness records (observed vs expected point counts) and want three coordinated reports — quality audit, string normalisation, and daily sum series — in a single low-cost call. It is ideal for data pipeline monitoring, ETL completeness checks, and dashboard preparation workflows where up to 200 rows need offline analytical processing without any live external lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:37:26.342Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-analytics-quality-audit-string-normalisation-58f0071d"}