{"uid":"cap_7kGd9gu_m3H4F4QvxT3Nf","slug":"promotion-observations-base-100-series-explicit-missing-value-fill-7143bd74","name":"Promotion Observations — Base-100 Series + Explicit Missing-Value Fill","description":"Promotion observations — Base-100 series + Explicit missing-value fill: Base-100 series + Explicit missing-value fill 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-169?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"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":0}}},"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_V4nQEGNlkYXxzScBuiHcF","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":"Converts promotion observation data (discount_amount, units_sold) into a Base-100 indexed time series and fills missing values using zero, mean, or median imputation, returning both reports for up to 200 rows.","exampleAgentPrompt":"Take my promotion data for store groups A and B across October 2026 — rows with discount_amount and units_sold — and give me a Base-100 series starting from row 0, filling any missing discount_amount values using the median method.","exampleUseCases":[{"title":"Benchmarking discount trends across store groups","prompt":"I have 4 weeks of promotion records for two store groups with discount_amount and units_sold. Can you index the discount_amount to Base-100 starting at row 0 and fill any nulls with the median so I can compare trends across groups?"},{"title":"Cleaning missing units sold before reporting","prompt":"My promotion dataset has some null units_sold values — can you fill those in using mean imputation and also produce a Base-100 indexed series for units_sold starting from the first row? I've got about 150 rows across several store groups."},{"title":"Normalizing promotion data for cross-period comparison","prompt":"I want to normalize my retail promotion observations so discount_amount is indexed to 100 at row 5 as the baseline, and any missing values should be replaced with zero. Can you run that on my dataset of 80 rows?"}],"resultDescription":"Returns two analytical reports: (1) a Base-100 indexed series where the chosen field (discount_amount or units_sold) is normalized relative to the specified base row, and (2) the same dataset with missing values explicitly filled using the selected method (zero, mean, or median). Both reports cover all supplied rows up to 200.","failureModes":["More than 200 rows submitted — exceeds maxItems limit","Invalid date format not matching YYYY-MM-DD pattern — schema validation error","base_index references a row index out of range for the supplied dataset","Unrecognized fill method value outside zero/mean/median enum","Empty rows array — minItems violation","Numeric values outside the allowed range (±1,000,000,000,000)"],"whenToPreferThis":"Choose this endpoint when you have tabular retail promotion data with discount_amount and/or units_sold fields and need both Base-100 normalization and explicit missing-value imputation in a single call. It is ideal for small-to-medium datasets (up to 200 rows) where you want reproducible, locally computed analytics without any external lookups, predictions, or live data dependencies. Prefer this over general-purpose analytics tools when you specifically need the combination of indexed series creation and null-fill in one payment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:32:37.817Z","isFirstParty":false,"canonicalSlug":"promotion-observations-base-100-series-explicit-missing-value-fill-7143bd74"}