{"uid":"cap_opl4nD_krm0oPu_l2vn4d","slug":"data-ingestion-batches-trailing-mean-series-date-by-category-pivot-eb67212d","name":"Data Ingestion Batches — Trailing Mean Series + Date by Category Pivot","description":"Data ingestion batches — Trailing mean series + Date by category pivot: Trailing mean series + Date by category pivot 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-152?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_JG2ERBbwO1x1D8WIjiHwU","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 a trailing moving average series and a date-by-category pivot table for data ingestion batch records (received_rows, accepted_rows) supplied by the caller.","exampleAgentPrompt":"Can you run a trailing mean series and date-by-category pivot on my ingestion batch data — I have received_rows and accepted_rows for four dataset groups across a few dates, and I want a window size of 3 on the accepted_rows field?","exampleUseCases":[{"title":"ETL pipeline acceptance rate trend","prompt":"I have daily ingestion batch records for two dataset groups over the past two weeks with received_rows and accepted_rows. Can you compute a trailing moving average with a window of 5 on accepted_rows, and also pivot the counts by date and group so I can see trends at a glance?"},{"title":"Data quality monitoring dashboard","prompt":"Here are my ingestion batch logs — each row has a date, a dataset_group, and received_rows plus accepted_rows counts. Run both a trailing mean series (window of 3) on received_rows and a date-by-category pivot so I can build a monitoring dashboard for our data quality team."},{"title":"Comparing ingestion volumes across groups","prompt":"I've got up to 150 ingestion batch records across several dataset groups and want to understand volume patterns. Please compute a trailing mean series with window 4 on received_rows and give me a pivot table of received_rows by date and dataset_group."}],"resultDescription":"Returns two analytical reports: (1) a trailing moving average series for the selected numeric field (received_rows or accepted_rows) computed over the specified window size across the supplied rows, and (2) a pivot table cross-tabulating dates against dataset_group categories with aggregated row counts — both derived purely from the caller-supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — request rejected","More than 200 rows supplied — exceeds maximum and request is rejected","Invalid date format (not YYYY-MM-DD) — schema validation failure","Window size less than 2 or greater than 200 — validation error","Required fields (row_id, dataset_group, date, received_rows, accepted_rows) missing from row objects — schema error","Numeric values outside allowed range (±1,000,000,000,000) — validation failure","Payment of 0.01 USDC not included or rejected — 402 response"],"whenToPreferThis":"Choose this endpoint when you have raw data ingestion batch records (with received_rows/accepted_rows metrics) already in hand and need both a rolling average time-series and a category-date pivot computed locally without any external data fetching, prediction, or professional assessment. Ideal for ETL monitoring, data quality dashboards, or pipeline analytics where you want two complementary statistical views in a single low-cost call. Not appropriate if you need real-time data fetching, forecasting, or analysis of non-ingestion-batch data types.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-21T00:52:28.719Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-trailing-mean-series-date-by-category-pivot-eb67212d"}