{"uid":"cap_oYzgQqHFTcN0f5NfCHCuZ","slug":"tutorial-completion-duplicate-key-report-daily-sum-series-0a361fe7","name":"Tutorial Completion — Duplicate Key Report + Daily Sum Series","description":"Tutorial completion — Duplicate key report + Daily sum series: Duplicate key report + 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-060?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_HGV4RK47UEYvWDY5sLWzo","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 data (starts and completions) to produce a duplicate key report and a daily sum time series in a single call.","exampleAgentPrompt":"Can you run a duplicate key report and daily sum series on these tutorial completion records — I have rows with row_id, game_area, date, starts, and completions fields (up to 200 rows) — and I want to aggregate by the 'completions' field?","exampleUseCases":[{"title":"Detect duplicates in tutorial ingestion pipeline","prompt":"I just ingested a batch of tutorial completion records from our game and I'm worried there are duplicate row IDs mixed in. Can you run a duplicate key report on these rows — they have row_id, game_area, date, starts, and completions — and also give me the daily sum of starts so I can sanity-check the totals?"},{"title":"Daily completions trend for a specific game area","prompt":"I have about 150 rows of tutorial completion data for our mobile game, each with a date, game_area, starts, and completions. Can you give me a daily sum series for the 'completions' field and also flag any duplicate row IDs in the dataset?"},{"title":"QA check before dashboard refresh","prompt":"Before I push this week's tutorial data to the dashboard, can you check for any duplicate keys and compute the daily sum of 'starts' across all game areas? I'll send you the full set of rows with row_id, game_area, date, starts, and completions."}],"resultDescription":"Returns two independent reports: (1) a duplicate key report identifying any row_ids that appear more than once in the supplied data, and (2) a daily sum time series aggregating the selected numeric field (starts or completions) by date — both computed locally on the supplied rows without external lookups.","failureModes":["Missing required fields (row_id, game_area, date, starts, or completions) cause validation errors","Exceeding 200 rows returns an error; only up to 200 rows accepted","Invalid date format (not YYYY-MM-DD) fails schema validation","Invalid 'field' enum value (not 'starts' or 'completions') causes rejection","Empty rows array (minItems: 1 violated) returns an error","Non-numeric starts/completions values outside allowed range fail validation"],"whenToPreferThis":"Choose this endpoint when you need both a data quality check (duplicate row detection) and a daily aggregation in a single inexpensive call on tutorial completion data with up to 200 rows. It is ideal when working with game tutorial metrics (starts and completions per game area and date) and you want local analytical computation without any external data lookups, predictions, or side effects. At $0.01 USDC per call you get two reports simultaneously, making it more efficient than calling separate deduplication and aggregation endpoints.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T06:39:56.671Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-duplicate-key-report-daily-sum-series-0a361fe7"}