# Advertising Performance Missing-Value Fill

> Advertising Performance Missing-Value Fill 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-15).

Fills missing numeric values (clicks or spend) in advertising performance records using zero, mean, or median imputation methods.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-sector-analytics-ad-performance-fill-missing?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/advertising-performance-missing-value-fill-86ad13bc
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_09sPJSugmW0mSIJDnDRm1

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-missing-value-fill-86ad13bc -d '<json body>'
```

Example prompt: Fill the missing spend values in my ad campaign records using median imputation — I have up to 50 rows with campaign names, dates, clicks, and some null spend fields that need to be filled before I run my analysis.

## When to prefer this

Choose this endpoint when you have up to 200 advertising performance records with missing numeric values (clicks or spend) and need simple, local imputation (zero, mean, or median) without external data enrichment or forecasting. It is ideal for data cleaning pipelines before reporting or ML feature preparation, and is cost-effective at $0.01 per call for bounded batch jobs.

## Known failure modes

- More than 200 rows submitted — exceeds maxItems limit
- Invalid date format not matching YYYY-MM-DD pattern
- Missing required fields (row_id, campaign, date, clicks, spend) on any record
- Invalid method value outside zero/mean/median enum
- Invalid field value outside clicks/spend enum
- Numeric values outside the allowed range (-1,000,000,000,000 to 1,000,000,000,000)

## How this service works

Advertising performance - Explicit missing-value fill: Explicit missing-value fill 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 explicit missing-value fill deliverable.

## Output

Returns the submitted advertising records with previously null or missing values for the specified field (clicks or spend) replaced using the chosen method (zero, mean, or median), enabling downstream analysis on complete datasets.

## 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
  },
  "field": {
   "enum": [
    "clicks",
    "spend"
   ],
   "type": "string",
   "default": "clicks"
  },
  "method": {
   "enum": [
    "zero",
    "mean",
    "median"
   ],
   "type": "string",
   "default": "median"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/advertising-performance-missing-value-fill-86ad13bc/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)