{"uid":"cap_vH9Fu4ijjEpr-rs1ODFNm","slug":"tutorial-completion-exact-row-deduplication-grouped-numeric-summary-f86141a5","name":"Tutorial Completion — Exact Row Deduplication + Grouped Numeric Summary","description":"Tutorial completion — Exact row deduplication + Grouped numeric summary: Exact row deduplication + Grouped numeric summary 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-040?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_y5_vSkx4eW3KeuQVeSvDv","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 produces a grouped numeric summary (by game area) for starts or completions, up to 200 rows.","exampleAgentPrompt":"Deduplicate my tutorial completion records and give me a grouped numeric summary by game_area for the 'completions' field — here are the rows: row-1, group-a, 2026-10-01, starts=10, completions=1; row-2, group-b, 2026-10-02, starts=20, completions=2; row-3, group-a, 2026-10-03, starts=15, completions=3.","exampleUseCases":[{"title":"Game tutorial funnel reporting","prompt":"I have daily tutorial start and completion counts across different game areas for October — can you deduplicate the rows and give me a grouped summary of completions by game_area so I can see which areas have the highest finish rates?"},{"title":"Cleaning duplicate event exports","prompt":"Our analytics export has some exact duplicate rows from a bug — can you strip the duplicates from these tutorial records and then summarize total starts grouped by game area? I've got about 150 rows to process."},{"title":"Onboarding effectiveness comparison","prompt":"I want to compare onboarding tutorial completions across our three game areas — can you deduplicate these 80 tutorial records and produce a grouped numeric summary on the completions field so I can see which area performs best?"}],"resultDescription":"Returns two reports: (1) a deduplicated version of the supplied rows with exact duplicate records removed, and (2) a grouped numeric summary of the selected field (starts or completions) aggregated by game_area. Both reports are computed locally with no external lookups.","failureModes":["More than 200 rows submitted — request rejected or truncated","Missing required fields (row_id, game_area, date, starts, completions) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Invalid field enum value (not 'starts' or 'completions') — rejected","All rows are duplicates — deduplication returns empty or single-row result","Null numeric values in starts/completions may affect summary accuracy"],"whenToPreferThis":"Choose this endpoint when you have up to 200 tutorial completion records that need both exact-duplicate removal and a grouped numeric summary in a single low-cost call ($0.01 USDC). It is ideal for offline/batch data cleaning and aggregation of game tutorial engagement data without needing a live database, external prediction, or professional assessment service.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T12:37:03.386Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-exact-row-deduplication-grouped-numeric-summary-f86141a5"}