{"uid":"cap_9Y8KqkgdNtJ6djJK_taG9","slug":"membership-activity-secondary-measure-weighted-mean-13aa6452","name":"Membership Activity Secondary-Measure Weighted Mean","description":"Membership activity - Secondary-measure weighted mean: Secondary-measure weighted mean 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 secondary-measure weighted mean deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-membership-weighted-average?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_qXXPgmjwxWypv461MkCK_","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 secondary-measure weighted mean (e.g. members weighted by renewals) across up to 200 membership activity records, grouped by tier and date.","exampleAgentPrompt":"Calculate the renewals-weighted mean of member counts for these membership records: row-1 on 2026-10-01 tier group-a with 10 members and 1 renewal, row-2 on 2026-10-02 tier group-b with 20 members and 2 renewals, row-3 on 2026-10-03 tier group-a with 15 members and 3 renewals — use members as the target field.","exampleUseCases":[{"title":"Weighted member count across subscription tiers","prompt":"I have daily membership data for our two subscription tiers over the past quarter — can you calculate the renewals-weighted mean of member counts? Here are the rows: row-1 2026-10-01 tier premium 500 members 45 renewals, row-2 2026-10-02 tier basic 1200 members 80 renewals, row-3 2026-10-03 tier premium 520 members 50 renewals. Use members as the field."},{"title":"Renewal-activity weighted average for churn analysis","prompt":"For our churn analysis, compute the weighted mean of renewals across these membership records, weighted by member count: row-1 2026-11-01 group-a 300 members 30 renewals, row-2 2026-11-02 group-b 450 members 55 renewals, row-3 2026-11-03 group-a 280 members 22 renewals. Set field to renewals."},{"title":"Monthly membership metric aggregation by tier","prompt":"Can you run a secondary-measure weighted mean on our monthly membership snapshot? I have 4 records — row-1 2026-12-01 tier silver 800 members 60 renewals, row-2 2026-12-01 tier gold 200 members 40 renewals, row-3 2026-12-02 tier silver 820 members 65 renewals, row-4 2026-12-02 tier gold 210 members 42 renewals — target the members field."}],"resultDescription":"Returns a single weighted mean value computed from the supplied membership activity records, where one numeric field (members or renewals) is averaged using the other as the weight, across up to 200 typed rows with tier and date dimensions.","failureModes":["Missing required fields (row_id, tier, date, members, renewals) returns validation error","More than 200 rows submitted exceeds maxItems limit","Invalid date format (not YYYY-MM-DD) fails pattern validation","Non-numeric values in members or renewals fields cause type errors","Empty rows array (minItems:1 violated) returns error","Invalid field enum value (not 'members' or 'renewals') rejected"],"whenToPreferThis":"Choose this endpoint when you need a statistically sound weighted mean for membership activity data — specifically when one membership metric (e.g. member count) should be averaged with another metric (e.g. renewals) serving as the weight. Ideal for subscription analytics, churn reporting, and tier-level aggregation with up to 200 records processed locally without external enrichment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T18:48:47.143Z","isFirstParty":false,"canonicalSlug":"membership-activity-secondary-measure-weighted-mean-13aa6452"}