{"id":3254,"date":"2023-07-14T14:51:53","date_gmt":"2023-07-14T14:51:53","guid":{"rendered":"https:\/\/refiner.io\/blog\/?p=3254"},"modified":"2025-04-15T16:18:53","modified_gmt":"2025-04-15T16:18:53","slug":"how-to-calculate-csat","status":"publish","type":"post","link":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/","title":{"rendered":"CSAT Formula: How to Calculate CSAT Score"},"content":{"rendered":"\n<p><strong>In this guide, I&#8217;ll show you the exact CSAT formula and explain how you could calculate your customer satisfaction score (also using Excel.)<\/strong><\/p>\n\n\n\n<p>CSAT is beyond incredible at revealing some harsh truths about your business &#8211; From how well you meet customer\u2019s needs to whether your product has any future at all, and a lot more in between.&nbsp;<\/p>\n\n\n\n<p>But to know all that, and more, you first need to figure out and calculate your CSAT.&nbsp;<\/p>\n\n\n\n<p>Below, I\u2019m showing you exactly how to do it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Calculating Your Customer Satisfaction Score &#8211; The CSAT Formula<\/strong><\/h2>\n\n\n\n<p>I wrote (<em>and firmly stand by<\/em>) these words in my <a href=\"https:\/\/refiner.io\/blog\/csat-survey\/\">complete guide to CSAT<\/a>:<\/p>\n\n\n\n<p><em>\u201cNo company can last without satisfied customers. Unless people enjoy what you sell and enjoy dealing with your company, your business stands little to no chance to flourish and grow.\u201d<\/em><\/p>\n\n\n\n<p>It\u2019s so true, isn\u2019t it?&nbsp;<\/p>\n\n\n\n<p><strong>But the thing is &#8211; We often have no idea about how satisfied our customers are.&nbsp;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We assume that since orders keep coming in, everything is fine.&nbsp;<\/li>\n\n\n\n<li>We see good reviews and never think about the people who, for one reason or another, might have decided not to share their negative comments (but do have them!)<\/li>\n\n\n\n<li>And we rarely stop and wonder if customers really perceive our product the way they think we do.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>CSAT is one way to uncover all these insights, and more. This simple metric allows us to see the business or product from our customer\u2019s perspective. Granted, CSAT can deliver some harsh truths too, but in the end, it\u2019s what we need to learn sometimes to be able to look at what we\u2019re building more objectively.&nbsp;<\/p>\n\n\n\n<p><em>(By the way, if you\u2019re unsure about what CSAT is and how to use it, <\/em><a href=\"https:\/\/refiner.io\/blog\/csat-survey\/\"><em>check out my complete guide to the customer satisfaction score<\/em><\/a><em>. Once you\u2019ve read it, come back to this page to learn how to calculate it for your product.)<\/em><\/p>\n\n\n\n<p>Before I show you the CSAT calculation formula, I need to cover one aspect of the score that\u2019s pertinent to the metric.&nbsp;<\/p>\n\n\n\n<p><strong>CSAT is based on a single, close-ended, and qualitative question. It looks like this.&nbsp;<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"676\" height=\"396\" src=\"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/CSAT.png\" alt=\"CSAT survey example. \" class=\"wp-image-3255\" srcset=\"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/CSAT.png 676w, https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/CSAT-300x176.png 300w\" sizes=\"auto, (max-width: 676px) 100vw, 676px\" \/><\/figure><\/div>\n\n\n<p><em>Note<\/em> &#8211; You might have seen slight variations of this question. But whatever the company was asking about, they, most likely, used a question that follows or closely resembles the example above.&nbsp;<\/p>\n\n\n\n<p>What\u2019s important to understand about it is that CSAT uses a simple rating scale to collect answers. Each response in CSAT has a corresponding numerical value (*), making it incredibly easy to calculate.&nbsp;<\/p>\n\n\n\n<p>(*) The example above uses icons to collect responses but it\u2019s perfectly fine to also use a scale of 1-5 instead. In either case, each response has a value. Typically, the lowest value equals \u201cVery Unsatisfied\u201d and the highest (or the rightmost icon) is its complete opposite &#8211; \u201cVery Satisfied.\u201d<\/p>\n\n\n\n<p><strong>To calculate your CSAT, you need to uncover the percentage of satisfied customers in your customer base.&nbsp;<\/strong><\/p>\n\n\n\n<p>This is how to do it.&nbsp;<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>First, find out the number of satisfied customers. You do that by adding up all respondents who answered the survey by selecting either 4 or 5 (or corresponding icons.)&nbsp;<\/li>\n\n\n\n<li>Second, you need to divide that number by the total number of respondents.<\/li>\n\n\n\n<li>Multiply the result by 100 to get the percentage value.&nbsp;<\/li>\n\n\n\n<li>The resulting value is your CSAT score.&nbsp;<\/li>\n<\/ol>\n\n\n\n<p>So, for example, let\u2019s say that a total of 260 people responded with either &#8220;satisfied&#8221; or &#8220;very satisfied&#8221; (or clicked on one of the two rightmost icons on your CSAT survey.) This means that the total number of your satisfied customers is 260. But that\u2019s not your CSAT score, of course.\u00a0<\/p>\n\n\n\n<p>To calculate the actual CSAT score, we need to figure out what is the percentage of these people among your all customers.&nbsp;<\/p>\n\n\n\n<p>But there is a problem, right? We\u2019re working with a sample of your audience only, the people who have responded to the survey. So, when calculating CSAT, we use the total number of survey responses as the baseline for your audience size.&nbsp;<\/p>\n\n\n\n<p>In other words, instead of including the total number of customers you have, we only consider the people who completed the survey.&nbsp;<\/p>\n\n\n\n<p>Using the formula above, we calculate what percentage satisfied customers form among your entire audience.&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"300\" src=\"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Calculate-CSAT-Score.jpg\" alt=\"How to calculate CSAT - CSAT formula example.\" class=\"wp-image-3256\" srcset=\"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Calculate-CSAT-Score.jpg 800w, https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Calculate-CSAT-Score-300x113.jpg 300w, https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Calculate-CSAT-Score-768x288.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure><\/div>\n\n\n<p>In this case, the number is just over 81%.&nbsp;<\/p>\n\n\n\n<p>But is that a good CSAT score? Let\u2019s touch on this briefly.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to determine whether your CSAT score is good?<\/strong><\/h2>\n\n\n\n<p>First, let\u2019s talk about the term &#8211; a good CSAT score. Is the highest score possible good? And following this logic, is a low score bad? It seems only logical but how low is too low, for example? Is a score in the 50\u2019s bad?&nbsp;<\/p>\n\n\n\n<p>These are common questions. CSAT score is just this, a number. It is open to interpretation, and it\u2019s only normal that founders get confused about the scores their companies are getting.&nbsp;<\/p>\n\n\n\n<p>So, let\u2019s take a closer look at different score ranges and discuss what they <em>*could*<\/em> mean for your company.<\/p>\n\n\n\n<p><strong>CSAT between 0 and 40%<\/strong> signifies that the majority of your customers aren\u2019t satisfied with your product, company, or the customer experience you provide. To get scores in this region, the number of satisfied customers must be far lower than the total number of respondents.&nbsp;<\/p>\n\n\n\n<p>And there probably is no confusion about these scores &#8211; They are bad. Most of your customers confirm that something is missing, after all. The next step for you is to figure out where your company falls short, and come up with a plan to improve those areas.&nbsp;<\/p>\n\n\n\n<p>In practical terms, this means collecting more customer feedback, and even turn to individual interviews to dig deeper into reasons for customer dissatisfaction.&nbsp;<\/p>\n\n\n\n<p><strong>CSAT scores between 41% and 60%<\/strong> mean that your customer base is split roughly half half between satisfied and unsatisfied customers. By far and away, this isn\u2019t a bad score but it certainly isn\u2019t an ideal one. That said, depending on your industry, it might also be a standard. Consider airlines, insurance companies, telecomms, and the like. What are the chances that you\u2019d rate them highly after spending an hour being on hold or facing the horror of rebooking your flight without being able to talk to a person?&nbsp;<\/p>\n\n\n\n<p>So, depending on your industry, these might be good or even, common scores.&nbsp;<\/p>\n\n\n\n<p>Nonetheless, it\u2019s still a good opportunity to collect more feedback and find out how you could take customer experience further.&nbsp;<\/p>\n\n\n\n<p><strong>CSAT scores above 61% are seriously good.<\/strong> In this case, more than half of your customers (or more) are satisfied with you. Naturally, this is the range to strive for if you\u2019re not there yet.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>CSAT score range<\/strong><\/td><td><strong>Meaning<\/strong><\/td><td><strong>Next actions<\/strong><\/td><\/tr><tr><td>0-40%<\/td><td>Most of your customers are dissatisfied.&nbsp;<\/td><td>In-depth research into causes for dissatisfaction. Immediate action to remediate.&nbsp;<\/td><\/tr><tr><td>41% &#8211; 60%<\/td><td>Customer base is split half and half between satisfied and unsatisfied.&nbsp;<\/td><td>Customer interviews and research to uncover both what the company does well and where you\u2019re falling short.&nbsp;<\/td><\/tr><tr><td>61% &#8211; 100%<\/td><td>Most of your customers are satisfied.&nbsp;<\/td><td>Research to identify areas of satisfaction to maintain and improve those results.&nbsp;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to evaluate customer satisfaction further and <a href=\"https:\/\/refiner.io\/blog\/improve-csat-score\/\">improve CSAT scores<\/a><\/strong><\/h2>\n\n\n\n<p>In the previous section, we\u2019ve broken down the most common CSAT scores and discussed what they could mean to your business. And so, you know that, in case of falling in either of the lower ranges, you might need to conduct some extensive research to uncover what\u2019s wrong.&nbsp;<\/p>\n\n\n\n<p>But what research do you do, then? Not CSAT again, of course. That insight you have already.&nbsp;<\/p>\n\n\n\n<p>In this case, you need to start evaluating customer\u2019s attitudes towards different aspects of your business. Luckily, there are are several other survey types that could help you uncover those insights:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/refiner.io\/solutions\/ces\/\">Customer Effort Score<\/a> (CES) can help you identify product features that your customers might find the most challenging.<\/li>\n\n\n\n<li><a href=\"https:\/\/refiner.io\/blog\/product-research\/\">Product research<\/a> and product surveys can help you iterate your idea to a point where it meets the customer needs.&nbsp;<\/li>\n\n\n\n<li><a href=\"https:\/\/refiner.io\/blog\/product-market-fit-questions\/\">Product-market fit surveys<\/a> can help you uncover similar insights too.&nbsp;<\/li>\n\n\n\n<li>Finally, <a href=\"https:\/\/refiner.io\/blog\/ux-research-surveys\/\">user experience (UX) surveys<\/a> can help you understand how customers perceive your product so far.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p><strong>Want to run any of those surveys and more? <\/strong><a href=\"https:\/\/refiner.io\/\"><strong>Check out Refiner<\/strong><\/a><strong>, our customer feedback software for SaaS and digital products. <\/strong><a href=\"https:\/\/app.refiner.io\/auth\/register\"><strong>Free trial available<\/strong><\/a><strong>.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this guide, I&#8217;ll show you the exact CSAT formula and explain how you could calculate your customer satisfaction score (also using Excel.) CSAT is beyond incredible at revealing some harsh truths about your business &#8211; From how well you meet customer\u2019s needs to whether your product has any future at all, and a lot [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":3259,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"refiner_sidebar_werbeblock":"1776","footnotes":""},"categories":[15],"tags":[],"class_list":["post-3254","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-csat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>CSAT Formula: Calculate CSAT (also in Excel) - CSAT Calculator<\/title>\n<meta name=\"description\" content=\"Discover how to calculate CSAT. Learn the CSAT formula and see how to use it (also in Excel). CSAT Calculator.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CSAT Formula: Calculate CSAT (also in Excel) - CSAT Calculator\" \/>\n<meta property=\"og:description\" content=\"Discover how to calculate CSAT. Learn the CSAT formula and see how to use it (also in Excel). CSAT Calculator.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/\" \/>\n<meta property=\"og:site_name\" content=\"Refiner Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T14:51:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-15T16:18:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Claculate-CSAT-Score.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1320\" \/>\n\t<meta property=\"og:image:height\" content=\"932\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Moritz Dausinger\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mdausinger\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Moritz Dausinger\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/\"},\"author\":{\"name\":\"Moritz Dausinger\",\"@id\":\"https:\/\/refiner.io\/blog\/#\/schema\/person\/55632335b069a1d4a08cfd16de5d4dd2\"},\"headline\":\"CSAT Formula: How to Calculate CSAT Score\",\"datePublished\":\"2023-07-14T14:51:53+00:00\",\"dateModified\":\"2025-04-15T16:18:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/\"},\"wordCount\":1427,\"publisher\":{\"@id\":\"https:\/\/refiner.io\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Claculate-CSAT-Score.png\",\"articleSection\":[\"CSAT\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/\",\"url\":\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/\",\"name\":\"CSAT Formula: Calculate CSAT (also in Excel) - CSAT Calculator\",\"isPartOf\":{\"@id\":\"https:\/\/refiner.io\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Claculate-CSAT-Score.png\",\"datePublished\":\"2023-07-14T14:51:53+00:00\",\"dateModified\":\"2025-04-15T16:18:53+00:00\",\"description\":\"Discover how to calculate CSAT. Learn the CSAT formula and see how to use it (also in Excel). CSAT Calculator.\",\"breadcrumb\":{\"@id\":\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#primaryimage\",\"url\":\"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Claculate-CSAT-Score.png\",\"contentUrl\":\"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Claculate-CSAT-Score.png\",\"width\":1320,\"height\":932},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/refiner.io\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CSAT Formula: How to Calculate CSAT Score\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/refiner.io\/blog\/#website\",\"url\":\"https:\/\/refiner.io\/blog\/\",\"name\":\"Refiner Blog\",\"description\":\"SaaS Growth Tactics &amp; Best Practices in Managing Customer Feedback\",\"publisher\":{\"@id\":\"https:\/\/refiner.io\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/refiner.io\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/refiner.io\/blog\/#organization\",\"name\":\"Refiner Blog\",\"url\":\"https:\/\/refiner.io\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/refiner.io\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2021\/06\/Refiner-Logo-Blog.png\",\"contentUrl\":\"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2021\/06\/Refiner-Logo-Blog.png\",\"width\":468,\"height\":88,\"caption\":\"Refiner Blog\"},\"image\":{\"@id\":\"https:\/\/refiner.io\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/refiner.io\/blog\/#\/schema\/person\/55632335b069a1d4a08cfd16de5d4dd2\",\"name\":\"Moritz Dausinger\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/refiner.io\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec002e5788821d64a86d8ed49b1d44b9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec002e5788821d64a86d8ed49b1d44b9?s=96&d=mm&r=g\",\"caption\":\"Moritz Dausinger\"},\"description\":\"CEO of Refiner\",\"sameAs\":[\"https:\/\/x.com\/mdausinger\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CSAT Formula: Calculate CSAT (also in Excel) - CSAT Calculator","description":"Discover how to calculate CSAT. Learn the CSAT formula and see how to use it (also in Excel). CSAT Calculator.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/","og_locale":"en_US","og_type":"article","og_title":"CSAT Formula: Calculate CSAT (also in Excel) - CSAT Calculator","og_description":"Discover how to calculate CSAT. Learn the CSAT formula and see how to use it (also in Excel). CSAT Calculator.","og_url":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/","og_site_name":"Refiner Blog","article_published_time":"2023-07-14T14:51:53+00:00","article_modified_time":"2025-04-15T16:18:53+00:00","og_image":[{"width":1320,"height":932,"url":"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Claculate-CSAT-Score.png","type":"image\/png"}],"author":"Moritz Dausinger","twitter_card":"summary_large_image","twitter_creator":"@mdausinger","twitter_misc":{"Written by":"Moritz Dausinger","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#article","isPartOf":{"@id":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/"},"author":{"name":"Moritz Dausinger","@id":"https:\/\/refiner.io\/blog\/#\/schema\/person\/55632335b069a1d4a08cfd16de5d4dd2"},"headline":"CSAT Formula: How to Calculate CSAT Score","datePublished":"2023-07-14T14:51:53+00:00","dateModified":"2025-04-15T16:18:53+00:00","mainEntityOfPage":{"@id":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/"},"wordCount":1427,"publisher":{"@id":"https:\/\/refiner.io\/blog\/#organization"},"image":{"@id":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#primaryimage"},"thumbnailUrl":"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Claculate-CSAT-Score.png","articleSection":["CSAT"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/","url":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/","name":"CSAT Formula: Calculate CSAT (also in Excel) - CSAT Calculator","isPartOf":{"@id":"https:\/\/refiner.io\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#primaryimage"},"image":{"@id":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#primaryimage"},"thumbnailUrl":"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Claculate-CSAT-Score.png","datePublished":"2023-07-14T14:51:53+00:00","dateModified":"2025-04-15T16:18:53+00:00","description":"Discover how to calculate CSAT. Learn the CSAT formula and see how to use it (also in Excel). CSAT Calculator.","breadcrumb":{"@id":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/refiner.io\/blog\/how-to-calculate-csat\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#primaryimage","url":"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Claculate-CSAT-Score.png","contentUrl":"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Claculate-CSAT-Score.png","width":1320,"height":932},{"@type":"BreadcrumbList","@id":"https:\/\/refiner.io\/blog\/how-to-calculate-csat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/refiner.io\/blog\/"},{"@type":"ListItem","position":2,"name":"CSAT Formula: How to Calculate CSAT Score"}]},{"@type":"WebSite","@id":"https:\/\/refiner.io\/blog\/#website","url":"https:\/\/refiner.io\/blog\/","name":"Refiner Blog","description":"SaaS Growth Tactics &amp; Best Practices in Managing Customer Feedback","publisher":{"@id":"https:\/\/refiner.io\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/refiner.io\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/refiner.io\/blog\/#organization","name":"Refiner Blog","url":"https:\/\/refiner.io\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/refiner.io\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2021\/06\/Refiner-Logo-Blog.png","contentUrl":"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2021\/06\/Refiner-Logo-Blog.png","width":468,"height":88,"caption":"Refiner Blog"},"image":{"@id":"https:\/\/refiner.io\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/refiner.io\/blog\/#\/schema\/person\/55632335b069a1d4a08cfd16de5d4dd2","name":"Moritz Dausinger","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/refiner.io\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec002e5788821d64a86d8ed49b1d44b9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec002e5788821d64a86d8ed49b1d44b9?s=96&d=mm&r=g","caption":"Moritz Dausinger"},"description":"CEO of Refiner","sameAs":["https:\/\/x.com\/mdausinger"]}]}},"featured_image_src":"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Claculate-CSAT-Score-600x400.png","featured_image_src_square":"https:\/\/refiner.io\/blog\/wp-content\/uploads\/2023\/07\/Claculate-CSAT-Score-600x600.png","author_info":{"display_name":"Moritz Dausinger","author_link":"https:\/\/refiner.io\/blog\/author\/user\/"},"_links":{"self":[{"href":"https:\/\/refiner.io\/blog\/wp-json\/wp\/v2\/posts\/3254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/refiner.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/refiner.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/refiner.io\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/refiner.io\/blog\/wp-json\/wp\/v2\/comments?post=3254"}],"version-history":[{"count":6,"href":"https:\/\/refiner.io\/blog\/wp-json\/wp\/v2\/posts\/3254\/revisions"}],"predecessor-version":[{"id":3967,"href":"https:\/\/refiner.io\/blog\/wp-json\/wp\/v2\/posts\/3254\/revisions\/3967"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/refiner.io\/blog\/wp-json\/wp\/v2\/media\/3259"}],"wp:attachment":[{"href":"https:\/\/refiner.io\/blog\/wp-json\/wp\/v2\/media?parent=3254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/refiner.io\/blog\/wp-json\/wp\/v2\/categories?post=3254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/refiner.io\/blog\/wp-json\/wp\/v2\/tags?post=3254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}