$npx -y skills add hanamizuki/solopreneur --skill gplay-reports-downloadFinancial and statistics report listing and downloading from Google Play Console via GCS. Use when asked to view, list, or download financial earnings, sales, payouts, or app statistics (installs, ratings, crashes).
| 1 | # Google Play Reports Download |
| 2 | |
| 3 | Use this skill when you need to list or download financial reports (earnings, sales, payouts) or statistics reports (installs, ratings, crashes, store performance, subscriptions) from Google Play Console. |
| 4 | |
| 5 | ## How reports work |
| 6 | |
| 7 | Google Play Console reports are **not available via the REST API**. They are stored as CSV/ZIP files in Google Cloud Storage (GCS) buckets: |
| 8 | |
| 9 | - **Bucket name**: varies by account — either `pubsite_prod_rev_<id>` or `pubsite_prod_<id>`. Always copy the exact URI from Play Console. |
| 10 | - **Financial reports**: `earnings/`, `sales/`, `payouts/`, `play_balance_krw/`, `wht_statements/` prefixes |
| 11 | - **Statistics reports**: `stats/installs/`, `stats/ratings/`, `stats/crashes/`, `stats/store_performance/`, `financial-stats/subscriptions/` prefixes |
| 12 | |
| 13 | The service account must have access to the GCS bucket (this access is granted automatically when the service account is added to Play Console with appropriate permissions). |
| 14 | |
| 15 | ## Prerequisites |
| 16 | |
| 17 | - A service account configured via `gplay auth login` |
| 18 | - The GCS bucket ID (see below — this is **not** the same as the Play Console URL developer ID) |
| 19 | - For financial reports: `VIEW_FINANCIAL_DATA` permission (service account must be added to Play Console with "View financial data" access) |
| 20 | - For stats reports: `VIEW_APP_INFORMATION` permission (service account must be added to Play Console with "View app information" access) |
| 21 | |
| 22 | ## Finding your bucket ID |
| 23 | |
| 24 | > **Important:** The bucket ID for reports is **not** the numeric ID in your Play Console URL. The URL ID and the GCS bucket ID are different. |
| 25 | |
| 26 | To find the correct bucket ID: |
| 27 | |
| 28 | 1. Go to **Google Play Console** > **Download reports** (in the left sidebar under "Download reports") |
| 29 | 2. Look for the **Cloud Storage URI** shown on that page, e.g.: |
| 30 | ``` |
| 31 | gs://pubsite_prod_rev_12110000881713004121/ |
| 32 | ``` |
| 33 | 3. You can pass either the full URI or just the numeric ID: `12110000881713004121` |
| 34 | |
| 35 | Alternatively, use the Google Cloud Console to find the bucket name associated with your Play Console account. |
| 36 | |
| 37 | **Common mistake:** Using the developer ID from the Play Console URL (`https://play.google.com/console/developers/<this_id>/...`) will result in a `404 Not Found` error because the GCS bucket uses a different internal ID. |
| 38 | |
| 39 | ## Financial reports |
| 40 | |
| 41 | ### List available financial reports |
| 42 | |
| 43 | ```bash |
| 44 | # List all financial reports |
| 45 | gplay reports financial list --bucket-id <id> |
| 46 | |
| 47 | # You can also pass the full GCS URI |
| 48 | gplay reports financial list --bucket-id "gs://pubsite_prod_rev_12345/" |
| 49 | |
| 50 | # Filter by type |
| 51 | gplay reports financial list --bucket-id <id> --type earnings |
| 52 | gplay reports financial list --bucket-id <id> --type sales |
| 53 | gplay reports financial list --bucket-id <id> --type payouts |
| 54 | |
| 55 | # Filter by date range |
| 56 | gplay reports financial list --bucket-id <id> --from 2026-01 --to 2026-06 |
| 57 | |
| 58 | # Combine filters |
| 59 | gplay reports financial list --bucket-id <id> --type earnings --from 2026-01 --to 2026-03 |
| 60 | ``` |
| 61 | |
| 62 | ### Download financial reports |
| 63 | |
| 64 | ```bash |
| 65 | # Download earnings for a specific month |
| 66 | gplay reports financial download --bucket-id <id> --from 2026-01 --type earnings |
| 67 | |
| 68 | # Download to a specific directory |
| 69 | gplay reports financial download --bucket-id <id> --from 2026-01 --type earnings --dir ./reports |
| 70 | |
| 71 | # Download a range of months |
| 72 | gplay reports financial download --bucket-id <id> --from 2026-01 --to 2026-06 --type sales |
| 73 | ``` |
| 74 | |
| 75 | ### Financial report types |
| 76 | |
| 77 | | Type | Description | Filename pattern | |
| 78 | |------|-------------|-----------------| |
| 79 | | `earnings` | Revenue and earnings data | `earnings/earnings_YYYYMM_<id>.zip` | |
| 80 | | `sales` | Sales transaction reports | `sales/salesreport_YYYYMM.zip` | |
| 81 | | `payouts` | Payment disbursement reports | `payouts/payout_YYYYMM.csv` | |
| 82 | | `play_balance` | Play balance reports (KRW) | `play_balance_krw/...` | |
| 83 | | `wht_statements` | Withholding tax statements | `wht_statements/...` | |
| 84 | |
| 85 | ## Statistics reports |
| 86 | |
| 87 | ### List available statistics reports |
| 88 | |
| 89 | ```bash |
| 90 | # List all stats reports |
| 91 | gplay reports stats list --bucket-id <id> |
| 92 | |
| 93 | # Filter by package name |
| 94 | gplay reports stats list --bucket-id <id> --package com.example.app |
| 95 | |
| 96 | # Filter by type |
| 97 | gplay reports stats list --bucket-id <id> --type installs |
| 98 | |
| 99 | # Filter by date range and package |
| 100 | gplay reports stats list --bucket-id <id> --package com.example.app --type installs --from 2026-01 --to 2026-06 |
| 101 | ``` |
| 102 | |
| 103 | ### Download statistics reports |
| 104 | |
| 105 | ```bash |
| 106 | # Download installs report |
| 107 | gplay reports stats download --bucket-id <id> --package com.example.app --from 2026-01 --type installs |
| 108 | |
| 109 | # Download to a specific directory |
| 110 | gplay reports stats download --bucket-id <id> --package com.example.app --from 2026-01 --type crashes --dir ./reports |
| 111 | |
| 112 | # Download a range of months |
| 113 | gplay reports stats download --bucket-id <id> --package com.example.app -- |