{"uid":"cap_iFkzh9_y3Cq5QZfU_hMWu","slug":"customer-segment-observations-numeric-interval-filter-secondary-9506ddc8","name":"Customer Segment Observations — Numeric Interval Filter + Secondary-Measure Weighted Mean","description":"Customer segment observations — Numeric interval filter + Secondary-measure weighted mean: Numeric interval filter + Secondary-measure weighted mean 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-132?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"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_c3QmLImeYqQr_5M3M-xGC","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":"Filters customer segment observation rows by a numeric interval on a chosen field and computes a secondary-measure weighted mean across up to 200 supplied rows, returning two independent analytical reports.","exampleAgentPrompt":"I have customer segment data with account_count and revenue_amount for several company groups — can you filter the rows where account_count is between 10 and 50, then compute a weighted mean on revenue_amount? Here are my rows: row-1 group-a 2026-10-01 account_count=10 revenue_amount=1, row-2 group-b 2026-10-02 account_count=20 revenue_amount=2, row-3 group-a 2026-10-03 account_count=15 revenue_amount=3.","exampleUseCases":[{"title":"Revenue-weighted mean for mid-tier segments","prompt":"I have 50 rows of customer segment observations with account_count and revenue_amount. Can you filter to only the rows where account_count is between 5 and 100 and then give me the weighted mean of revenue_amount across those filtered segments?"},{"title":"Account count analysis within revenue band","prompt":"From my company group data, filter all rows where revenue_amount falls between 1000 and 50000, and compute the weighted mean of account_count for that filtered set. I'm sending you about 80 rows across groups A, B, and C."},{"title":"Dual-report segmentation for board summary","prompt":"I need two analytical reports on our customer segment records: first filter where account_count is between 20 and 200, then calculate the secondary-measure weighted mean of revenue_amount. I have around 150 rows from Q4 2026 to supply."}],"resultDescription":"Returns two independent analytical reports using local analytical engines: (1) a numeric interval filter report showing which of the supplied rows fall within the specified minimum/maximum range on the chosen field, and (2) a secondary-measure weighted mean report computing the weighted average of the secondary measure across the filtered subset. No external data is fetched; all computation is performed on the user-supplied rows (up to 200).","failureModes":["Rows array is empty or missing — validation error returned","More than 200 rows supplied — request rejected","Field value not one of 'account_count' or 'revenue_amount' — enum validation failure","Minimum greater than maximum — may return empty filter result or error","Null values in the weight or measure fields may cause weighted mean to be undefined or skipped","Row missing required fields (row_id, company_group, date) — schema validation error","Date field not matching YYYY-MM-DD pattern — validation error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 customer segment observation rows (with account_count and revenue_amount fields) and need both a numeric interval filter and a secondary-measure weighted mean in a single paid call for $0.01 USDC. It is a local analytical engine with no external lookups, making it fast, deterministic, and private. Prefer it over generic analytics tools when you want two bundled reports cheaply and your data fits within the 200-row limit.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T00:52:09.004Z","isFirstParty":false,"canonicalSlug":"customer-segment-observations-numeric-interval-filter-secondary-9506ddc8"}