AugmentClaude
BackendTestingSecurity

Product Funnel Stats

By m13v· m13v/social-autoposter· 0

Track marketing funnel metrics from social posts through bookings.

Installation

  1. Make sure Claude is on your device and in your terminal.

    Skills load from ~/.claude/skills/ when Claude Code starts up — so you need it on your machine first. If you don't have it yet, install it once with the command below, then run claude in any terminal to verify.

    One-time setup
    npm i -g @anthropic-ai/claude-code

    Already have it? Skip ahead.

  2. Paste into Claude Code or into your terminal.
    Install
    Sign up to copy
    Sign up free to reveal

    This copies the whole skill folder into ~/.claude/skills/posthog-funnel-m13v/ — the SKILL.md plus any scripts, reference docs, or templates the skill ships with. Safe default: works for every skill.

    Faster alternative (instruction-only skills)

    Skips the clone and grabs only the SKILL.md file. Don't use this if the skill ships Python scripts, reference markdowns, or asset templates — they won't be downloaded and the skill will fail when it tries to load them.

    Quick install (SKILL.md only)
    Sign up to copy
    Sign up free to reveal
  3. Restart Claude Code.

    Quit and reopen Claude Code (or any other agent that loads from ~/.claude/skills/). New skills are picked up on startup.

  4. Just ask Claude.

    Skills auto-activate when your request matches the skill's description — no slash command needed. Trigger phrases live in the skill's own frontmatter; you can read them in the “What this skill does” section above.

Prefer to read the source first? Open on GitHub.

When Claude uses it

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'.

What this skill does

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:

SourceWhatConnection
Posts DB (DATABASE_URL)Social post counts, engagement, platform breakdown~/social-autoposter/.env
PostHog API (POSTHOG_PERSONAL_API_KEY)Pageviews, CTA clicks by domainProject 330744
Bookings DB (BOOKINGS_DATABASE_URL)Cal.com bookings by clientSeparate Neon DB

Product-to-Domain Mapping

ProductMain DomainSEO Landing PagesCal slug
Cyranocyrano.systemsapartment-security-cameras.comcyrano
PieLinegetpieline.comaiphoneordering.compieline
Fazmfazm.ai—fazm
S4Ls4l.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:

ProjectPostsEngagementSEO PagesPageviewsCTA ClicksCTRBookings

Never omit SEO Pages or CTA Clicks from the summary table — these are core funnel metrics.

Related skills

G

Generative Code Art

anthropics

Create algorithmic art with p5.js using randomness and interactive parameters.

OfficialComplete terms in LICENSE.txt
P

Poster & Visual Design

anthropics

Create original posters and visual art in PNG and PDF formats.

OfficialComplete terms in LICENSE.txt
C

Claude API Helper

anthropics

Build, debug, and optimize Claude API applications with caching and model migration support.

OfficialComplete terms in LICENSE.txt
M

MCP Server Builder

anthropics

Build protocol servers that connect language models to external APIs and services.

OfficialComplete terms in LICENSE.txt