{"id":2328,"date":"2010-07-12T07:37:00","date_gmt":"2010-07-12T07:37:00","guid":{"rendered":"http:\/\/www.questionpro.com\/?p=2328"},"modified":"2010-07-12T07:37:00","modified_gmt":"2010-07-12T07:37:00","slug":"follow-these-data-cleaning-tips-on-you-online-survey-panel-responses","status":"publish","type":"post","link":"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/","title":{"rendered":"Follow These Data Cleaning Tips On You Online Survey Panel Responses"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-2329 size-thumbnail\" style=\"margin-left: 10px; margin-right: 10px;\" title=\"iStock_000005822932XSmall\" src=\"https:\/\/www.questionpro.com\/blog\/wp-content\/uploads\/2010\/07\/istock_000005822932xsmall-150x150.jpg\" alt=\"image\" width=\"150\" height=\"150\" \/>The great thing about using online panel respondents for your survey is the ability to profile exactly the kinds of respondents that you want. \u00a0The disadvantage of using survey panels is that there is a lot of garbage data that&#8217;s included.<\/p>\n<p>For example: People who speed through a survey, \u00a0people who leave gibberish for open ended responses, \u00a0people who just click on the same rating scale number all the way down the matrix and more.<\/p>\n<p>Nico Peruzzi,\u00a0PhD from Outsource Research Consulting, has an ingeniously simple and effective way to get the best of both from the survey panel experience. \u00a0His latest article on Research Access gives you tips on how to identify bad respondents and exactly how to clean them up with nothing more than a simple spreadsheet function.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The great thing about using online panel respondents for your survey is the ability to profile exactly the kinds of [&hellip;]<\/p>\n","protected":false},"author":128,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[180],"tags":[428],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Follow These Data Cleaning Tips On You Online Survey Panel Responses | QuestionPro<\/title>\n<meta name=\"description\" content=\"The great thing about using online panel respondents for your survey is the ability to profile exactly the kinds of respondents that you want. \u00a0The\" \/>\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.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Follow These Data Cleaning Tips On You Online Survey Panel Responses | QuestionPro\" \/>\n<meta property=\"og:description\" content=\"The great thing about using online panel respondents for your survey is the ability to profile exactly the kinds of respondents that you want. \u00a0The\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/\" \/>\n<meta property=\"og:site_name\" content=\"QuestionPro\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/questionpro\" \/>\n<meta property=\"article:published_time\" content=\"2010-07-12T07:37:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.questionpro.com\/blog\/wp-content\/uploads\/2010\/07\/istock_000005822932xsmall-150x150.jpg\" \/>\n<meta name=\"author\" content=\"Ivana Taylor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@questionpro\" \/>\n<meta name=\"twitter:site\" content=\"@questionpro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ivana Taylor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/\"},\"author\":{\"name\":\"Ivana Taylor\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/#\/schema\/person\/5a547e9ba0ad62a9ffa6f12466a7a244\"},\"headline\":\"Follow These Data Cleaning Tips On You Online Survey Panel Responses\",\"datePublished\":\"2010-07-12T07:37:00+00:00\",\"dateModified\":\"2010-07-12T07:37:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/\"},\"wordCount\":142,\"publisher\":{\"@id\":\"https:\/\/www.questionpro.com\/blog\/#organization\"},\"keywords\":[\"Essay\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/\",\"url\":\"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/\",\"name\":\"Follow These Data Cleaning Tips On You Online Survey Panel Responses | QuestionPro\",\"isPartOf\":{\"@id\":\"https:\/\/www.questionpro.com\/blog\/#website\"},\"datePublished\":\"2010-07-12T07:37:00+00:00\",\"dateModified\":\"2010-07-12T07:37:00+00:00\",\"description\":\"The great thing about using online panel respondents for your survey is the ability to profile exactly the kinds of respondents that you want. \u00a0The\",\"breadcrumb\":{\"@id\":\"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.questionpro.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uncategorized\",\"item\":\"https:\/\/www.questionpro.com\/blog\/category\/uncategorized\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Follow These Data Cleaning Tips On You Online Survey Panel Responses\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/#website\",\"url\":\"https:\/\/www.questionpro.com\/blog\/\",\"name\":\"QuestionPro\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.questionpro.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.questionpro.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/#organization\",\"name\":\"QuestionPro\",\"url\":\"https:\/\/www.questionpro.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.questionpro.com\/blog\/wp-content\/uploads\/2022\/10\/questionpro-logo.svg\",\"contentUrl\":\"https:\/\/www.questionpro.com\/blog\/wp-content\/uploads\/2022\/10\/questionpro-logo.svg\",\"caption\":\"QuestionPro\"},\"image\":{\"@id\":\"https:\/\/www.questionpro.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/questionpro\",\"https:\/\/twitter.com\/questionpro\",\"https:\/\/www.linkedin.com\/company\/questionpro\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/#\/schema\/person\/5a547e9ba0ad62a9ffa6f12466a7a244\",\"name\":\"Ivana Taylor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d23fe73ba92b9a95ce057e280755df6b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d23fe73ba92b9a95ce057e280755df6b?s=96&d=mm&r=g\",\"caption\":\"Ivana Taylor\"},\"description\":\"Ivana Taylor provides DIY Marketing advice, marketing trends and marketing how-to tips and strategies for small business owners and CEOs.\",\"url\":\"https:\/\/www.questionpro.com\/blog\/author\/thirdforce\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Follow These Data Cleaning Tips On You Online Survey Panel Responses | QuestionPro","description":"The great thing about using online panel respondents for your survey is the ability to profile exactly the kinds of respondents that you want. \u00a0The","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.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/","og_locale":"en_US","og_type":"article","og_title":"Follow These Data Cleaning Tips On You Online Survey Panel Responses | QuestionPro","og_description":"The great thing about using online panel respondents for your survey is the ability to profile exactly the kinds of respondents that you want. \u00a0The","og_url":"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/","og_site_name":"QuestionPro","article_publisher":"https:\/\/www.facebook.com\/questionpro","article_published_time":"2010-07-12T07:37:00+00:00","og_image":[{"url":"https:\/\/www.questionpro.com\/blog\/wp-content\/uploads\/2010\/07\/istock_000005822932xsmall-150x150.jpg"}],"author":"Ivana Taylor","twitter_card":"summary_large_image","twitter_creator":"@questionpro","twitter_site":"@questionpro","twitter_misc":{"Written by":"Ivana Taylor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/#article","isPartOf":{"@id":"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/"},"author":{"name":"Ivana Taylor","@id":"https:\/\/www.questionpro.com\/blog\/#\/schema\/person\/5a547e9ba0ad62a9ffa6f12466a7a244"},"headline":"Follow These Data Cleaning Tips On You Online Survey Panel Responses","datePublished":"2010-07-12T07:37:00+00:00","dateModified":"2010-07-12T07:37:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/"},"wordCount":142,"publisher":{"@id":"https:\/\/www.questionpro.com\/blog\/#organization"},"keywords":["Essay"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/","url":"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/","name":"Follow These Data Cleaning Tips On You Online Survey Panel Responses | QuestionPro","isPartOf":{"@id":"https:\/\/www.questionpro.com\/blog\/#website"},"datePublished":"2010-07-12T07:37:00+00:00","dateModified":"2010-07-12T07:37:00+00:00","description":"The great thing about using online panel respondents for your survey is the ability to profile exactly the kinds of respondents that you want. \u00a0The","breadcrumb":{"@id":"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.questionpro.com\/blog\/follow-these-data-cleaning-tips-on-you-online-survey-panel-responses\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.questionpro.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Uncategorized","item":"https:\/\/www.questionpro.com\/blog\/category\/uncategorized\/"},{"@type":"ListItem","position":3,"name":"Follow These Data Cleaning Tips On You Online Survey Panel Responses"}]},{"@type":"WebSite","@id":"https:\/\/www.questionpro.com\/blog\/#website","url":"https:\/\/www.questionpro.com\/blog\/","name":"QuestionPro","description":"","publisher":{"@id":"https:\/\/www.questionpro.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.questionpro.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.questionpro.com\/blog\/#organization","name":"QuestionPro","url":"https:\/\/www.questionpro.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.questionpro.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.questionpro.com\/blog\/wp-content\/uploads\/2022\/10\/questionpro-logo.svg","contentUrl":"https:\/\/www.questionpro.com\/blog\/wp-content\/uploads\/2022\/10\/questionpro-logo.svg","caption":"QuestionPro"},"image":{"@id":"https:\/\/www.questionpro.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/questionpro","https:\/\/twitter.com\/questionpro","https:\/\/www.linkedin.com\/company\/questionpro\/"]},{"@type":"Person","@id":"https:\/\/www.questionpro.com\/blog\/#\/schema\/person\/5a547e9ba0ad62a9ffa6f12466a7a244","name":"Ivana Taylor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.questionpro.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d23fe73ba92b9a95ce057e280755df6b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d23fe73ba92b9a95ce057e280755df6b?s=96&d=mm&r=g","caption":"Ivana Taylor"},"description":"Ivana Taylor provides DIY Marketing advice, marketing trends and marketing how-to tips and strategies for small business owners and CEOs.","url":"https:\/\/www.questionpro.com\/blog\/author\/thirdforce\/"}]}},"featured_image_src":null,"featured_image_src_square":null,"author_info":{"display_name":"Ivana Taylor","author_link":"https:\/\/www.questionpro.com\/blog\/author\/thirdforce\/"},"_links":{"self":[{"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/posts\/2328"}],"collection":[{"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/users\/128"}],"replies":[{"embeddable":true,"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/comments?post=2328"}],"version-history":[{"count":0,"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/posts\/2328\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/media?parent=2328"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/categories?post=2328"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/tags?post=2328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}