{"uid":"cap_WPQcBkkmNWTk2UyoYOKkR","slug":"join-coverage-daily-sum-secondary-measure-weighted-mean-analytics-e8c594d8","name":"Join Coverage Daily Sum + Secondary-Measure Weighted Mean Analytics","description":"Join coverage — Daily sum series + Secondary-measure weighted mean: Daily sum series + 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-142?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_q6-MKp3uKShOssoBnKySx","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 a daily sum series and a secondary-measure weighted mean for supplied join coverage records (matched_rows, source_rows) across up to 200 rows in two independent reports.","exampleAgentPrompt":"I have join coverage records for group-a and group-b across October 2026 — can you run a daily sum series plus a weighted mean on matched_rows for these four rows: row-1 on 2026-10-01 with source_rows=1 and matched_rows=10, row-2 on 2026-10-02 with source_rows=2 and matched_rows=20, row-3 on 2026-10-03 with source_rows=3 and matched_rows=15, row-4 on 2026-10-04 with source_rows=4 and matched_rows=30?","exampleUseCases":[{"title":"Daily ETL join coverage review","prompt":"I've got daily join coverage data for two dataset groups across last week — run me a daily sum series and weighted mean on matched_rows for these 7 rows so I can see where our join rates peaked and what the weighted average looks like."},{"title":"Source row aggregation for data audit","prompt":"Here are 50 join coverage records by date and dataset group — I need the daily sum series for source_rows and a secondary-measure weighted mean, so I can audit how many source rows we processed each day relative to matches."},{"title":"Multi-group coverage trend analysis","prompt":"I have join coverage records from three dataset groups across a full month, about 120 rows total — give me the daily sum series and secondary-measure weighted mean for matched_rows so I can spot coverage trends across groups over time."}],"resultDescription":"Two independent analytical reports: (1) a daily sum series showing the total of the selected field (matched_rows or source_rows) per date, and (2) a secondary-measure weighted mean across the supplied join coverage records. Results are computed locally from the supplied data with no external lookup.","failureModes":["More than 200 rows supplied — request rejected due to maxItems constraint","Missing required fields (row_id, date, dataset_group, matched_rows, source_rows) on any row — validation error","Date field not matching YYYY-MM-DD pattern — schema validation failure","Numeric values outside allowed range (±1,000,000,000,000) — validation error","Empty rows array — minItems constraint violation"],"whenToPreferThis":"Choose this endpoint when you have tabular join coverage data (matched_rows, source_rows) with date and group labels and need both a daily sum aggregation and a weighted mean in a single paid call. Ideal for data quality pipelines, ETL monitoring, and dataset reconciliation workflows where you want two complementary statistical summaries computed from your own supplied data without any external data access or live lookup.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:54:26.733Z","isFirstParty":false,"canonicalSlug":"join-coverage-daily-sum-secondary-measure-weighted-mean-analytics-e8c594d8"}