{"uid":"cap_j4tpLxvGCXhHeFio0zmzx","slug":"event-coverage-record-quality-audit-date-by-category-pivot-623b4479","name":"Event Coverage Record Quality Audit + Date by Category Pivot","description":"Event coverage — Record quality audit + Date by category pivot: Record quality audit + Date by category pivot for supplied event coverage records (covered_sessions, planned_sessions). 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-news-11-017?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","channel_group","date","covered_sessions","planned_sessions"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"channel_group":{"type":"string","default":"","maxLength":80},"covered_sessions":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"planned_sessions":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","channel_group":"group-a","covered_sessions":10,"planned_sessions":1},{"date":"2026-10-02","row_id":"row-2","channel_group":"group-b","covered_sessions":20,"planned_sessions":2},{"date":"2026-10-03","row_id":"row-3","channel_group":"group-a","covered_sessions":15,"planned_sessions":3},{"date":"2026-10-04","row_id":"row-4","channel_group":"group-b","covered_sessions":30,"planned_sessions":4}],"maxItems":200,"minItems":1},"field":{"enum":["covered_sessions","planned_sessions"],"type":"string","default":"covered_sessions"}}},"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_XOTqbw4HJZOB6iyvaHfYy","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 local analytical reports on event coverage data: a record quality audit and a date-by-category pivot table, for up to 200 rows of covered_sessions and planned_sessions data.","exampleAgentPrompt":"Can you run a record quality audit and a date-by-category pivot on my event coverage data? I have rows with channel_group, date, covered_sessions, and planned_sessions — up to 200 rows — and I want to pivot on covered_sessions.","exampleUseCases":[{"title":"Event coverage data quality check","prompt":"I have about 150 rows of event session data with channel groups, dates, covered sessions, and planned sessions. Can you audit the record quality to find any bad or missing values and also give me a pivot of covered_sessions by date and channel group?"},{"title":"Media planning session coverage review","prompt":"We finished our media event last week and I need to review how well we covered each channel group by date. Run a quality audit and a date-by-category pivot on my planned_sessions data across these channel groups and dates."},{"title":"Automated pipeline data validation","prompt":"Before I pass this batch of 200 event coverage records to our reporting system, can you check them for data quality issues and give me a pivot table of covered_sessions broken down by date and channel group so I can spot any anomalies?"}],"resultDescription":"Returns two independent reports: (1) a record quality audit highlighting issues such as nulls, out-of-range values, or malformed fields across the supplied rows; and (2) a date-by-category pivot table aggregating the selected field (covered_sessions or planned_sessions) grouped by date and channel_group. Both reports are computed locally with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, channel_group, date, covered_sessions, planned_sessions) causes row-level rejection","Invalid date format (not YYYY-MM-DD) fails schema validation","Values outside the numeric range (-1T to +1T) are rejected","Empty rows array returns an error","Invalid field enum value (not covered_sessions or planned_sessions) causes request failure"],"whenToPreferThis":"Choose this endpoint when you need both a data quality audit and a date-by-category pivot in a single $0.01 call for up to 200 event coverage rows with covered_sessions and planned_sessions fields. It is ideal for lightweight, offline batch analytics on event or media session data without needing a live database, external API, or BI tool. Prefer alternatives if you need more than 200 rows, live data enrichment, predictive analytics, or reports beyond quality audit and date pivot.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-04T18:49:34.528Z","isFirstParty":false,"canonicalSlug":"event-coverage-record-quality-audit-date-by-category-pivot-623b4479"}