{"uid":"cap_jcKQY7tYOYCiilEpGtf4E","slug":"source-diversity-duplicate-key-report-secondary-measure-weighted-mean-03921c94","name":"Source Diversity Duplicate Key Report + Secondary-Measure Weighted Mean","description":"Source diversity — Duplicate key report + Secondary-measure weighted mean: Duplicate key report + Secondary-measure weighted mean for supplied source diversity records (source_count, outlet_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-news-17-067?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","channel_group","date","source_count","outlet_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"outlet_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"source_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"channel_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","outlet_count":1,"source_count":10,"channel_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","outlet_count":2,"source_count":20,"channel_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","outlet_count":3,"source_count":15,"channel_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","outlet_count":4,"source_count":30,"channel_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_count","outlet_count"],"type":"string","default":"source_count"}}},"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_zekE-wJyeslXXqgfix6yO","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":"Runs two local analytical reports on supplied source diversity data: a duplicate key report and a secondary-measure weighted mean, for up to 200 rows.","exampleAgentPrompt":"Can you run a duplicate key report and a weighted mean on my source diversity data? Here are the rows — each has a row_id, channel_group, date, source_count, and outlet_count — and I want the weighted mean calculated on source_count.","exampleUseCases":[{"title":"Duplicate detection in news source data","prompt":"I have a list of up to 200 news source diversity records with row IDs, channel groups, dates, source counts, and outlet counts. Can you check them for duplicate keys and also give me the weighted mean of source_count?"},{"title":"Outlet count weighted mean for media audit","prompt":"Run two reports on my media outlet diversity dataset — first flag any duplicate row IDs, and second compute the weighted mean of outlet_count across all my supplied rows grouped by channel_group."},{"title":"Channel group source diversity summary","prompt":"I need to analyze these source diversity records from my channel groups. Run a duplicate key check and a secondary-measure weighted mean on the source_count field for all 150 rows I'm sending you."}],"resultDescription":"Returns two analytical reports: (1) a duplicate key report identifying rows with repeated identifiers, and (2) a secondary-measure weighted mean of the selected field (source_count or outlet_count) computed across the supplied rows, covering up to 200 input rows with no external lookups or live data.","failureModes":["More than 200 rows submitted — exceeds the maxItems limit","Missing required fields (row_id, channel_group, date, source_count, outlet_count) in any row","Date field not matching YYYY-MM-DD pattern","Numeric values outside the allowed range (-1,000,000,000,000 to 1,000,000,000,000)","Invalid enum value for field parameter (must be source_count or outlet_count)","Empty rows array submitted"],"whenToPreferThis":"Choose this endpoint when you need two lightweight offline analytical reports — duplicate key detection and a weighted mean — on a batch of up to 200 source diversity records (source_count, outlet_count) without any external data lookup, live enrichment, or prediction. It is ideal when you already have structured source diversity data and need fast, local statistical summaries at minimal cost ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:49:24.427Z","isFirstParty":false,"canonicalSlug":"source-diversity-duplicate-key-report-secondary-measure-weighted-mean-03921c94"}