{"uid":"cap_rs4FArz8l-BDODu3iUXyK","slug":"tutorial-completion-exact-row-deduplication-daily-sum-series-2eada08f","name":"Tutorial Completion — Exact Row Deduplication + Daily Sum Series","description":"Tutorial completion — Exact row deduplication + Daily sum series: Exact row deduplication + Daily sum series 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-044?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_G9Vzqq-xbY5A3CegImSme","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 (starts/completions) by exact row and produces a daily sum time series for a chosen metric, returning two analytical reports in one call.","exampleAgentPrompt":"Can you deduplicate these tutorial completion records and give me a daily sum series for 'completions'? Here are 4 rows: row-1 on 2026-10-01 in group-a with 10 starts and 1 completion, row-2 on 2026-10-02 in group-b with 20 starts and 2 completions, row-3 on 2026-10-03 in group-a with 15 starts and 3 completions, row-4 on 2026-10-04 in group-b with 30 starts and 4 completions.","exampleUseCases":[{"title":"Daily tutorial completion trend","prompt":"I have a week's worth of tutorial start and completion logs for our game — can you remove any exact duplicate rows and then show me a daily sum series for 'starts' so I can see how player engagement trended? Here are the records: row-1 2026-10-01 group-a starts=10 completions=1, row-2 2026-10-02 group-b starts=20 completions=2, row-3 2026-10-03 group-a starts=15 completions=3."},{"title":"Cleaning duplicate tutorial event logs","prompt":"Our data pipeline sometimes sends the same tutorial event twice — can you run an exact row deduplication on these completion records and also give me the daily sum for 'completions'? I've got up to 200 rows across multiple game areas and dates I'd like to clean up."},{"title":"Game area tutorial performance summary","prompt":"We're tracking tutorial starts and completions across different game areas each day and I suspect there are duplicates in our export. Please deduplicate the rows exactly and produce a daily sum series for 'starts' — here are 4 sample rows: row-1 2026-10-01 group-a 10 starts 1 completion, row-2 2026-10-02 group-b 20 starts 2 completions, row-3 2026-10-01 group-a 10 starts 1 completion (possible dup), row-4 2026-10-04 group-b 30 starts 4 completions."}],"resultDescription":"Two analytical reports: (1) an exact row deduplication report identifying and removing duplicate records from the supplied tutorial completion rows, and (2) a daily sum time series for the chosen metric field ('starts' or 'completions') aggregated by date. Both reports are computed locally on the supplied data with no external lookups.","failureModes":["Rows array empty or missing — validation error","More than 200 rows submitted — rejected with maxItems error","Invalid date format (not YYYY-MM-DD) — pattern validation failure","Missing required fields (row_id, game_area, date, starts, completions) — schema validation error","Invalid field enum value (not 'starts' or 'completions') — rejected","Payment not included or insufficient — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 tutorial completion records (starts/completions per game area per day) and need both exact duplicate row removal and a daily aggregated sum series in a single low-cost call. It is purpose-built for gaming/tutorial analytics data with this specific schema. Prefer it over general deduplication tools when your data fits the game_area + date + starts/completions structure and you want both reports at once for $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:34:39.819Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-exact-row-deduplication-daily-sum-series-2eada08f"}