Tag Archives: store

Automating Google Play Store reports with ‘gsutil’ and Windows PowerShell

Why (feel free to skip)

As Android developer I have various mobile devices (phones, tablets, watches) with all Android version starting 4.0 (Ice Cream Sandwich, API 14) up to Android 12 (L, API 31). Those devices accompanied by very detailed test scenarios help me ensure best possible user experience 🙂

Android test devices

As Android developer I have various mobile devices (phones, tablets, watches) with all Android version starting 4.0 (Ice Cream Sandwich, API 14) up to Android 12 (L, API 31).

When prepping release for an app, all test cases for that particular app are performed on each device. For each Android version I keep track of active installs and user rating. Applying that data in the test scenario. This helps me focus more on particular set of for ex. unhappy users running specific OS version.

Below is a screenshot of a test scenario for one of my apps: GSM Signal Monitor & SIM Card Info.

GSM Signal Monitor & SIM Card Info test scenario

GSM Signal Monitor & SIM Card Info test scenario

Each Android version has number of active installs and rating. Going to Google Play Store dev console and collecting this information by hand is somehow tedious job, so I decided to automate it using ‘Google Cloud Storage Util‘ and a bit of Windows PowerShell scripting.

How

Our task is to fetch Google Play store monthly reports for app installs and ratings by OS version, filter them and get data that can easily be copy pasted in the ‘Active Installs‘ tab of the test scenario.

1. Cloud Storage bucket ID

Google Play reports, beside dev console can also be accessed via Google Cloud Storage bucket associated with your developer account. You can go to “Download reports”, pick the report type you want and select “Copy Cloud Storage URI” next to it.

Google Play Cloud Storage URI

The url will look like this

gs://< bucket_id >/stats/installs/

where < bucket_id > will be your actual developer account cloud storage bucket. Remember this bucket id. We will be using it later.

2. Install gsutil

Google provides GSUtil for using cloud storage from the command line. Head over to https://cloud.google.com/storage/docs/gsutil_install#expandable-1 and follow the installation instructions.

We will be utilizing the gsutil.cmd assuming that the script is available in system PATH.

Next we need to authorize gsutil to access our cloud storage data. Follow the instructions on how to Authenticate stand-alone gsutil. For ‘project-id’ use the project ID of the app you want to get reports for. I’m interested in retrieving reports for GSM Signal Monitor & SIM Card Info app so I will be using it’s Cloud Storage project id.

Cloud Storage Project ID

If everything is setup correctly, opening command prompt and typing “gsutil help” should produce result similar to the screenshot below:

gsutil help command output

3. PowerShell magic 🙂

Script below will fetch installs and ratings reports from Google Play for specific app for the current month. Will get the last date available in the install report, filter both install and rating reports by ‘last available date’ and strip the reports from rows / columns we are not interested in. It will iterate over the active installs and will try to match installs with the ratings.

Replace $bucketId and $appPackageName with your cloud storage bucket id and your app package name.

Reports fetched from Google Play and the final output will be saved in the current working directory.

Upon execution you will get a report for your app active users/ratings by Android version, based on the data for the last date available in the install report nicely opened in your default text editor.

Script output: Active users and ratings.

P.S: Enable column selection mode in Notepad++ to get only the numbers. Use the arrow keys or your mouse while holding Shift + Alt.

P.S1: More info on how to retrieve various reports with gsutil here.

Feel free to modify the script to suit your reporting needs 🙂

Happy Fruits is out now!

Happy Fruits is out now!

Happy Fruits is a simple match-3 puzzle game similar to Jewels / Bejeweled type of games.
Your goal is to swap adjacent fruits to create combinations of 3 or more fruits of the same color and type, horizontally or vertically.

When you match 4 or more fruits, horizontally or vertically the whole game field row or column is removed.

After removing fruits new fruits drop down on the game field. Quite often the falling fruits create new valid combinations causing a chain reaction (or cascade).

Features:
* 3 game modes: Normal, Timed and Endless
* Hints
* Infinite number of levels
* Saved games. Store your progress and resume playing later on.
* Android TV support
* Game pad support
* “Optimized for your device” graphics
* In game stats
* In game help

It’s free on the Google Play Store.

google-play-badge

Happy Blocks 1.0

future_graphic

I’m happy to announce that ‘Happy Blocks’ version 1.0 is released.

Go get it and enjoy one beautiful, well balanced, challenging ball and paddle game with a total of 150 levels, various power ups and power downs, mini games, achievements, leaderboards and much more.

google-play-badge

My mind about having a tablet recently changed

I was skeptical about having a tablet, finding no use of the device at all, but due to my recent involvement with my gift – Samsung Galaxy S3  i got fascinated with the development opportunities android based devices offer. As a software developer this side of things is more interesting.

Now on the topic. Having some ideas for apps I was looking for a debug console and device  beside my phone to test the apps on. So after quick research i decided that 100 euro tablet would do the trick. I was also looking into the even cheaper tablets but they felt laggy while in use.

The device I brought is Privileg MID-7A tablet.

image

Cheap 7″ tablet with 1GB of ram, 8GB of internal storage, 1.2 Ghz processor, resolution of 1024×600 and WiFi. Also front and back cameras. The touch screen is good. The OS is Android 4.0.3.  Perfect for debugging and testing apps.

Here are the device specs on Bulgarian.

While doing the job of a development tool I slowly started using the tablet for different things like watching a movie in bed. Browsing the net and playing games. I also blog from the device while on the road. Its usefully for the times when you don’t want to carry a laptop around or having some time to kill. The tablet in combination with my S3 is my new mobile setup. I share the net from the phone.

I am considering the idea to buy a case with a keyboard.

In conclusion. I like having a tablet around. I really like it. When I have some free time I will root the device and install Android 4.2 on it.

Nice little thing  🙂 I’m writing this post from it.