메뉴
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'.
SOC 직업 분류 기준
| 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.