Workflow · Sales and growth · Opening soon
App store reviews by rating
Turn exported App Store Connect customer reviews into a rating summary. Group them by month and rating, and include average rating.
Someone typed
“summarize app store reviews by rating, app version and month, with average rating”
The agent read it as
Summarize App Store Connect Customer Reviews by rating, app version and month, with average rating.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
App Store Connect Customer Reviews
CSV export · 18 rows
Step
Summarize by month and rating
Step 1
Result
Review Ratings Summary
16 rows
Schedule
Runs when you say
Proposed
- FileApp Store Connect Customer ReviewsCSV export · 18 rows
- StepSummarize by month and ratingStep 1
- ResultReview Ratings Summary16 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 16 rows came out.
- Download App Store Connect Customer Reviews sample (18 rows)App Store Connect: Sales and Trends > Customer Reviews > Export
What you get back
The result of that run, the rows to look at first.
Review Ratings SummarySample data16 rows
| Month | App version | Rating | Review count | Average rating |
|---|---|---|---|---|
| 2026-09-01 | 3.3.0 | 2 | 1 | 2 |
| 2026-09-01 | 3.3.0 | 4 | 1 | 4 |
| 2026-09-01 | 3.3.0 | 5 | 1 | 5 |
| 2026-10-01 | 3.4.0 | 1 | 1 | 1 |
| 2026-10-01 | 3.4.0 | 2 | 1 | 2 |
| 2026-10-01 | 3.4.0 | 3 | 1 | 3 |
| 2026-10-01 | 3.4.0 | 4 | 1 | 4 |
| 2026-10-01 | 3.4.0 | 5 | 1 | 5 |
| 2026-10-01 | 3.4.1 | 2 | 1 | 2 |
| 2026-10-01 | 3.4.1 | 3 | 1 | 3 |
| 2026-10-01 | 3.4.1 | 4 | 1 | 4 |
| 2026-10-01 | 3.4.1 | 5 | 2 | 5 |
How do you summarize app store reviews by rating?
Export App Store Connect customer reviews as a file, then upload it to Mammoth. The workflow groups reviews by month and rating, and returns a review ratings summary with average rating.
How it works
How to use the Review Ratings Summary workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Review Ratings Summary: questions
What export should you use?
Use the customer reviews export from App Store Connect. Any spreadsheet-style export with the review rows and rating fields can work.
What happens to reviews that do not match a rule?
Rows that do not match the grouping rules stay out of that summary. They are not changed, and they are not counted in the grouped result.
How do you change the rules?
Edit the workflow in words, for example, change the fields you group by or add another step. Then upload a new export and run it again.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Measure how fast the pipeline turns into revenue, and where people drop out of your funnel.
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template
- Funnel analysisHow many people reach each step of your funnel, in order, and where they drop offSee the workflow Template
- Sales forecast from pipelineForecast this quarter’s sales from a HubSpot export, using stage probability, close month, and closed won revenue.See the workflow Built by the agent
- Survey results analysisSummarize Typeform survey responses by question and respondent segment, with score averages and response counts.See the workflow Built by the agent
- Time to first valueMeasure how many days new accounts take to reach their first key action, grouped by signup week, from a Mixpanel events export.See the workflow Built by the agent
- Feature adoptionCompare feature adoption this month and last month from a Mixpanel export. See which features held, dropped, or shifted.See the workflow Built by the agent