Skip to main content

How to create and automate custom reports on Reviewflowz

A
Written by Axel Lavergne

Reviewflowz is one of the only review management solutions on the market that comes with the ability to build your own reports.

But with great power comes *some* learning curve.

In this post, we'll cover how to create your own custom reports and how to send those reports to any email address you want on a daily, weekly, or monthly basis.

TLDR

  • The Reviewflowz chart builder reads as one sentence, Show a metric, by a dimension, as a chart type, so you build your own report much like an Excel pivot table.

  • Reviewflowz custom reports break your reviews down by dimensions such as platform, rating, language, country, tag, team member and AI-extracted topic, plus custom dimensions you define.

  • Reviewflowz sends a custom report by email, Slack or Microsoft Teams every day, week or month, with tables in the message body and charts as pictures.

  • A Reviewflowz report measures metrics such as review velocity, average rating, reply rate, reply time and sentiment mentions, and you set the time range for each report you send.

How to set up your own custom reports with Reviewflowz

Open Dashboard in the sidebar and click the gear icon next to the page title. In the Arrange cards window, click Create custom chart. Your saved reports live on the Reports page, where you can also click New report.

Every report is either a draft or published. The Reports page has a Published tab and a Drafts tab.

You can edit, and play around with both, but changing a published report changes the report on your dashboard.

So it's good to know what your team is using today, and what's still work in progress.

To create a new report, click Create custom chart on the dashboard, as shown here.

The Arrange cards window on the Dashboard, with the Create custom chart button

You land on the chart builder, which reads as one sentence with three main fields: Show, by, and as a.

  1. Show (the metrics)

  2. by (the dimensions)

  3. as a (the chart type)

This works very much like pivot tables on Excel, if you're familiar with that system.

Note: The date range and Filters at the top of the builder update the chart preview only. They are not saved as part of the chart.

  • as a sets the chart type: Table, Line Chart, Bar Chart, Area Chart, Pie Chart, or Mixed (Bar + Line).

  • by sets the dimensions, what you break your data down with. On a chart, the dimension is usually on the X axis.

  • Show sets the metrics, the data points you're looking for. On a chart, the metric is usually on the Y axis.

For example, if you wanted to break down positive and negative reviews over time on a bar chart, you'd set

  1. Show: Positive Reviews and Negative Reviews (2 different metrics)

  2. by: Date Period

  3. as a: Bar Chart

The chart builder set to show Positive Reviews and Negative Reviews by Date Period as a Bar Chart

The resulting chart would look something like this.

When you select "Date Period" as a dimension, the chart comes with a period selector (Day, Week or Month), so you can adjust on the chart directly. The default will be set based on the time range.

For example, if you're looking at a time range of under a week, the period will be set to daily. If you're looking at a time range of over a month, it'll be set to monthly.

The period selector on a chart, with Day, Week and Month

Every change saves itself as a draft while you build. Once you're happy with your chart preview, publish it to add it to your dashboard.

To do that, click Publish at the top right of the builder.

Name your report so your team can tell it apart from the others.

When naming a report, remember that reports won't have a specific date range associated to it, or any other filters

  • Example of how to name a report : Positive & Negative reviews over time

  • Example of how not to name a report : Positive & Negative reviews this year

How to send reports to your team members on a daily, weekly, or monthly basis

Once you've created a report, you can send it over email to anyone on your team.

To do that, open Integrations in the sidebar and go to the Send Review Digest tab. Click Add a new report automation.

The Weekly Digest at the top of that tab is a ready-made summary with a fixed layout and schedule, so you only choose who receives it. The report automation below it is the one you configure yourself.

A new report automation card opens, where you select a few options to configure your report

  1. To: Choose Email, Slack or MS Teams, then pick the recipients.

  2. Frequency: Choose Every day, Every week or Every month.

  3. Day, hour, minute and time zone: Select at what time we should send out the report. If you've selected a weekly frequency, select what day of the week you want us to send the report. We send monthly reports on the first day of the month.

  4. Reports: Click Add report and select what report(s) you want us to send. In an email, tables are embedded in the email body directly. Charts come as a picture of the chart, with the data available at the time of sending.

A report automation card on the Send Review Digest tab, with recipients, frequency, day, time and reports

Don't forget to set the time range next to each report.

If you set "Yesterday", the report will show data for the day before it's sent. That makes the most sense for a daily report.

If you set "Previous week", the report will forcefully show data for the previous full week (Monday to Sunday), even if you send it on Wednesdays.

Finally, turn on the switch at the bottom of the card so it reads Active.

What dimensions are available in custom reports?

Here's a list of all available dimensions to break down your data by

  • Review profile

  • Product name

  • Review platform

  • Rating

  • Content Length

  • Replied?

  • Country

  • Language

  • Tags (account defined)

  • Team

  • Keywords

  • Date range

  • Version (App store & Play store)

  • Topic (AI extracted)

  • Subtopic

  • Any account-defined custom dimensions.

Custom dimensions are "columns" you can use to group your review profiles or locations together. Whatever makes sense in your business, and in your existing reports, you can define on Reviewflowz, and break down your review data with.

What metrics are available in custom reports?

  • Review velocity: This is the # of reviews collected during your date range

  • Average rating: This is the average rating of the reviews collected during your date range (to see how many reviews it takes to move your overall rating, read how many Google reviews you need to raise your rating)

  • Platform rating: This is the rating as shown on the review platform. Only available for dates after account activation.

  • Platform count: This is the # of reviews as shown on the review platform. Only available for dates after account activation. It may differ significantly from the actual # of reviews, depending on how the platform handles empty reviews, review updates, and review deletions.

  • Cumulative review count: This is the total # of reviews collected up to the end date on your date range.

  • Reply rate

  • Reply time

  • New replies

  • Positive reviews: 4 and 5 star reviews

  • Negative reviews: 1, 2, and 3 star reviews
    ​

Sentiment analysis metrics

  • Mention count: This is the number of review extracts on a given topic or subtopic

  • Positive mentions: This is the number of review extracts with a positive sentiment score

  • Negative mentions: This is the number of review extracts with a positive sentiment score

  • Neutral mention: This is the number of review extracts with a neutral sentiment score

For more information about review extracts and sentiment analysis, check out our guide on the topic.

Did this answer your question?