{"uid":"cap_SpcQR2dQFrYRKI3pW831m","slug":"partnership-pipeline-category-frequencies-date-by-category-pivot-b7150d33","name":"Partnership Pipeline — Category Frequencies + Date by Category Pivot","description":"Partnership pipeline — Category frequencies + Date by category pivot: Category frequencies + Date by category pivot for supplied partnership pipeline records (qualified_partners, active_partners). 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-09-110?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","qualified_partners","active_partners"],"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},"active_partners":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"qualified_partners":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","active_partners":1,"qualified_partners":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","active_partners":2,"qualified_partners":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","active_partners":3,"qualified_partners":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","active_partners":4,"qualified_partners":30}],"maxItems":200,"minItems":1},"field":{"enum":["qualified_partners","active_partners"],"type":"string","default":"qualified_partners"}}},"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_t4nodAYAf-O_iDxyPtvvS","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 partnership pipeline data (qualified_partners, active_partners) to produce two reports: category frequency counts and a date-by-category pivot table, for up to 200 rows.","exampleAgentPrompt":"Can you analyze my partnership pipeline records and give me both a category frequency breakdown and a date-by-category pivot for qualified_partners? I have about 50 rows with fields: row_id, company_group, date, qualified_partners, and active_partners.","exampleUseCases":[{"title":"Quarterly partner distribution review","prompt":"I have 120 rows of partnership pipeline data with company groups and dates. Can you run a category frequency report and a date-by-category pivot on the qualified_partners field so I can see how partner counts are distributed across groups over time?"},{"title":"Active partner activity heatmap","prompt":"Take these 80 rows of partner pipeline records and generate a pivot of active_partners broken down by date and company group, plus a frequency count of how often each group shows up."},{"title":"Partnership audit across business units","prompt":"I need to audit our partnership pipeline — here are 200 rows with row_id, company_group, date, qualified_partners, and active_partners. Give me a category frequency table and a date-by-category pivot using the active_partners field."}],"resultDescription":"Two analytical reports derived from the supplied rows: (1) a category frequency table showing how often each company_group appears in the dataset, and (2) a date-by-category pivot table showing the chosen metric (qualified_partners or active_partners) broken down by date and company_group. No external data is fetched; all computation is done on the provided rows.","failureModes":["Missing required fields (row_id, company_group, date, qualified_partners, active_partners) causes validation failure","Date values not matching YYYY-MM-DD pattern are rejected","Exceeding 200 rows returns an error or truncation","Invalid field enum value (not 'qualified_partners' or 'active_partners') causes rejection","Empty rows array returns an error","Payment failure (insufficient USDC) blocks the request"],"whenToPreferThis":"Choose this endpoint when you have up to 200 rows of partnership pipeline data and need two quick statistical views — category frequency counts and a date-by-category pivot — without needing external lookups, predictions, or live data. Ideal for offline batch analysis, reporting pipelines, or dashboard preparation where the data is already available and two report types are needed in a single call for $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:54.149Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-category-frequencies-date-by-category-pivot-b7150d33"}