{"uid":"cap_gON2H6RB04gGPbPu2jAC1","slug":"customer-segment-observations-category-frequencies-date-by-category-0f0ba49a","name":"Customer Segment Observations — Category Frequencies + Date by Category Pivot","description":"Customer segment observations — Category frequencies + Date by category pivot: Category frequencies + Date by category pivot 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-110?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_3JzzIcUL4KQ6OQin10HG7","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":"Runs two local analytical reports on customer segment observation data: category frequency counts and a date-by-category pivot, for up to 200 rows.","exampleAgentPrompt":"I have a list of up to 200 customer segment observations with company groups, dates, account counts, and revenue amounts — can you run both a category frequency breakdown and a date-by-category pivot on this data using account_count as the metric?","exampleUseCases":[{"title":"Monthly revenue pivot by segment","prompt":"I've got 150 rows of customer segment data with dates and revenue_amount for each company group — can you pivot the revenue by date and company group, and also show me how often each group appears in the dataset?"},{"title":"Account count frequency audit","prompt":"Here are my customer segment observations for Q3 — each row has a company_group, date, and account_count. Can you give me a frequency count of each category and a date-by-category pivot table using account_count?"},{"title":"Segment distribution for board report","prompt":"I need to analyze our customer segment records — I have about 80 rows with company_group, date, and revenue_amount fields. Run a category frequency report and a date-by-revenue pivot so I can summarize the segment distribution for our board deck."}],"resultDescription":"Returns two analytical reports derived from the supplied rows: (1) a category frequency table showing how often each company_group value appears, and (2) a date-by-category pivot table aggregating the chosen metric (account_count or revenue_amount) across dates and company groups. No external data is fetched; all computation is local.","failureModes":["Input rows array is empty or missing — minimum 1 row required","More than 200 rows supplied — maxItems limit exceeded","Invalid date format — must match YYYY-MM-DD pattern","Missing required fields (row_id, company_group, date, account_count, revenue_amount) on any row","Field enum value not recognized — must be 'account_count' or 'revenue_amount'","Payment of 0.01 USDC not completed — x402 payment required before response is returned"],"whenToPreferThis":"Choose this endpoint when you have up to 200 customer segment observation rows with company group and date fields and need two fast, local analytical summaries — category frequency counts and a date-by-category pivot — without any external lookup, prediction, or live data fetch. It is ideal when privacy or data residency matters, since no data leaves the local analytical engine, and when you need both reports in a single low-cost call ($0.01 USDC).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-16T12:44:29.167Z","isFirstParty":false,"canonicalSlug":"customer-segment-observations-category-frequencies-date-by-category-0f0ba49a"}