{"uid":"cap_MHhtxL2JJcW_d_W_PCVA7","slug":"promotion-observations-string-normalisation-keyed-dataset-comparison-d9106e17","name":"Promotion Observations — String Normalisation + Keyed Dataset Comparison","description":"Promotion observations — String normalisation + Keyed dataset comparison: String normalisation + Keyed dataset comparison 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-036?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},"other":{"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":21},{"date":"2026-10-03","row_id":"row-3","units_sold":3,"store_group":"group-a","discount_amount":17},{"date":"2026-10-04","row_id":"row-4","units_sold":4,"store_group":"group-b","discount_amount":33}],"maxItems":200,"minItems":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_OROBAUTyWfuVQqoC6sYFc","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":"Normalises string fields and performs keyed dataset comparison across two sets of promotion observation records (discount_amount, units_sold) for up to 200 rows, producing 2 independent analytical reports.","exampleAgentPrompt":"Can you compare these two sets of promotion records — both have up to 50 rows with row_id, store_group, date, discount_amount, and units_sold — and give me a string normalisation report plus a keyed comparison showing where the discount amounts or units sold differ between the two datasets?","exampleUseCases":[{"title":"Promotional period discount variance check","prompt":"I have two exports of promotion data from our retail system — one from last month and one from this month — each with around 80 rows containing row_id, store_group, date, discount_amount, and units_sold. Can you normalise the store group strings and tell me where the discount amounts differ between the two datasets by row key?"},{"title":"Store group label inconsistency audit","prompt":"Our promotion records have messy store group names like 'Group A', 'group-a', and 'GROUP A' across two datasets of about 40 rows each. Can you run string normalisation and a keyed comparison on both sets so I can see which rows have mismatched labels or different units_sold values?"},{"title":"Cross-team promotion data reconciliation","prompt":"Our marketing team and our ops team each submitted a promotion observation file — both about 100 rows, with row_id, store_group, date, discount_amount, and units_sold. Can you normalise the strings and do a keyed comparison to flag any rows where the two teams reported different discount amounts or units sold?"}],"resultDescription":"Two analytical reports: (1) a string normalisation report covering store_group and other string fields across the supplied rows, and (2) a keyed dataset comparison report identifying row-by-row differences in discount_amount and units_sold between the two supplied datasets, matched on row_id.","failureModes":["More than 200 rows submitted — request rejected or truncated","Missing required fields (row_id, store_group, date, discount_amount, units_sold) — validation error","date field not matching YYYY-MM-DD pattern — schema validation failure","Mismatched row_ids between the two datasets — comparison may produce incomplete results","Null numeric values in discount_amount or units_sold — may affect comparison output","Empty rows array — minimum 1 item required"],"whenToPreferThis":"Choose this endpoint when you need to both normalise string fields and compare two keyed promotion datasets (discount_amount, units_sold) in a single paid call, without requiring any live data lookup, external prediction, or professional assessment. It is best suited for retail analytics workflows where two promotion record exports need to be reconciled or audited against each other, especially when store group label inconsistencies are suspected.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:33:33.281Z","isFirstParty":false,"canonicalSlug":"promotion-observations-string-normalisation-keyed-dataset-comparison-d9106e17"}