{"uid":"cap_usLq3wwIutCVrOfsJthJ2","slug":"partnership-pipeline-trailing-mean-series-base-100-series-3ad57ef2","name":"Partnership Pipeline — Trailing Mean Series + Base-100 Series","description":"Partnership pipeline — Trailing mean series + Base-100 series: Trailing mean series + Base-100 series for supplied partnership pipeline records (qualified_partners, active_partners). 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-09-147?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","qualified_partners","active_partners"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"active_partners":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"qualified_partners":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","active_partners":1,"qualified_partners":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","active_partners":2,"qualified_partners":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","active_partners":3,"qualified_partners":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","active_partners":4,"qualified_partners":30}],"maxItems":200,"minItems":1},"field":{"enum":["qualified_partners","active_partners"],"type":"string","default":"qualified_partners"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":0}}},"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_BbexJ_ZI0wE4Q1uGWGKAe","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 trailing moving-average series and base-100 index series for partnership pipeline metrics (qualified_partners, active_partners) from user-supplied row data.","exampleAgentPrompt":"Can you run a trailing mean and base-100 index analysis on my partnership pipeline data — I have qualified_partners and active_partners by date and company group, using a 4-period window and base index at position 0, and I want to analyze the qualified_partners field?","exampleUseCases":[{"title":"Cross-group partner pipeline benchmarking","prompt":"I have monthly qualified_partners and active_partners counts for three company groups over the past year — can you index them all to base 100 starting from January and also compute a 3-month trailing average so I can compare pipeline growth across groups?"},{"title":"Sales ops weekly partner trend smoothing","prompt":"Our sales ops team tracks active_partners and qualified_partners each week. Can you smooth out the noise with a 5-week rolling mean and also show me a base-100 series starting from week 1 so we can see the trend clearly?"},{"title":"Quarterly business review pipeline analytics","prompt":"For our QBR I need two views of our partner pipeline: a trailing 2-quarter mean and a base-100 indexed series for qualified_partners across our APAC and EMEA groups — here's the data with dates and row IDs, can you generate both reports?"}],"resultDescription":"Returns two independent analytical reports for the supplied partnership pipeline rows: (1) a trailing mean series showing the rolling average of the selected metric over the specified window, and (2) a base-100 series that re-indexes the selected metric relative to a chosen baseline row — both computed per row/date/company_group, covering up to 200 input records.","failureModes":["Fewer than 1 row supplied — request rejected","More than 200 rows supplied — exceeds maximum, request rejected","Missing required fields (row_id, date, company_group, qualified_partners, active_partners) — validation error","Date not in YYYY-MM-DD format — pattern validation failure","Window size less than 2 or greater than 200 — out of range error","base_index pointing beyond available row count — index out of bounds","Null numeric values may affect mean computation for affected windows","Payment of 0.01 USDC not received — request blocked"],"whenToPreferThis":"Choose this endpoint when you have already-collected partnership pipeline data (qualified_partners, active_partners) and need two specific analytical transforms — trailing moving average and base-100 normalization — applied in a single API call at very low cost. It is ideal for business development analysts who want smoothed trend lines and indexed comparison series without building their own analytics stack. Prefer this over generic BI tools when working inside an agent workflow that needs structured numeric output. Do not use this if you need live data lookup, forecasting, external data enrichment, or analysis of metrics beyond qualified_partners and active_partners.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:51.747Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-trailing-mean-series-base-100-series-3ad57ef2"}