{"uid":"cap_q9iY1CYl_bh0JbZ-4uTEa","slug":"join-coverage-analytics-string-normalisation-two-measure-correlation-02f48c79","name":"Join Coverage Analytics: String Normalisation + Two-Measure Correlation","description":"Join coverage — String normalisation + Two-measure correlation: String normalisation + Two-measure correlation 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-033?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_SMvjGnATGQ_7qdVJfA77E","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 string normalisation and two-measure correlation analysis on supplied join coverage records (matched_rows, source_rows) for up to 200 rows, returning two independent analytical reports.","exampleAgentPrompt":"Can you run string normalisation and two-measure correlation on my join coverage data? I have 4 rows: group-a on 2026-10-01 had 10 matched out of 1 source, group-b on 2026-10-02 had 20 matched out of 2 source, group-a on 2026-10-03 had 15 matched out of 3 source, and group-b on 2026-10-04 had 30 matched out of 4 source.","exampleUseCases":[{"title":"Pipeline join quality audit","prompt":"I need to check join coverage health for my ETL pipeline — here are 6 days of data with matched_rows and source_rows per dataset group. Can you run string normalisation and a two-measure correlation so I can see if group-a and group-b are trending differently?"},{"title":"Data warehouse coverage regression","prompt":"We had a schema change last week and I want to see if it affected join rates. I have 50 rows of matched_rows vs source_rows data across two groups from the past month — please run the correlation and normalisation analysis on them."},{"title":"Multi-group join consistency check","prompt":"Can you analyse this join coverage table with 30 rows across four dataset groups? I want both the string normalisation report and the two-measure correlation between matched_rows and source_rows to see which groups have inconsistent coverage."}],"resultDescription":"Returns two independent analytical reports: (1) a string normalisation report on the join coverage records and (2) a two-measure correlation analysis between matched_rows and source_rows, computed entirely from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request will be rejected due to maxItems constraint","Missing required fields (row_id, date, dataset_group, matched_rows, source_rows) cause validation errors","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","Null or out-of-range numeric values for matched_rows or source_rows may affect correlation computation","Empty rows array (minItems: 1) will be rejected"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously normalise join coverage string data and compute a two-measure correlation between matched_rows and source_rows in a single call, without requiring any external data sources. Best suited for data engineers auditing ETL pipeline join quality or data quality analysts checking dataset merge efficiency across groups, especially when both analytical reports are needed together at low cost ($0.01 USDC for both).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T02:00:33.228Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-string-normalisation-two-measure-correlation-02f48c79"}