account-analytics
Sync account-level daily analytics from Late API into the database. Pulls daily metrics (impressions, reach, likes, comments, shares, views) per platform, follower counts from connected accounts, and stores everything for trend tracking.
Usage
node skills/account-analytics/scripts/account-analytics.js [options]
Options
| Flag |
Description |
Default |
--dry-run |
Show analytics without DB writes |
false |
What It Does
- Calls
GET /v1/analytics/daily-metrics?profileId= for daily platform breakdown
- Calls
GET /v1/accounts?profileId= for follower counts per platform
- Upserts daily metrics into
daily_social_analytics (one row per platform per day)
- Prints a summary table to the console
Prerequisites
LATE_API_KEY in .env
INSFORGE_CONNECTION_STRING in .env
DB Tables Written
daily_social_analytics — daily per-platform metrics (followers, posts_count, likes, comments, shares, impressions, reach, engagement_rate)
Output
Console summary showing:
- Per-platform daily metrics
- Follower counts across all platforms
- Total engagement summary
1---2name: account-analytics3description: account-analytics4---5# account-analytics67Sync account-level daily analytics from Late API into the database. Pulls daily metrics (impressions, reach, likes, comments, shares, views) per platform, follower counts from connected accounts, and stores everything for trend tracking.89## Usage1011```bash12node skills/account-analytics/scripts/account-analytics.js [options]13```1415## Options1617| Flag | Description | Default |18|------|-------------|---------|19| `--dry-run` | Show analytics without DB writes | false |2021## What It Does22231. Calls `GET /v1/analytics/daily-metrics?profileId=` for daily platform breakdown242. Calls `GET /v1/accounts?profileId=` for follower counts per platform253. Upserts daily metrics into `daily_social_analytics` (one row per platform per day)264. Prints a summary table to the console2728## Prerequisites2930- `LATE_API_KEY` in `.env`31- `INSFORGE_CONNECTION_STRING` in `.env`3233## DB Tables Written3435- `daily_social_analytics` — daily per-platform metrics (followers, posts_count, likes, comments, shares, impressions, reach, engagement_rate)3637## Output3839Console summary showing:40- Per-platform daily metrics41- Follower counts across all platforms42- Total engagement summary