{"uid":"cap_Yx8ZUbGbE8JI7t1w-QJrL","slug":"join-coverage-analytics-adjacent-row-changes-secondary-measure-b58ad3e6","name":"Join Coverage Analytics: Adjacent Row Changes + Secondary-Measure Weighted Mean","description":"Join coverage — Adjacent row changes + Secondary-measure weighted mean: Adjacent row changes + 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-159?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_no5cKFL9Klmjw-V5M72IB","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 two analytical reports on join coverage data: adjacent row-to-row changes and a secondary-measure weighted mean, given matched_rows and source_rows per record.","exampleAgentPrompt":"Analyze my join coverage data for the group-a and group-b datasets from October 1–4, 2026 — I have matched_rows and source_rows for each date — and give me both the adjacent row changes and a weighted mean report on matched_rows.","exampleUseCases":[{"title":"ETL pipeline join quality audit","prompt":"I have 4 days of join coverage records for my ETL pipeline across two dataset groups, with matched_rows and source_rows per day. Can you run the adjacent row changes and weighted mean analysis on matched_rows so I can see where coverage dropped?"},{"title":"Data warehouse coverage drift detection","prompt":"Here are 10 daily join coverage snapshots for my data warehouse tables — row_id, date, dataset_group, matched_rows, and source_rows all filled in. Run both the adjacent-change and weighted-mean reports on source_rows so I can spot any drift."},{"title":"Multi-group join rate comparison","prompt":"I've got join coverage logs across three dataset groups for the past week. Can you compute the adjacent row-to-row changes plus a secondary weighted mean on matched_rows so I can compare coverage stability across groups?"}],"resultDescription":"Returns two analytical reports: (1) adjacent row changes showing period-over-period differences in the selected metric (matched_rows or source_rows), and (2) a secondary-measure weighted mean summarizing the coverage metric across the supplied rows, grouped by dataset context. Up to 200 rows processed per call.","failureModes":["Missing required fields (row_id, date, matched_rows, source_rows, dataset_group) returns a validation error","Submitting more than 200 rows exceeds the maxItems limit and is rejected","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Null values for both matched_rows and source_rows may produce incomplete or undefined calculations","Submitting fewer than 1 row (empty array) is rejected","Invalid field enum value (anything other than matched_rows or source_rows) causes rejection"],"whenToPreferThis":"Choose this endpoint when you have tabular join coverage data with matched_rows and source_rows and need both a sequential delta analysis and a weighted mean summary in a single paid call. Ideal for data engineers validating ETL pipeline join rates, analysts monitoring coverage drift, or QA workflows checking join quality across dataset groups. Best for batch sizes up to 200 rows where no external data lookup or prediction is needed — purely local computation on your supplied data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:46.963Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-adjacent-row-changes-secondary-measure-b58ad3e6"}