{"uid":"cap_olmGI406gTdPhDVkyFgQQ","slug":"creative-review-data-deduplication-and-numeric-interval-filter-610eaf52","name":"Creative Review Data Deduplication and Numeric Interval Filter","description":"Creative review — Exact row deduplication + Numeric interval filter: Exact row deduplication + Numeric interval filter for supplied creative review records (feedback_count, approved_items). 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-creative-25-043?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","feedback_count","approved_items"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"asset_group":{"type":"string","default":"","maxLength":80},"approved_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"feedback_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","approved_items":1,"feedback_count":10},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","approved_items":2,"feedback_count":20},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","approved_items":3,"feedback_count":15},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","approved_items":4,"feedback_count":30}],"maxItems":200,"minItems":1},"field":{"enum":["feedback_count","approved_items"],"type":"string","default":"feedback_count"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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__Yd9s04Cpe8H64As7Yidt","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 exact rows and filters creative review records by a numeric interval on feedback_count or approved_items, returning 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"Deduplicate my creative review records and filter to only rows where feedback_count is between 5 and 80 — here are up to 200 rows with row_id, asset_group, date, feedback_count, and approved_items fields. Give me the two analytical reports.","exampleUseCases":[{"title":"Filtering high-feedback creative assets","prompt":"I have a list of creative review records for our ad campaigns — can you remove any exact duplicate rows and then filter down to only the entries where feedback_count falls between 20 and 150? I'll give you up to 180 rows with asset_group, date, feedback_count, and approved_items."},{"title":"Cleaning approved items data for reporting","prompt":"Before our weekly creative report, can you deduplicate these 120 creative review records and filter them so only rows with approved_items between 1 and 500 are kept? I need both output reports."},{"title":"Auditing creative group duplicates by date","prompt":"Can you run a deduplication and numeric interval filter on my creative review dataset? I want rows where feedback_count is between 0 and 100, with duplicates removed — the data has asset_group, date, feedback_count, and approved_items columns across about 90 rows."}],"resultDescription":"Two analytical reports covering: (1) exact row deduplication results showing which rows were removed as duplicates, and (2) numeric interval filter results showing which records fall within the specified minimum–maximum range for the chosen field (feedback_count or approved_items). No external lookups or predictions are made; all analysis runs on the supplied rows.","failureModes":["Fewer than 1 row supplied — rejected by schema minItems constraint","More than 200 rows supplied — rejected by schema maxItems constraint","Invalid date format (not YYYY-MM-DD) — schema pattern validation failure","Field value outside allowed numeric range (±1,000,000,000,000) — rejected","Missing required fields (row_id, asset_group, date, feedback_count, approved_items) — schema validation error","minimum greater than maximum — may return empty filter result set with no error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 creative review records (with feedback_count and approved_items metrics) and need both exact row deduplication and a numeric range filter applied together in a single call returning two reports. Prefer it over general-purpose data tools when working specifically with creative review datasets and when a low per-call cost ($0.01 USDC) matters. Not suitable for datasets exceeding 200 rows, live data lookups, predictive analytics, or string-based filtering.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:36:43.049Z","isFirstParty":false,"canonicalSlug":"creative-review-data-deduplication-and-numeric-interval-filter-610eaf52"}