{"uid":"cap_n3wlVy1jnf2st28vWhpUq","slug":"advertising-performance-duplicate-key-report-1bdb1a03","name":"Advertising Performance Duplicate Key Report","description":"Advertising performance - Duplicate key report: Duplicate key report 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 duplicate key report deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-ad-performance-key-duplicates?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_t3tRGKTrnM6tu06ges_ll","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":"Identifies duplicate key combinations in advertising performance records (campaign, date, clicks, spend) across up to 200 submitted rows.","exampleAgentPrompt":"Check my advertising performance data for duplicate key combinations — here are my rows: campaign 'group-a' on 2026-10-01 with 10 clicks and $1 spend (row-1), 'group-b' on 2026-10-02 with 20 clicks and $2 spend (row-2), and 'group-a' on 2026-10-01 with 15 clicks and $3 spend (row-3). Flag any rows that share the same campaign and date.","exampleUseCases":[{"title":"Pre-load data quality check","prompt":"Before I push this week's ad performance data to our dashboard, can you scan these 50 rows for any duplicate campaign-and-date combinations? Here's the batch: [rows with row_id, campaign, date, clicks, spend]. Flag which ones are duplicates so I can clean them up first."},{"title":"ETL pipeline deduplication step","prompt":"My ETL pipeline pulled campaign data for October — can you run a duplicate key check on these records to make sure no campaign-date pairs appear more than once before I merge them into the main table?"},{"title":"Audit ad spend records for billing","prompt":"I need to audit this list of 120 advertising spend records for duplicate entries — same campaign name and date shouldn't appear twice. Here are all the rows with row_id, campaign, date, clicks, and spend values. Tell me which row_ids are duplicates."}],"resultDescription":"A report identifying which submitted rows share duplicate composite keys (typically campaign + date combinations), including the flagged row IDs and duplicate groupings, enabling data quality remediation before further processing.","failureModes":["Empty or missing rows array returns an error","More than 200 rows submitted exceeds the maxItems limit and is rejected","Rows missing required fields (row_id, campaign, date, clicks, spend) fail schema validation","Invalid date format (not YYYY-MM-DD) causes row-level validation failure","Numeric fields outside the allowed range (-1T to +1T) are rejected"],"whenToPreferThis":"Use this endpoint when you need a fast, low-cost ($0.01) local data-quality check to identify duplicate composite keys in advertising performance datasets of up to 200 rows. It is ideal as a pre-processing step before loading campaign data into analytics systems, BI dashboards, or data warehouses. Prefer this over general deduplication tools when your data is specifically structured around campaign, date, clicks, and spend fields.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T00:59:54.309Z","isFirstParty":false,"canonicalSlug":"advertising-performance-duplicate-key-report-1bdb1a03"}