Google Play Console
Reviews, installs, ratings and crashes for your apps from the Google Play Console reports bucket.
The Google Play Console connector reads the CSV files Google automatically writes to your developer account's Cloud Storage bucket: reviews, installs, ratings and crashes. No paid API and no extra quota to enable on Google Cloud.
To connect it you need, besides signing in with your Google developer account, to manually paste the Cloud Storage bucket URI: you find it in Play Console, under "Download reports", with the "Copy Cloud Storage URI" button. Google does not expose it through an API, so it has to be pasted by hand once, during the connection.
Each report uses a single category (Reviews, Installs, Ratings or Crashes). If your account has more than one app, they all appear in the same report: the package name is just another column, which you can filter in the report if you only want one app.
Required permissions
devstorage.read_only: Needed to read the report CSV files (reviews, installs, ratings, crashes) that Google automatically writes to your Play Console account's Cloud Storage bucket.
Available metrics
Available metrics depend on the category chosen in the report:
- Reviews: no numeric metric, only the Count and the review's own dimensions (see below).
- Installs: Daily Device Installs, Daily Device Uninstalls, Daily Device Upgrades, Total User Installs, Daily User Installs, Daily User Uninstalls, Active Device Installs, Install events, Update events, Uninstall events.
- Ratings: Daily Average Rating, Total Average Rating.
- Crashes: Daily Crashes, Daily ANRs.
For Installs, Ratings and Crashes you can also pick an additional breakdown as a dimension: app version, carrier, country, device, language or Android OS version (not every breakdown exists for every category, see Available dimensions).
Available dimensions
Available dimensions depend on the category:
- Reviews: Date, Package name, App version code, App version name, Reviewer language, Device, Star rating, Review title, Review text, Developer reply date, Developer reply text, Review link.
- Installs, Ratings, Crashes: Date, Package name, plus the chosen breakdown (if different from "Overview"): App version, Carrier, Country, Device, Language or Android OS version. Not every breakdown exists for every category: Crashes has no Carrier/Country/Language.
Date and Package name are always included, even with "Overview" selected.
Known limits
- Bucket URI must be copied by handGoogle does not expose your Play Console account's Cloud Storage bucket URI through any API: it must be pasted by hand the first time you connect, from Play Console, Download reports, the "Copy Cloud Storage URI" button. If you ever switch developer account, the connector needs to be reconnected with the new URI.
- One category per reportReviews, Installs, Ratings and Crashes are separate categories: a single report cannot mix metrics or dimensions from different categories, saving the report blocks it. To compare data across categories you need one report per category.
Execution notes
The connector downloads one CSV file per month in the requested period, for every app in the bucket (not just the one you care about): a report over a long period can take a bit longer. If an app has no data for a given month, that file simply does not exist: this is not an error, it just means "0 rows" for that month.