{"uid":"cap_UyuI7ZZ_LnKLMDg2PMoS6","slug":"join-coverage-analytics-string-normalisation-daily-sum-series-3faba73f","name":"Join Coverage Analytics: String Normalisation + Daily Sum Series","description":"Join coverage — String normalisation + Daily sum series: String normalisation + Daily sum series 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-027?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_Mpp1R0dEzM7UHM_cXjn4M","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 daily sum time series for join coverage metrics (matched_rows and source_rows) across up to 200 supplied rows, returning two analytical reports.","exampleAgentPrompt":"Analyze my join coverage data for group-a and group-b across October 2026 — I have 4 rows with dates, matched_rows, and source_rows values — and give me both the string normalisation report and daily sum series for matched_rows.","exampleUseCases":[{"title":"ETL pipeline join quality audit","prompt":"I have a week's worth of daily join coverage records from two dataset groups — give me a string normalisation report and the daily sum series for matched_rows so I can see where my pipeline is dropping rows."},{"title":"Data reconciliation daily rollup","prompt":"Here are 50 join coverage records with dates, matched_rows, and source_rows for groups 'invoices' and 'payments' — run the string normalisation and daily sum series analysis on source_rows so I can reconcile my datasets."},{"title":"Coverage trend monitoring across groups","prompt":"I want to monitor join coverage trends across my dataset groups for Q3 — can you compute the daily sum series and string normalisation for matched_rows across these 120 records I'm uploading?"}],"resultDescription":"Returns two analytical reports: (1) a string normalisation report covering the selected join coverage field values across dataset groups, and (2) a daily sum series aggregating the chosen field (matched_rows or source_rows) by date. No external lookups or live data are used — analysis is performed entirely on the supplied rows.","failureModes":["Fewer than 1 or more than 200 rows submitted — request rejected","Date values not in YYYY-MM-DD format — validation error","matched_rows or source_rows values outside ±1,000,000,000,000 — schema rejection","Missing required fields (row_id, dataset_group, date) — input validation failure","Invalid field enum value (not 'matched_rows' or 'source_rows') — rejected"],"whenToPreferThis":"Choose this endpoint when you have tabular join coverage data (matched_rows vs source_rows) keyed by date and dataset group, and need both a string normalisation pass and a daily sum time series in one call for up to 200 rows. It is ideal for data engineers auditing ETL pipelines or reconciling datasets without needing live lookups or external data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:33.857Z","isFirstParty":false,"canonicalSlug":"join-coverage-analytics-string-normalisation-daily-sum-series-3faba73f"}