# APAC journey reference (live numbers)

Pulled read-only from `gcp-martech-infra.plg_dashboard.vw_pql_candidate_facts` (location us-west2),
the global PLG warehouse behind the `tidb_growth_data` dashboard. APAC scope = India + APAC-Others
(**excl. CN & JP**). This is the **journey reference** — it has far less behavioral depth than what a
full PQL model needs (no QPS/DDL/fit), but it's the ground truth for activation and is enough to run
the Signal axis today.

## Aha-milestone funnel

| Market | Tenants | Made cluster | Ran query | Done import | Has card | logs≥100 | logs≥1000 | ≥3 clusters |
|--------|---------|--------------|-----------|-------------|----------|----------|-----------|-------------|
| APAC · India | 21,788 | 20,300 (93%) | 9,176 (42%) | 758 | 247 (1.1%) | 93 | 6 | 304 |
| APAC · Others | 16,641 | 15,074 (91%) | 9,189 (55%) | 673 | 496 (3.0%) | 114 | 8 | 433 |
| **Total** | **38,429** | ~92% | ~48% | **~1.4k** | **743** | 207 | **14** | ~737 |

Japan (out of scope this round): 2,426 tenants, 65% query, 226 card (9.3%) — captured for later.

### Query
```sql
SELECT
  CASE WHEN UPPER(country)='IN' THEN 'APAC-India' ELSE 'APAC-Others' END AS bucket,
  COUNT(*) tenants,
  COUNTIF(first_cluster_created_at IS NOT NULL) made_cluster,
  COUNTIF(first_query_executed_at IS NOT NULL)  ran_query,
  COUNTIF(first_import_completed_at IS NOT NULL) done_import,
  COUNTIF(has_payment_method) has_card,
  COUNTIF(logs_28d>=100) logs100p, COUNTIF(logs_28d>=1000) logs1000p,
  COUNTIF(cluster_count>=3) multicluster3p
FROM `gcp-martech-infra.plg_dashboard.vw_pql_candidate_facts`
WHERE UPPER(country) IN ('IN','SG','AU','NZ','KR','TH','MY','ID','PH','VN','HK','TW')
GROUP BY bucket ORDER BY tenants DESC;
```

## Signal coverage gaps (every v1 enrichment is empty)
```sql
SELECT COUNT(*) apac_total,
  COUNTIF(company_ai_category IS NOT NULL)     has_ai_cat,      -- 0
  COUNTIF(track_step IS NOT NULL)              has_trackstep,   -- 0
  COUNTIF(tenant_avg_qps IS NOT NULL)          has_qps,         -- 0
  COUNTIF(spending_limit_updated_at IS NOT NULL) has_spendlimit,-- 0
  COUNTIF(account_segmentation IS NOT NULL)    has_acctseg      -- 151 (0.4%)
FROM `gcp-martech-infra.plg_dashboard.vw_pql_candidate_facts`
WHERE UPPER(country) IN ('IN','SG','AU','NZ','KR','TH','MY','ID','PH','VN','HK','TW');
```

## Scored distribution (from `../apac-pql-v1.sql`)

| Tier | n | Detail |
|------|---|--------|
| P0 | **0** | blocked on fit enrichment |
| P1 | **459** | 180 Strong (175 import) + 279 Moderate (146 card) |
| P2 | 6,004 | 3,437 Unknown-Early nurture + 2,567 verify-identity (1,046 import-driven free-email saved from suppression) |
| SUPPRESS | 31,966 | free-email, no behavior |

Reproduce: see the verification block at the bottom of [`../apac-pql-v1.sql`](../apac-pql-v1.sql).

## How to connect (read-only)
```bash
gcloud auth activate-service-account --key-file=bigquery-service-account-key.json   # sa-plg-growth@gcp-martech-infra
bq --project_id=gcp-martech-infra --location=us-west2 query --use_legacy_sql=false < apac/apac-pql-v1.sql
```
APAC will eventually point this at its own data source; this warehouse is the reference until then.