{"uid":"cap_JBt-r02m719Skd6MZKIvS","slug":"join-coverage-record-quality-audit-and-two-measure-correlation-5f429b37","name":"Join Coverage Record Quality Audit and Two-Measure Correlation","description":"Join coverage — Record quality audit + Two-measure correlation: Record quality audit + Two-measure correlation 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-015?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}}},"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_SMrxbPIY_2eSHs6VKlLOc","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":"Audits record quality and computes two-measure correlation for join coverage data (matched_rows, source_rows) across up to 200 supplied rows, producing two independent analytical reports.","exampleAgentPrompt":"Can you audit the quality of these join coverage records and check the correlation between matched_rows and source_rows? I have 4 rows across groups 'group-a' and 'group-b' from October 2026 — row-1 has source_rows=1 and matched_rows=10, row-2 has source_rows=2 and matched_rows=20, row-3 has source_rows=3 and matched_rows=15, row-4 has source_rows=4 and matched_rows=30.","exampleUseCases":[{"title":"ETL pipeline join quality audit","prompt":"I have daily ETL join results for the past week across two dataset groups — can you run a record quality audit and correlation check on the matched_rows versus source_rows for all 7 days? Here are the records with their row IDs, dates, and group names."},{"title":"Data team join coverage health check","prompt":"We're seeing some weird join behavior in our data warehouse. Can you audit these 20 join coverage records for quality issues and tell me how correlated matched_rows and source_rows are across our 'customers' and 'orders' dataset groups from November 2025?"},{"title":"Monthly join performance review","prompt":"At end of month I want to review join coverage quality — please analyze these 50 rows of matched_rows and source_rows data from October 2026 across our dataset groups and give me both a quality audit and a correlation report."}],"resultDescription":"Returns two independent analytical reports: (1) a record quality audit highlighting missing values, anomalies, and completeness issues across the supplied join coverage rows, and (2) a two-measure correlation analysis between matched_rows and source_rows across the dataset. No external lookups or predictions are made; analysis is performed locally on the supplied data only.","failureModes":["More than 200 rows submitted — request rejected due to maxItems limit","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — validation error","Invalid date format (must match YYYY-MM-DD pattern) — schema validation failure","Numeric values outside allowed range (±1,000,000,000,000) — schema rejection","Empty rows array — minItems:1 violation","Payment not included or insufficient — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you have join coverage data with matched_rows and source_rows metrics and need both a record quality audit and a correlation analysis in a single call at low cost ($0.01 USDC). Ideal for data engineers and analysts who want offline, local analytical processing of up to 200 rows without any external lookups or live data access. Best when you already have the join coverage records in hand and need structured quality and correlation reports quickly.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:46.367Z","isFirstParty":false,"canonicalSlug":"join-coverage-record-quality-audit-and-two-measure-correlation-5f429b37"}