{"uid":"cap_uCz1hFiLdlKiWXyLwfLNS","slug":"contact-record-quality-exact-row-deduplication-secondary-measure-984a7865","name":"Contact Record Quality — Exact Row Deduplication + Secondary-Measure Weighted Mean","description":"Contact record quality — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean for supplied contact record quality records (checked_records, duplicate_records). 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-03-051?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","checked_records","duplicate_records"],"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},"checked_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"duplicate_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","checked_records":10,"duplicate_records":1},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","checked_records":20,"duplicate_records":2},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","checked_records":15,"duplicate_records":3},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","checked_records":30,"duplicate_records":4}],"maxItems":200,"minItems":1},"field":{"enum":["checked_records","duplicate_records"],"type":"string","default":"checked_records"}}},"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_uxcm8Ml86GN4Qrtxo2YkV","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 exact rows and computes a secondary-measure weighted mean across up to 200 contact record quality data points, returning two analytical reports.","exampleAgentPrompt":"I have 4 rows of contact record quality data across two company groups — group-a had 10 checked records with 1 duplicate on 2026-10-01, and group-b had 20 checked with 2 duplicates on 2026-10-02 — can you deduplicate the exact rows and give me the weighted mean for checked_records across all of them?","exampleUseCases":[{"title":"Monthly duplicate rate audit per group","prompt":"I've got a month's worth of contact record quality logs — rows for group-a and group-b with daily checked_records and duplicate_records counts. Can you remove any exact duplicate rows and compute the weighted mean of duplicate_records so I can see where our data quality is worst?"},{"title":"Multi-team CRM data quality benchmarking","prompt":"We have contact record stats from 5 company groups over the past quarter, up to 150 rows total. Please deduplicate any identical entries and give me the weighted mean for checked_records so we can benchmark data quality across teams."},{"title":"Pre-merge contact database cleansing","prompt":"Before we merge two contact databases, I want to check quality — I have about 80 rows with row IDs, company groups, dates, and counts of checked vs duplicate records. Can you run exact row deduplication and calculate the weighted mean of duplicate_records to flag the worst offenders?"}],"resultDescription":"Returns two analytical reports: (1) a deduplicated version of the input rows with exact duplicates removed, and (2) a secondary-measure weighted mean computed over the chosen field (checked_records or duplicate_records), grouped or aggregated as appropriate. No external lookups or predictions are performed — all analysis is local and deterministic.","failureModes":["Input array exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, date, checked_records, duplicate_records) cause validation errors","Date values not matching YYYY-MM-DD pattern will fail schema validation","Null numeric values may affect weighted mean calculation accuracy","Payment failure (insufficient USDC balance) prevents endpoint execution"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a weighted mean summary in a single call for contact record quality data (checked_records, duplicate_records). It is purpose-built for this metric pair and returns two reports for one payment, making it efficient for CRM data quality workflows. Prefer it over generic statistics APIs when your data is already structured with row_id, company_group, date, and the two contact quality measures.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:51:27.759Z","isFirstParty":false,"canonicalSlug":"contact-record-quality-exact-row-deduplication-secondary-measure-984a7865"}