{"uid":"cap_YicYXxvTGtAOMZPch3hll","slug":"join-coverage-analytics-category-frequencies-adjacent-row-changes-9b09761e","name":"Join Coverage Analytics: Category Frequencies + Adjacent Row Changes","description":"Join coverage — Category frequencies + Adjacent row changes: Category frequencies + Adjacent row changes 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-104?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_HRypoSHgKvJGMYMEzU0YE","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":"Analyzes join coverage records (matched_rows, source_rows) to produce two local reports: category frequency distribution by dataset_group and adjacent row-to-row change detection for a selected numeric field.","exampleAgentPrompt":"I have up to 200 join coverage records with matched_rows and source_rows per dataset_group and date — can you run a category frequency breakdown by group and also flag adjacent row changes in the matched_rows field for me?","exampleUseCases":[{"title":"Audit join match rates by group","prompt":"Here are my join coverage logs for October — each row has a dataset_group, a date, matched_rows, and source_rows. Can you give me a frequency breakdown by dataset_group and show me where matched_rows changed between consecutive rows?"},{"title":"Spot coverage drops in ETL pipeline","prompt":"I'm monitoring my ETL pipeline's join quality. I have 150 records with source_rows and matched_rows tagged by dataset_group. Run a category frequency report and highlight adjacent row changes in source_rows so I can see where coverage drops."},{"title":"Profile join dataset before QA review","prompt":"Before my data QA review, I need two quick reports on these join coverage records: how often each dataset_group appears, and what the row-to-row changes look like in matched_rows. I have about 80 rows with dates and group labels."}],"resultDescription":"Returns two analytical reports derived entirely from the supplied rows: (1) a category frequency table showing how often each dataset_group value appears, and (2) an adjacent row change report showing delta values between consecutive rows for the selected numeric field (matched_rows or source_rows). No external lookups or predictions are performed; all analysis is local.","failureModes":["Fewer than 1 row submitted returns a validation error","More than 200 rows submitted exceeds the limit and is rejected","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) causes schema validation failure","Invalid date format (not YYYY-MM-DD) triggers a pattern mismatch error","Numeric values outside ±1,000,000,000,000 are rejected","Invalid field enum value (not matched_rows or source_rows) causes an error","Payment of 0.01 USDC not included or rejected results in a 402 response"],"whenToPreferThis":"Choose this endpoint when you have join coverage tabular data (with matched_rows and source_rows fields) and need two specific analytical views — category frequency by dataset_group and adjacent row change detection — computed locally without any external API calls, predictions, or live data lookups. It is cost-effective at $0.01 for both reports simultaneously on up to 200 rows. Prefer this over general analytics tools when your data is already structured per the schema and you want fast, deterministic local computation.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:40.767Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-category-frequencies-adjacent-row-changes-9b09761e"}