{"uid":"cap_OVcgwG1Wf5USvlCGp_Sc6","slug":"join-coverage-analytics-weighted-mean-dataset-comparison-41c802ad","name":"Join Coverage Analytics: Weighted Mean + Dataset Comparison","description":"Join coverage — Secondary-measure weighted mean + Keyed dataset comparison: Secondary-measure weighted mean + Keyed dataset comparison 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-186?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"},"other":{"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":21,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_rows":3,"matched_rows":17,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_rows":4,"matched_rows":33,"dataset_group":"group-b"}],"maxItems":200,"minItems":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_CazpRf7tEO5lGn5Nn6wur","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 a secondary-measure weighted mean and performs a keyed dataset comparison for join coverage records (matched_rows, source_rows) across two supplied datasets.","exampleAgentPrompt":"Can you compute a weighted mean of matched_rows (weighted by source_rows) and compare two sets of join coverage records — the primary dataset has rows like group-a on 2026-10-01 with 1 source row and 10 matched rows, and I have a second dataset with slightly different matched_row counts for the same keys?","exampleUseCases":[{"title":"ETL pipeline join quality audit","prompt":"I have two runs of our ETL pipeline producing join coverage stats — each with row_id, dataset_group, date, source_rows, and matched_rows. Can you compute the weighted mean of matched_rows for both runs and compare them side by side to see where coverage diverged?"},{"title":"Dataset group coverage drift detection","prompt":"We track join coverage daily across group-a and group-b. Here are this week's records and last week's records — can you compute the source-row-weighted mean of matched_rows for each dataset and flag where the two differ significantly?"},{"title":"Data migration coverage validation","prompt":"After migrating our data warehouse, I want to verify that matched_rows counts are consistent before and after. I have two sets of up to 200 rows with row_id, date, dataset_group, source_rows, and matched_rows — run a weighted mean and keyed comparison on both, please."}],"resultDescription":"Returns two independent analytical reports: (1) a secondary-measure weighted mean of the selected field (matched_rows or source_rows), where the other measure acts as the weight, computed over the supplied rows; and (2) a keyed dataset comparison between the primary rows and the secondary 'other' rows, identifying differences by row_id, dataset_group, and date. Both reports are computed locally with no external data access.","failureModes":["Fewer than 1 row supplied returns a validation error","More than 200 rows supplied exceeds the row limit","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) causes schema rejection","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","Null values in both matched_rows and source_rows may produce undefined weighted mean results","Mismatched keys between primary and secondary datasets may result in sparse comparison output"],"whenToPreferThis":"Use this endpoint when you need both a weighted mean calculation and a keyed side-by-side dataset comparison for join coverage data (matched_rows, source_rows) in a single $0.01 call, without needing live lookups or external enrichment. It is ideal for data engineers validating ETL join quality, comparing pipeline runs, or auditing coverage drift across dataset groups with up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T00:56:14.236Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-weighted-mean-dataset-comparison-41c802ad"}