Use the Apple Public Data data source connector to check how many reviews and what kind of ratings an app on the App Store has received. You can also create an overview dashboard to analyze the reviews and ratings over time.
For a full list of metrics and dimensions available in our Apple Public Data data source connector, take a look at our Apple Public Data documentation.
Once you’ve connected to Apple Public Data, you’re ready to create your first queries!
Query types for this data source
When connecting to the Apple Public Data data source, you need to select a query type. The query type defines what sort of metrics and dimensions are available.
- App store
- App Store search
- App Store reviews
- Top App Store apps
- Books
- Audiobook search
- Book search
- Top audiobooks
- Top books
- Music
- Music search
- Top Apple Music
- Top iTunes Music
- Top music videos
- TV
- Movie search
- Short film search
- TV show search
- Top movies
- Top TV shows
- Top short films
- Podcasts
- Podcast search
- Top podcasts
- Other
- Top iTunes U courses
Try these queries
See the following use cases for examples on how to use the metrics and dimensions.
See average ratings
Take a look at the average ratings for an app in the App Store.
Use the "App Store reviews" query type.
The "Average rating" metric shows the average of ratings given.
For best results in Looker Studio, use the time series chart type.
- Select the App store reviews query type and specify the keywords or app ID for searching apps.
- Set the date range to Year to date.
- Select the Average rating metric.
See reviews and ratings
View the review content and ratings for an app.
Use the "App Store reviews" query type.
For best results in Looker Studio, use the table chart type.
- Select the App Store reviews query type and specify the keywords or app ID for searching apps.
- Set the date range to Year to date.
- Select the Review content and Rating dimensions to pull the review text along with the rating.
See number of ratings
Take a look at how the ratings are distributed on a 1-5 scale.
Use the "App Store reviews" query type.
The "Ratings" metric shows the number of ratings given.
For best results in Looker Studio, use the bar chart type.
- Select the App Store reviews query type and specify the keywords or app ID for searching apps.
- Set the date range to Year to date.
- Select the Ratings metric.
- Select the Rating dimension to split the query results by rating.
More resources
You might also be interested in: