{"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 LinkedIn tools'\n    END AS platform_kind\n  FROM apify.actor\n  WHERE COALESCE(is_deprecated, false) = false\n    AND (LOWER(COALESCE(target_platform, '')) IN ('linkedin') OR LOWER(COALESCE(full_name, '')) LIKE '%linkedin%' OR LOWER(COALESCE(title, '')) LIKE '%linkedin%')\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 'linkedin' AS platform_key, 'LinkedIn' 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  'linkedin' AS platform_key,\n  'LinkedIn' 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 10","mode":"sql","notes":[],"rationale":"pg sql path (Text-to-SQL / vector over pgvector)"},"results":[{"key":"LinkedIn crawler summary","url":null,"score":null,"title":"LinkedIn crawler summary","platform_key":"linkedin","platform_name":"LinkedIn","over_threshold_pct":29.13,"platform_type_count":8,"over_threshold_actors":187,"revenue_threshold_usd":100,"total_platform_actors":642,"total_estimated_monthly_revenue":6957635.5},{"key":"Type - Jobs / recruiting","url":null,"score":null,"title":"Type - Jobs / recruiting","top_actor":"apimaestro/linkedin-jobs-scraper-api","platform_key":"linkedin","platform_kind":"Jobs / recruiting","platform_name":"LinkedIn","type_actor_count":139,"revenue_threshold_usd":100,"type_over_threshold_pct":23.74,"type_over_threshold_actors":33,"top_estimated_monthly_revenue":20454.19921875},{"key":"Type - Company / employees","url":null,"score":null,"title":"Type - Company / employees","top_actor":"harvestapi/linkedin-company","platform_key":"linkedin","platform_kind":"Company / employees","platform_name":"LinkedIn","type_actor_count":125,"revenue_threshold_usd":100,"type_over_threshold_pct":32.8,"type_over_threshold_actors":41,"top_estimated_monthly_revenue":162835.6875},{"key":"Type - Lead generation","url":null,"score":null,"title":"Type - Lead generation","top_actor":"apimaestro/linkedin-profile-detail","platform_key":"linkedin","platform_kind":"Lead generation","platform_name":"LinkedIn","type_actor_count":121,"revenue_threshold_usd":100,"type_over_threshold_pct":28.93,"type_over_threshold_actors":35,"top_estimated_monthly_revenue":718253},{"key":"Type - Profiles / accounts","url":null,"score":null,"title":"Type - Profiles / accounts","top_actor":"harvestapi/linkedin-profile-search","platform_key":"linkedin","platform_kind":"Profiles / accounts","platform_name":"LinkedIn","type_actor_count":101,"revenue_threshold_usd":100,"type_over_threshold_pct":40.59,"type_over_threshold_actors":41,"top_estimated_monthly_revenue":2647424},{"key":"Type - Content / posts","url":null,"score":null,"title":"Type - Content / posts","top_actor":"pratikdani/linkedin-posts-scraper","platform_key":"linkedin","platform_kind":"Content / posts","platform_name":"LinkedIn","type_actor_count":63,"revenue_threshold_usd":100,"type_over_threshold_pct":31.75,"type_over_threshold_actors":20,"top_estimated_monthly_revenue":13417},{"key":"Type - Other LinkedIn tools","url":null,"score":null,"title":"Type - Other LinkedIn tools","top_actor":"bestscrapers/linkedin-open-to-work-status","platform_key":"linkedin","platform_kind":"Other LinkedIn tools","platform_name":"LinkedIn","type_actor_count":53,"revenue_threshold_usd":100,"type_over_threshold_pct":13.21,"type_over_threshold_actors":7,"top_estimated_monthly_revenue":2656.9599609375},{"key":"Type - Ads / marketing","url":null,"score":null,"title":"Type - Ads / marketing","top_actor":"muhammad_usama/linkedin-data-scraper-every-thing","platform_key":"linkedin","platform_kind":"Ads / marketing","platform_name":"LinkedIn","type_actor_count":26,"revenue_threshold_usd":100,"type_over_threshold_pct":15.38,"type_over_threshold_actors":4,"top_estimated_monthly_revenue":9790.759765625},{"key":"Type - Search / discovery","url":null,"score":null,"title":"Type - Search / discovery","top_actor":"apimaestro/linkedin-posts-search-scraper-no-cookies","platform_key":"linkedin","platform_kind":"Search / discovery","platform_name":"LinkedIn","type_actor_count":14,"revenue_threshold_usd":100,"type_over_threshold_pct":42.86,"type_over_threshold_actors":6,"top_estimated_monthly_revenue":92789}],"answer":"当前 playbook 快照中，LinkedIn 相关 Actor 共 642 个，粗分 8 类；估算月收入达到 US$100+ 的有 187 个，占 29.13%。 分类明细：Jobs / recruiting: 139 个，33 个达标（23.74%），头部 apimaestro/linkedin-jobs-scraper-api / US$20,454.20；Company / employees: 125 个，41 个达标（32.80%），头部 harvestapi/linkedin-company / US$162,835.69；Lead generation: 121 个，35 个达标（28.93%），头部 apimaestro/linkedin-profile-detail / US$718,253.00；Profiles / accounts: 101 个，41 个达标（40.59%），头部 harvestapi/linkedin-profile-search / US$2,647,424.00；Content / posts: 63 个，20 个达标（31.75%），头部 pratikdani/linkedin-posts-scraper / US$13,417.00；Other LinkedIn tools: 53 个，7 个达标（13.21%），头部 bestscrapers/linkedin-open-to-work-status / US$2,656.96；Ads / marketing: 26 个，4 个达标（15.38%），头部 muhammad_usama/linkedin-data-scraper-every-thing / US$9,790.76；Search / discovery: 14 个，6 个达标（42.86%），头部 apimaestro/linkedin-posts-search-scraper-no-cookies / US$92,789.00。 这些 Actor 的估算月收入合计约 US$6,957,635.50。","meta":{"q":"有多少关于linkin的爬虫，分几类，迈过门槛（每个月100美金以上收入）占比多少","mode":"query","view":"auto","page":1,"limit":10}}