{"uid":"cap_oQa34oM1JZYTWG497BmI2","slug":"company-record-completeness-analyzer-deduplication-trailing-mean-series-39a816de","name":"Company Record Completeness Analyzer — Deduplication + Trailing Mean Series","description":"Company record completeness — Exact row deduplication + Trailing mean series: Exact row deduplication + Trailing mean series for supplied company record completeness records (populated_fields, required_fields). 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-company-01-045?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","populated_fields","required_fields"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"required_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"populated_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","required_fields":1,"populated_fields":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","required_fields":2,"populated_fields":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","required_fields":3,"populated_fields":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","required_fields":4,"populated_fields":30}],"maxItems":200,"minItems":1},"field":{"enum":["populated_fields","required_fields"],"type":"string","default":"populated_fields"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_F1epRdxYJi3GbvoN4SBU0","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":"Deduplicates company record completeness rows and computes a trailing mean time series for populated_fields or required_fields across up to 200 records in two combined reports.","exampleAgentPrompt":"I have 50 daily company record completeness rows with populated_fields and required_fields counts — can you deduplicate them exactly and then compute a trailing mean series with a window of 7 for the populated_fields column, grouped by company_group?","exampleUseCases":[{"title":"CRM data quality audit by company group","prompt":"I've got 120 rows of company record completeness data across three company groups, each with a date, populated_fields, and required_fields count. Can you remove any exact duplicate rows and then give me a 5-day trailing mean series for populated_fields so I can see how each group's data quality trends over time?"},{"title":"Detecting stale or repeated completeness entries","prompt":"We exported 80 daily completeness snapshots for our company records and suspect some rows were logged twice. Can you run an exact deduplication on them and also give me a rolling average of required_fields with a window of 3 so we can spot patterns after duplicates are removed?"},{"title":"Monthly field population rate trend report","prompt":"Here are 200 rows of company record completeness entries from the past quarter — date, company_group, populated_fields, and required_fields. Please deduplicate the exact duplicates and compute a trailing mean with a window of 10 for required_fields so I can track how consistently teams are filling mandatory fields."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing duplicate entries from the supplied records, and (2) a trailing mean time series report computing rolling averages of the selected field (populated_fields or required_fields) over the specified window size, segmented by company_group and date.","failureModes":["Fewer than 1 row or more than 200 rows submitted — request rejected","Invalid date format (not YYYY-MM-DD) — validation error","Window size outside 2–200 range — rejected","Null or missing required fields (row_id, company_group, date, populated_fields, required_fields) — validation error","Non-numeric values for populated_fields or required_fields — schema rejection","Invalid field enum value (not populated_fields or required_fields) — error"],"whenToPreferThis":"Choose this endpoint when you have a batch of company record completeness data (up to 200 rows) and need both exact duplicate removal and a rolling average time series in one call at minimal cost. It is ideal for data quality audits, CRM hygiene checks, and trend analysis on field population rates without needing an external database or live lookup service.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:45:01.285Z","isFirstParty":false,"canonicalSlug":"company-record-completeness-analyzer-deduplication-trailing-mean-series-39a816de"}