Connect g2 Review to Power BI

Add the review source in Catchr using the product identifier after /products/. Select the configured profile, app or property. Build a Power BI query with Review Date, Review Title, Rating and Review Text, preview the returned reviews and import the generated URL using Get data > Web in Power BI Desktop. Set review dates and rating types in Power Query, and retain the source identifier when combining several profiles.

Yes, when those details are returned. Catchr exposes Company Size, Reviewer Role, and Reviewer Details alongside individual review text and ratings. Use them to compare feedback from different customer segments, and display the number of reviews behind each average. Keep missing company sizes in an unknown group instead of assuming they represent small businesses. These fields describe reviewers; they are not a list of companies currently researching or buying your product.

The G2 Review source provides review data and selected product rating summaries. Its current catalog does not include Buyer Intent activity, Grid rankings, NPS, or G2's generated sentiment themes. You can read and categorize Review Text in your own analysis, but that will not reproduce G2's Market Intelligence calculations. Use the appropriate G2 product for those proprietary reports, and keep them clearly labeled if you bring an export into the same dashboard.

Group individual reviews by Review Date, count distinct Review IDs, and average valid Rating values for the selected period. Product-level Average Rating, Review Count, star-count totals, and ease-of-use, setup, and support ratings are separate current summaries. They cannot be requested together with individual review fields. Use separate scorecards for those summaries; changing a date filter does not turn a current product score into its historical value.

A simple average of retrieved review ratings is not a G2 category ranking. G2 applies its own scoring methodology, and older reviews carry less weight in category and Market Report rankings. Your chart may also cover a narrower date range or customer segment than the product page. Compare the same measure and review population, verify the scale before combining different rating fields, and label your calculated average as a review average rather than a G2 ranking.

G2 provides a CSV download in its Review Activity area for users with the relevant access. You can use such an export as a separate spreadsheet data source when you need a fixed review set for analysis. Catchr provides a connection based on the configured product profiles for reporting on the fields it exposes. The two routes need not contain the same columns: G2's internal moderation and review-source information are not part of Catchr's current G2 Review catalog. See the G2 Review Activity guide.

Do not treat a single dashboard request as an exhaustive archive. Catchr pages through reviews until the available results or date boundary are reached, with a stopping threshold of roughly 1,000 matching reviews. Use smaller date windows for high-volume products and inspect the returned coverage before comparing long periods. The profile's current Review Count can exceed the individual rows you retrieved. A review visible only in a private moderation workflow should not be expected in a public product-review report.