{"uid":"cap_63gSS_XEF7uJ1E__E3l6R","slug":"tutorial-completion-exact-row-deduplication-base-100-series-9db40216","name":"Tutorial Completion Exact Row Deduplication + Base-100 Series","description":"Tutorial completion — Exact row deduplication + Base-100 series: Exact row deduplication + Base-100 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-047?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"},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":0}}},"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_svTQTB5jgm-uUoZEI2Tno","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 and produces a Base-100 indexed time series for a chosen metric (starts or completions) across game areas, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Deduplicate these tutorial completion records and give me a Base-100 series for completions starting from row index 0 — I have 4 rows across group-a and group-b with dates from 2026-10-01 to 2026-10-04, starts like 10, 20, 15, 30 and completions 1, 2, 3, 4.","exampleUseCases":[{"title":"Game onboarding funnel normalization","prompt":"I have 50 rows of tutorial start and completion counts across different game areas and dates — can you deduplicate them and produce a Base-100 series for starts, using row index 0 as the base?"},{"title":"Duplicate detection in tutorial tracking data","prompt":"Our analytics pipeline sometimes logs duplicate tutorial events. Can you run exact row deduplication on this batch of 120 tutorial completion records and also index the completions field to base-100 starting from row 5?"},{"title":"Weekly tutorial engagement report","prompt":"Here are this week's tutorial completion logs for three game areas — deduplicate the rows and give me both the deduplication report and a base-100 indexed series for the completions metric starting from index 0."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing duplicate records from the supplied tutorial completion rows, and (2) a Base-100 indexed time series for the chosen metric field (starts or completions) anchored at the specified base_index row. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, game_area, date, starts, completions) on any row — validation error","base_index out of range for provided rows — error or fallback","Invalid date format (not YYYY-MM-DD) — schema rejection","starts or completions values outside allowed numeric range — rejection"],"whenToPreferThis":"Choose this endpoint when you need both exact duplicate removal and a normalized Base-100 time series from tutorial completion data in a single low-cost call. It is ideal for game analytics pipelines processing up to 200 rows of tutorial funnel data (starts and completions) per game area and date, where you want two independent analytical reports without any external API calls or live lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:36:47.687Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-exact-row-deduplication-base-100-series-9db40216"}