{"uid":"cap_2fSqiiK0aA_3mcPOP1jwp","slug":"duplicate-observations-analytics-record-quality-audit-string-935cb35c","name":"Duplicate Observations Analytics — Record Quality Audit, String Normalisation & Daily Sum Series","description":"Duplicate observations — Record quality audit + String normalisation + Daily sum series: Record quality audit + String normalisation + Daily sum series for supplied duplicate observations records (duplicate_rows, total_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-04-198?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":20},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":15},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["duplicate_rows","total_rows"],"type":"string","default":"duplicate_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_ByIXmt-DAcLwVa3v7wdsY","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 (record quality audit, string normalisation, and daily sum series) on up to 200 rows of duplicate-observation data containing duplicate_rows and total_rows fields.","exampleAgentPrompt":"Can you run the three-report duplicate-observations analysis on my dataset — here are 5 rows with row_id, dataset_group, date, duplicate_rows, and total_rows — and use 'duplicate_rows' as the target field? I need the record quality audit, string normalisation, and daily sum series all in one go.","exampleUseCases":[{"title":"Data pipeline duplicate rate audit","prompt":"I have a batch of 50 rows from our ingestion pipeline, each with a row_id, dataset_group, date, duplicate_rows count, and total_rows count. Can you run the record quality audit, string normalisation check, and daily sum series on them using the duplicate_rows field so I can see where data quality is breaking down?"},{"title":"Daily duplicate trend summary","prompt":"Here are 120 daily observation records from our analytics warehouse — each has a date, dataset_group, duplicate_rows, and total_rows. Please generate the daily sum series for total_rows so I can spot which days had the highest record volumes."},{"title":"Dataset group string cleanup check","prompt":"I've got 80 rows of duplicate-detection logs with mixed-case and inconsistent dataset_group labels. Can you run the string normalisation report alongside the record quality audit on these rows so I can see which group names need cleaning up?"}],"resultDescription":"Three distinct analytical reports returned together: (1) a record quality audit summarising anomalies or issues in the submitted rows, (2) a string normalisation report highlighting inconsistencies in text fields like dataset_group, and (3) a daily sum series aggregating the selected numeric field (duplicate_rows or total_rows) by date — all computed locally without external lookups.","failureModes":["Fewer than 1 or more than 200 rows submitted — rejected with validation error","Invalid date format (not YYYY-MM-DD) — row fails schema validation","Null or out-of-range numeric values for duplicate_rows or total_rows — may cause partial computation","Unrecognised field selector value (not 'duplicate_rows' or 'total_rows') — rejected by enum validation","Missing required fields (row_id, dataset_group, date) — row rejected"],"whenToPreferThis":"Choose this endpoint when you need three bundled analytical reports (quality audit, string normalisation, daily sum series) on a compact dataset of duplicate-observation records (up to 200 rows) in a single low-cost call, without requiring live lookups or external data enrichment. It is ideal for offline data quality checks on pipeline outputs or warehouse exports where the data is already in hand.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:19:39.442Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-record-quality-audit-string-935cb35c"}