{"ok":true,"cached":true,"plan":{"sql":"WITH platform_matches AS (\n  SELECT\n    id, full_name, title, url, total_users_30d, runs30_total, est_monthly_revenue,\n    CASE\n      WHEN (full_name || ' ' || COALESCE(title,'')) ILIKE '%job%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%recruit%'\n        THEN 'Jobs / recruiting'\n      WHEN (full_name || ' ' || COALESCE(title,'')) ILIKE '%company%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%companies%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%employee%'\n        THEN 'Company / employees'\n      WHEN (full_name || ' ' || COALESCE(title,'')) ILIKE '%sales%navigator%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%lead%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%email%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%contact%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%prospect%'\n        THEN 'Lead generation'\n      WHEN (full_name || ' ' || COALESCE(title,'')) ILIKE '%profile%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%people%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%person%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%user%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%account%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%channel%'\n        THEN 'Profiles / accounts'\n      WHEN (full_name || ' ' || COALESCE(title,'')) ILIKE '%search%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%keyword%'\n        THEN 'Search / discovery'\n      WHEN (full_name || ' ' || COALESCE(title,'')) ILIKE '%post%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%comment%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%feed%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%tweet%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%video%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%short%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%reel%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%transcript%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%subtitle%'\n        THEN 'Content / posts'\n      WHEN (full_name || ' ' || COALESCE(title,'')) ILIKE '%ad%'\n        OR (full_name || ' ' || COALESCE(title,'')) ILIKE '%advert%'\n        THEN 'Ads / marketing'\n      ELSE 'Other YouTube tools'\n    END AS platform_kind\n  FROM apify.actor\n  WHERE COALESCE(is_deprecated, false) = false\n    AND (LOWER(COALESCE(target_platform, '')) IN ('youtube') OR LOWER(COALESCE(full_name, '')) LIKE '%youtube%' OR LOWER(COALESCE(title, '')) LIKE '%youtube%')\n),\nkind_stats AS (\n  SELECT\n    platform_kind,\n    CAST(COUNT(*) AS int) AS type_actor_count,\n    CAST(COUNT(*) FILTER (WHERE COALESCE(est_monthly_revenue, 0) >= 100.0) AS int) AS type_over_threshold_actors,\n    CAST(ROUND(100.0 * COUNT(*) FILTER (WHERE COALESCE(est_monthly_revenue, 0) >= 100.0) / NULLIF(COUNT(*), 0), 2) AS double precision) AS type_over_threshold_pct,\n    CAST(MAX(COALESCE(est_monthly_revenue, 0)) AS double precision) AS top_estimated_monthly_revenue,\n    (ARRAY_AGG(full_name ORDER BY COALESCE(est_monthly_revenue, 0) DESC NULLS LAST, total_users_30d DESC NULLS LAST))[1] AS top_actor\n  FROM platform_matches\n  GROUP BY platform_kind\n),\nsummary AS (\n  SELECT\n    CAST(COUNT(*) AS int) AS total_platform_actors,\n    CAST(COUNT(DISTINCT platform_kind) AS int) AS platform_type_count,\n    CAST(100.0 AS double precision) AS revenue_threshold_usd,\n    CAST(COUNT(*) FILTER (WHERE COALESCE(est_monthly_revenue, 0) >= 100.0) AS int) AS over_threshold_actors,\n    CAST(ROUND(100.0 * COUNT(*) FILTER (WHERE COALESCE(est_monthly_revenue, 0) >= 100.0) / NULLIF(COUNT(*), 0), 2) AS double precision) AS over_threshold_pct,\n    CAST(SUM(COALESCE(est_monthly_revenue, 0)) AS double precision) AS total_estimated_monthly_revenue\n  FROM platform_matches\n)\nSELECT\n  0 AS sort_order,\n  platform_name || ' crawler summary' AS title,\n  platform_key,\n  platform_name,\n  NULL::text AS platform_kind,\n  total_platform_actors, platform_type_count, revenue_threshold_usd,\n  over_threshold_actors, over_threshold_pct, total_estimated_monthly_revenue,\n  NULL::int AS type_actor_count, NULL::int AS type_over_threshold_actors,\n  NULL::double precision AS type_over_threshold_pct,\n  NULL::text AS top_actor, NULL::double precision AS top_estimated_monthly_revenue\nFROM summary, (SELECT 'youtube' AS platform_key, 'YouTube' AS platform_name) p\nUNION ALL\nSELECT\n  CAST(ROW_NUMBER() OVER (ORDER BY type_actor_count DESC, top_estimated_monthly_revenue DESC) AS int) AS sort_order,\n  'Type - ' || platform_kind AS title,\n  'youtube' AS platform_key,\n  'YouTube' AS platform_name,\n  platform_kind,\n  NULL::int, NULL::int, CAST(100.0 AS double precision),\n  NULL::int, NULL::double precision, NULL::double precision,\n  type_actor_count, type_over_threshold_actors, type_over_threshold_pct,\n  top_actor, top_estimated_monthly_revenue\nFROM kind_stats\nORDER BY sort_order, type_actor_count DESC NULLS LAST\nLIMIT 8","mode":"sql","notes":[],"rationale":"pg sql path (Text-to-SQL / vector over pgvector)"},"results":[{"key":"YouTube crawler summary","url":null,"score":null,"title":"YouTube crawler summary","platform_key":"youtube","platform_name":"YouTube","over_threshold_pct":14.19,"platform_type_count":6,"over_threshold_actors":89,"revenue_threshold_usd":100,"total_platform_actors":627,"total_estimated_monthly_revenue":920618.5},{"key":"Type - Content / posts","url":null,"score":null,"title":"Type - Content / posts","top_actor":"pintostudio/youtube-transcript-scraper","platform_key":"youtube","platform_kind":"Content / posts","platform_name":"YouTube","type_actor_count":296,"revenue_threshold_usd":100,"type_over_threshold_pct":15.54,"type_over_threshold_actors":46,"top_estimated_monthly_revenue":227596},{"key":"Type - Profiles / accounts","url":null,"score":null,"title":"Type - Profiles / accounts","top_actor":"streamers/youtube-channel-scraper","platform_key":"youtube","platform_kind":"Profiles / accounts","platform_name":"YouTube","type_actor_count":99,"revenue_threshold_usd":100,"type_over_threshold_pct":14.14,"type_over_threshold_actors":14,"top_estimated_monthly_revenue":48097.3984375},{"key":"Type - Other YouTube tools","url":null,"score":null,"title":"Type - Other YouTube tools","top_actor":"streamers/youtube-scraper","platform_key":"youtube","platform_kind":"Other YouTube tools","platform_name":"YouTube","type_actor_count":98,"revenue_threshold_usd":100,"type_over_threshold_pct":9.18,"type_over_threshold_actors":9,"top_estimated_monthly_revenue":248165.59375},{"key":"Type - Lead generation","url":null,"score":null,"title":"Type - Lead generation","top_actor":"dataovercoffee/Youtube-Channel-Business-Email-Scraper","platform_key":"youtube","platform_kind":"Lead generation","platform_name":"YouTube","type_actor_count":51,"revenue_threshold_usd":100,"type_over_threshold_pct":21.57,"type_over_threshold_actors":11,"top_estimated_monthly_revenue":90398.3984375},{"key":"Type - Search / discovery","url":null,"score":null,"title":"Type - Search / discovery","top_actor":"grow_media/youtube-search-api","platform_key":"youtube","platform_kind":"Search / discovery","platform_name":"YouTube","type_actor_count":45,"revenue_threshold_usd":100,"type_over_threshold_pct":8.89,"type_over_threshold_actors":4,"top_estimated_monthly_revenue":2595.67993164062},{"key":"Type - Ads / marketing","url":null,"score":null,"title":"Type - Ads / marketing","top_actor":"lurkapi/youtube-to-mp3-audio-downloader","platform_key":"youtube","platform_kind":"Ads / marketing","platform_name":"YouTube","type_actor_count":38,"revenue_threshold_usd":100,"type_over_threshold_pct":13.16,"type_over_threshold_actors":5,"top_estimated_monthly_revenue":2352.23999023438}],"answer":"当前 playbook 快照中，YouTube 相关 Actor 共 627 个，粗分 6 类；估算月收入达到 US$100+ 的有 89 个，占 14.19%。 分类明细：Content / posts: 296 个，46 个达标（15.54%），头部 pintostudio/youtube-transcript-scraper / US$227,596.00；Profiles / accounts: 99 个，14 个达标（14.14%），头部 streamers/youtube-channel-scraper / US$48,097.40；Other YouTube tools: 98 个，9 个达标（9.18%），头部 streamers/youtube-scraper / US$248,165.59；Lead generation: 51 个，11 个达标（21.57%），头部 dataovercoffee/Youtube-Channel-Business-Email-Scraper / US$90,398.40；Search / discovery: 45 个，4 个达标（8.89%），头部 grow_media/youtube-search-api / US$2,595.68；Ads / marketing: 38 个，5 个达标（13.16%），头部 lurkapi/youtube-to-mp3-audio-downloader / US$2,352.24。 这些 Actor 的估算月收入合计约 US$920,618.50。","meta":{"q":"有多少关于youtube的爬虫，分几类，迈过门槛（每个月100美金以上收入）占比多少","mode":"query","view":"auto","page":1,"limit":10}}