{"uid":"cap_qzhjznyQACTshm43uAgaM","slug":"join-coverage-analytics-record-quality-audit-exact-row-deduplication-9efa477a","name":"Join Coverage Analytics — Record Quality Audit, Exact Row Deduplication & Category Frequencies","description":"Join coverage — Record quality audit + Exact row deduplication + Category frequencies: Record quality audit + Exact row deduplication + Category frequencies for supplied join coverage records (matched_rows, source_rows). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-212?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}}},"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_Q1Nc6-R9XaUATeRDZurBa","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":"Runs three local analytical reports on join coverage data (matched_rows, source_rows): record quality audit, exact row deduplication, and category frequency analysis — all in a single call for up to 200 rows.","exampleAgentPrompt":"Can you audit these join coverage records for quality issues, remove any exact duplicates, and give me a frequency breakdown by dataset_group? I have 4 rows: row-1 on 2026-10-01 with source_rows=1, matched_rows=10, group-a; row-2 on 2026-10-02 with source_rows=2, matched_rows=20, group-b; row-3 on 2026-10-03 with source_rows=3, matched_rows=15, group-a; row-4 on 2026-10-04 with source_rows=4, matched_rows=30, group-b.","exampleUseCases":[{"title":"Pre-load join coverage validation","prompt":"Before I load these join coverage results into our data warehouse, can you run a quality audit, deduplicate exact rows, and show me how often each dataset_group appears? Here are 8 rows from our nightly ETL — dataset_group values are 'sales', 'inventory', and 'returns', dates ranging from 2026-11-01 to 2026-11-08, with matched_rows and source_rows for each."},{"title":"Debugging inflated match counts","prompt":"I think some of my join coverage records are duplicated or have bad matched_rows values — can you run a record quality audit and exact deduplication report on these 15 rows? The dataset_group is either 'customers' or 'orders', dates are 2026-09-01 through 2026-09-15, and several rows might have null source_rows."},{"title":"Category frequency summary for stakeholder report","prompt":"I need to know how many records fall into each dataset_group category in my join coverage data — can you also flag any quality issues and duplicates while you're at it? I have 50 rows spanning groups like 'alpha', 'beta', and 'gamma' from 2026-01-01 to 2026-02-19."}],"resultDescription":"Returns three independent analytical reports: (1) a record quality audit flagging nulls, out-of-range values, and format issues in the supplied rows; (2) an exact row deduplication report identifying and removing identical records; and (3) a category frequency table showing how often each dataset_group value appears. All computed locally with no external lookups.","failureModes":["Submitting more than 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause row-level rejection","Malformed date strings not matching YYYY-MM-DD pattern are flagged or rejected","numeric values outside ±1,000,000,000,000 range are rejected","Empty rows array returns an error","Payment failure (insufficient USDC balance) blocks the request"],"whenToPreferThis":"Choose this endpoint when you need all three of record quality auditing, exact deduplication, and category frequency analysis on join coverage data (matched_rows, source_rows fields) in a single low-cost call. It is ideal for data engineers who want a bundled analytical pass on up to 200 join coverage rows without standing up local tooling. Prefer alternatives if you need only one of the three reports, need more than 200 rows, require fuzzy deduplication, or need live/external data lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:54:30.540Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-record-quality-audit-exact-row-deduplication-9efa477a"}