Ues this guide to pull data from Google Play Reviews into the Google Sheets, Data Studio, and Excel reports you create with Supermetrics.
If you need to connect this data source to one of our data warehouse or cloud storage destinations, explore our prerequisite and filling guides.
Before you begin
Google Play Reviews is a public data source — you don't need a specific account or permissions to access it. It returns data for any app's 400 most recent reviews in the Google Play Store.
To search for an app's data, you need to pull its app ID from its Play Store URL. This allows you to query that data with Supermetrics. To find this ID:
- Open the Play Store page for the app you'd like to pull data for.
- Look at the URL in your browser bar. The text string after id= is the app's ID. For example, in a URL ending in /store/apps/details?id=ee.example.client, the app ID would be ee.example.client.
Instructions
For Excel users
If your team uses Supermetrics for Excel, you'll see different options for managing and sharing data source connections in that destination. Learn more.
Make sure you've installed the Supermetrics add-on before you connect.
- Open a new Google Sheets file.
- Navigate to Extensions → Supermetrics → Launch sidebar to open Supermetrics.
- Click Create new query.
- Under Data source, select Google Play Reviews.
- Click Start.
- Navigate to Report configuration.
- Enter the app's Google Play Store ID.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Google Sheets.
Make sure you've connected Supermetrics to Data Studio before following the steps below.
- Open the Supermetrics data source gallery.
- Navigate to Google Play Reviews and click Try.
- Click Authorize.
- If you're connecting Google Play Reviews for the first time, log in with the Google Account you use with Supermetrics. Click Allow.
- Click Authorize.
- Navigate to Report configuration.
- Enter the app's Google Play Store ID.
- Scroll down to the bottom of the page. To create a report with our template, select Use report template for new reports. To create a blank report, deselect this option.
- In the pane's top right, click Connect.
- Click Create report.
- Click Add to report.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Data Studio.
Make sure you've installed the Supermetrics add-on before you connect.
- Open an Excel file.
- Click Data → Show Supermetrics.
- Under Data source, select Google Play Reviews.
- Choose to make this connection shared or private.
- Click Start.
- Navigate to Report configuration.
- Enter the app's Google Play Store ID.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Excel.