{"uid":"cap_x9gcO8JtmJaZj6di0X8eh","slug":"sitemap-inventories-secondary-measure-weighted-mean-explicit-missing-c1ed5fa9","name":"Sitemap Inventories – Secondary-Measure Weighted Mean + Explicit Missing-Value Fill","description":"Sitemap inventories — Secondary-measure weighted mean + Explicit missing-value fill: Secondary-measure weighted mean + Explicit missing-value fill for supplied sitemap inventories records (listed_urls, fetched_urls). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-web-04-187?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","site_group","date","listed_urls","fetched_urls"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"site_group":{"type":"string","default":"","maxLength":80},"listed_urls":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"fetched_urls":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","site_group":"group-a","listed_urls":10,"fetched_urls":1},{"date":"2026-10-02","row_id":"row-2","site_group":"group-b","listed_urls":20,"fetched_urls":2},{"date":"2026-10-03","row_id":"row-3","site_group":"group-a","listed_urls":15,"fetched_urls":3},{"date":"2026-10-04","row_id":"row-4","site_group":"group-b","listed_urls":30,"fetched_urls":4}],"maxItems":200,"minItems":1},"field":{"enum":["listed_urls","fetched_urls"],"type":"string","default":"listed_urls"},"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_v9AMxLHOVOiYdUYDV1553","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":"Computes a secondary-measure weighted mean and fills missing values in sitemap inventory records (listed_urls, fetched_urls) for up to 200 rows, producing two analytical reports.","exampleAgentPrompt":"Can you calculate the secondary-measure weighted mean for listed_urls across these 4 sitemap inventory rows — filling any missing values using median imputation — and give me both analytical reports? Rows: site_group A on 2026-10-01 with 10 listed and 1 fetched, site_group B on 2026-10-02 with 20 listed and 2 fetched, site_group A on 2026-10-03 with 15 listed and null fetched, site_group B on 2026-10-04 with 30 listed and 4 fetched.","exampleUseCases":[{"title":"Sitemap crawl gap analysis by group","prompt":"I have daily sitemap records for two site groups over the past week — some fetched_urls values are missing. Can you fill those nulls using the mean and then compute the weighted mean of fetched_urls so I can see which group has the best crawl coverage?"},{"title":"SEO audit with null URL counts","prompt":"Our sitemap export has null entries in listed_urls for a few dates. Fill the missing values with zero and compute the weighted mean of listed_urls across all rows so I can benchmark our indexation rate — I have about 150 rows to process."},{"title":"Comparing listed vs fetched URL ratios","prompt":"Can you run both the listed_urls and fetched_urls weighted mean reports on my sitemap inventory data? Use median fill for any nulls. I've got 80 rows across three site groups and want to understand the ratio of listed to fetched URLs per group."}],"resultDescription":"Two local analytical reports per call: one containing the secondary-measure weighted mean of the chosen field (listed_urls or fetched_urls) across the submitted rows, and one with explicit missing-value fills applied using the selected method (zero, mean, or median), covering up to 200 input rows total.","failureModes":["More than 200 rows submitted — request rejected or truncated","Invalid date format (not YYYY-MM-DD) causes row validation failure","Missing required fields (row_id, site_group, date) causes schema rejection","Field enum value outside [listed_urls, fetched_urls] returns error","Method enum value outside [zero, mean, median] returns error","All values null for selected field may yield undefined weighted mean","Numeric values outside ±1,000,000,000,000 boundary rejected"],"whenToPreferThis":"Choose this endpoint when you have tabular sitemap inventory data with listed_urls and/or fetched_urls columns, need to handle missing values explicitly before aggregation, and want a weighted mean computed locally without any live web lookup or external data enrichment. It is ideal for SEO teams auditing sitemap crawl coverage across site groups over time, especially when data quality issues (nulls) are present. It is not suitable for real-time sitemap fetching, prediction, or datasets exceeding 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:46:17.171Z","isFirstParty":false,"canonicalSlug":"sitemap-inventories-secondary-measure-weighted-mean-explicit-missing-c1ed5fa9"}