m13v/posthog-funnel
.claude/skills/posthog-funnel/SKILL.md
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'.
$ install --global
skillsauthnpx skillsauth add m13v/social-autoposter posthog-funnelInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 7, 2026, 3:18 AM33.0s1 file scanned
SKILL.md
- 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
Product Funnel Stats
Full marketing funnel per project: social posts -> pageviews -> CTA clicks -> Cal.com bookings.
Usage
/posthog-funnel # all products
/posthog-funnel cyrano # single product
/posthog-funnel --days 7 # custom lookback
How it works
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 Neon DB |
Product-to-Domain Mapping
| 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.
PostHog Keys
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 data
Output
The script prints per-project:
- Social post counts (total, recent, active, removed) with platform breakdown
- Engagement totals (upvotes, comments, views)
- SEO landing page count (total pages created by the social-autoposter pipeline)
- PostHog pageviews with top pages breakdown
- CTA click details (button text, section, timestamp)
- Cal.com booking stats (total, booked, cancelled, real vs test)
- Funnel conversion rates (pageviews -> CTAs -> bookings)
Full funnel: social posts -> SEO pages created -> pageviews -> CTA clicks -> bookings
Reporting format
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.
Related Skills
m13v/client-website
tools
VerifiedTrustedCommunity
End-to-end workflow for creating, rebuilding, or enhancing a client's website. Covers SEO audit, content extraction, Next.js scaffolding, real image/video assets, structured data, SEO guide pages, component injection, analytics, deployment, and dashboard registration. Includes concrete design system blueprints with exact Tailwind classes, component templates, and section layouts. Use when: 'create client website', 'rebuild website', 'recreate site', 'client landing page', 'SEO pages for client', or when onboarding a new client who needs a web presence.
36SKILL.mdUpdated Apr 16, 2026
m13v/client-website
tools
VerifiedTrustedCommunity
End-to-end workflow for creating, rebuilding, or enhancing a client's website. Covers SEO audit, content extraction, Next.js scaffolding, real image/video assets, structured data, SEO guide pages, component injection, analytics, deployment, and dashboard registration. Includes concrete design system blueprints with exact Tailwind classes, component templates, and section layouts. Use when: 'create client website', 'rebuild website', 'recreate site', 'client landing page', 'SEO pages for client', or when onboarding a new client who needs a web presence.
35SKILL.mdUpdated Apr 7, 2026
m13v/social-autoposter-setup
tools
VerifiedTrustedCommunity
Set up social-autoposter for a new user. Interactive wizard that installs via npm, creates the database, configures accounts, verifies browser logins, and optionally sets up scheduled automation. Use when: 'set up social autoposter', 'install social autoposter', 'configure social posting'.
35SKILL.mdUpdated Apr 7, 2026
m13v/social-autoposter
testing
VerifiedTrustedCommunity
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', or after completing any task (mandatory per CLAUDE.md).
35SKILL.mdUpdated Apr 7, 2026