{"uid":"cap_2s9gCwkoEAAKdP1tiExzf","slug":"join-coverage-analytics-exact-row-deduplication-secondary-measure-da24e1fc","name":"Join Coverage Analytics: Exact Row Deduplication + Secondary-Measure Weighted Mean","description":"Join coverage — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean for supplied join coverage records (matched_rows, source_rows). 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-analytics-09-051?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","matched_rows","source_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"matched_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_rows":1,"matched_rows":10,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_rows":2,"matched_rows":20,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":15,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":30,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["matched_rows","source_rows"],"type":"string","default":"matched_rows"}}},"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_NkXz9vFGLL6Dzu55ZyiJZ","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 join coverage records by exact row and computes a secondary-measure weighted mean over matched_rows and source_rows fields, returning two analytical reports for up to 200 supplied rows.","exampleAgentPrompt":"I have 4 join coverage records for groups 'group-a' and 'group-b' dated 2026-10-01 through 2026-10-04 — can you deduplicate them exactly and give me the weighted mean for the matched_rows field? The rows are: row-1 (source=1, matched=10), row-2 (source=2, matched=20), row-3 (source=3, matched=15), row-4 (source=4, matched=30).","exampleUseCases":[{"title":"ETL pipeline join coverage audit","prompt":"I've got 50 join coverage records from our ETL pipeline across two dataset groups — can you deduplicate them exactly and calculate the weighted mean of matched_rows so I can see our overall match rate?"},{"title":"Source row reconciliation across date range","prompt":"We have join coverage data for dataset groups 'sales' and 'returns' from October 2026, about 120 rows — please deduplicate and give me the weighted mean for source_rows so I can reconcile the numbers."},{"title":"Data quality check for matched row counts","prompt":"Before I trust our join results, can you take these 80 join coverage records for group 'orders' and run exact deduplication plus a weighted mean on matched_rows to flag any inconsistencies?"}],"resultDescription":"Returns two analytical reports: (1) the exactly deduplicated set of join coverage rows, and (2) the weighted mean of the specified secondary measure (matched_rows or source_rows) computed across the supplied records. Both reports are produced locally using shared analytical engines with no external lookups.","failureModes":["More than 200 rows submitted — endpoint rejects input exceeding maxItems limit","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — validation error","Date field not matching YYYY-MM-DD pattern — schema validation failure","Null or out-of-range numeric values for matched_rows or source_rows — may produce null in weighted mean","Invalid field enum value (not 'matched_rows' or 'source_rows') — rejected by schema","Empty rows array (minItems: 1 not met) — validation error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 join coverage records (matched_rows, source_rows) and need both exact row deduplication and a weighted mean aggregation in a single paid call. It is ideal for data engineers auditing ETL pipeline join quality, reconciling matched vs. source row counts across dataset groups, or producing summary statistics without any external data lookups or model predictions. At $0.01 USDC per call yielding two reports, it is cost-effective for lightweight analytical needs on supplied data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-11T12:48:33.794Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-exact-row-deduplication-secondary-measure-da24e1fc"}