skills.rest
pingwu
pingwuCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

growth-analytics

Define core growth metrics with AARRR funnel and cohort SQL templates.

12|41|Updated Feb 5, 2026
Search Tags:#retention#cohort-analysis#ab-testing#north-star#aarr#growth-analytics#kpis-okrs
One-click install
npx skills add https://github.com/pingwu/solo-unicorn --skill growth-analytics
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: growth-analytics
Source: https://github.com/pingwu/solo-unicorn/tree/main/skills/growth-analytics
Command: npx skills add https://github.com/pingwu/solo-unicorn --skill growth-analytics

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Quantify and optimize growth by defining and tracking core metrics.

Core Features & Use Cases

  • AARRR pirate metrics framework: apply funnel analysis to identify bottlenecks.
  • North Star metric selection: choose a guiding metric that aligns with business value.
  • A/B testing and sample size planning: design experiments with statistical rigor.
  • Cohort retention analysis with SQL templates: diagnose retention issues across cohorts.
  • Use Case: When setting up analytics, designing experiments, or diagnosing growth bottlenecks.

Quick Start

Analyze your current analytics setup and generate a North Star metric, an AARRR funnel, and a retention cohort template for the last 30 days.

Frequently Asked Questions about growth-analytics

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

FAQPage Schema
How do I define a North Star metric to guide product growth?▼

A North Star metric guides product growth by aligning a single core metric with overall business value and customer value delivery. This Skill helps define and track this guiding metric to quantify and optimize growth across SaaS and consumer apps.

How do I perform an AARRR funnel analysis to identify growth bottlenecks?▼

To perform AARRR funnel analysis, apply the pirate metrics framework to map the user journey from acquisition to referral. This Skill provides practical guidelines to diagnose growth bottlenecks and identify drop-off points across each funnel stage.

Can I generate SQL templates for cohort retention analysis?▼

Yes, you can generate SQL templates for cohort retention analysis to diagnose retention issues across different user cohorts. This Skill provides metric definitions and SQL templates to quantify and optimize retention over the last 30 days.

What is the best way to plan A/B testing sample sizes with statistical rigor?▼

The best way to plan A/B testing sample sizes is by designing experiments with strict statistical rigor to ensure valid results. This Skill provides A/B testing guidance and sample size planning to prioritize growth experiments effectively.

Does this growth analytics approach work for both SaaS and consumer apps?▼

Yes, this growth analytics approach supports product analytics and growth diagnostics across both SaaS and consumer apps. It enables North Star metric selection, AARRR funnel analysis, and retention cohort reporting for diverse product contexts.

Related Skills

Explore More Data & Analytics Skills→
CodeAlive-AICodeAlive-AI
3

posthog-analytics

Retrieve PostHog product analytics answers from raw events and properties.

Official
Intermediate
clawpod-appclawpod-app
46

experiment-design

Design growth experiments with hypotheses, ICE scoring, and success criteria.

Community
Intermediate
maigenticmaigentic
37

growth-hacking-playbook

Design a 90-day growth playbook with AARRR metrics and ICE-scored experiments.

Community
Advanced
robdmcrobdmc

duckdb-sql

Generate DuckDB SQL queries from plain English questions using asset schemas.

Community
Advanced