{"uid":"cap_-0HFqH1whcAF9NkVNRXwD","slug":"customer-segment-observations-exact-row-deduplication-grouped-numeric-0a7ab653","name":"Customer Segment Observations — Exact Row Deduplication + Grouped Numeric Summary","description":"Customer segment observations — Exact row deduplication + Grouped numeric summary: Exact row deduplication + Grouped numeric summary 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-040?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"}}},"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_7d6jq4t6DTbpN1ojPFUeq","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":"Deduplicates customer segment observation rows and computes grouped numeric summaries (count, revenue) across company groups and dates — two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have a list of customer segment observations with company groups, dates, account counts, and revenue amounts — can you deduplicate the exact duplicate rows and give me a grouped numeric summary of revenue_amount broken down by company group? Here are my rows: group-a on 2026-10-01 had 10 accounts and $1 revenue (row-1), group-b on 2026-10-02 had 20 accounts and $2 revenue (row-2), group-a on 2026-10-03 had 15 accounts and $3 revenue (row-3), group-b on 2026-10-04 had 30 accounts and $4 revenue (row-4).","exampleUseCases":[{"title":"Deduplicate monthly revenue segment export","prompt":"I exported our monthly segment data and suspect there are duplicate rows — can you run exact row deduplication and give me a grouped summary of revenue_amount by company group? I have about 80 rows with row IDs, company groups, dates, account counts, and revenue amounts."},{"title":"Audit account counts across company groups","prompt":"Can you take these 150 customer segment observation records and deduplicate any exact duplicates, then give me a grouped numeric summary of account_count across company groups so I can see which groups have the most accounts? Each row has a row_id, company_group, date, account_count, and revenue_amount."},{"title":"Quarterly segment data quality check","prompt":"Before our quarterly review, can you deduplicate these customer segment rows and produce a grouped summary of both account_count and revenue_amount by company group? I'll send you up to 200 rows — each has a row_id, date, company_group, account_count, and revenue_amount."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing fully duplicate records from the supplied rows, and (2) a grouped numeric summary aggregating the selected field (account_count or revenue_amount) across company groups and dates — covering up to 200 input rows.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, company_group, date, account_count, revenue_amount) cause validation errors","Date strings not matching YYYY-MM-DD pattern will fail schema validation","Numeric values outside the allowed range (±1 trillion) will be rejected","Empty rows array (minItems: 1 violated) returns an error"],"whenToPreferThis":"Choose this endpoint when you have raw customer segment observation data (with company groups, dates, account counts, and revenue amounts) and need both exact row deduplication and grouped numeric summaries in a single low-cost call. It is ideal for lightweight data quality and aggregation tasks on datasets up to 200 rows where no external data lookup, prediction, or live enrichment is needed. Prefer alternatives if you need probabilistic deduplication, fuzzy matching, or more than 200 rows processed at once.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-16T12:44:55.531Z","isFirstParty":false,"canonicalSlug":"customer-segment-observations-exact-row-deduplication-grouped-numeric-0a7ab653"}