Connect Trustpilot Review to Power BI

Add the review source in Catchr using the profile identifier after /review/, such as the company domain. Select the configured profile, app or property. Build a Power BI query with Review Title, Rating and Review Date, 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.

Catchr exposes individual review titles, text, ratings, dates, reviewer information, country codes, likes, review URLs, and company reply text and dates when available. Separate profile totals include Review Count, Average Rating, and counts by star rating. This is a review-reporting source: invitation delivery, TrustBox impressions, profile search performance, and Trustpilot's own AI insight dashboards are not included in its current field catalog.

A simple average of the reviews in your dashboard is not the TrustScore. Trustpilot explains that its score considers more than an arithmetic mean, including the influence of recent customer experiences. Your dashboard may also cover only a selected period or a subset of reviews. Label a calculation based on individual Rating values as average review rating, and do not relabel it TrustScore. Catchr's catalog does not expose a dedicated TrustScore field.

Use Review Date to group individual reviews by month and count distinct Review IDs. Calculate the average of valid Rating values or group reviews by their star rating to show the distribution for that period. Profile-level Review Count and star-count totals are current summary values, not monthly changes. Request these totals in separate charts: Catchr does not allow profile summary fields and individual review fields in the same request.

Yes, for the reviews and reply data returned by the connector. Build a review table with Rating, Review Text, Reply Text, and the review URL; filter empty Reply Text to identify reviews that appear unanswered in the retrieved data. Where both dates are present, calculate the elapsed time between Review Date and Reply Date. This measures the reply currently returned, not a complete history of every response or edit. Publish replies in Trustpilot itself.

A single request should not be treated as a complete archive. Catchr pages through reviews and stops after roughly 1,000 matching reviews, or when it reaches the available results or requested date boundary. For a high-volume profile, use smaller date windows and compare the returned coverage before drawing conclusions. Profile totals can exceed the individual reviews retrieved, and historical profile ratings cannot be reconstructed simply by moving a date filter on a current summary chart.

Yes. Add the review sources separately and map each profile to the correct business or location before combining results. Keep the platform, review count, date range, and scoring method visible so a Trustpilot score is not mistaken for an equivalent Google measure. A useful comparison shows recent review volume, the share of low ratings, and recurring complaints side by side. Catchr also provides a Google Business Profile source for reporting on local business performance.