cotera

Trustpilot Competitor Benchmark

Compare your Trustpilot reviews against competitors side by side. See who wins on satisfaction, where they struggle, and where you can differentiate.

Competitive analysisCustomer satisfactionMarket positioningReporting

The Challenge

You know your own Trustpilot score, but how does it stack up? Manually reading through competitor reviews to understand what their customers love and hate takes forever. And even when you do it, the comparison lives in your head instead of in a spreadsheet your team can actually use. You need a structured benchmark that compares the real customer experience across your competitive set.

What This Prompt Does

Multi-Company Pull

Fetch Trustpilot reviews for you and every competitor

Theme Extraction

Identify what customers love and hate per company

Side-by-Side Compare

Build a benchmark table with ratings and complaint themes

Export to Sheets

Log the full comparison to Google Sheets for your team

The Prompt

The Prompt

Task

Use @google_searchName it "google_search" and call it with @google_search to find competitor domains, then use @Trustpilot/Get ReviewsName it "Trustpilot/Get Reviews" and call it with @Trustpilot/Get Reviews to pull reviews for your company and each competitor. Compare ratings, review themes, and customer sentiment side by side, and export the benchmark data to Google Sheets via @Google Sheets/Append RowName it "Google Sheets/Append Row" and call it with @Google Sheets/Append Row.

Example: Compare Trustpilot reviews for Mailchimp vs Klaviyo vs Brevo to see who customers rate highest and why.

Input

The user will provide:

  1. Their company domain
  2. A list of competitor names or domains (2-5 competitors)
  3. A Google Sheets spreadsheet ID for the output

Example: "Benchmark mailchimp.com against klaviyo.com, brevo.com, and activecampaign.com. Output to sheet ID 1abc123"

Context

What to Compare

Per company:

  • Overall Trustpilot rating
  • Total review count (proxy for brand awareness)
  • Rating distribution (% of 5-star, 4-star, 3-star, 2-star, 1-star)
  • Top 3 positive themes (what customers love)
  • Top 3 negative themes (what customers hate)
  • Most common complaint category

Cross-company:

  • Who has the highest satisfaction rate (4-5 star %)
  • Who has the most damaging complaints
  • Where each company wins and loses relative to others
  • Which pain points are industry-wide vs company-specific

Benchmark Strategy

  1. If only company names are given, use Google Search to find their primary domains
  2. Pull 2-3 pages of Trustpilot reviews per company
  3. Calculate rating distribution and average for each
  4. Extract and categorize review themes per company
  5. Build a comparison matrix highlighting relative strengths and weaknesses
  6. Append summary rows to Google Sheets: Company, Avg Rating, Total Reviews, Top Positive Theme, Top Negative Theme, Satisfaction Rate

What Counts as a Valid Result

  • Compare the same volume of reviews per company for a fair benchmark
  • Use actual ratings and themes from reviews, never fabricate
  • Call out when a company has too few Trustpilot reviews for reliable comparison
  • Separate industry-wide complaints from company-specific ones

Output

Benchmark Summary Table: | Company | Avg Rating | Total Reviews | Satisfaction Rate | Top Complaint | |---------|-----------|--------------|-------------------|---------------| | [Company 1] | X.X | Y | Z% | [theme] | | [Company 2] | X.X | Y | Z% | [theme] |

Detailed Comparison:

For each company:

  • Rating: [X.X]/5 ([total] reviews)
  • Customers love: [theme 1], [theme 2], [theme 3]
  • Customers hate: [theme 1], [theme 2], [theme 3]
  • Best quote: "[actual positive review excerpt]"
  • Worst quote: "[actual negative review excerpt]"

Key Takeaways:

  • Who is winning on customer satisfaction and why
  • Industry-wide pain points every player struggles with
  • Unique positioning opportunities based on competitor weaknesses

Google Sheets: One row per company with columns for Avg Rating, Total Reviews, Satisfaction Rate, Top Positive Theme, Top Negative Theme, and Key Quote.

Example Usage

Try asking:

  • →"Benchmark our Trustpilot reviews against Zendesk, Freshdesk, and Intercom"
  • →"Who has better customer satisfaction on Trustpilot: Shopify or BigCommerce?"
  • →"Compare Trustpilot ratings for the top 5 email marketing platforms and export to Sheets"