菜单
Full product funnel stats: social posts, pageviews, CTA clicks, bookings. Use when: 'funnel stats', 'product stats', 'how are cyrano/pieline doing', 'posthog funnel', 'project stats', 'boost hop', 'boost hop funnel'.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
Automate social media posting across Reddit, X/Twitter, LinkedIn, and Moltbook. Find threads, post comments, create original posts, track engagement stats. Use when: 'post to social', 'social autoposter', 'find threads to comment on', 'create a post', 'audit social posts', 'update post stats'.
Set up social-autoposter for a new user end to end. Installs/repairs the runtime, discovers product and voice context, connects X/Twitter, seeds search topics, schedules the draft autopilot, and verifies it produces a draft. Use when: 'set up social autoposter', 'install social autoposter', 'configure social posting'.
Use when the user says "convert this browser MCP call to python", "automate this with CDP", "stop using LLM tokens for this scrape", "make this a python script", or wants to replace browser-MCP-driven automation with a Python+CDP script that reuses the running MCP browser's session. Zero LLM tokens consumed once written. Per-platform (e.g., `scripts/linkedin_browser.py`).
Create a browser automation script that bundles multi-step browser interactions into a single browser_run_code call. Use when: 'automate browser flow', 'create browser script', 'script this browser task', 'bundle browser steps', 'reduce browser tokens'.
| name | posthog-funnel |
| description | Full product funnel stats: social posts, pageviews, CTA clicks, bookings. Use when: 'funnel stats', 'product stats', 'how are cyrano/pieline doing', 'posthog funnel', 'project stats', 'boost hop', 'boost hop funnel'. |
| user_invocable | true |
Full marketing funnel per project: social posts -> pageviews -> CTA clicks -> Cal.com bookings.
/posthog-funnel # all products
/posthog-funnel cyrano # single product
/posthog-funnel --days 7 # custom lookback
Run the unified stats script:
python3 ~/social-autoposter/scripts/project_stats.py [--project NAME] [--days 30] [--quiet]
This queries three data sources in one shot:
| Source | What | Connection |
|---|---|---|
Posts DB (DATABASE_URL) | Social post counts, engagement, platform breakdown | ~/social-autoposter/.env |
PostHog API (POSTHOG_PERSONAL_API_KEY) | Pageviews, CTA clicks by domain | Project 330744 |
Bookings DB (BOOKINGS_DATABASE_URL) | Cal.com bookings by client | Separate Postgres database (same Cloud SQL instance) |
| Product | Main Domain | SEO Landing Pages | Cal slug |
|---|---|---|---|
| Cyrano | cyrano.systems | apartment-security-cameras.com | cyrano |
| PieLine | getpieline.com | aiphoneordering.com | pieline |
| Fazm | fazm.ai | — | fazm |
| S4L | s4l.ai | — | s4l |
Domains are read from config.json -> projects[].website and projects[].landing_pages.base_url.
Two keys, same project (330744):
NEXT_PUBLIC_POSTHOG_KEY (phc_...) — project ingestion key, writes events from browsers and webhooksPOSTHOG_PERSONAL_API_KEY (phx_...) — personal API key, reads/queries dataThe script prints per-project:
Full funnel: social posts -> SEO pages created -> pageviews -> CTA clicks -> bookings
When reporting results to the user, the Project Highlights table MUST include all funnel columns:
| Project | Posts | Engagement | SEO Pages | Pageviews | CTA Clicks | CTR | Bookings |
|---|
Never omit SEO Pages or CTA Clicks from the summary table — these are core funnel metrics.