Member-only story
How to Get the Most Out of App Store Feedback with Airtable
Desk research with feedback analysis

When I start to work on a mobile app project that is already live, I first plan interviews to get feedback from the users about the app.
But another great thing to do is dive deep into all App Store Reviews, whether for iOS or Android. It is a lot faster, and I noticed most things said in interviews repeat and correlate with what I got from the reviews.
This can be done on the app you are working on or competitors’ apps to spot any weaknesses or strengths they might possess.
It doesn’t even have to App. You can analyze reviews and feedback from any source. For example “Trustpilot”. Options are limitless.
There is a lot of data to process, and Airtable helped me a lot.
Think of it like Excel but on steroids.
You can use any other app, but this one worked best for me. In the last project, I analyzed about 600 comments.
It All Starts with Manual Work First
The first step involves some manual work, unfortunately. The first thing I did — was copy and paste all of the comments to Airtable manually.
However, I am still looking for an easy way to automate this.
Then I filtered out by “most useful” to get my project's most valuable and relevant feedback.
When you dig in there, you can find some gems.
Even if these are technical problems, they correlate to the user’s experience and should be adequately communicated.
How to Structure a Document

Later, I categorized 1 to 5 stars and divided them further.
Making myself filter options to “category”, “user lifecycle”, and “specific complaints/requests”. I can see later frequency and number of problems, which helps a lot when deciding what to prioritize.
So I ended up with many entries in this category and spent some time filtering them out.