{"uid":"cap_0Mv7bteCFQeIzJFR2d409","slug":"tutorial-completion-analytics-duplicate-key-report-date-by-category-12b7025f","name":"Tutorial Completion Analytics — Duplicate Key Report + Date by Category Pivot","description":"Tutorial completion — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot 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-068?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_4u0wBSzCu4txy3kOXb9gM","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":"Analyzes tutorial completion records (starts and completions) to produce a duplicate key report and a date-by-category pivot table, for up to 200 rows.","exampleAgentPrompt":"I have tutorial completion data with row IDs, game areas, dates, starts, and completions — can you run a duplicate key check and also pivot the starts field by date and game area across these rows?","exampleUseCases":[{"title":"Data quality audit before reporting","prompt":"Before I publish my weekly tutorial report, can you scan these 150 tutorial completion records for any duplicate row IDs and also give me a pivot of starts broken down by date and game area?"},{"title":"Game area performance comparison","prompt":"I've got tutorial data for our three game areas across October — run a duplicate key check on the row IDs and pivot the completions field by date and game area so I can compare performance."},{"title":"Learning analytics dashboard prep","prompt":"I need to prep data for our learning dashboard — here are 80 rows of tutorial starts and completions by game area and date. Can you flag any duplicate keys and build a date-by-category pivot on the starts field?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any repeated row_id values in the submitted dataset, and (2) a date-by-category pivot table cross-tabulating the selected field (starts or completions) by date rows and game_area columns. Results are computed locally against the supplied data; no external lookup is performed.","failureModes":["Input array empty or missing — returns validation error","row_id field blank or exceeds 80 characters — row rejected","date field not in YYYY-MM-DD format — parse error","More than 200 rows submitted — request rejected with row limit error","field enum value not 'starts' or 'completions' — validation error","Numeric values outside allowed range — validation error"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously audit tutorial completion data for duplicate row keys AND produce a cross-tabulated date-by-category pivot in a single low-cost call. Ideal for game learning platforms tracking tutorial starts and completions across multiple game areas over time, especially when you want both data quality checks and summary analytics together without writing custom code.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:32:20.898Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-analytics-duplicate-key-report-date-by-category-12b7025f"}