Toolradar category-level AI crawler request snapshot
Extracted 5 November 2026, UTC. This read-only query outputs category aggregates only.

BEGIN READ ONLY;
COPY (
 SELECT c.slug AS category_slug, c.name AS category_name,
        COUNT(DISTINCT t.id) AS tools_with_reads,
        SUM(a.requests) AS requests, SUM(a.verified) AS verified_requests,
        COUNT(DISTINCT a.date) AS observed_days
 FROM "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 a."pageType" = 'tool' AND t.status = 'published'
   AND a.date >= DATE '2026-10-30' AND a.date < DATE '2026-11-05'
 GROUP BY c.id
 HAVING COUNT(DISTINCT t.id) >= 8
 ORDER BY requests DESC, c.slug
 LIMIT 10
) TO STDOUT WITH CSV HEADER;
COMMIT;

Current category membership and published status at extraction are applied to historical events.
A tool can belong to multiple categories, so category rows overlap. The extract covers only
individual tool pages; compare and alternatives pages, category pages and other page types are excluded.
The underlying table groups Cloudflare AI crawler request counts by UTC day, tool, page type and bot.
Requests include 2xx and 304 deliveries; verified is the subset Cloudflare marked verified.
User-agent identification is not proof of an operator, and verification coverage differs by bot.
A request is not a person, recommendation, citation, lead or purchase.