{"uid":"cap_c6I967i7V6Q7MW6PLup5Z","slug":"market-survey-observations-category-frequencies-date-by-category-pivot-4fcaab9a","name":"Market Survey Observations — Category Frequencies + Date by Category Pivot","description":"Market survey observations — Category frequencies + Date by category pivot: Category frequencies + Date by category pivot for supplied market survey observations records (respondent_count, sample_weight). 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-06-110?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","respondent_count","sample_weight"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"sample_weight":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"respondent_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","sample_weight":1,"respondent_count":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","sample_weight":2,"respondent_count":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","sample_weight":3,"respondent_count":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","sample_weight":4,"respondent_count":30}],"maxItems":200,"minItems":1},"field":{"enum":["respondent_count","sample_weight"],"type":"string","default":"respondent_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_OD7VnpD8JGGQA-MicWdaz","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 market survey observation records to produce two reports: category-level frequency counts and a date-by-category pivot table, for up to 200 rows.","exampleAgentPrompt":"Analyze these market survey rows for respondent_count — give me category frequencies by company_group and a date-by-category pivot table: row-1 group-a 2026-10-01 count=10 weight=1, row-2 group-b 2026-10-02 count=20 weight=2, row-3 group-a 2026-10-03 count=15 weight=3, row-4 group-b 2026-10-04 count=30 weight=4.","exampleUseCases":[{"title":"Brand tracker survey rollup","prompt":"I have 150 rows of brand tracker survey data with company groups and weekly dates — can you give me both a frequency count per group and a date-by-group pivot on respondent_count so I can see how each brand is trending?"},{"title":"Weighted sample analysis by segment","prompt":"Run two reports on my market survey observations: category frequencies and a date-by-category pivot, but use sample_weight as the measure instead of respondent counts — here are my 80 rows with row IDs, groups, and dates."},{"title":"Quarterly survey data tabulation","prompt":"I've collected survey responses from four company groups across Q3 — please tabulate category frequencies and a date-by-category pivot for respondent_count so I can compare group participation over the quarter."}],"resultDescription":"Returns two analytical reports computed locally from the supplied rows: (1) category frequency counts showing how often each company_group appears and its aggregated respondent_count or sample_weight values, and (2) a date-by-category pivot table cross-tabulating dates against company groups with the selected measure. No external data is fetched.","failureModes":["Rows array empty or missing — returns validation error","More than 200 rows submitted — exceeds maximum row limit","Invalid date format (not YYYY-MM-DD) — schema pattern validation fails","Null or non-numeric respondent_count/sample_weight when field is selected — may produce null aggregates","Invalid field enum value (not respondent_count or sample_weight) — rejected by schema","Missing required fields (row_id, company_group, date) — row-level validation error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 market survey observation rows with company group and date fields and need both a category frequency summary and a date-by-category pivot in a single call. It is ideal for offline/local analysis where no live data lookup is needed, and when you want two complementary reports (frequency + pivot) bundled for $0.01 USDC. Prefer alternatives if you need more than 200 rows, time-series forecasting, outlier detection, or external data enrichment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:49:32.501Z","isFirstParty":false,"canonicalSlug":"market-survey-observations-category-frequencies-date-by-category-pivot-4fcaab9a"}