{"uid":"cap_DPUoPqYphyfXCnbh6DOhB","slug":"brand-mention-inventories-trailing-mean-series-date-by-category-pivot-03d0234f","name":"Brand Mention Inventories — Trailing Mean Series + Date by Category Pivot","description":"Brand mention inventories — Trailing mean series + Date by category pivot: Trailing mean series + Date by category pivot for supplied brand mention inventories records (mention_count, source_count). 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-company-18-152?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","mention_count","source_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"mention_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_count":1,"company_group":"group-a","mention_count":10},{"date":"2026-10-02","row_id":"row-2","source_count":2,"company_group":"group-b","mention_count":20},{"date":"2026-10-03","row_id":"row-3","source_count":3,"company_group":"group-a","mention_count":15},{"date":"2026-10-04","row_id":"row-4","source_count":4,"company_group":"group-b","mention_count":30}],"maxItems":200,"minItems":1},"field":{"enum":["mention_count","source_count"],"type":"string","default":"mention_count"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_TjgKcXTmsruySZG3PFR_L","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 a trailing mean time series and a date-by-category pivot table for supplied brand mention inventory records (mention_count, source_count) in a single call.","exampleAgentPrompt":"Take my brand mention inventory data for groups 'acme' and 'globex' from October 2026 — mention_count and source_count per day — and give me both a trailing mean series with a 7-day window and a date-by-category pivot for mention_count.","exampleUseCases":[{"title":"Rolling average for brand PR campaign","prompt":"I have daily mention counts and source counts for three brand groups over the past 30 days. Can you compute a trailing mean with a 5-day window on mention_count and also pivot the data by date and company group so I can see how each brand performed each day?"},{"title":"Competitive share-of-voice smoothing","prompt":"Here's my brand mention inventory for 'BrandA' and 'BrandB' from last quarter — each row has a date, company_group, mention_count, and source_count. Give me a trailing mean series using a window of 10 and a date-by-category pivot on source_count so I can compare smoothed media reach side by side."},{"title":"Monthly brand monitoring summary","prompt":"I've got 150 rows of brand mention data across four company groups for November 2026. Run a trailing mean series with window size 4 on mention_count and produce a date-by-category pivot, so I can spot trends and see which groups were most active on which days."}],"resultDescription":"Two independent analytical reports: (1) a trailing mean time series showing smoothed values of the chosen field (mention_count or source_count) over the specified rolling window for each company group, and (2) a date-by-category pivot table cross-tabulating dates against company groups for the selected metric. Both reports are computed locally against the supplied data with no external lookups.","failureModes":["Missing required fields (row_id, company_group, date, mention_count, source_count) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","More than 200 rows submitted exceeds the row limit","Window size outside range 2–200 is rejected","Payment of 0.01 USDC not provided or fails x402 flow results in 402 response","Null numeric values may affect trailing mean computation depending on handling"],"whenToPreferThis":"Choose this endpoint when you have pre-collected brand mention inventory data (up to 200 rows) and need both a rolling/trailing mean time series and a date-by-category pivot in one low-cost call. Ideal for offline batch analytics on brand monitoring datasets where no live data retrieval or external enrichment is needed. Best when you want two complementary analytical views (trend smoothing + cross-tabulation) for mention_count or source_count in a single request.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T18:57:05.601Z","isFirstParty":false,"canonicalSlug":"brand-mention-inventories-trailing-mean-series-date-by-category-pivot-03d0234f"}