play-console-insightslisted

# /audit-aso — Play Store ASO Audit Weekly audit of Product's Google Play Store presence. Combines: 1. **Play Console reports bucket** (`gs://pubsite_prod_rev_*/`) — daily CSVs for installs, acquisition by search term, store-listing visitors → installers CVR, country breakdown 2. **Play Developer Reporting API** — vitals (crash rate, ANR rate, slow rendering) — degraded vitals tank Play Store ranking and CVR 3. **Play Developer Publishing API** (`androidpublisher.googleapis.com`) — store-listing experiments (best-effort; falls back to manual YAML if endpoint unavailable) 4. **Product production DB** — install → paid-sub funnel scoped to Organic / Google-Play channels (via `/install-funnel`) Produces console summary + Confluence report + Jira comment. Stores a snapshot per run in `.context/channel-audits/aso/` so the next run can diff and flag anomalies. --- ## Prerequisites Environment variables (from `.env`): ``` # OAuth2 — same client may be reused for Google Ads (scope is what differs) GOOGLE_PLAY_CLIENT_ID=<oauth2 client id> GOOGLE_PLAY_CLIENT_SECRET=<oauth2 client secret> GOOGLE_PLAY_REFRESH_TOKEN=<long-lived refresh token> # App GOOGLE_PLAY_PACKAGE_NAME=${ANDROID_PACKAGE_NAME} # Product Android applicationId (verified in product-android/app/build.gradle) # Reports bucket — copy from Play Console → Download reports → Copy Cloud Storage URI # Begins with `pubsite_prod_rev_<digits>` GOOGLE_PLAY_REPORTS_BUCKET=pubsite_prod_rev_XXXXXXXXXXXXX # Reused SSH