Intercom: list all conversations with bad ratings

Build a dynamic list of all the conversations that had a bad rating.

The process

Try It for Yourself

What do I get out of it?

By identifying the conversations where there was a problem, you can investigate what went wrong, and fix your process in order to improve your customer satisfaction.

How does it work?

Let's list all the conversations that have a rating of 25% or below in the past 30 days.

  1. Import "Conversations" data from Intercom in a sheet called "Intercom conversations". See how to import your data in Actiondesk here.
  2. Add a calculated column called "In past 30 days" with the following formula: =IF(TODAY()-#'Created at'
  3. Filter the column "In past 30 days" on the value "Yes".
  4. Filter the column "Conversation rating" on the values


If you or your team investigate what went wrong for each conversation, you can add a note column where you can write explications.

What do I get out of it?

By identifying the conversations where there was a problem, you can investigate what went wrong, and fix your process in order to improve your customer satisfaction.

How does it work?

Let's list all the conversations that have a rating of 25% or below in the past 30 days.

  1. Import "Conversations" data from Intercom in a sheet called "Intercom conversations". See how to import your data in Actiondesk here.
  2. Add a calculated column called "In past 30 days" with the following formula: =IF(TODAY()-#'Created at'
  3. Filter the column "In past 30 days" on the value "Yes".
  4. Filter the column "Conversation rating" on the values


If you or your team investigate what went wrong for each conversation, you can add a note column where you can write explications.

Read more
Create My First Report
see all Intercom use cases
The Advantages

Key Benefits

Eliminate the need for expensive third-party connectors and laborious copy-pasting.

Seamlessly import, organize, filter, and manipulate your Intercom data. Analyze it alongside data from other sources, and build custom Intercom dashboards and reports.

View and organize your Intercom data within a familiar spreadsheet interface.

Seamlessly import, organize, filter, and manipulate your Intercom data. Analyze it alongside data from other sources, and build custom Intercom dashboards and reports.

Feel confident in knowing that your data is always accurate and up-to-date.

Thanks to real-time cloud-based updates, any changes to your data made from within Intercom are automatically reflected in your Actiondesk spreadsheet.

Save time to analyze your data and make better decisions for your business
Create My First Report
Learn More

Our Use Cases

Create My First Report
X
Please wait...
Oops! Something went wrong while submitting the form.