---
title: How to Add Average Google Reviews, HelloPeter, and TrustPilot Scores to Reports
description: Learn how to add average Google Reviews, HelloPeter, and TrustPilot scores to your comparison table and commentary box. A simple way to enhance brand benchmarking and reporting clarity.
---

[Skip to content](https://dataeq.com/knowledge-base/how-to-add-average-google-reviews-hellopeter-and-trustpilot-scores-to-reports#main-content)

[![](https://dataeq.com/hs-fs/hubfs/DataEQ_Logo_FOR%20USE%20ON%20DARK%20BACKGROUND.png?width=200&height=150&name=DataEQ_Logo_FOR%20USE%20ON%20DARK%20BACKGROUND.png)](https://www.dataeq.com)

Open main navigation

Close main navigation

- Contact us

 Contact us

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://dataeq.com/knowledge-base)
2. [Analyse](https://dataeq.com/knowledge-base/analyse)
3. [Metrics and Drill Downs](https://dataeq.com/knowledge-base/analyse#metrics-and-drill-downs)

# How to Add Average Google Reviews, HelloPeter, and TrustPilot Scores to Reports

## We’ve introduced a feature to simplify competitive benchmarking: average review scores for Google Reviews, HelloPeter, and TrustPilot are now available in both the comparison table and commentary box. This makes it easier to surface brand sentiment at a glance, because when you’re evaluating performance, context matters.

#### How It Works

We calculate the average score using a simple formula:

> **Average Score =** Total Sum of Ratings / Number of Mentions

This provides a consistent, five-point scale average that’s easy to scan and understand.

---

#### Adding Average Scores to the Comparison Table

Here’s how to include these metrics in your comparison table:

1. Open the comparison table configuration.
2. From the column dropdown, select:
   
     - `Average give point Google Business score`
     - `Average give point HelloPeter score`
     - `Average give point TrustPilot score`
3. **Note:** You can only split rows by **brand**—this functionality is not available for other entity types.

> Ensure that review data is being collected for each platform before applying these scores. No mentions = no average.

---

#### Including Scores in the Commentary Box

To add the same scores to the commentary box, use the following merge tags:

- `0`
- `0`
- `0`

These tags will dynamically populate the average scores within the output, ensuring commentary stays aligned with data in the table.

---

#### Need Help?

If you have any questions or would like help configuring your setup, reach out to the team. We’re here to ensure your reporting delivers the insight and clarity your stakeholders expect.

- [Analyse](https://dataeq.com/knowledge-base/analyse#main-content)

    - [Metrics and Drill Downs](https://dataeq.com/knowledge-base/analyse#metrics-and-drill-downs)
    - [Exploring Authors](https://dataeq.com/knowledge-base/analyse#exploring-authors)
    - [Alerts and Notifications](https://dataeq.com/knowledge-base/analyse#alerts-and-notifications)
    - [The Reports Panel](https://dataeq.com/knowledge-base/analyse#the-reports-panel)
    - [Getting Started on Analyse](https://dataeq.com/knowledge-base/analyse#getting-started-on-analyse)
    - [Visualising Conversation Topics](https://dataeq.com/knowledge-base/analyse#visualising-conversation-topics)
    - [Mentions Panel](https://dataeq.com/knowledge-base/analyse#mentions-panel)
    - [Labelling Data](https://dataeq.com/knowledge-base/analyse#labelling-data)
    - [Filtering and Analysing Data](https://dataeq.com/knowledge-base/analyse#filtering-and-analysing-data)
- [Engage](https://dataeq.com/knowledge-base/engage#main-content)

    - [User Roles & Permissions](https://dataeq.com/knowledge-base/engage#user-roles-permissions)
    - [Reporting and Analytics](https://dataeq.com/knowledge-base/engage#reporting-and-analytics)
    - [Additional Features](https://dataeq.com/knowledge-base/engage#additional-features)
    - [Tips & Troubleshooting](https://dataeq.com/knowledge-base/engage#tips-troubleshooting)
    - [Ticket Management](https://dataeq.com/knowledge-base/engage#ticket-management)
    - [Getting Started](https://dataeq.com/knowledge-base/engage#getting-started)
    - [Working with Tickets](https://dataeq.com/knowledge-base/engage#working-with-tickets)
- [Publish](https://dataeq.com/knowledge-base/publish#main-content)

    - [Multi-Platform Publishing](https://dataeq.com/knowledge-base/publish#multi-platform-publishing)
    - [Getting Started with Publish](https://dataeq.com/knowledge-base/publish#getting-started-with-publish)
    - [Creating and Managing Content](https://dataeq.com/knowledge-base/publish#creating-and-managing-content)
    - [Campaigns and the Content Calendar](https://dataeq.com/knowledge-base/publish#campaigns-and-the-content-calendar)
    - [Approval Workflows](https://dataeq.com/knowledge-base/publish#approval-workflows)
    - [Reporting & Logs](https://dataeq.com/knowledge-base/publish#reporting-logs)
- [Glossaries](https://dataeq.com/knowledge-base/glossaries)
- [Data Source Information](https://dataeq.com/knowledge-base/data-source-information#main-content)

    - [What can we collect?](https://dataeq.com/knowledge-base/data-source-information#what-can-we-collect)
    - [Platform FAQs](https://dataeq.com/knowledge-base/data-source-information#platform-faqs)

[![Chill listening crop-3](https://dataeq.com/hs-fs/hubfs/DataEQ_Logo_FOR%20USE%20ON%20LIGHT%20BACKGROUND.png%20(1)-1.png?width=90&height=32&name=DataEQ_Logo_FOR%20USE%20ON%20LIGHT%20BACKGROUND.png%20(1)-1.png "Chill listening crop-3")](https://25676464.hs-sites-eu1.com/)

<https://www.linkedin.com/company/dataeq/>

Copyright © 2025, DataEQ