{"uid":"cap_09sPJSugmW0mSIJDnDRm1","slug":"advertising-performance-missing-value-fill-86ad13bc","name":"Advertising Performance Missing-Value Fill","description":"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.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-ad-performance-fill-missing?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},"field":{"enum":["clicks","spend"],"type":"string","default":"clicks"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_Al-kWvhJQ88Zk9BZkgJhS","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":"Fills missing numeric values (clicks or spend) in advertising performance records using zero, mean, or median imputation methods.","exampleAgentPrompt":"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.","exampleUseCases":[{"title":"Clean ad data before reporting","prompt":"I have a dataset of 80 ad performance rows where some clicks values are null — can you fill those missing clicks using the median method so I can generate my weekly report?"},{"title":"Zero-fill missing spend for budget tracking","prompt":"Some of my campaign spend fields are missing for the past month's records. Fill those missing spend values with zero so I can tally total budget usage across all campaigns."},{"title":"Mean-impute clicks for ML feature prep","prompt":"Before I train my campaign performance model, I need to impute missing clicks values using the mean across my 120 ad records — can you do that for campaigns group-a and group-b?"}],"resultDescription":"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.","failureModes":["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)"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T19:14:08.181Z","isFirstParty":false,"canonicalSlug":"advertising-performance-missing-value-fill-86ad13bc"}