Toolradar AI Assistants category aggregate for Dupple, extracted 2026-11-05 22:05:16.975 UTC.
Read-only transaction on Toolradar's production Postgres. CSV values are aggregates only, with no tool names or customer information. Direct category membership and published status were current at extraction; a tool may belong to more than one category. Direct membership differs from the parent-and-descendants total on some category pages.

Counts use Category c JOIN CategoryTool ct ON ct."categoryId"=c.id JOIN Tool t ON t.id=ct."toolId", WHERE c.slug='ai-assistants' AND t.status='published'. total is COUNT(*); free_or_freemium filters t.pricing IN ('free','freemium'); pricing_check_date_present filters t."pricingCheckedAt" IS NOT NULL. A stored check date is not independent verification of every plan or proof that a price is current.

Price spread uses ToolMetricSnapshot s JOIN Category c ON c.id=s."categoryId" JOIN Tool t ON t.id=s."toolId", WHERE c.slug='ai-assistants', s.metric='entry_price', s.detail->>'basis'='USD|seat:user' and t.status='published'. It reports count, minimum, percentile_cont(0.5) and maximum of s.value, at the weekly computation 2026-11-05 11:42:30.463 UTC. This cohort has 100 tools, at least the eight-tool minimum. Values are monthly equivalents of qualifying checked standard paid entry plans in US dollars per user; annual prices are divided by twelve. Other currencies and units are excluded. Values may have changed, unparseable and quote-only prices are omitted, and the spread is not a vendor price list or a like-for-like feature comparison.

Review-source counts use the same direct membership, published status and names in Tool.externalReviews.sources JSON arrays. Count DISTINCT tool IDs grouped by source; retain source names with at least eight tools. Sources can overlap, counts are not reviewers and do not establish review independence or currency.

AI crawler counts use AiBotFetchDaily a JOIN Tool t ON t.slug=a."toolSlug" JOIN CategoryTool ct ON ct."toolId"=t.id JOIN Category c ON c.id=ct."categoryId" WHERE c.slug='ai-assistants', a."pageType"='tool', t.status='published', a.date >= DATE '2026-10-30' and a.date < DATE '2026-11-05'. Count DISTINCT tools, sum a.requests and a.verified, and count distinct observed days. Membership and publication status are current at extraction but are applied to historical events. Counts include 2xx and 304 tool-page responses, not other page types; verification coverage differs by bot. Requests are not people, citations, recommendations, leads or sales. General method: https://toolradar.com/data/ai-crawler-tool-page-categories-method-2026-11-05.txt.

Separately published session data: https://toolradar.com/data/tool-page-sessions-categories-2026-11-05.csv and https://toolradar.com/data/tool-page-sessions-categories-method-2026-11-05.txt. Sessions sum qualifying per-tool pages and are not unique people or verified buyers; the method gives the window, threshold and other limits.

Source code: Toolradar Prisma schema and weekly ToolMetricSnapshot metric registry. No independent audit. Membership, prices, source records and available snapshots can change.