# Weekly Metrics Tracker

Social followers pulled from Meta Business Suite (business_id=2655918034805939, asset_id=1231963533322701).
App Installs / Active Users are a DB proxy, not app-store/analytics-SDK numbers — there's no MMP or analytics SDK wired into the app yet. Query run against the production Postgres DB (`auth_user` table) on the diveplaza host:

```sql
SELECT count(*) FROM auth_user WHERE date_joined >= '<week_start>'::date;      -- Installs (new): signups this week
SELECT count(*) FROM auth_user WHERE last_login  >= now() - interval '7 days'; -- Active Users: logged in last 7 days
```

`Installs (new)` = new account signups in the week (proxy for installs — no app-store attribution). `Active Users` = distinct accounts with a login in the trailing 7 days as of the query. Re-run both queries each week and update the row below.

| Week | App Installs (new) | Active Users | Social Followers | Reach | Engagement Rate | Shops Onboarded (cumulative) | Notes |
|------|---------------------|--------------|-------------------|-------|-------------------|-------------------------------|-------|
| 1 (2026-08-03) | 0 | 3 | FB 20 / IG 45 | — | — | 0 | Baseline, pre-campaign. Pillar A live posting starts today. Pillar B (shop outreach) not yet started. Total registered users: 57. |