How do I install the Posthog Funnel skill?

Run npx skillmds@latest add m13v/posthog-funnel in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Posthog Funnel safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Posthog Funnel?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Posthog Funnel free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Posthog Funnel?

m13v (@m13v) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Posthog Funnel by m13v — Agent Skill

Name: Posthog Funnel
Author: m13v

File contents

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 Postgres database (same Cloud SQL instance)

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 webhooks
POSTHOG_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.

---name: posthog-funneldescription: 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'.---# Product Funnel StatsFull 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 worksRun the unified stats script:```bashpython3 ~/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-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 KeysTwo keys, same project (330744):- `NEXT_PUBLIC_POSTHOG_KEY` (`phc_...`) — project ingestion key, writes events from browsers and webhooks- `POSTHOG_PERSONAL_API_KEY` (`phx_...`) — personal API key, reads/queries data## OutputThe 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 formatWhen 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.

Frequently asked questions

Posthog Funnel