Add a computed column called "Month" with the formula =YEAR(#Created at)&"_"&MONTH(#Created at)
Create another sheet called "Rating dashboard". In B2, write "rating", and in C2 to G2, write 0% ; 25% ; 50% ; 75% ; 100%.
In B3, write the months you want to see the data for: "2020_10" for October 2020, etc.
In C3, write the formula =COUNTIFS(#Conversation rating, C$2, #Month, $B3)
Lastly, copy and paste this formula over the whole range in your dashboard.
You're done ✌️. Feel free to add future months to the dashboard so that, as time goes by, you'll have the value for the upcoming months at your disposal already calculated. You can hide the rows for now and unhide them when needed.
What do I get out of it?
Understand how your customers perceive your customer support and improve your customer satisfaction.
How does it work?
There are a few variations of these use cases. Let us show you how to get the number of conversations per rating grade and per month.
Add a computed column called "Month" with the formula =YEAR(#Created at)&"_"&MONTH(#Created at)
Create another sheet called "Rating dashboard". In B2, write "rating", and in C2 to G2, write 0% ; 25% ; 50% ; 75% ; 100%.
In B3, write the months you want to see the data for: "2020_10" for October 2020, etc.
In C3, write the formula =COUNTIFS(#Conversation rating, C$2, #Month, $B3)
Lastly, copy and paste this formula over the whole range in your dashboard.
You're done ✌️. Feel free to add future months to the dashboard so that, as time goes by, you'll have the value for the upcoming months at your disposal already calculated. You can hide the rows for now and unhide them when needed.
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
