{"uid":"cap_KCwcCmgqnrDMUNdbhmLhd","slug":"membership-activity-daily-sum-series-2940de5d","name":"Membership Activity Daily Sum Series","description":"Membership activity - Daily sum series: Daily sum series for Membership activity. 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-membership-date-series?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","tier","date","members","renewals"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"tier":{"type":"string","default":"","maxLength":80},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"members":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"renewals":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","tier":"group-a","row_id":"row-1","members":10,"renewals":1},{"date":"2026-10-02","tier":"group-b","row_id":"row-2","members":20,"renewals":2},{"date":"2026-10-03","tier":"group-a","row_id":"row-3","members":15,"renewals":3},{"date":"2026-10-04","tier":"group-b","row_id":"row-4","members":30,"renewals":4}],"maxItems":200,"minItems":1},"field":{"enum":["members","renewals"],"type":"string","default":"members"}}},"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_FKosWsqqNg0MIv2AmCxeP","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 series for membership activity (members or renewals) across typed records, grouped by tier and date, with local data-quality processing.","exampleAgentPrompt":"Take these membership records for tiers group-a and group-b across October 2026 and compute the daily sum series for the members field — I have 4 rows with row IDs row-1 through row-4, dates from 2026-10-01 to 2026-10-04, and member counts of 10, 20, 15, and 30 respectively.","exampleUseCases":[{"title":"Daily member count rollup by tier","prompt":"I have 50 daily membership records across two tiers — 'premium' and 'standard' — with dates from 2026-09-01 to 2026-10-20 and member counts for each day. Can you compute the daily sum series for the members field so I can see total members per day?"},{"title":"Daily renewal totals for retention reporting","prompt":"Here are 120 membership activity rows spanning three tiers for Q3 2026, each with a renewal count. Can you aggregate these into a daily sum series for the renewals field so I can see how many renewals happened each day?"},{"title":"Membership trend data for dashboard","prompt":"I need to prepare a daily time series of member counts from these 80 records tagged with tier 'enterprise' covering 2026-07-01 through 2026-09-30 — can you run the daily sum series computation on the members field?"}],"resultDescription":"Returns a daily sum series where each data point represents the aggregated total of the selected field (members or renewals) for each date, based on up to 200 input records. Includes local numeric processing and data-quality checks with no external enrichment or forecasting.","failureModes":["Input array exceeds 200 rows — request rejected with validation error","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Missing required fields (row_id, tier, date, members, renewals) causes item-level rejection","Invalid field enum value (not 'members' or 'renewals') returns validation error","Empty rows array (minItems: 1 violated) causes request failure","Numeric values outside allowed range (-1e12 to 1e12) rejected"],"whenToPreferThis":"Choose this endpoint when you need to aggregate raw membership activity records (members or renewals) into a clean daily sum time series, grouped by date across up to 200 typed rows. It is ideal for subscription analytics, membership dashboards, and retention reporting where local computation without external enrichment is sufficient and cost-efficiency matters.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T18:48:49.231Z","isFirstParty":false,"canonicalSlug":"membership-activity-daily-sum-series-2940de5d"}