{"uid":"cap_d6a2O7IXaGSzZlFpKGfkA","slug":"url-canonicalization-duplicate-key-report-trailing-mean-series-062fd65e","name":"URL Canonicalization — Duplicate Key Report + Trailing Mean Series","description":"URL canonicalization — Duplicate key report + Trailing mean series: Duplicate key report + Trailing mean series for supplied url canonicalization records (observed_urls, unique_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-20-061?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","site_group","date","observed_urls","unique_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},"unique_urls":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"observed_urls":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","site_group":"group-a","unique_urls":1,"observed_urls":10},{"date":"2026-10-02","row_id":"row-2","site_group":"group-b","unique_urls":2,"observed_urls":20},{"date":"2026-10-03","row_id":"row-3","site_group":"group-a","unique_urls":3,"observed_urls":15},{"date":"2026-10-04","row_id":"row-4","site_group":"group-b","unique_urls":4,"observed_urls":30}],"maxItems":200,"minItems":1},"field":{"enum":["observed_urls","unique_urls"],"type":"string","default":"observed_urls"},"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_2ND14ivfD01XYHX_EbbAX","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":"Analyzes supplied URL canonicalization records to produce a duplicate key report and a trailing mean series for observed or unique URL counts, up to 200 rows.","exampleAgentPrompt":"Can you run a duplicate key report and trailing mean series on my URL canonicalization data? I have rows for site_group 'group-a' and 'group-b' with observed_urls values from 2026-10-01 to 2026-10-04, and I want the trailing mean over a window of 3 periods for the observed_urls field.","exampleUseCases":[{"title":"Audit SEO crawler URL deduplication logs","prompt":"I have a week's worth of URL canonicalization records from our SEO crawler — can you check for any duplicate row keys across site groups and also compute a 7-day trailing mean of observed_urls so I can see the trend?"},{"title":"Monitor unique URL growth with rolling average","prompt":"Run a trailing mean analysis on my unique_urls data across these site groups over the past 30 days using a window of 5, so I can see if unique URL counts are trending up or stabilizing."},{"title":"Detect data pipeline key collisions in URL records","prompt":"I need to validate my URL canonicalization pipeline output — please generate a duplicate key report for these 150 rows across multiple site groups so I can catch any duplicate date and site_group combinations before loading them into production."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying rows with repeated key combinations across the supplied URL canonicalization records, and (2) a trailing mean series computed over the specified window for the chosen field (observed_urls or unique_urls), covering up to 200 rows of input data.","failureModes":["Input array exceeds 200 rows — request will be rejected","Missing required fields (row_id, site_group, date, observed_urls, unique_urls) cause validation errors","Invalid date format (not YYYY-MM-DD) triggers schema rejection","Window parameter outside 2–200 range causes an error","Field value not in enum ['observed_urls','unique_urls'] causes rejection","Null numeric values may affect trailing mean computation quality"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously audit URL canonicalization records for duplicate key combinations AND compute a rolling/trailing mean time series on URL count metrics, all in a single low-cost call. It is ideal for offline/batch analysis of supplied data (no live lookups), supporting up to 200 rows. Prefer this over general-purpose analytics when your data specifically contains site_group, date, observed_urls, and unique_urls fields and you need both data quality (deduplication) and trend (rolling mean) outputs together.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T12:45:34.382Z","isFirstParty":false,"canonicalSlug":"url-canonicalization-duplicate-key-report-trailing-mean-series-062fd65e"}