{"uid":"cap_-2E9COvdnwN4UMFLbFCjI","slug":"promotion-observations-iqr-outlier-flags-and-date-by-category-pivot-b1692c81","name":"Promotion Observations IQR Outlier Flags and Date-by-Category Pivot","description":"Promotion observations — IQR outlier flags + Date by category pivot: IQR outlier flags + Date by category pivot for supplied promotion observations records (discount_amount, units_sold). 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-05-178?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","store_group","date","discount_amount","units_sold"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"units_sold":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"store_group":{"type":"string","default":"","maxLength":80},"discount_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","units_sold":1,"store_group":"group-a","discount_amount":10},{"date":"2026-10-02","row_id":"row-2","units_sold":2,"store_group":"group-b","discount_amount":20},{"date":"2026-10-03","row_id":"row-3","units_sold":3,"store_group":"group-a","discount_amount":15},{"date":"2026-10-04","row_id":"row-4","units_sold":4,"store_group":"group-b","discount_amount":30}],"maxItems":200,"minItems":1},"field":{"enum":["discount_amount","units_sold"],"type":"string","default":"discount_amount"}}},"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_5SFkO8qiOqZtB8ZINmK7d","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 two analytical reports on supplied promotion data: IQR-based outlier detection and a date-by-category pivot table for discount_amount or units_sold across up to 200 rows.","exampleAgentPrompt":"Can you flag any IQR outliers and generate a date-by-store-group pivot for these 50 promotion records, using units_sold as the analysis field? I have row IDs, store groups, dates, discount amounts, and units sold for each row.","exampleUseCases":[{"title":"Outlier detection in discount campaigns","prompt":"I have 120 rows of promotion data with row IDs, store groups, dates, discount amounts, and units sold — can you flag any discount_amount values that are IQR outliers and also give me a pivot of discount amounts by date and store group?"},{"title":"Units sold anomaly check by store","prompt":"Run an IQR outlier check on units_sold across my 80 promotion observations and also pivot the units sold by date and store group so I can see patterns — here are the rows with row_id, store_group, date, discount_amount, and units_sold."},{"title":"Retail promo performance summary","prompt":"I've got quarterly promotion records for two store groups — about 150 rows — and I want to know which rows have statistically extreme discount amounts via IQR flagging, plus a date-by-category breakdown of discount_amount as a pivot table."}],"resultDescription":"Two independent analytical reports: (1) IQR outlier flags identifying which rows have statistically extreme values for the selected field (discount_amount or units_sold), including IQR boundaries and flag status per row; (2) a date-by-store-group pivot table summarizing the selected field's values across all supplied promotion records. Both reports are computed locally on the supplied data with no external lookups.","failureModes":["Input array exceeds 200 rows — request will be rejected","Missing required fields (row_id, store_group, date, discount_amount, units_sold) on any row causes validation error","Invalid date format (not YYYY-MM-DD) causes schema rejection","Insufficient data variance for meaningful IQR computation (e.g. all identical values)","Invalid field enum value (must be 'discount_amount' or 'units_sold')"],"whenToPreferThis":"Choose this endpoint when you have up to 200 promotion observation records and need both outlier detection and a pivot summary in a single $0.01 call, without requiring any external data sources, live lookups, or predictions. It is ideal for retail analytics workflows where you already have the raw promotion data and want rapid statistical flagging and category-date summarization bundled together.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T12:45:28.669Z","isFirstParty":false,"canonicalSlug":"promotion-observations-iqr-outlier-flags-and-date-by-category-pivot-b1692c81"}