{"uid":"cap_X6zBZ2v4MWCreF8Asdn0r","slug":"brand-mention-inventories-exact-row-deduplication-category-frequencies-6d436e51","name":"Brand Mention Inventories — Exact Row Deduplication + Category Frequencies","description":"Brand mention inventories — Exact row deduplication + Category frequencies: Exact row deduplication + Category frequencies for supplied brand mention inventories records (mention_count, source_count). 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-18-041?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","mention_count","source_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"mention_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_count":1,"company_group":"group-a","mention_count":10},{"date":"2026-10-02","row_id":"row-2","source_count":2,"company_group":"group-b","mention_count":20},{"date":"2026-10-03","row_id":"row-3","source_count":3,"company_group":"group-a","mention_count":15},{"date":"2026-10-04","row_id":"row-4","source_count":4,"company_group":"group-b","mention_count":30}],"maxItems":200,"minItems":1}}},"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_snVck5-GKDvDjKiArLhWb","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 brand mention inventory rows and computes category-level mention/source frequency reports for up to 200 supplied records.","exampleAgentPrompt":"I have a list of brand mention records with mention_count and source_count columns — can you run exact row deduplication and give me category frequency breakdowns by company group? Here are up to 200 rows including row IDs, dates, and company groups like 'group-a' and 'group-b'.","exampleUseCases":[{"title":"Deduplicating brand mention export","prompt":"I exported brand mention data from our tracking tool and suspect there are duplicate rows. Can you deduplicate these records exactly and tell me the frequency of mentions and sources per company group? I have about 150 rows with row IDs, dates, company groups, mention counts, and source counts."},{"title":"Competitive brand monitoring summary","prompt":"We track brand mentions for three competitor groups daily. Can you take these 200 rows of mention inventory and give me both a deduplicated clean dataset and a breakdown of how often each company group appears along with total mention and source counts?"},{"title":"Category frequency audit for brand data","prompt":"I need to audit our brand mention inventory for duplicates and get a frequency report by category. Here's the dataset — rows have a row_id, date, company_group, mention_count, and source_count. Please run exact deduplication and give me the category frequency summary."}],"resultDescription":"Two analytical reports: (1) an exact-deduplicated version of the supplied rows, removing any perfectly duplicate records; and (2) a category frequency breakdown showing mention_count and source_count aggregates grouped by company_group across the supplied dataset. No external data is fetched; all analysis is performed on the supplied input only.","failureModes":["Rows array empty or missing — validation error","More than 200 rows submitted — request rejected or truncated","Missing required fields (row_id, company_group, date, mention_count, source_count) — row-level validation error","Invalid date format (not YYYY-MM-DD) — pattern validation failure","Numeric values outside allowed range — schema rejection","Payment not completed — x402 payment required response"],"whenToPreferThis":"Use this endpoint when you have a batch of up to 200 brand mention inventory records and need both exact duplicate removal and category-level frequency analysis in a single call. Ideal for cleaning exported brand monitoring data before downstream reporting, or when you need a quick grouped summary of mention/source counts by company group without building a local data pipeline. Not suitable for live brand mention lookup, predictive analytics, or datasets exceeding 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T18:57:18.843Z","isFirstParty":false,"canonicalSlug":"brand-mention-inventories-exact-row-deduplication-category-frequencies-6d436e51"}