{"uid":"cap_T5NPvrEaKQAmJS4Z4tBzs","slug":"advertising-performance-exact-row-deduplication-88dc9fbd","name":"Advertising Performance Exact Row Deduplication","description":"Advertising performance - Exact row deduplication: Exact row deduplication for Advertising performance. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded exact row deduplication deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-ad-performance-deduplicate?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","campaign","date","clicks","spend"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"spend":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"clicks":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"campaign":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","spend":1,"clicks":10,"row_id":"row-1","campaign":"group-a"},{"date":"2026-10-02","spend":2,"clicks":20,"row_id":"row-2","campaign":"group-b"},{"date":"2026-10-03","spend":3,"clicks":15,"row_id":"row-3","campaign":"group-a"},{"date":"2026-10-04","spend":4,"clicks":30,"row_id":"row-4","campaign":"group-b"}],"maxItems":200,"minItems":1}}},"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_gN13_y6fA0sMmVrQ1QMzJ","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":"Removes exact duplicate rows from advertising performance datasets (up to 200 records) based on campaign, date, clicks, and spend fields.","exampleAgentPrompt":"Can you deduplicate these advertising performance records I have — there are about 50 rows with fields for row_id, campaign, date, clicks, and spend, and I need exact duplicate rows removed before I run my analysis?","exampleUseCases":[{"title":"Pre-analysis ad data cleanup","prompt":"I've exported my campaign performance data and suspect there are duplicate rows — can you run exact deduplication on these records? Each row has a row_id, campaign name like 'summer-promo', a date like 2026-10-01, plus clicks and spend values."},{"title":"Reconciling merged campaign exports","prompt":"I merged two ad performance exports and now I have duplicate entries. Can you deduplicate this set of ~120 rows by removing any rows where the campaign, date, clicks, and spend are all identical?"},{"title":"Automated pipeline data quality step","prompt":"As part of my daily ad reporting pipeline, I need to strip exact duplicate rows from today's campaign data before loading it into the dashboard — can you run deduplication on these records with fields row_id, campaign, date, clicks, and spend?"}],"resultDescription":"A cleaned set of advertising performance records with exact duplicate rows removed, preserving one copy of each unique row. Output reflects only distinct combinations of campaign, date, clicks, and spend values across the submitted records.","failureModes":["Fewer than 1 row submitted — minItems validation error","More than 200 rows submitted — maxItems exceeded error","Missing required fields (row_id, campaign, date, clicks, spend) — schema validation error","Date field not matching YYYY-MM-DD pattern — format validation error","Numeric fields outside allowed range — boundary validation error"],"whenToPreferThis":"Choose this endpoint when you have a bounded set of up to 200 advertising performance records (with campaign, date, clicks, spend fields) and need fast, local exact-match deduplication with no external API calls or enrichment. Ideal for pre-analysis data cleaning, ETL pipeline quality steps, or reconciling merged ad exports. Not suitable for fuzzy/near-duplicate matching, datasets over 200 rows, or non-advertising data schemas.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T00:59:02.814Z","isFirstParty":false,"canonicalSlug":"advertising-performance-exact-row-deduplication-88dc9fbd"}