{"uid":"cap_YYtf94ekFWi_7rNmWPHPD","slug":"join-coverage-analytics-string-normalisation-grouped-numeric-summary-78aa4485","name":"Join Coverage Analytics — String Normalisation + Grouped Numeric Summary","description":"Join coverage — String normalisation + Grouped numeric summary: String normalisation + Grouped numeric summary 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-023?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_fQV3_bF-wz63-68-K_plQ","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":"Accepts up to 200 join coverage records (matched_rows, source_rows) and returns two analytical reports: string normalisation of labels and a grouped numeric summary, computed locally without external lookups.","exampleAgentPrompt":"I have 4 join coverage records — row-1 on 2026-10-01 with source_rows=1 and matched_rows=10 in group-a, row-2 on 2026-10-02 with source_rows=2 and matched_rows=20 in group-b, row-3 on 2026-10-03 with source_rows=3 and matched_rows=15 in group-a, and row-4 on 2026-10-04 with source_rows=4 and matched_rows=30 in group-b — can you normalise the group labels and give me a grouped numeric summary for matched_rows?","exampleUseCases":[{"title":"ETL pipeline join quality audit","prompt":"Here are 50 join coverage records from my ETL pipeline with dataset_group labels like 'Sales_Data', 'sales-data', and 'SALES DATA' — normalise those group names and give me a grouped numeric summary of matched_rows so I can see which groups have low join rates."},{"title":"Data warehouse coverage report","prompt":"I've got 120 join coverage rows across three dataset groups from last quarter, each with a date, matched_rows, and source_rows — run string normalisation on the group labels and give me the grouped numeric summary for source_rows so I can see total coverage per group."},{"title":"Daily join health check for two groups","prompt":"Can you take these 8 join coverage records from today — four in group-a and four in group-b — normalise the group names, and give me a grouped summary of matched_rows so I know which group is underperforming?"}],"resultDescription":"Returns two analytical reports: (1) a string normalisation report that standardises the dataset_group label values across the submitted rows, and (2) a grouped numeric summary aggregating the selected field (matched_rows or source_rows) by dataset_group, including statistics such as count, sum, mean, min, and max per group. No external data is fetched; all computation is performed locally on the supplied rows.","failureModes":["Fewer than 1 row submitted — validation error","More than 200 rows submitted — request rejected","Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — schema validation error","date field not in YYYY-MM-DD format — pattern validation error","Invalid field enum value (not 'matched_rows' or 'source_rows') — validation error","All numeric values are null — summary statistics may be empty or undefined"],"whenToPreferThis":"Choose this endpoint when you need a quick, low-cost ($0.01 USDC) dual-report analysis of join coverage data — specifically string normalisation of group labels combined with grouped numeric summaries — on a batch of up to 200 rows. It is ideal for data engineers auditing ETL join quality, data quality analysts profiling dataset coverage, or pipelines that need lightweight local analytics without hitting external databases or prediction services. Prefer it over general-purpose analytics APIs when the input is exactly the join coverage schema (matched_rows, source_rows, dataset_group, date) and two specific report types suffice.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:36.104Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-string-normalisation-grouped-numeric-summary-78aa4485"}