{"uid":"cap_Wr8LH5ZiJiGmrVvkZqamP","slug":"donation-campaign-records-date-by-category-pivot-588eba4c","name":"Donation Campaign Records – Date by Category Pivot","description":"Donation campaign records - Date by category pivot: Date by category pivot for Donation campaign records. Up to 200 supplied typed records. Local descriptive analytics; no enrichment or forecast. One of 25 new profiles across 20 shared operations in this industry. 0.01 USDC includes one bounded date by category pivot report.","url":"https://market.datapackvibe.com/x402/assistant-ar-analytics-donation-records-pivot?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","campaign","date","donations","amount"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"campaign":{"type":"string","default":"","maxLength":80},"donations":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","amount":1,"row_id":"row-1","campaign":"group-a","donations":10},{"date":"2026-10-02","amount":2,"row_id":"row-2","campaign":"group-b","donations":20},{"date":"2026-10-03","amount":3,"row_id":"row-3","campaign":"group-a","donations":15},{"date":"2026-10-04","amount":4,"row_id":"row-4","campaign":"group-b","donations":30}],"maxItems":200,"minItems":1},"field":{"enum":["donations","amount"],"type":"string","default":"donations"}}},"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_r7kD0_5IlNGBa-A9l3d5V","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":"Generates a date-by-campaign pivot table from up to 200 donation campaign records, summarizing a chosen numeric field (donations count or amount) across dates and campaign groups.","exampleAgentPrompt":"Take my donation campaign records — two campaigns 'Spring Drive' and 'Fall Gala', with entries dated 2025-01-01 through 2025-01-31 — and generate a date-by-campaign pivot table showing total donation counts for each day.","exampleUseCases":[{"title":"Monthly fundraising performance comparison","prompt":"I have 150 rows of donation data across three campaigns — 'Annual Fund', 'Emergency Relief', and 'Youth Program' — each with a date and donation count. Can you pivot this by date and campaign so I can see how many donations each campaign got each day this month?"},{"title":"Revenue breakdown by campaign over quarter","prompt":"Here are our Q1 donation records across campaigns 'GivingTuesday' and 'SpringAppeal'. Pivot the amount field by date and campaign so I can see the total dollar amounts raised per day per campaign."},{"title":"Comparing two campaigns head-to-head by day","prompt":"I've got two fundraising campaigns running simultaneously — 'Email Blast' and 'Social Media' — and about 80 transaction rows with dates and donation amounts. Build me a date-by-category pivot on the amount field so I can see which campaign outperformed the other day by day."}],"resultDescription":"A bounded pivot report (date-by-campaign matrix) summarizing the selected numeric field — either donations count or amount — aggregated per date and campaign category. Output is a local descriptive analytics result with no enrichment, forecasting, or external data lookups.","failureModes":["Input array is empty or missing required fields (row_id, campaign, date, donations, amount) — validation error returned","Date strings not matching YYYY-MM-DD pattern — schema validation failure","More than 200 rows submitted — exceeds maxItems limit, request rejected","Invalid field enum value (not 'donations' or 'amount') — schema validation error","Numeric values outside allowed range (-1e12 to 1e12) — validation error"],"whenToPreferThis":"Choose this endpoint when you need a fast, local pivot summary of donation campaign records grouped by date and campaign category, with no need for external enrichment or forecasting. It is ideal for nonprofit analysts or fundraising teams who have up to 200 structured campaign records and want a cross-tabulation of either donation counts or amounts across dates and campaigns, at minimal cost ($0.01 per call).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:47:24.420Z","isFirstParty":false,"canonicalSlug":"donation-campaign-records-date-by-category-pivot-588eba4c"}