posthog
Query PostHog for product analytics, create insights, dashboards, and track AI referral traffic. Auto-activates when user asks about analytics, user behavior, funnels, retention, AI traffic, or dashboards. Trigger words: "check posthog", "create insight", "analytics", "user behavior", "AI traffic", "dashboard", "funnel", "retention"
معلومات المصدر
- المستودع
- BasedHardware/omi-landing
- آخر نشاط في المصدر
- ٢٣ يناير ٢٠٢٦ في ٠١:٥٤
- لغة SKILL.md المكتشفة
- الإنجليزية
- النجوم
- ٤
- التفرعات
- ٥
خيارات التثبيت
يُحدَّد Prompt الذي يراجع المصدر أولًا بشكل افتراضي. يمكنك التبديل إلى أمر مباشر أو تنزيل نسخة محلية.
مراجعة ملفات المصدر
اقرأ SKILL.md وأي ملفات مرافقة يعرضها SkillsMP قبل أن تقرر التثبيت.
عرض SKILL.md
SKILL.md
تعليمات المصدر · معاينة للقراءة فقط- name
- posthog
- description
- Query PostHog for product analytics, create insights, dashboards, and track AI referral traffic. Auto-activates when user asks about analytics, user behavior, funnels, retention, AI traffic, or dashboards. Trigger words: "check posthog", "create insight", "analytics", "user behavior", "AI traffic", "dashboard", "funnel", "retention"
# PostHog Analytics Skill
Query and manage PostHog product analytics for Mediar applications.
## Configuration
**Host:** `https://eu.i.posthog.com`
**Project Key (SDK):** `phc_NFSaZUao49XckpqaeyB3lIEKrFXhhXbKaI81jqZ8yn9`
**Personal API Key:** Required for API operations. Read `POSTHOG_API_KEY` from `.env.local`
### Getting a Personal API Key
1. Go to https://eu.posthog.com/settings/user-api-keys
2. Click "Create personal API key"
3. Name it (e.g., "claude-code")
4. Select scopes: `insight:read`, `insight:write`, `dashboard:read`, `dashboard:write`, `query:read`
5. Add to `.env.local`: `POSTHOG_API_KEY=phx_xxx...`
---
## PowerShell Queries (Windows)
Use PowerShell for all queries to avoid bash escaping issues.
### Get Project ID
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{ 'Authorization' = \"Bearer $token\" }
$response = Invoke-RestMethod -Uri 'https://eu.i.posthog.com/api/projects/' -Headers $headers
$response.results | ForEach-Object { Write-Host \"[$($_.id)] $($_.name)\" }
"
```
### List All Insights
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{ 'Authorization' = \"Bearer $token\" }
$projectId = 'YOUR_PROJECT_ID' # Get from above query
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/insights/?limit=20\" -Headers $headers
$response.results | ForEach-Object {
Write-Host \"[$($_.id)] $($_.name)\"
Write-Host \" Type: $($_.filters.insight) | Created: $($_.created_at)\"
}
"
```
### List All Dashboards
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{ 'Authorization' = \"Bearer $token\" }
$projectId = 'YOUR_PROJECT_ID'
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/dashboards/\" -Headers $headers
$response.results | ForEach-Object {
Write-Host \"[$($_.id)] $($_.name)\"
Write-Host \" Tiles: $($_.tiles.Count) | Created: $($_.created_at)\"
}
"
```
---
## Create Insights
### Create AI Referral Traffic Insight
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$body = @{
name = 'AI Referral Traffic'
filters = @{
insight = 'TRENDS'
events = @(@{ id = '`$pageview'; type = 'events' })
properties = @{
type = 'OR'
values = @(
@{ key = '`$referrer'; value = 'chatgpt.com'; operator = 'icontains'; type = 'event' }
@{ key = '`$referrer'; value = 'claude.ai'; operator = 'icontains'; type = 'event' }
@{ key = '`$referrer'; value = 'perplexity.ai'; operator = 'icontains'; type = 'event' }
@{ key = '`$referrer'; value = 'gemini.google.com'; operator = 'icontains'; type = 'event' }
)
}
date_from = '-30d'
}
} | ConvertTo-Json -Depth 10
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/insights/\" -Method POST -Headers $headers -Body $body
Write-Host \"Created insight: $($response.id) - $($response.name)\"
"
```
### Create Pageviews by Page Insight
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$body = @{
name = 'Top Pages'
filters = @{
insight = 'TRENDS'
events = @(@{ id = '`$pageview'; type = 'events' })
breakdown = '`$pathname'
breakdown_type = 'event'
date_from = '-7d'
}
} | ConvertTo-Json -Depth 10
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/insights/\" -Method POST -Headers $headers -Body $body
Write-Host \"Created insight: $($response.id) - $($response.name)\"
"
```
### Create User Funnel Insight
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$body = @{
name = 'Signup Funnel'
filters = @{
insight = 'FUNNELS'
events = @(
@{ id = '`$pageview'; type = 'events'; name = 'Visit' }
@{ id = 'signup_started'; type = 'events'; name = 'Start Signup' }
@{ id = 'signup_completed'; type = 'events'; name = 'Complete Signup' }
)
date_from = '-30d'
}
} | ConvertTo-Json -Depth 10
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/insights/\" -Method POST -Headers $headers -Body $body
Write-Host \"Created funnel: $($response.id) - $($response.name)\"
"
```
---
## Dashboard Operations
### Create Dashboard
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$body = @{
name = 'AI Traffic Dashboard'
description = 'Track traffic from AI assistants (ChatGPT, Claude, Perplexity)'
} | ConvertTo-Json
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/dashboards/\" -Method POST -Headers $headers -Body $body
Write-Host \"Created dashboard: $($response.id) - $($response.name)\"
"
```
### Add Insight to Dashboard
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$dashboardId = 'YOUR_DASHBOARD_ID'
$insightId = 'YOUR_INSIGHT_ID'
$body = @{
tiles = @(@{ insight = $insightId })
} | ConvertTo-Json -Depth 5
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/dashboards/$dashboardId/\" -Method PATCH -Headers $headers -Body $body
Write-Host \"Added insight to dashboard: $($response.name)\"
"
```
---
## Query Events (HogQL)
### Query Recent Events
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$body = @{
query = @{
kind = 'HogQLQuery'
query = 'SELECT event, properties.`$referrer` as referrer, count() as count FROM events WHERE timestamp > now() - INTERVAL 7 DAY GROUP BY event, referrer ORDER BY count DESC LIMIT 20'
}
} | ConvertTo-Json -Depth 5
$response = Invoke-RestMethod -Uri \"https://eu.i.posthog.com/api/projects/$projectId/query/\" -Method POST -Headers $headers -Body $body
$response.results | ForEach-Object { Write-Host $_ }
"
```
### Query AI Bot Referrals
```powershell
powershell -Command "
$token = (Get-Content .env.local | Where-Object { $_ -match '^POSTHOG_API_KEY=' }) -replace 'POSTHOG_API_KEY=', '' -replace '\"', ''
$headers = @{
'Authorization' = \"Bearer $token\"
'Content-Type' = 'application/json'
}
$projectId = 'YOUR_PROJECT_ID'
$body = @{
query = @{
kind = 'HogQLQuery'
query = @'
SELECT
CASE
WHEN properties.`$referrer` LIKE '%chatgpt%' OR properties.`$referrer` LIKE '%openai%' THEN 'ChatGPT'
WHEN properties.`$referrer` LIKE '%claude.ai%' THEN 'Claude'
WHEN properties.`$referrer` LIKE '%perplexity%' THEN 'Perplexity'
WHEN properties.`$referrer` LIKE '%gemini%' THEN 'Gemini'
ELSE 'Other AI'
END as ai_source,
count() as visits,
uniq(distinct_id) as unique_users
FROM events
WHERE event = '$pageview'
AND (
properties.`$referrer` LIKE '%chatgpt%'
OR properties.`$referrer` LIKE '%openai%'
OR properties.`$referrer` LIKE '%claude.ai%'
OR properties.`$referrer` LIKE '%perplexity%'
OR properties.`$referrer` LIKE '%gemini%'
)
AND timestamp > now() - INTERVAL 30 DAY
GROUP BY ai_source
ORDER BY visits DESC
'@
}
} | ConvertTo-Json -Depth 5
عرض على GitHubملف SKILL.md هذا كبير جدا، لذلك يعرض SkillsMP القسم الاول فقط هنا. عرض على GitHub
