{"uid":"cap_yEu449QLqZZr1z_BTzSAx","slug":"customer-segment-observations-duplicate-key-report-base-100-series-efd57753","name":"Customer Segment Observations — Duplicate Key Report + Base-100 Series","description":"Customer segment observations — Duplicate key report + Base-100 series: Duplicate key report + Base-100 series for supplied customer segment observations records (account_count, revenue_amount). 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-company-16-063?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","account_count","revenue_amount"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"account_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"revenue_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","account_count":10,"company_group":"group-a","revenue_amount":1},{"date":"2026-10-02","row_id":"row-2","account_count":20,"company_group":"group-b","revenue_amount":2},{"date":"2026-10-03","row_id":"row-3","account_count":15,"company_group":"group-a","revenue_amount":3},{"date":"2026-10-04","row_id":"row-4","account_count":30,"company_group":"group-b","revenue_amount":4}],"maxItems":200,"minItems":1},"field":{"enum":["account_count","revenue_amount"],"type":"string","default":"account_count"},"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_60MMz53W3qGDqa4RaD_Oj","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 customer segment observation records to produce a duplicate key report and a base-100 indexed series for account_count or revenue_amount, covering up to 200 rows in two independent reports.","exampleAgentPrompt":"Run a duplicate key check and a base-100 series on my customer segment observations — here are the rows: group-a on 2026-10-01 had account_count 10 and revenue_amount 1 (row-1), group-b on 2026-10-02 had account_count 20 and revenue_amount 2 (row-2), group-a on 2026-10-03 had account_count 15 and revenue_amount 3 (row-3). Use account_count as the field and start the base index at row 0.","exampleUseCases":[{"title":"Segment data deduplication audit","prompt":"I have 50 customer segment records by company group and date — can you check them for duplicate row keys and also give me a base-100 series on the revenue_amount field starting from the first row?"},{"title":"Monthly account count rebasing","prompt":"Here are our monthly account_count observations across two customer segments for the past quarter — run a duplicate key report and rebase the account_count values to 100 starting at index 0 so I can compare growth rates."},{"title":"Revenue trend normalization by segment","prompt":"I need to normalize our segment revenue_amount data to a base-100 index starting at position 2 and also flag any rows with duplicate keys — here are 80 rows of company_group, date, account_count, and revenue_amount observations."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any rows sharing the same key combination within the supplied records, and (2) a base-100 indexed series for the chosen field (account_count or revenue_amount) anchored at the specified base_index row. Both reports are computed locally without external lookups or predictions, covering up to 200 input rows.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, company_group, date, account_count, or revenue_amount) — validation error","Invalid date format (must be YYYY-MM-DD) — schema validation failure","base_index out of range (0–199) — error returned","field enum value not in ['account_count','revenue_amount'] — invalid input","Empty rows array — minimum 1 row required"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key audit and a base-100 normalization of customer segment metrics in a single low-cost call. It is ideal for data quality workflows on segment observation tables where you want to catch repeated keys and also produce rebased trend series for account counts or revenue figures, all without relying on any external data source or live lookup.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-16T12:44:56.854Z","isFirstParty":false,"canonicalSlug":"customer-segment-observations-duplicate-key-report-base-100-series-efd57753"}