{"uid":"cap_D4o2en0JC13f0zLmPVMgR","slug":"join-coverage-analytics-two-measure-correlation-keyed-dataset-e711a42e","name":"Join Coverage Analytics: Two-Measure Correlation + Keyed Dataset Comparison","description":"Join coverage — Two-measure correlation + Keyed dataset comparison: Two-measure correlation + 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-183?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},"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_9_oJxSb0MifDikKIJvtKY","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 analytical reports on join coverage data: a correlation analysis between matched_rows and source_rows, plus a keyed comparison between two supplied datasets, for up to 200 rows.","exampleAgentPrompt":"I have two sets of join coverage records — each row has a row_id, dataset_group, date, matched_rows, and source_rows — can you run a two-measure correlation between matched_rows and source_rows and also do a keyed comparison between the two datasets? Here's dataset 1 with rows like {row_id: 'run-1', dataset_group: 'orders', date: '2024-01-15', source_rows: 1000, matched_rows: 950} and dataset 2 with the same keys but slightly different matched_rows values.","exampleUseCases":[{"title":"ETL pipeline join quality check","prompt":"I ran my ETL join twice — once last week and once today — and I want to compare the join coverage results side by side. Both datasets have row_id, dataset_group, date, matched_rows, and source_rows. Can you do a keyed comparison between them and also tell me if matched_rows and source_rows are correlated within each run?"},{"title":"Data warehouse join coverage audit","prompt":"I have 150 rows of join coverage metrics from our data warehouse pipeline, split across two dataset groups. Each row has a date, row_id, source_rows, and matched_rows. Please run a correlation analysis between source_rows and matched_rows, and compare this week's dataset against last week's dataset by key."},{"title":"Cross-group join performance comparison","prompt":"We have two snapshots of join coverage data — group-a and group-b — from different dates, each with matched_rows and source_rows per row. Can you correlate matched_rows with source_rows across both snapshots and then do a keyed dataset comparison between snapshot 1 and snapshot 2 to highlight where numbers diverged?"}],"resultDescription":"Returns two independent analytical reports: (1) a two-measure correlation report quantifying the statistical relationship between matched_rows and source_rows across the supplied rows, and (2) a keyed dataset comparison report highlighting differences between the primary and secondary datasets matched by row_id and dataset_group. All analysis is performed locally on the supplied data with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","Numeric values outside allowed range (±1 trillion) — rejection","Empty rows array (minItems: 1 violated) — error","Malformed JSON body — 400 bad request","Payment not included or insufficient — 402 payment required"],"whenToPreferThis":"Choose this endpoint when you need both a correlation analysis and a keyed dataset comparison on join coverage data (matched_rows, source_rows) in a single $0.01 call covering up to 200 rows. It is ideal for data engineers auditing ETL join quality, comparing two pipeline run snapshots, or measuring how source row counts relate to matched row counts across dataset groups. Prefer it over single-report endpoints when you need two complementary analyses on the same join coverage data in one request.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:45.132Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-two-measure-correlation-keyed-dataset-e711a42e"}