{"uid":"cap_Og_nzQXhtgh9ig4klZP34","slug":"tutorial-completion-duplicate-key-report-iqr-outlier-flags-139849d9","name":"Tutorial Completion — Duplicate Key Report + IQR Outlier Flags","description":"Tutorial completion — Duplicate key report + IQR outlier flags: Duplicate key report + IQR outlier flags 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-065?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_KIjRca99AJknBv_OTOUYR","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 up to 200 tutorial completion records to produce a duplicate key report and IQR-based outlier flags for a selected numeric field.","exampleAgentPrompt":"Can you check my tutorial completion data for duplicate row IDs and flag any IQR outliers in the 'completions' field? I have about 50 rows with columns for row_id, game_area, date, starts, and completions.","exampleUseCases":[{"title":"Audit game tutorial funnel data quality","prompt":"I've got 120 rows of tutorial funnel data with row_id, game_area, date, starts, and completions columns — can you run a duplicate key check and flag any IQR outliers in the starts field so I can clean up the dataset before analysis?"},{"title":"Spot anomalous completion counts across areas","prompt":"Here are 80 tutorial completion records across different game areas. Please check for duplicate row IDs and identify any rows where completions looks like a statistical outlier using IQR — I want to know which rows to investigate."},{"title":"Pre-pipeline data validation for tutorial metrics","prompt":"Before I load this batch of 150 tutorial tracking rows into our dashboard, can you run a duplicate key report and IQR outlier flags on the completions field? I need to catch any bad data before it causes problems downstream."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any rows sharing the same key values, and (2) IQR-based outlier flags marking rows whose selected numeric field (starts or completions) falls outside the interquartile range boundaries. Both reports are derived entirely from the supplied data with no external lookups.","failureModes":["Fewer than 1 row submitted — minimum row count not met","More than 200 rows submitted — exceeds maximum batch size","Missing required fields (row_id, game_area, date, starts, completions) in any row","Invalid date format (must match YYYY-MM-DD pattern)","Invalid field enum value — must be 'starts' or 'completions'","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000)","Payment failure or insufficient USDC balance"],"whenToPreferThis":"Choose this endpoint when you need two specific data quality checks — duplicate key detection and IQR outlier flagging — run simultaneously on tutorial completion records (starts/completions) for up to 200 rows. It is ideal for pre-pipeline validation of game tutorial funnel data where no external data enrichment, prediction, or live lookup is needed. Prefer this over general-purpose analytics tools when working specifically with game area tutorial data and needing a low-cost ($0.01 USDC) combined duplicate + outlier report.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:33:45.506Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-duplicate-key-report-iqr-outlier-flags-139849d9"}