{"uid":"cap_6PNFgP6jBKhznl_OP0cKE","slug":"join-coverage-analytics-exact-row-deduplication-two-measure-correlation-9602af43","name":"Join Coverage Analytics — Exact Row Deduplication + Two-Measure Correlation","description":"Join coverage — Exact row deduplication + Two-measure correlation: Exact row deduplication + 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-050?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_67-_vqtHqy83n2Cr38abs","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 exact rows and computes correlation between matched_rows and source_rows measures for up to 200 join coverage records, delivering two analytical reports in a single call.","exampleAgentPrompt":"I have join coverage records with matched_rows and source_rows values across groups — can you deduplicate the exact rows and run a correlation analysis between those two measures for my 4 rows: 2026-10-01 row-1 group-a matched=10 source=1, 2026-10-02 row-2 group-b matched=20 source=2, 2026-10-03 row-3 group-a matched=15 source=3, 2026-10-04 row-4 group-b matched=30 source=4?","exampleUseCases":[{"title":"ETL pipeline join quality audit","prompt":"I've got 50 rows of join coverage data from my ETL pipeline with matched_rows and source_rows per dataset group and date — please deduplicate any exact duplicate rows and tell me how correlated matched_rows and source_rows are across the whole dataset."},{"title":"Data warehouse coverage anomaly detection","prompt":"Can you run exact row deduplication and a two-measure correlation between matched_rows and source_rows on these 120 join coverage records from my data warehouse? I want to know if there are duplicate entries and how tightly the two counts track each other."},{"title":"Multi-group join coverage comparison","prompt":"I have join coverage records from three dataset groups over the past month — about 80 rows total with matched_rows and source_rows for each date. Can you deduplicate them and compute a correlation between those two measures so I can see if higher source row counts predict higher match rates?"}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing duplicate rows from the submitted join coverage records, and (2) a two-measure Pearson or equivalent correlation report quantifying the statistical relationship between matched_rows and source_rows across the supplied dataset. Both reports are computed locally on the submitted data with no external lookups.","failureModes":["Fewer than 1 or more than 200 rows submitted — validation error","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — schema validation failure","Date not matching YYYY-MM-DD format — pattern validation error","Numeric values outside allowed range (±1,000,000,000,000) — validation rejection","All rows are identical (degenerate deduplication case) — may return trivial deduplication result","Insufficient variance in matched_rows or source_rows for meaningful correlation — correlation may return NaN or undefined"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a two-measure correlation on join coverage data (matched_rows vs source_rows) in a single low-cost call. It is ideal for data engineering and ETL quality checks where you need to clean duplicates and quantify the relationship between match counts and source counts simultaneously, without sending data to an external ML or analytics platform. Prefer this over general-purpose analytics services when your data is already structured with row_id, dataset_group, date, matched_rows, and source_rows fields and you want deterministic local computation at minimal cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:54:29.963Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-exact-row-deduplication-two-measure-correlation-9602af43"}