{"uid":"cap_83LlCjxBouecVkBkgF40t","slug":"join-coverage-analytics-grouped-numeric-summary-daily-sum-series-9d0571a1","name":"Join Coverage Analytics: Grouped Numeric Summary + Daily Sum Series","description":"Join coverage — Grouped numeric summary + Daily sum series: Grouped numeric summary + Daily sum series 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-089?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_fSIE-rS8D8PV14nMGJY-2","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 grouped numeric summary and a daily sum time series for join coverage data (matched_rows, source_rows) across up to 200 supplied rows.","exampleAgentPrompt":"Can you run grouped summary and daily sum series reports on my join coverage data? Here are 4 records: row-1 on 2026-10-01 with matched_rows=10 and source_rows=1 for group-a, row-2 on 2026-10-02 with matched_rows=20 and source_rows=2 for group-b, row-3 on 2026-10-03 with matched_rows=15 and source_rows=3 for group-a, row-4 on 2026-10-04 with matched_rows=30 and source_rows=4 for group-b — analyze the matched_rows field.","exampleUseCases":[{"title":"ETL pipeline join coverage audit","prompt":"I have daily join coverage logs for two dataset groups over the past week — can you give me a grouped numeric summary and daily sum series for matched_rows? Here are the records: row-1 on 2026-10-01, matched_rows=10, source_rows=100, group-a; row-2 on 2026-10-02, matched_rows=15, source_rows=110, group-a; row-3 on 2026-10-01, matched_rows=8, source_rows=90, group-b; row-4 on 2026-10-02, matched_rows=12, source_rows=95, group-b."},{"title":"Source row volume trend by group","prompt":"Can you compute the daily sum series and grouped summary for source_rows across these 5 join coverage records? row-1 on 2026-11-01, source_rows=500, matched_rows=450, group-finance; row-2 on 2026-11-02, source_rows=600, matched_rows=580, group-finance; row-3 on 2026-11-01, source_rows=300, matched_rows=290, group-ops; row-4 on 2026-11-02, source_rows=350, matched_rows=340, group-ops; row-5 on 2026-11-03, source_rows=400, matched_rows=385, group-ops — use the source_rows field."},{"title":"Data quality monitoring for nightly joins","prompt":"Every night our pipeline produces join coverage records — here are last night's 3 records and I need a grouped numeric summary plus daily sum series for matched_rows: row-1 on 2026-12-01, matched_rows=200, source_rows=210, dataset_group=customers; row-2 on 2026-12-01, matched_rows=180, source_rows=195, dataset_group=orders; row-3 on 2026-12-01, matched_rows=90, source_rows=100, dataset_group=inventory."}],"resultDescription":"Returns two independent analytical reports: (1) a grouped numeric summary breaking down the selected field (matched_rows or source_rows) by dataset_group, including descriptive statistics; and (2) a daily sum time series showing the total of the selected field aggregated by date across all supplied rows. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","Supplying more than 200 rows exceeds the maxItems limit and is rejected","Null numeric values may be excluded from aggregations or cause incomplete statistics","Empty rows array (minItems:1 violated) returns an error","Invalid field enum value (not 'matched_rows' or 'source_rows') causes a validation error"],"whenToPreferThis":"Choose this endpoint when you have join coverage records with matched_rows and source_rows fields and need both a group-level numeric summary and a date-level daily sum series in a single call. It is ideal for data engineers or analytics pipelines monitoring ETL join quality across dataset groups over time. Prefer it over general-purpose analytics tools when you need a quick, low-cost ($0.01 USDC) dual-report output on up to 200 supplied rows without needing live data lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:34.538Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-grouped-numeric-summary-daily-sum-series-9d0571a1"}