{"id":1256,"date":"2013-03-13T05:24:48","date_gmt":"2013-03-13T05:24:48","guid":{"rendered":"http:\/\/www.sogolytics.com\/blog\/?p=1256"},"modified":"2026-06-30T05:05:08","modified_gmt":"2026-06-30T09:05:08","slug":"big-data-takes-little-dataresponse-rate-anaysis-pivot-table","status":"publish","type":"post","link":"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/","title":{"rendered":"Using Pivot Tables for Survey Response Rate Analysis"},"content":{"rendered":"<p>According to research conducted by the <a title=\"Big data: The next frontier for innovation, competition, and productivity\" href=\"https:\/\/www.mckinsey.com\/business-functions\/mckinsey-digital\/our-insights\/big-data-the-next-frontier-for-innovation\" target=\"_blank\" rel=\"noopener\">McKinsey Global Institute<\/a>, \u201cThe use of big data will underpin new waves of productivity growth and consumer surplus. For example, we estimate that a retailer using big data to the full has the potential to increase its operating margin by more than 60 percent.\u201d<\/p>\n<p>&nbsp;<\/p>\n<p>But of course, you already know this.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/sogosurvey.com\/blog\/wp-content\/uploads\/2013\/03\/Data-Management_iStock_000017925399XSmall.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1261 alignright\" title=\"Data Analysis\" src=\"\/blog\/wp-content\/uploads\/2013\/03\/Data-Management_iStock_000017925399XSmall-300x229.jpg\" alt=\"Online Survey Tool\" width=\"300\" height=\"229\" srcset=\"https:\/\/www.sogolytics.com\/blog\/wp-content\/uploads\/2013\/03\/Data-Management_iStock_000017925399XSmall-300x229.jpg 300w, https:\/\/www.sogolytics.com\/blog\/wp-content\/uploads\/2013\/03\/Data-Management_iStock_000017925399XSmall-392x300.jpg 392w, https:\/\/www.sogolytics.com\/blog\/wp-content\/uploads\/2013\/03\/Data-Management_iStock_000017925399XSmall.jpg 396w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>While Facebook and Google are classic examples of companies having a difficult time quantifying the vast stores of information they\u2019ve collected, everyone recognizes the true value of data is not in its acquisition, but in its use.<\/p>\n<p>&nbsp;<\/p>\n<p>Finding innovative ways to use this information isn\u2019t easy \u2014 the key is to slice your data into smaller, digestible bytes. This becomes difficult if your <a href=\"https:\/\/www.sogolytics.com\/blog\/best-online-survey-tools\/\">survey tool<\/a> lacks the features and functionality to help you gather, crunch and share that data.<\/p>\n<p>&nbsp;<\/p>\n<p>Sogolytics\u2019s powerful reporting tool allows you to dig deeper. With <a title=\"Response Rate Analysis\" href=\"https:\/\/www.sogolytics.com\/help\/survey-response-rate-report\/\" target=\"_blank\" rel=\"noopener\">Response Rate Analysis<\/a>, Pivot Table and even a <a title=\"Data Cleansing Module\" href=\"https:\/\/www.sogolytics.com\/help\/how-to-edit-individual-survey-responses\/\" target=\"_blank\" rel=\"noopener\">Data Cleansing Module<\/a>, you can observe, react to and get ahead of important trends.<\/p>\n<p>&nbsp;<\/p>\n<p>Smart companies will keep searching for ways to leverage &#8220;big data&#8221;. But Sogolytics gives you the power, <em>now<\/em>, to chop big data down to size and make it work for you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>According to research conducted by the McKinsey Global Institute, \u201cThe use of big data will underpin new waves of productivity growth and consumer surplus. For example, we estimate that a retailer using big data to the full has the potential to increase its operating margin by more than 60 percent.\u201d &nbsp; But of course, you already know this. &nbsp; While Facebook and Google are classic examples of companies having a difficult time quantifying the vast stores of information they\u2019ve collected, everyone recognizes the true value of data is not in its acquisition, but in its use. &nbsp; Finding innovative ways to use this information isn\u2019t easy \u2014 the key is to slice your data into smaller, digestible bytes. This becomes difficult if your survey tool lacks the features and functionality to help you gather, crunch and share that data. &nbsp; Sogolytics\u2019s powerful reporting tool allows you to dig deeper. With Response Rate Analysis, Pivot Table and even a Data Cleansing Module, you can observe, react to and get ahead of important trends. &nbsp; Smart companies will keep searching for ways to leverage &#8220;big data&#8221;. But Sogolytics gives you the power, now, to chop big data down to size and make it work for you.<\/p>\n","protected":false},"author":1,"featured_media":5050,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[205],"tags":[19,467,60,261,257],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.7.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using Pivot Tables for Survey Response Rate Analysis - Sogolytics<\/title>\n<meta name=\"description\" content=\"The use of big data will underpin new waves of productivity growth and consumer surplus. Slice your data into smaller, digestible bytes using survey tools.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Pivot Tables for Survey Response Rate Analysis - Sogolytics\" \/>\n<meta property=\"og:description\" content=\"The use of big data will underpin new waves of productivity growth and consumer surplus. Slice your data into smaller, digestible bytes using survey tools.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/\" \/>\n<meta property=\"og:site_name\" content=\"Sogolytics Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-13T05:24:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-30T09:05:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sogolytics.com\/blog\/wp-content\/uploads\/2018\/12\/window.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"487\" \/>\n\t<meta property=\"og:image:height\" content=\"714\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sogolytics\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sogosurvey\" \/>\n<meta name=\"twitter:site\" content=\"@sogosurvey\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/\",\"url\":\"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/\",\"name\":\"Using Pivot Tables for Survey Response Rate Analysis - Sogolytics\",\"isPartOf\":{\"@id\":\"https:\/\/www.sogolytics.com\/blog\/#website\"},\"datePublished\":\"2013-03-13T05:24:48+00:00\",\"dateModified\":\"2026-06-30T09:05:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.sogolytics.com\/blog\/#\/schema\/person\/137ad89cc093b0bb889c68e4b1825fb1\"},\"description\":\"The use of big data will underpin new waves of productivity growth and consumer surplus. Slice your data into smaller, digestible bytes using survey tools.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Using Pivot Tables for Survey Response Rate Analysis\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sogolytics.com\/blog\/#website\",\"url\":\"https:\/\/www.sogolytics.com\/blog\/\",\"name\":\"Sogolytics Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sogolytics.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sogolytics.com\/blog\/#\/schema\/person\/137ad89cc093b0bb889c68e4b1825fb1\",\"name\":\"Sogolytics\",\"url\":\"https:\/\/www.sogolytics.com\/blog\/author\/sogosurvey\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Pivot Tables for Survey Response Rate Analysis - Sogolytics","description":"The use of big data will underpin new waves of productivity growth and consumer surplus. Slice your data into smaller, digestible bytes using survey tools.","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:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/","og_locale":"en_US","og_type":"article","og_title":"Using Pivot Tables for Survey Response Rate Analysis - Sogolytics","og_description":"The use of big data will underpin new waves of productivity growth and consumer surplus. Slice your data into smaller, digestible bytes using survey tools.","og_url":"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/","og_site_name":"Sogolytics Blog","article_published_time":"2013-03-13T05:24:48+00:00","article_modified_time":"2026-06-30T09:05:08+00:00","og_image":[{"width":487,"height":714,"url":"https:\/\/www.sogolytics.com\/blog\/wp-content\/uploads\/2018\/12\/window.jpg","type":"image\/jpeg"}],"author":"Sogolytics","twitter_card":"summary_large_image","twitter_creator":"@sogosurvey","twitter_site":"@sogosurvey","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/","url":"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/","name":"Using Pivot Tables for Survey Response Rate Analysis - Sogolytics","isPartOf":{"@id":"https:\/\/www.sogolytics.com\/blog\/#website"},"datePublished":"2013-03-13T05:24:48+00:00","dateModified":"2026-06-30T09:05:08+00:00","author":{"@id":"https:\/\/www.sogolytics.com\/blog\/#\/schema\/person\/137ad89cc093b0bb889c68e4b1825fb1"},"description":"The use of big data will underpin new waves of productivity growth and consumer surplus. Slice your data into smaller, digestible bytes using survey tools.","breadcrumb":{"@id":"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sogolytics.com\/blog\/big-data-takes-little-dataresponse-rate-anaysis-pivot-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Using Pivot Tables for Survey Response Rate Analysis"}]},{"@type":"WebSite","@id":"https:\/\/www.sogolytics.com\/blog\/#website","url":"https:\/\/www.sogolytics.com\/blog\/","name":"Sogolytics Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sogolytics.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sogolytics.com\/blog\/#\/schema\/person\/137ad89cc093b0bb889c68e4b1825fb1","name":"Sogolytics","url":"https:\/\/www.sogolytics.com\/blog\/author\/sogosurvey\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sogolytics.com\/blog\/wp-json\/wp\/v2\/posts\/1256"}],"collection":[{"href":"https:\/\/www.sogolytics.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sogolytics.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/blog\/wp-json\/wp\/v2\/comments?post=1256"}],"version-history":[{"count":26,"href":"https:\/\/www.sogolytics.com\/blog\/wp-json\/wp\/v2\/posts\/1256\/revisions"}],"predecessor-version":[{"id":67587,"href":"https:\/\/www.sogolytics.com\/blog\/wp-json\/wp\/v2\/posts\/1256\/revisions\/67587"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/blog\/wp-json\/wp\/v2\/media\/5050"}],"wp:attachment":[{"href":"https:\/\/www.sogolytics.com\/blog\/wp-json\/wp\/v2\/media?parent=1256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sogolytics.com\/blog\/wp-json\/wp\/v2\/categories?post=1256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sogolytics.com\/blog\/wp-json\/wp\/v2\/tags?post=1256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}