{"uid":"cap_7NOyFa3xt_wWnSMMcyeaI","slug":"customer-followups-category-frequencies-date-by-category-pivot-a0546b7d","name":"Customer Followups — Category Frequencies + Date by Category Pivot","description":"Customer followups — Category frequencies + Date by category pivot: Category frequencies + Date by category pivot for supplied customer followups records (completed_followups, due_followups). 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-operations-19-110?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","completed_followups","due_followups"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"team_group":{"type":"string","default":"","maxLength":80},"due_followups":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_followups":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","due_followups":1,"completed_followups":10},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","due_followups":2,"completed_followups":20},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","due_followups":3,"completed_followups":15},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","due_followups":4,"completed_followups":30}],"maxItems":200,"minItems":1},"field":{"enum":["completed_followups","due_followups"],"type":"string","default":"completed_followups"}}},"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_on0uHhCpeX3ZZ35i3GqO4","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 followup records to produce two reports: category frequencies by team group and a date-by-category pivot table for completed or due followups.","exampleAgentPrompt":"Can you analyze these customer followup records for my team — I have up to 50 rows with row IDs, team groups, dates, and completed_followups counts — and give me both a category frequency breakdown by team group and a date-by-category pivot table for completed_followups?","exampleUseCases":[{"title":"Sales team followup completion audit","prompt":"I have 80 rows of customer followup data with team group, date, and completed_followups for each row — can you give me a frequency breakdown of how often each team group appears and a pivot table showing completed followups by date and team?"},{"title":"Due followup backlog analysis by team","prompt":"Here are 120 customer followup records with team_group, date, row_id, and due_followups values — analyze the due_followups field and give me a category frequency report plus a date-by-category pivot so I can see where the backlog is heaviest."},{"title":"Weekly CRM followup activity summary","prompt":"I want to summarize this week's CRM data — I've got about 60 rows of followup records tagged by team group and date. Can you run the category frequency and date-pivot analysis on the completed_followups field so I can see which groups are most active and on which days?"}],"resultDescription":"Returns two analytical reports: (1) a category frequencies table showing how often each team_group appears across the supplied rows, and (2) a date-by-category pivot table cross-tabulating the selected metric (completed_followups or due_followups) by date and team_group. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Rows exceeding 200 items will be rejected — the endpoint enforces a maxItems:200 constraint","Missing required fields (row_id, team_group, date, completed_followups, due_followups) will cause validation errors","Date values not matching YYYY-MM-DD format will fail schema pattern validation","Numeric values outside ±1,000,000,000,000 will be rejected","An empty rows array (minItems:1) will fail validation","Invalid field enum value (must be 'completed_followups' or 'due_followups') will cause errors","Payment failure or insufficient USDC balance will block the request"],"whenToPreferThis":"Choose this endpoint when you have up to 200 customer followup records with team group and date dimensions and need both a category frequency summary and a date-by-category pivot in a single low-cost call ($0.01 USDC). It is ideal when data privacy matters since computation is local with no external lookup. Prefer it over general BI tools when you need a lightweight, pay-per-use analytical call that returns structured tabular reports without requiring a persistent data warehouse connection.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-31T00:43:53.151Z","isFirstParty":false,"canonicalSlug":"customer-followups-category-frequencies-date-by-category-pivot-a0546b7d"}