{"uid":"cap_ZQ65NAbfZh5Y2DxP1CgvL","slug":"tutorial-completion-exact-row-deduplication-numeric-distribution-b89d6b66","name":"Tutorial Completion — Exact Row Deduplication + Numeric Distribution","description":"Tutorial completion — Exact row deduplication + Numeric distribution: Exact row deduplication + Numeric distribution for supplied tutorial completion records (starts, completions). 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-game-20-039?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","game_area","date","starts","completions"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"starts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"game_area":{"type":"string","default":"","maxLength":80},"completions":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","starts":10,"game_area":"group-a","completions":1},{"date":"2026-10-02","row_id":"row-2","starts":20,"game_area":"group-b","completions":2},{"date":"2026-10-03","row_id":"row-3","starts":15,"game_area":"group-a","completions":3},{"date":"2026-10-04","row_id":"row-4","starts":30,"game_area":"group-b","completions":4}],"maxItems":200,"minItems":1},"field":{"enum":["starts","completions"],"type":"string","default":"starts"}}},"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_6ln1FlZxVwe91ZFn2aYwD","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":"Deduplicates tutorial completion records by exact row match and computes a numeric distribution report for a chosen metric (starts or completions), returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have up to 200 rows of tutorial completion data with fields like row_id, game_area, date, starts, and completions — can you deduplicate them by exact row match and also give me a numeric distribution report on the 'completions' field?","exampleUseCases":[{"title":"Game tutorial funnel deduplication","prompt":"I've collected tutorial tracking records from our game with row_id, game_area, date, starts, and completions columns — some rows may be exact duplicates. Can you deduplicate them and give me a distribution breakdown of the 'starts' numbers?"},{"title":"Completion rate distribution for e-learning","prompt":"Here are up to 150 rows of our e-learning tutorial completion logs. Please remove any exact duplicate rows and run a numeric distribution on the 'completions' field so I can see how completion counts are spread."},{"title":"QA check on tutorial analytics export","prompt":"We exported tutorial records from our analytics system and suspect duplicates crept in. Can you do an exact row deduplication and also show me the numeric distribution for 'starts' across all rows?"}],"resultDescription":"Returns two reports: (1) an exact row deduplication report identifying and removing duplicate records from the supplied tutorial completion rows, and (2) a numeric distribution report (e.g. min, max, mean, percentiles, frequency bins) for the chosen field ('starts' or 'completions'). Both reports are computed locally on the supplied data with no external lookups.","failureModes":["Input array is empty or missing — returns validation error","More than 200 rows submitted — exceeds maxItems limit","Invalid date format not matching YYYY-MM-DD pattern — schema validation error","Missing required fields (row_id, game_area, date, starts, completions) on any row — rejection","Invalid 'field' enum value (must be 'starts' or 'completions') — schema error","Payment not processed — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you need both exact duplicate detection and a numeric distribution summary on tutorial completion data in a single low-cost call ($0.01 USDC). It is ideal for offline/local analytical processing of up to 200 rows without requiring any external data sources, live lookups, or predictions. Prefer alternatives if you need more than 200 rows, other analytical operations (e.g. histograms, correlations, pivot tables), or data from domains other than tutorial/game completion tracking.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:35:34.011Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-exact-row-deduplication-numeric-distribution-b89d6b66"}