Intercom: list all conversations with bad ratings

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

All use cases
HubSpot
SQL
Airtable
Salesforce
Pipedrive
Intercom
Stripe

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

Intercom: list slipping away users

List users who haven't logged in to your app for a while and get your team to do something about it

Create this report with my data →

Intercom: track the time it takes to close for a conversation

Calculate the average weekly or monthly time it takes your team to close a conversation initiated by a customer.

Create this report with my data →

Intercom: analyze your conversation rating

If you're using ratings, see the number of conversations for each rating, sliced down per week or month, or customer support operator.

Create this report with my data →

Intercom: calculate the time it takes for first response to a conversation

Analyze the average time it takes your team to respond to a customer initiated conversation.

Create this report with my data →

Intercom: list all conversations with bad ratings

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

Create this report with my data →

Intercom: list open conversations with customers waiting for more than x hours

Easily identify potential problems to solve urgently.

Create this report with my data →

Intercom: analyze your leads pipeline comparing weekly leads vs qualified leads

Count your total number of leads, qualified leads and the percentage of qualified leads for each week

Create this report with my data →
Create My First Report
X
Please wait...
Oops! Something went wrong while submitting the form.