agentleFS
CodeAlive-AICodeAlive-AI/ceo-ai-os/skills/posthog-analytics/SKILL.md

posthog-analytics

Skill9 starsChanged 6 months agoMITView on GitHub

Raw PostHog data queries via MCP — event catalog, query recipes, dashboards, funnels, experiments. Use for specific data questions. For CEO-level metric interpretation and frameworks, use metrics-briefing instead.

7 other projects use a version of this, 1 of them edited.

Adopted by

Most recently taken up by

The file

We split this skill into the rules it gives an agent

3 rules. 0 are common, 1 is distinctive, and 2 are very specific to this project.

  • 0

    Common

    Most of the 7 edited versions we read keep these.

  • 1

    Distinctive

    This author's own choices. Worth a look.

  • 2

    Very specific

    Tied to their project's names, files or tools. Probably skip.

  • Common
  • Distinctive
  • Very specific
  1. Very specific:

    Call the native MCP tool posthog__<tool-name> directly (server=posthog, tool=<tool-name>).

    line 21
  2. Very specific:

    Default project is "app" ([YOUR_APP_PROJECT_ID]).

    line 167
  3. Distinctive:

    Always segment by target cohort when possible

    line 219

“Common” is measured: kept by at least 6 in 10 of the 7 edited versions of this file we could read. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.

Keep what fits and drop the rest. Your version, ready for your agents.
Files
SKILL.md

PostHog Analytics

Direct access to PostHog data for your projects.

Projects

NameIDUse
app[YOUR_APP_PROJECT_ID]Main product analytics (DEFAULT)
landing[YOUR_LANDING_PROJECT_ID]Landing page analytics
documentation[YOUR_DOCS_PROJECT_ID]Docs site analytics

Tool

Call the native MCP tool posthog__<tool-name> directly (server=posthog, tool=<tool-name>). Parameters go in a JSON object — examples below use shorthand key=value.

Event Catalog

Journey & Funnel Events

EventDescriptionKey Properties
conversion_funnelFunnel stage trackingfunnel (value_realization, onboarding, workspace_collaboration, primary_resource_activation, primary_resource_import)
funnel_next_stage_availableStage transitioncurrentStage, nextStage, nextStageName, funnelId, organizationId
user_journey_milestoneUser milestone reachedmilestone, milestoneId, journeyId, timeSincePrevious, organizationId, signup_method
journey_critical_path_progressCritical path progressprogress, completedMilestones, journeyId, organizationId
key_milestone_reachedQuery milestone—

Funnel Stages (from funnel_next_stage_available)

signup_started → account_created → email_confirmed
→ workspace_created → first_value_moment
→ first_primary_resource_added → primary_resource_connect_started
→ primary_resource_connected → primary_resource_processed
→ first_key_action_executed → first_value_delivered
→ return_usage → regular_usage → power_user
→ team_invitation_sent

Milestone Values (from user_journey_milestone)

Return Visit, Weekly Active, First Resource Connected, Account Created, workspace_activated, First Value Moment, First Workspace Created

Chat & Search Events

EventKey Properties
core_action— (core product usage)
session_started—
session_resumed—
context_sources_changed—
context_source_selected—
core_query_performedquery, searchMode, searchType, resultCount, timeToResults, workspaceId, totalRepositories
deep_workflow_started—
example_selected—
core_action_retry—

Repository Events

EventKey Properties
primary_resource_actionaction, repositoryType, processingStatus, repositoryName, isReindex, autoReindex, isPrivate, organizationId
primary_resource_listing_viewed—
primary_resource_ready—

Workspace Events

EventKey Properties
workspace_create_started—
workspace_updated—
workspace_deleted / workspace_delete_initiated—
workspace_edit_started—
workspace_resources_updated—
workspace_refresh_triggered—
team_collaboration_event—
workspace_usage_patterns—
primary_action_started—

Sharing Events (virality signals)

EventKey Properties
output_sharing_enabled—
share_link_copied—
public_output_viewed—

Person Properties (B2B-relevant)

PropertyTypeUse
email_verifiedBooleanQualified signup filter
has_primary_integration_connectedBooleanActivation signal
has_secondary_integration_connectedBooleanActivation signal
$initial_utm_sourceStringFirst-touch attribution
$initial_utm_mediumStringFirst-touch attribution
$initial_utm_campaignStringFirst-touch attribution
$initial_referring_domainStringFirst-touch attribution
$initial_current_urlStringLanding page attribution

Event Properties (cross-event)

PropertyTypeFound On
organizationIdStringMost events — B2B account grouping
workspace_id / workspaceIdStringWorkspace events, search, journey
workspace_name / workspaceNameStringWorkspace events
sourceStringJourney, funnel, search events
isAuthenticatedBooleanMost events
timeSincePreviousNumericJourney milestones

Key Tools

Discovery

posthog__event-definitions-list
posthog__event-definitions-list q="signup"
posthog__properties-list type=event eventName="conversion_funnel"
posthog__properties-list type=person
posthog__entity-search query="activation"

Natural Language Queries (recommended)

posthog__query-generate-hogql-from-question question="..."

Best for:

  • Complex breakdowns by multiple properties
  • Account-level (organizationId) aggregations
  • Attribution analysis ($initial_* properties)
  • Time-between-events calculations

Saved Insights

posthog__insights-get-all
posthog__insight-get insightId="123"
posthog__insight-query insightId="123"

Dashboards

posthog__dashboards-get-all
posthog__dashboard-get dashboardId=[YOUR_DASHBOARD_ID]

Experiments & Feature Flags

posthog__experiment-get-all
posthog__experiment-results-get experimentId=123 refresh=false
posthog__feature-flag-get-all
posthog__feature-flag-get-definition flagKey="my-flag"

Errors

posthog__list-errors orderBy=occurrences dateFrom="2026-01-01T00:00:00Z"
posthog__error-details issueId="uuid-here"

Surveys

posthog__surveys-get-all
posthog__survey-stats survey_id="uuid"

Switching Projects

Default project is "app" ([YOUR_APP_PROJECT_ID]). To query landing or docs:

posthog__switch-project projectId=[YOUR_LANDING_PROJECT_ID]
# Now all queries target "landing"
# Switch back after:
posthog__switch-project projectId=[YOUR_APP_PROJECT_ID]

Query Recipes

CEO Morning Briefing

# DAU yesterday
posthog__query-generate-hogql-from-question question="How many unique users had pageview events yesterday?"

# New signups yesterday
posthog__query-generate-hogql-from-question question="How many user_journey_milestone events with milestone Account Created happened yesterday?"

# Funnel progression yesterday
posthog__query-generate-hogql-from-question question="Show all funnel_next_stage_available events from yesterday, count by currentStage to nextStage transition"

Weekly CEO Dashboard

# Funnel health
posthog__query-generate-hogql-from-question question="Show funnel_next_stage_available events in the last 7 days, count unique users for each currentStage to nextStage pair"

# Active companies
posthog__query-generate-hogql-from-question question="How many distinct organizationId values had any events in the last 7 days?"

# TTFV
posthog__query-generate-hogql-from-question question="What is the average timeSincePrevious for user_journey_milestone where milestone is First Value Moment, last 30 days?"

# Source attribution
posthog__query-generate-hogql-from-question question="For users who reached first_value_delivered in funnel_next_stage_available last 30 days, what are the top initial UTM sources?"

Product Health

# Search quality
posthog__query-generate-hogql-from-question question="What is the average resultCount and timeToResults for core_query_performed events this week?"

# Primary resource connection success
posthog__query-generate-hogql-from-question question="How many primary_resource_action events by processingStatus in the last 7 days?"

Output Format

Present results concisely for chat platforms:

  • Key number + trend (vs previous period)
  • Flag anomalies
  • Link to metric class (Primary CEO / Secondary / B2B bridge)
  • Always segment by target cohort when possible

Download now (ZIP)

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

No reviews yet

People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.

  • It worked
  • Partly
  • It didn't
What did you use it for? e.g. Reviewing pull requests in a Rails app

Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.