{"uid":"cap_FKBNxtqcv5e6ja5TeyYAu","slug":"newsroom-assignments-exact-row-deduplication-secondary-measure-e6e92eec","name":"Newsroom Assignments — Exact Row Deduplication + Secondary-Measure Weighted Mean","description":"Newsroom assignments — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean for supplied newsroom assignments records (assigned_items, completed_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-news-03-051?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","channel_group","date","assigned_items","completed_items"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"channel_group":{"type":"string","default":"","maxLength":80},"assigned_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","channel_group":"group-a","assigned_items":10,"completed_items":1},{"date":"2026-10-02","row_id":"row-2","channel_group":"group-b","assigned_items":20,"completed_items":2},{"date":"2026-10-03","row_id":"row-3","channel_group":"group-a","assigned_items":15,"completed_items":3},{"date":"2026-10-04","row_id":"row-4","channel_group":"group-b","assigned_items":30,"completed_items":4}],"maxItems":200,"minItems":1},"field":{"enum":["assigned_items","completed_items"],"type":"string","default":"assigned_items"}}},"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_4s8yWjFIxN8pNszNRLMUk","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":"Deduplicates newsroom assignment rows and computes a secondary-measure weighted mean across assigned_items or completed_items data, producing two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you deduplicate these newsroom assignment records and compute the weighted mean for completed_items across channel groups? I have 4 rows: row-1 on 2026-10-01 for group-a with 10 assigned and 1 completed, row-2 on 2026-10-02 for group-b with 20 assigned and 2 completed, row-3 on 2026-10-03 for group-a with 15 assigned and 3 completed, and row-4 on 2026-10-04 for group-b with 30 assigned and 4 completed.","exampleUseCases":[{"title":"Editorial team daily assignment audit","prompt":"I have daily newsroom assignment logs for our two channel groups for last week — can you deduplicate any repeated rows and give me a weighted mean on assigned_items? Here are the records: row-1, 2026-10-01, group-a, 10 assigned, 1 completed; row-2, 2026-10-02, group-b, 20 assigned, 2 completed; row-3, 2026-10-03, group-a, 15 assigned, 3 completed."},{"title":"Completed items performance analysis","prompt":"Run a deduplication and weighted mean analysis on completed_items for these newsroom assignment records — I want to see both a clean deduplicated report and the weighted mean summary: row-1, 2026-10-01, group-a, 50 assigned, 40 completed; row-2, 2026-10-02, group-b, 80 assigned, 60 completed; row-3, 2026-10-01, group-a, 50 assigned, 40 completed (possible duplicate)."},{"title":"Multi-channel assignment load balancing review","prompt":"Can you process these 5 newsroom assignment rows across group-a and group-b, deduplicate exact repeats, and compute the weighted mean for assigned_items? row-1 2026-10-01 group-a 100 assigned 80 completed, row-2 2026-10-02 group-b 200 assigned 150 completed, row-3 2026-10-03 group-a 120 assigned 90 completed, row-4 2026-10-04 group-b 180 assigned 130 completed, row-5 2026-10-04 group-b 180 assigned 130 completed."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing duplicate rows from the supplied newsroom assignment records, and (2) a secondary-measure weighted mean report computing a weighted average across the chosen measure field (assigned_items or completed_items), both derived purely from the supplied data with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, channel_group, date, assigned_items, completed_items) causes rejection","Invalid date format (non-YYYY-MM-DD) fails schema validation","Numeric values outside ±1,000,000,000,000 are rejected","Empty rows array (minItems:1 violated) returns an error","Invalid field enum value (not assigned_items or completed_items) causes failure"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a weighted mean computation on newsroom assignment data (assigned_items or completed_items) in a single call. It is ideal for editorial operations teams cleaning assignment logs and needing a statistical summary without building custom data pipelines. Best suited for datasets of up to 200 rows where both reports are needed together at low cost ($0.01 USDC for both).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:51:46.807Z","isFirstParty":false,"canonicalSlug":"newsroom-assignments-exact-row-deduplication-secondary-measure-e6e92eec"}