skills.rest
Birdhouse-Labs
Birdhouse-LabsOFFICIAL
Explore all skills by this author →
Website𝕏@birdhouselabsaiGitHub

posthog-usage-report

Generate Birdhouse app usage reports from PostHog with active users, events, and install trends.

36|5|Updated Feb 27, 2026
Search Tags:#analytics#posthog#product analytics#hogql#usage report#active users#install tracking
One-click install
npx skills add https://github.com/Birdhouse-Labs/birdhouse --skill posthog-usage-report-birdhouse-labs
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: posthog-usage-report
Source: https://github.com/Birdhouse-Labs/birdhouse/tree/main/.agents/skills/internal/birdhouse/posthog-usage-report
Command: npx skills add https://github.com/Birdhouse-Labs/birdhouse --skill posthog-usage-report-birdhouse-labs

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Understanding who is actually using the Birdhouse app requires manually querying PostHog across multiple time windows and stitching together user activity, geography, and install data into a readable report. ## Core Features & Use Cases - Multi-Window Usage Queries: Runs parallel HogQL queries for 1, 3, and 7 day windows showing per-user event counts, active days, and first/last seen timestamps. - Install Tracking: Reports daily install counts over 5 days plus per-install details including OS, browser, device type, and user agent. - Internal vs External User Annotation: Automatically flags known team members (founders) and highlights external users worth attention. - Use Case: Ask for a usage report before a weekly standup to see how many external users were active this week, where they are located, and whether installs are trending up. ## Quick Start Ask the agent to generate a PostHog usage report for the Birdhouse app covering the last 7 days.

Frequently Asked Questions about posthog-usage-report

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a PostHog usage report for my app?▼

Switch to the correct PostHog project, then run HogQL queries grouping events by person name and location across your desired time windows. Filter by a product property to exclude unrelated traffic like marketing sites.

How to query active users in PostHog with HogQL?▼

Use a HogQL query on the events table grouping by person.properties.name and geoip fields, counting events and using uniq(toDate(timestamp)) for active days. Filter with a timestamp interval like now() - INTERVAL 7 DAY.

Can PostHog track app installs separately from website traffic?▼

Yes, filter events by a custom property such as properties.product to isolate app events from marketing site traffic. A dedicated install event can be queried with the trends API for daily counts.

Why does countDistinct fail in PostHog HogQL queries?▼

HogQL does not support countDistinct(); use the uniq() function instead for distinct counts. For example, uniq(toDate(timestamp)) counts distinct active days per user.

What are the limitations of PostHog geoip location data?▼

GeoIP locations are approximate and based on IP addresses, so cities may be inaccurate for VPN or mobile users. Anonymous users appear with null names and should be labeled as anonymous in reports.

Related Skills

Explore More Data & Analytics Skills→
PostHogPostHog
58

integration-django

Integrates PostHog analytics into Django applications via middleware and AppConfig.

Official
Advanced
kayackayac
11

np-report

Query the D1 production database to generate usage analytics reports.

Official
Intermediate
PostHogPostHog
58

user-deep-dive

Aggregate PostHog and Vitally data into a user activity profile with outreach angles.

Official
Advanced
EvezArtEvezArt
3

analytics-dashboard

Automate analytics provider setup and dashboard generation for web applications.

Community
Intermediate