# Advertising Performance Exact Row Deduplication

> Advertising Performance Exact Row Deduplication is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-16).

Removes exact duplicate rows from advertising performance datasets (up to 200 records) based on campaign, date, clicks, and spend fields.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-sector-analytics-ad-performance-deduplicate?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-16
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/advertising-performance-exact-row-deduplication-88dc9fbd
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_T5NPvrEaKQAmJS4Z4tBzs

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability advertising-performance-exact-row-deduplication-88dc9fbd -d '<json body>'
```

Example prompt: 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?

## When to prefer this

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.

## Known failure modes

- 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

## How this service works

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.

## Output

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.

## Request schema (JSON Schema)

```json
{
 "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
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/advertising-performance-exact-row-deduplication-88dc9fbd/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from market.datapackvibe.com](https://www.zero.xyz/host/market.datapackvibe.com/llms.txt)