{"uid":"cap_sT-HVXr0TEDv2etLKVpqj","slug":"camera-coverage-analytics-daily-sum-series-date-by-category-pivot-363ec43c","name":"Camera Coverage Analytics — Daily Sum Series & Date-by-Category Pivot","description":"Camera coverage — Daily sum series + Date by category pivot: Daily sum series + Date by category pivot for supplied camera coverage records (shot_count, coverage_seconds). 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-creative-12-143?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","shot_count","coverage_seconds"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"shot_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"asset_group":{"type":"string","default":"","maxLength":80},"coverage_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","shot_count":10,"asset_group":"group-a","coverage_seconds":1},{"date":"2026-10-02","row_id":"row-2","shot_count":20,"asset_group":"group-b","coverage_seconds":2},{"date":"2026-10-03","row_id":"row-3","shot_count":15,"asset_group":"group-a","coverage_seconds":3},{"date":"2026-10-04","row_id":"row-4","shot_count":30,"asset_group":"group-b","coverage_seconds":4}],"maxItems":200,"minItems":1},"field":{"enum":["shot_count","coverage_seconds"],"type":"string","default":"shot_count"}}},"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_FcO0al3pZiPEuqK7NTw_1","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":"Computes two analytical reports on camera coverage data: a daily sum time series and a date-by-category pivot table, for up to 200 rows of shot_count or coverage_seconds data.","exampleAgentPrompt":"I have a list of camera coverage records with shot counts and coverage seconds for several asset groups across multiple dates — can you give me both a daily sum time series and a date-by-category pivot for the shot_count field? Here are the rows: [{\"row_id\":\"r1\",\"asset_group\":\"studio-a\",\"date\":\"2025-01-01\",\"shot_count\":42,\"coverage_seconds\":3600},{\"row_id\":\"r2\",\"asset_group\":\"studio-b\",\"date\":\"2025-01-01\",\"shot_count\":18,\"coverage_seconds\":1800}].","exampleUseCases":[{"title":"Daily shot count rollup for production review","prompt":"I've got camera coverage logs from last week with shot counts across three studio groups — can you aggregate them into a daily sum series and also pivot shot_count by date and asset group so I can see which studio was busiest each day?"},{"title":"Coverage seconds analysis for broadcast scheduling","prompt":"Here are 150 rows of camera records for our broadcast team, each with asset_group, date, and coverage_seconds — please compute the daily total coverage_seconds and give me a pivot table by date and group so I can see which groups ran longest on which days."},{"title":"Weekly camera activity summary by location group","prompt":"I need to analyze camera activity across five location groups for the past month. Can you take these records and produce both a daily sum time series and a date-by-category pivot for shot_count so I can spot any coverage gaps?"}],"resultDescription":"Two analytical reports derived from the supplied camera coverage rows: (1) a daily sum time series showing the total of the selected field (shot_count or coverage_seconds) aggregated by date, and (2) a date-by-category pivot table cross-tabulating dates against asset groups with summed values. Results cover up to 200 input rows and are computed entirely from the supplied data with no external lookups.","failureModes":["More than 200 rows supplied — request rejected or truncated","Missing required fields (row_id, asset_group, date, shot_count, coverage_seconds) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (±1,000,000,000,000) — validation error","Empty rows array — error due to minItems:1 constraint","Invalid field enum value (not shot_count or coverage_seconds) — schema rejection"],"whenToPreferThis":"Choose this endpoint when you have raw camera coverage records (with shot_count and/or coverage_seconds per asset group and date) and need both a daily time series aggregate and a cross-tabulated pivot in a single low-cost call. It is ideal for media production, broadcast operations, or surveillance analytics workflows where you want local, deterministic aggregation without any external data lookups or predictions. Prefer it over general-purpose analytics tools when you need both report types simultaneously for up to 200 rows at minimal cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:43:42.845Z","isFirstParty":false,"canonicalSlug":"camera-coverage-analytics-daily-sum-series-date-by-category-pivot-363ec43c"}