{"uid":"cap_fHwxTUZxHNKzvUetyEfCg","slug":"returns-handling-analytics-weighted-mean-date-by-category-pivot-696adea1","name":"Returns Handling Analytics — Weighted Mean & Date-by-Category Pivot","description":"Returns handling — Secondary-measure weighted mean + Date by category pivot: Secondary-measure weighted mean + Date by category pivot for supplied returns handling records (returned_units, processing_minutes). 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-retail-04-185?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","store_group","date","returned_units","processing_minutes"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"store_group":{"type":"string","default":"","maxLength":80},"returned_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"processing_minutes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","store_group":"group-a","returned_units":10,"processing_minutes":1},{"date":"2026-10-02","row_id":"row-2","store_group":"group-b","returned_units":20,"processing_minutes":2},{"date":"2026-10-03","row_id":"row-3","store_group":"group-a","returned_units":15,"processing_minutes":3},{"date":"2026-10-04","row_id":"row-4","store_group":"group-b","returned_units":30,"processing_minutes":4}],"maxItems":200,"minItems":1},"field":{"enum":["returned_units","processing_minutes"],"type":"string","default":"returned_units"}}},"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_JlKXKImCY-8FGxMrCFqfE","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 secondary-measure weighted mean and a date-by-category pivot table for returns handling data (returned_units, processing_minutes) in a single paid call delivering two reports.","exampleAgentPrompt":"Run a weighted mean and date-by-category pivot on my returns handling data — I have 4 rows: row-1, group-a, 2026-10-01, 10 returned units, 1 processing minute; row-2, group-b, 2026-10-02, 20 units, 2 minutes; row-3, group-a, 2026-10-03, 15 units, 3 minutes; row-4, group-b, 2026-10-04, 30 units, 4 minutes — use returned_units as the primary field.","exampleUseCases":[{"title":"Weekly returns performance review by store","prompt":"I have 50 rows of last week's returns data with store groups, dates, returned units, and processing minutes — can you give me a weighted mean and a date-by-category pivot so I can see which stores had the heaviest return load? Use returned_units as the field."},{"title":"Processing time bottleneck identification","prompt":"Pivot my returns handling records by date and store group and compute a weighted mean of processing_minutes — I want to spot which days and categories are slowing down our returns desk. Here are 120 rows of data."},{"title":"Monthly category-level returns summary","prompt":"Take these 200 rows of monthly returns handling records and produce a secondary-measure weighted mean plus a date-by-category pivot using returned_units, grouped by store_group — I need this for our monthly ops report."}],"resultDescription":"Two analytical reports derived from the supplied rows: (1) a secondary-measure weighted mean for the chosen field (returned_units or processing_minutes) across the dataset, and (2) a date-by-category pivot table cross-tabulating values by date and store_group. Results cover up to 200 input rows and are computed locally without external lookups.","failureModes":["Input array exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, store_group, date, returned_units, processing_minutes) cause validation errors","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","Null values in numeric fields may affect weighted mean computation","Invalid field enum value (not 'returned_units' or 'processing_minutes') causes rejection","Payment of 0.01 USDC not fulfilled via x402 protocol results in 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you need both a weighted mean summary and a date-by-category pivot on returns handling data (returned_units, processing_minutes) in a single low-cost call. It is ideal for retail operations teams doing batch offline analytics on up to 200 rows of returns records without needing live data, predictions, or external integrations. It offers two reports for $0.01 USDC, making it cost-effective for routine periodic analysis.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:55:39.214Z","isFirstParty":false,"canonicalSlug":"returns-handling-analytics-weighted-mean-date-by-category-pivot-696adea1"}