{"uid":"cap_Ptj8eLwjd897ydaCOo4fR","slug":"join-coverage-analytics-grouped-numeric-summary-date-by-category-pivot-8663f31d","name":"Join Coverage Analytics — Grouped Numeric Summary & Date-by-Category Pivot","description":"Join coverage — Grouped numeric summary + Date by category pivot: Grouped numeric summary + Date by category pivot 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-097?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_A32AVzkwmq47lAGiCLXMd","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":"Generates two statistical reports on join coverage data: a grouped numeric summary and a date-by-category pivot for matched_rows and source_rows metrics.","exampleAgentPrompt":"Analyze my join coverage data for group-a and group-b across October 2026 — give me a grouped numeric summary and a date-by-category pivot for matched_rows, using these 4 records: row-1 (2026-10-01, group-a, 10 matched, 1 source), row-2 (2026-10-02, group-b, 20 matched, 2 source), row-3 (2026-10-03, group-a, 15 matched, 3 source), row-4 (2026-10-04, group-b, 30 matched, 4 source).","exampleUseCases":[{"title":"ETL pipeline coverage audit","prompt":"I have 50 join coverage records from last week's pipeline run across three dataset groups — can you give me a grouped numeric summary and a date pivot on matched_rows so I can see which groups are underperforming?"},{"title":"Daily join quality trend report","prompt":"Generate a date-by-category pivot and grouped summary of source_rows for my join coverage data from November 2026 — I need to spot any days where coverage dropped across my dataset groups."},{"title":"Multi-dataset join comparison","prompt":"I need two reports on my join coverage: a grouped numeric summary and a date-by-category breakdown for matched_rows, across datasets alpha, beta, and gamma for the past month's worth of rows."}],"resultDescription":"Returns two independent analytical reports computed locally: (1) a grouped numeric summary of the specified metric (matched_rows or source_rows) broken down by dataset_group, including aggregated statistics; and (2) a date-by-category pivot table showing the metric's values across dates and groups. Covers up to 200 input rows per call.","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","Arrays exceeding 200 items are rejected","Invalid field enum value (anything other than matched_rows or source_rows) causes an error","Payment of 0.01 USDC not received causes request to fail with 402"],"whenToPreferThis":"Use this endpoint when you need quick, local statistical analysis of join coverage records without any live data lookup or external enrichment. Ideal for data engineers who want to audit ETL pipeline join quality, summarize coverage metrics by group, or pivot coverage trends over time — all within a single low-cost call that returns two complementary reports simultaneously.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:47.263Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-grouped-numeric-summary-date-by-category-pivot-8663f31d"}