{"uid":"cap_dzXSBxlMyyXnr4nuf98d2","slug":"advertising-performance-daily-sum-series-1ca24788","name":"Advertising Performance Daily Sum Series","description":"Advertising performance - Daily sum series: Daily sum series for Advertising performance. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded daily sum series deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-ad-performance-date-series?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","campaign","date","clicks","spend"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"spend":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"clicks":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"campaign":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","spend":1,"clicks":10,"row_id":"row-1","campaign":"group-a"},{"date":"2026-10-02","spend":2,"clicks":20,"row_id":"row-2","campaign":"group-b"},{"date":"2026-10-03","spend":3,"clicks":15,"row_id":"row-3","campaign":"group-a"},{"date":"2026-10-04","spend":4,"clicks":30,"row_id":"row-4","campaign":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["clicks","spend"],"type":"string","default":"clicks"}}},"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_3s1kerQYnapcCBobwPko4","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 daily sum time-series aggregations (clicks or spend) grouped by campaign from up to 200 advertising performance records.","exampleAgentPrompt":"Can you sum up our daily clicks by campaign from this ad data? I have rows with campaign names, dates, and click counts — here are 4 rows: row-1 for group-a on 2026-10-01 with 10 clicks and $1 spend, row-2 for group-b on 2026-10-02 with 20 clicks and $2 spend, row-3 for group-a on 2026-10-03 with 15 clicks and $3 spend, row-4 for group-b on 2026-10-04 with 30 clicks and $4 spend — give me the daily sum series for clicks.","exampleUseCases":[{"title":"Daily spend rollup for two campaigns","prompt":"I have a week of raw ad data across two campaigns — can you compute the total spend per day for each campaign? The rows include campaign name, date, spend, and clicks. Aggregate on the spend field."},{"title":"Click trend series for campaign reporting","prompt":"Pull together a daily sum of clicks from my advertising rows so I can chart the trend over time. I've got about 150 records with campaign, date, clicks, and spend — group them by day and sum the clicks field."},{"title":"Detecting high-spend days across campaigns","prompt":"I want to see which days had the highest total ad spend across my campaigns — can you compute the daily spend totals from my 80 advertising records so I can spot any spikes?"}],"resultDescription":"A bounded daily sum series where each entry represents the total of the selected metric (clicks or spend) for a given date, aggregated locally without external enrichment. Results cover up to 200 input rows and are delivered as typed numeric records grouped by date and campaign.","failureModes":["Missing required fields (row_id, campaign, date, clicks, spend) causes validation failure","Date strings not matching YYYY-MM-DD pattern are rejected","More than 200 rows submitted exceeds the maxItems limit and returns an error","Null numeric values for the selected field may result in zeroed or excluded entries","Empty rows array (minItems:1 violated) returns an error"],"whenToPreferThis":"Use this endpoint when you have raw advertising row data with dates, campaign labels, clicks, and spend, and need a fast, cheap daily aggregation into a sum series without external enrichment or forecasting. Ideal for pre-charting pipelines, campaign reporting dashboards, or anomaly detection preprocessing where local numeric computation suffices and low latency with minimal cost ($0.01 USDC) is important.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T19:17:45.946Z","isFirstParty":false,"canonicalSlug":"advertising-performance-daily-sum-series-1ca24788"}