{"uid":"cap_xEevq5WZo6-AwFMKlWFXU","slug":"proposal-preparation-date-by-category-pivot-keyed-dataset-comparison-23736258","name":"Proposal Preparation: Date-by-Category Pivot + Keyed Dataset Comparison","description":"Proposal preparation — Date by category pivot + Keyed dataset comparison: Date by category pivot + Keyed dataset comparison for supplied proposal preparation records (completed_sections, planned_sections). 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-writing-08-188?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","document_group","date","completed_sections","planned_sections"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"document_group":{"type":"string","default":"","maxLength":80},"planned_sections":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_sections":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","document_group":"group-a","planned_sections":1,"completed_sections":10},{"date":"2026-10-02","row_id":"row-2","document_group":"group-b","planned_sections":2,"completed_sections":20},{"date":"2026-10-03","row_id":"row-3","document_group":"group-a","planned_sections":3,"completed_sections":15},{"date":"2026-10-04","row_id":"row-4","document_group":"group-b","planned_sections":4,"completed_sections":30}],"maxItems":200,"minItems":1},"field":{"enum":["completed_sections","planned_sections"],"type":"string","default":"completed_sections"},"other":{"type":"array","items":{"type":"object","required":["row_id","document_group","date","completed_sections","planned_sections"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"document_group":{"type":"string","default":"","maxLength":80},"planned_sections":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_sections":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","document_group":"group-a","planned_sections":1,"completed_sections":10},{"date":"2026-10-02","row_id":"row-2","document_group":"group-b","planned_sections":2,"completed_sections":21},{"date":"2026-10-03","row_id":"row-3","document_group":"group-a","planned_sections":3,"completed_sections":17},{"date":"2026-10-04","row_id":"row-4","document_group":"group-b","planned_sections":4,"completed_sections":33}],"maxItems":200,"minItems":0}}},"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_tbsfTp4TXnO6gsxi9mOce","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 analytical reports on proposal preparation data: a date-by-category pivot table and a keyed dataset comparison between two supplied datasets (completed_sections vs planned_sections), for up to 200 rows.","exampleAgentPrompt":"Analyze my proposal preparation data — I have two datasets (primary and comparison) each with up to 50 rows including row_id, document_group, date, completed_sections, and planned_sections. Run a date-by-category pivot on the completed_sections field and also compare the two datasets by key so I can see where they differ.","exampleUseCases":[{"title":"Proposal progress pivot by team","prompt":"I have daily proposal tracking records for two document groups — 'legal' and 'technical' — over the past month, with completed_sections and planned_sections logged per day. Can you pivot that data by date and group so I can see how each team is trending on completed_sections?"},{"title":"Planned vs actual sections comparison","prompt":"I've got two snapshots of our proposal data — one from last week and one from this week — each with row_id, document_group, date, planned_sections, and completed_sections. Run a keyed comparison between them so I can see which rows changed and by how much."},{"title":"Multi-group proposal audit","prompt":"We're auditing our RFP preparation process across four document groups. I have 120 rows of data with completion and planning figures by date. Can you pivot the planned_sections by date and category, and also compare it against a baseline dataset to flag differences?"}],"resultDescription":"Returns two independent analytical reports: (1) a date-by-category pivot table summarizing the selected metric (completed_sections or planned_sections) broken down by date and document_group, and (2) a keyed dataset comparison report showing differences between the primary and secondary (other) datasets matched by row_id. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Missing required fields (row_id, document_group, date, completed_sections, planned_sections) cause validation errors","Date values not matching YYYY-MM-DD pattern are rejected","Exceeding 200 rows in either dataset returns an error","Null numeric values may affect aggregation results in pivot","Mismatched row_ids between primary and secondary datasets result in unmatched rows in comparison report","Payment of 0.01 USDC not received results in 402 response"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous analytical views of proposal preparation data — specifically a date-by-category pivot combined with a keyed dataset comparison — without requiring any external data lookup or prediction. It is ideal for tracking proposal writing progress across document groups over time and comparing two snapshots of the same dataset. Prefer this over general analytics tools when working within the x402 micropayment ecosystem and when your data fits within 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:33:17.794Z","isFirstParty":false,"canonicalSlug":"proposal-preparation-date-by-category-pivot-keyed-dataset-comparison-23736258"}