bigfunctions > get_playstore_reviews

get_playstore_reviews¶

Call or Deploy get_playstore_reviews ?

✅ You can call this get_playstore_reviews bigfunction directly from your Google Cloud Project (no install required).

This get_playstore_reviews function is deployed in bigfunctions GCP project in 39 datasets for all of the 39 BigQuery regions. You need to use the dataset in the same region as your datasets (otherwise you may have a function not found error).
Function is public, so it can be called by anyone. Just copy / paste examples below in your BigQuery console. It just works!
You may prefer to deploy the BigFunction in your own project if you want to build and manage your own catalog of functions --> Read Getting Started. This is particularly useful if you want to create private functions (for example calling your internal APIs).
For any question or difficulties, please read Getting Started.
Found a bug? Please raise an issue here

Public BigFunctions Datasets are like:

Region	Dataset
`eu`	`bigfunctions.eu`
`us`	`bigfunctions.us`
`europe-west1`	`bigfunctions.europe_west1`
`asia-east1`	`bigfunctions.asia_east1`
...	...

Description¶

Signature

get_playstore_reviews(app_id, country, language)

Description

GET Google Play Store Reviews of an app (using google-play-scraper)

app_id can be found in the url of the app on the play store. For example for url https://play.google.com/store/apps/details?id=com.fpe.comptenickel&hl=en&pli=1, the app_id is com.fpe.comptenickel
country is the two-letter country iso code of the device where the app was downloaded
language is the two-letter language iso code of the review

The function will return the 600 newest reviews as json.

Examples¶

GET reviews written in English for Nickel App installed on French devices

EUUSeurope-west1

select bigfunctions.eu.get_playstore_reviews('com.fpe.comptenickel', 'fr', 'en')

select bigfunctions.us.get_playstore_reviews('com.fpe.comptenickel', 'fr', 'en')

select bigfunctions.europe_west1.get_playstore_reviews('com.fpe.comptenickel', 'fr', 'en')

+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
| reviews                                                                                                                                                      |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
| [
  {
    appVersion: "2.90.0"
    at: "Thu, 19 Sep 2024 10:44:05 GMT",
    content: "...",
    repliedAt: ...,
    replyContent: ...,
    ...
  },
  ...
]
 |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+

Use cases¶

A market research team wants to analyze user sentiment towards a specific mobile application (e.g., "Nickel App" with app ID com.fpe.comptenickel) across different regions. They want to understand how French users who have downloaded the app and written their review in English perceive the app. To achieve this, they would use the get_playstore_reviews BigQuery function with the following parameters:

app_id: com.fpe.comptenickel
country: fr (France)
language: en (English)

They would then execute a query like this (adjusting the dataset bigfunctions.us to match their BigQuery region):

SELECT * FROM UNNEST(JSON_EXTRACT_ARRAY(bigfunctions.us.get_playstore_reviews('com.fpe.comptenickel', 'fr', 'en'), '$.reviews')) AS review;

This query retrieves the reviews as a JSON array, then unnests the array so each review is a separate row. The team can then perform further analysis on the content, score, and other fields within each review to gauge user sentiment, identify common themes in positive or negative feedback, and understand the overall user experience for this specific user segment. This information can then be used to inform product development, marketing strategies, and customer support efforts.