{"uid":"cap_LZj6jscdFBoB5rv6bcmG2","slug":"data-ingestion-batches-daily-sum-series-trailing-mean-series-e4ebc9b1","name":"Data Ingestion Batches — Daily Sum Series + Trailing Mean Series","description":"Data ingestion batches — Daily sum series + Trailing mean series: Daily sum series + Trailing mean series for supplied data ingestion batches records (received_rows, accepted_rows). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-01-136?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","received_rows","accepted_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"accepted_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"received_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","accepted_rows":1,"dataset_group":"group-a","received_rows":10},{"date":"2026-10-02","row_id":"row-2","accepted_rows":2,"dataset_group":"group-b","received_rows":20},{"date":"2026-10-03","row_id":"row-3","accepted_rows":3,"dataset_group":"group-a","received_rows":15},{"date":"2026-10-04","row_id":"row-4","accepted_rows":4,"dataset_group":"group-b","received_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["received_rows","accepted_rows"],"type":"string","default":"received_rows"},"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__nrClmhVieSilhySKPh7N","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":"Computes daily sum and trailing mean analytics for received_rows and accepted_rows across up to 200 data ingestion batch records.","exampleAgentPrompt":"Calculate the daily sum series and trailing mean series for my ingestion batch data — I have records with received_rows and accepted_rows across multiple dataset groups, I want to analyze the accepted_rows field with a window of 7, here are my rows: [{\"row_id\":\"r1\",\"dataset_group\":\"group-a\",\"date\":\"2025-01-01\",\"received_rows\":100,\"accepted_rows\":90}, ...]","exampleUseCases":[{"title":"Pipeline acceptance rate trend monitoring","prompt":"I have 60 days of data ingestion batch records with received_rows and accepted_rows for two dataset groups. Can you compute the daily sum and a 7-day trailing mean for accepted_rows so I can spot dips in acceptance rate over time?"},{"title":"Data quality audit across groups","prompt":"Run a daily sum and trailing mean analysis on these 120 ingestion batch rows — I want to look at received_rows with a window of 14 to understand if any dataset group is consistently receiving fewer rows than expected."},{"title":"ETL pipeline health dashboard","prompt":"I need to summarize my ETL pipeline's daily ingestion counts. Here are 200 batch records with dates, dataset_group, received_rows, and accepted_rows — give me both the daily sum series and a trailing mean with window 5 for the received_rows field."}],"resultDescription":"Returns two independent analytical reports: (1) a daily sum series aggregating the chosen metric (received_rows or accepted_rows) by date, and (2) a trailing mean series computed over the specified window size — both derived from the supplied ingestion batch records, up to 200 rows.","failureModes":["More than 200 rows submitted — exceeds maxItems limit","Missing required fields (row_id, dataset_group, date, received_rows, accepted_rows) cause validation failure","Invalid date format not matching YYYY-MM-DD pattern","Window value outside allowed range (must be 2–200)","Numeric values outside allowed range (±1,000,000,000,000)","Empty rows array (minItems: 1 not met)"],"whenToPreferThis":"Choose this endpoint when you have pre-collected data ingestion batch records and need both a daily aggregation (sum) and a smoothed trend (trailing mean) in a single paid call. Ideal for pipeline monitoring, ETL health checks, or data quality reporting where you already hold the raw row data locally and want two statistical views at once without external data fetching.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-21T00:52:24.061Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-daily-sum-series-trailing-mean-series-e4ebc9b1"}