{"uid":"cap_wwFBkojugPrZk-gz5tpxL","slug":"join-coverage-two-measure-correlation-and-secondary-measure-weighted-c2162f1e","name":"Join Coverage Two-Measure Correlation and Secondary-Measure Weighted Mean","description":"Join coverage — Two-measure correlation + Secondary-measure weighted mean: Two-measure correlation + 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-181?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_tM_5nXbsZ4ggiIsM9b_q4","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 Pearson/rank correlation between matched_rows and source_rows, plus a weighted mean of a selected secondary measure, for up to 200 join coverage records.","exampleAgentPrompt":"I have join coverage records for two dataset groups — can you run the two-measure correlation between matched_rows and source_rows, plus the weighted mean for matched_rows, across these 4 rows: row-1 on 2026-10-01 with source_rows=1 and matched_rows=10 in group-a, row-2 on 2026-10-02 with source_rows=2 and matched_rows=20 in group-b, row-3 on 2026-10-03 with source_rows=3 and matched_rows=15 in group-a, and row-4 on 2026-10-04 with source_rows=4 and matched_rows=30 in group-b?","exampleUseCases":[{"title":"ETL pipeline join quality audit","prompt":"I have 50 rows of join coverage data from my nightly ETL run — can you compute the correlation between matched_rows and source_rows and also give me the weighted mean of matched_rows so I can see if my join rate is consistent across dataset groups?"},{"title":"Data warehouse coverage trend analysis","prompt":"Here are 120 join coverage records from our data warehouse spanning October; please run the two-measure correlation and weighted mean report on source_rows using matched_rows as the weight column, grouped by dataset_group."},{"title":"Cross-group match rate comparison","prompt":"I need to compare join match quality between group-a and group-b — can you calculate the correlation between source_rows and matched_rows plus the weighted mean of source_rows for all these records?"}],"resultDescription":"Returns two independent analytical reports: (1) a correlation coefficient measuring the linear relationship between matched_rows and source_rows across supplied rows, and (2) a weighted mean of the selected field (matched_rows or source_rows) — both computed locally without external lookups, covering up to 200 input rows.","failureModes":["More than 200 rows supplied — request exceeds maxItems limit and will be rejected","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — validation error returned","Date strings not matching YYYY-MM-DD pattern — schema validation failure","Null values in both measure columns for all rows — correlation computation may be undefined or return NaN","Invalid field enum value (not 'matched_rows' or 'source_rows') — schema rejection"],"whenToPreferThis":"Choose this endpoint when you need simultaneous statistical analysis of join coverage data — specifically both a correlation between matched and source row counts and a weighted mean of one measure — in a single paid call. Ideal for data engineers auditing ETL pipeline join quality, analysts checking data completeness ratios, or any workflow needing lightweight local statistical computation on up to 200 join coverage observations without external data lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:44.548Z","isFirstParty":false,"canonicalSlug":"join-coverage-two-measure-correlation-and-secondary-measure-weighted-c2162f1e"}