{"uid":"cap_67XmYztdojpJ6thWFAqpZ","slug":"creative-review-numeric-interval-filter-secondary-measure-weighted-mean-52d312d0","name":"Creative Review — Numeric Interval Filter + Secondary-Measure Weighted Mean","description":"Creative review — Numeric interval filter + Secondary-measure weighted mean: Numeric interval filter + Secondary-measure weighted mean for supplied creative review records (feedback_count, approved_items). 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-creative-25-132?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","feedback_count","approved_items"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"asset_group":{"type":"string","default":"","maxLength":80},"approved_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"feedback_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","approved_items":1,"feedback_count":10},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","approved_items":2,"feedback_count":20},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","approved_items":3,"feedback_count":15},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","approved_items":4,"feedback_count":30}],"maxItems":200,"minItems":1},"field":{"enum":["feedback_count","approved_items"],"type":"string","default":"feedback_count"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_MM0vK2sRyTu-GEoTC0B1M","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":"Filters creative review records (feedback_count, approved_items) by a numeric interval and computes a secondary-measure weighted mean, returning two analytical reports for up to 200 supplied rows.","exampleAgentPrompt":"I have creative review records with feedback_count and approved_items for several asset groups — can you filter the rows where feedback_count is between 5 and 50, then compute the weighted mean of approved_items across those filtered records?","exampleUseCases":[{"title":"Filter low-engagement creative reviews","prompt":"I have 150 creative review rows with feedback_count and approved_items. Can you filter out only the records where feedback_count falls between 10 and 80, then give me the weighted mean of approved_items for those filtered rows?"},{"title":"Weighted mean for approved items by asset group","prompt":"Here's my creative review dataset — I need to keep only the rows where approved_items is between 2 and 100, and then calculate the secondary-measure weighted mean of feedback_count for that filtered subset."},{"title":"Quality review interval analysis","prompt":"I'm reviewing creative asset performance and want to focus on records where feedback_count is between 0 and 30. Can you filter my dataset to that range and compute a weighted mean of approved_items so I can see how approval rates look for lower-feedback creatives?"}],"resultDescription":"Returns two analytical reports: (1) rows from the supplied creative review dataset whose specified field (feedback_count or approved_items) falls within the given [minimum, maximum] interval, and (2) a secondary-measure weighted mean computed over those filtered rows — all derived locally from the supplied data with no external lookups.","failureModes":["Empty rows array or fewer than 1 row supplied returns an error","Rows exceeding 200 items will be rejected","Invalid date format (not YYYY-MM-DD) causes row validation failure","Minimum value greater than maximum value may return empty filtered result set","Missing required row fields (row_id, asset_group, date, feedback_count, approved_items) causes schema validation error","Non-numeric values for feedback_count or approved_items may cause computation errors"],"whenToPreferThis":"Choose this endpoint when you have up to 200 creative review records with feedback_count and approved_items fields and need to simultaneously filter rows by a numeric range AND compute a weighted mean of the secondary measure — all in one $0.01 call. Prefer this over generic analytics services when your domain is specifically creative review or digital asset approval workflows and you need both filtering and weighted aggregation delivered as two reports in a single request.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:39:57.730Z","isFirstParty":false,"canonicalSlug":"creative-review-numeric-interval-filter-secondary-measure-weighted-mean-52d312d0"}