# Advertising Performance Duplicate Key Report

> Advertising Performance Duplicate Key Report 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-20).

Identifies duplicate key combinations in advertising performance records (campaign, date, clicks, spend) across up to 200 submitted rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-sector-analytics-ad-performance-key-duplicates?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-20
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/advertising-performance-duplicate-key-report-1bdb1a03
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_n3wlVy1jnf2st28vWhpUq

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-duplicate-key-report-1bdb1a03 -d '<json body>'
```

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

## When to prefer this

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.

## Known failure modes

- 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

## How this service works

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.

## Output

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.

## 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-duplicate-key-report-1bdb1a03/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)