{"uid":"cap_cp_ExLUMx5i_vgJlvDnc9","slug":"data-ingestion-batches-grouped-numeric-summary-date-by-category-pivot-f5bf7171","name":"Data Ingestion Batches — Grouped Numeric Summary + Date by Category Pivot","description":"Data ingestion batches — Grouped numeric summary + Date by category pivot: Grouped numeric summary + 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-097?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"}}},"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_uW19bi4JnNzZsW9Wwf4no","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":"Generates two local analytical reports for data ingestion batch records: a grouped numeric summary and a date-by-category pivot for received_rows or accepted_rows.","exampleAgentPrompt":"Can you run a grouped numeric summary and a date-by-category pivot on these data ingestion batch records — I have 8 rows with dataset groups 'pipeline-a' and 'pipeline-b', and I want to analyze the received_rows field?","exampleUseCases":[{"title":"ETL pipeline health review","prompt":"I have 50 daily ingestion batch records across 4 dataset groups with dates and both received_rows and accepted_rows filled in — can you give me a grouped numeric summary and a date-by-category pivot so I can see where rows are being dropped?"},{"title":"Weekly ingestion reporting for data team","prompt":"Run a grouped numeric summary and date pivot on my ingestion batch data for last week — about 30 rows across groups 'crm-feed', 'erp-feed', and 'web-events', analyzing the accepted_rows field."},{"title":"Audit ingestion discrepancies by group","prompt":"I need to audit my ingestion batches — here are 20 rows with dataset groups 'source-alpha' and 'source-beta', can you produce a grouped summary and a date-by-category pivot for received_rows so I can spot the outliers?"}],"resultDescription":"Returns two independent analytical reports computed locally: (1) a grouped numeric summary of the chosen metric (received_rows or accepted_rows) across dataset groups, and (2) a date-by-category pivot table showing values broken down by date and dataset_group. Up to 200 rows processed per call.","failureModes":["Fewer than 1 row supplied — validation error","More than 200 rows submitted — rejected with max items error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (±1 trillion) — validation error","Missing required fields (row_id, dataset_group, date, received_rows, accepted_rows) — schema error","Invalid field enum value (not 'received_rows' or 'accepted_rows') — rejected"],"whenToPreferThis":"Choose this endpoint when you need fast, local analytics on data ingestion batch records without any external data lookup or live pipeline access. It is ideal for generating two complementary views — a grouped numeric summary plus a date-by-category pivot — on up to 200 rows of ingestion data in a single low-cost call. Prefer it over general-purpose analytics tools when your data is already structured with dataset_group and date dimensions and you want deterministic, reproducible batch reports.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:23.701Z","isFirstParty":false,"canonicalSlug":"data-ingestion-batches-grouped-numeric-summary-date-by-category-pivot-f5bf7171"}