Customer Reviews Visualization for Google Data Studio

This is a Google Data Studio Community Visualization for customer reviews. Use it to add your latest reviews to a report.

Here is how it looks in a report:

View demo Data Studio report


How to add this visualization to your report

1- Add your reviews as a data source

This visualization is designed to work with typical customer reviews data: ID, name, date, rating, comment. As an example, our demo report uses the data from this sample Google Sheet, through the Google Sheets connector.

2- Activate community visualizations

On your reviews data source, set "Community visualizations access" to "On".

3-Add the visualization

Manifest path: gs://baguette-gds-viz/customer-review
Component ID: review

4- Connect your data

Connect each data field to the corresponding field in your data source.

Review ID(1)
Dimension – String or Number It's not displayed anywhere. It's just here to be sure that records don't get accidentally aggregated if you ever have 2 reviews with the same name/date/comment/rating.

Review date(2)
Dimension – Date at the YYYYMMDD format.

Review name(3)
Dimension – String

Review comment(4)
Dimension – String

Rating(5)
Metric – Number between 0 and 5 Decimals are rounded to the lower half-star. For example, 3.2 is displayed as 3 stars, 4.6 is displayed as 4 stars and a half.

5- Sort by date

Sort your data by descending date so that the most recent reviews appear first.

6- Repeat this process

Add more instances of this visualization for multiple reviews. To define which review to display (latest review, latest - 1, latest - 2  ...), select an offset value (1st, 2nd, 3rd ...) in the style tab:

7- Customize the style

This visualization should work well with themes. Feel free to add borders and backgrounds to match the style of your report.


Changelog

December 3, 2019: Change the review selection input from a text to a select field December 2, 2019: Release the first version of this visualization


Terms and Credits

By using this visualization, you accept our Terms of Service and Privacy Policy.

This visualization uses:


Support

If you experience issues, please contact us at [email protected].

Please include screenshots and a Google Sheet data sample shared with the address above. Remember to remove sensitive or personally-identifying data.