{"uid":"cap_edQ-P2rUKGmFU3J4UlQ9G","slug":"promotion-observations-duplicate-key-report-missing-value-fill-15a95d8d","name":"Promotion Observations — Duplicate Key Report + Missing-Value Fill","description":"Promotion observations — Duplicate key report + Explicit missing-value fill: Duplicate key report + 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-070?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"}}},"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_TOV6_LBs94RJrBWLJysdd","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":"Analyzes up to 200 promotion observation rows to produce a duplicate key report and fill missing values in discount_amount or units_sold fields using zero, mean, or median imputation.","exampleAgentPrompt":"Can you check my promotion observations for duplicate row IDs and also fill in any missing discount_amount values using the median — I have about 50 rows with store_group, date, and units_sold fields?","exampleUseCases":[{"title":"Cleaning promo data before reporting","prompt":"I have 120 rows of promotion data with store_group, date, discount_amount, and units_sold — some discount_amounts are null. Can you fill those missing values using the mean and also flag any duplicate row IDs for me?"},{"title":"Auditing campaign records for key conflicts","prompt":"Before I merge our Q4 promotion records into the database, can you run a duplicate key check on these 80 rows and fill any missing units_sold with zero?"},{"title":"Preparing retail discount data for analysis","prompt":"I've got a batch of 150 promotional observation rows and I need two things: a report showing any duplicate row IDs, and all the missing discount_amount values filled in using the median imputation method."}],"resultDescription":"Returns two independent reports: (1) a duplicate key report identifying rows with repeated row_id values, and (2) an explicit missing-value fill report showing the target field (discount_amount or units_sold) with nulls replaced by the chosen method (zero, mean, or median). Both reports are computed locally without any external data lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Invalid date format (not YYYY-MM-DD) — schema validation error","Unknown imputation method outside zero/mean/median enum — rejected","Empty rows array — minimum 1 row required","Field value outside allowed numeric range — schema rejection","Payment not fulfilled — x402 payment required response"],"whenToPreferThis":"Use this endpoint when you have promotion observation data (up to 200 rows) that needs simultaneous duplicate key detection and missing-value imputation in a single paid call. It is ideal for retail data preparation workflows where both data integrity checks and null handling are needed before downstream analysis, without requiring any external lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T12:44:59.388Z","isFirstParty":false,"canonicalSlug":"promotion-observations-duplicate-key-report-missing-value-fill-15a95d8d"}