Skip to main content

How to connect Reviewflowz to Looker Studio

Connect your reviews and ratings history from every platform to Looker Studio with the Reviewflowz connector. Authorize, pick Reviews or Ratings history and build your report.

A
Written by Axel Lavergne

Reviewflowz has its own Looker Studio connector. You open it from the Data Sync card, sign in to Reviewflowz, pick what to report on, and your reviews and ratings history from every platform load into Looker Studio as fields you can chart. You need a Premium or Enterprise plan.

Before you start

  • A Premium or Enterprise plan. The connector needs API access, which both plans include. There is no separate fee for the connector.

  • A Google account with Looker Studio.

Connect Reviewflowz to Looker Studio

Step 1: Pick Looker Studio in Data Sync

In Reviewflowz, open Integrations, then Data Sync. Click + Add a new data sync and pick Looker Studio.

The Data Sync card with Looker Studio picked and the Open Looker Studio link

Step 2: Open the connector

Click Open Looker Studio on the card. Looker Studio opens on the Reviewflowz connector.

Step 3: Authorize the connector

Click Authorize. The first time, Looker Studio also asks you to authorize the community connector with your Google account. Authorize that too.

The Reviewflowz connector in Looker Studio with its Authorize button

Step 4: Sign in and pick the account

Sign in to Reviewflowz, pick the account Looker Studio should read and click Authorize. This is Reviewflowz's own consent screen, so you never paste a token.

The Reviewflowz consent screen asking which account Looker Studio should read

Step 5: Choose your data and connect

Choose Reviews or Ratings history, then click Connect.

The Data picker in Looker Studio open on Reviews and Ratings history, with Connect at the top right

Looker Studio creates the data source and lists its fields.

Choose your data

The connector gives you two data sources. Pick one when you connect. Reviews has one row per review. Ratings history has the rating and review count each platform showed, per listing per day.

For more than one view, add a second data source and pick the other option.

Reviews

Reviews has one row per live review. Removed reviews are left out. The fields are:

  • Rating (a metric, averaged)

  • Review date

  • Platform

  • Reviewer name

  • Reviewer company

  • Review text

  • Title

  • Reply text

  • Reply date

  • Replier

  • Listing

  • Listing URL

  • Location name

  • Tags

  • Topics

  • Subtopics

  • Language

  • Review URL

Your custom dimensions appear as fields too, with no setup.

The field list of a Reviews data source in Looker Studio

Ratings history

Ratings history has two metrics. Platform rating is averaged. Platform review count takes the maximum.

A Looker Studio table built from Reviews, with listing, reviewer name and rating

Set a date range and limit the data

Looker Studio asks for a date range, and Reviewflowz applies it on its side, so only reviews in that range load. A shorter range also avoids the size error below.

To limit the data to some locations or listings, use the Syncs picker on the Data Sync card.

Use several Reviewflowz accounts

If you have more than one Reviewflowz account, you pick which one to share when you sign in. A connection reads one account. To read another one, connect again and pick it there.

Stop sharing your data

The Data Sync card shows when Looker Studio last synced. To stop sharing, click Revoke on the card. Looker Studio loses access immediately. To connect again, edit the data source in Looker Studio and reconnect.

Fix an error message

Looker Studio shows these messages from Reviewflowz word for word. Each one says what to do.

  • This date range has more reviews than Looker Studio can load in one go. Pick a shorter date range, or split the report by listing.

  • Your Reviewflowz sign-in has expired. Edit the data source and reconnect.

  • Reviewflowz no longer accepts this connection (it was revoked or expired). Edit the data source and reconnect.

Related articles

Did this answer your question?