

{"id":6225,"date":"2012-09-05T06:00:19","date_gmt":"2012-09-05T13:00:19","guid":{"rendered":"http:\/\/www.questionpro.com\/?p=6225"},"modified":"2012-09-05T06:00:19","modified_gmt":"2012-09-05T13:00:19","slug":"how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi","status":"publish","type":"post","link":"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/","title":{"rendered":"How to Use External and Custom Variables to Save Time in Data Analysis"},"content":{"rendered":"<p>One of the things we are always promoting is keeping your surveys short. \u00a0But that can be easier said than done when we need so much information from our respondents.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6226 size-full\" title=\"iStock_000005985927XSmall\" src=\"https:\/\/www.questionpro.com\/blog\/wp-content\/uploads\/2012\/08\/istock_000005985927xsmall.jpg\" alt=\"image\" width=\"406\" height=\"296\" \/><\/p>\n<p>Well, there&#8217;s actually a fairly easy way to deal with this dilemma &#8212; you can use External and Custom Variables to not only shorten your survey, but make sure that the information that is attached to each response is accurate. \u00a0Let me give you a real life example.<\/p>\n<p>For several years I ran some customer surveys for a financial services client. \u00a0The surveys would run weekly to get their satisfaction scores based on their most recent transactions.<\/p>\n<p>As you would imagine, some clients had more than one transaction during the week, so simply sending them a survey invitation was NOT going to help us improve their experience on any specific transaction. \u00a0So this is how we dealt with that scenario.<\/p>\n<p>The client created a downloaded report (internally) that captured the clients name, email and transaction that they ran. \u00a0We created an external custom variable for the name of the transaction. \u00a0And then inside the invitation letter, we used the default &#8220;Name&#8221; custom variable to personalize the message and then inserted their specific transaction that they had for that week that was attached to that specific survey.<\/p>\n<p>If the respondent had more than one transaction that week &#8211; they would get more than one survey invitation that clarified exactly which transaction experience they were rating on that survey.<\/p>\n<p><strong>The outcome<\/strong><\/p>\n<p>This might sound complicated and difficult &#8211; but believe me it only took about five minutes to do.<\/p>\n<p>The client would send me the report spreadsheet. \u00a0I would use the list feature in QuestionPro to upload the list with the external variables mapped out. \u00a0We would run the survey and the responses would come flooding in.<\/p>\n<p>This process gave the client very clear data about what the satisfaction scores were for each transaction and allowed them to track satisfaction scores not only for the transaction, but for any team member that was associated with that process.<\/p>\n<p>Learn more about how to incorporate external and custom variables into your survey here:<\/p>\n<p>Custom Variables: https:\/\/www.questionpro.com\/help\/131.html<br \/>\nData Pre-population: https:\/\/www.questionpro.com\/help\/241.html<br \/>\nMail Merge: https:\/\/www.questionpro.com\/help\/customer-experience\/100.html<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the things we are always promoting is keeping your surveys short. \u00a0But that can be easier said than [&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":[250,203],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Use External and Custom Variables to Save Time in Data Analysis | QuestionPro<\/title>\n<meta name=\"description\" content=\"One of the things we are always promoting is keeping your surveys short. \u00a0But that can be easier said than done when we need so much information from our\" \/>\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\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use External and Custom Variables to Save Time in Data Analysis | QuestionPro\" \/>\n<meta property=\"og:description\" content=\"One of the things we are always promoting is keeping your surveys short. \u00a0But that can be easier said than done when we need so much information from our\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/\" \/>\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=\"2012-09-05T13:00:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.questionpro.com\/blog\/wp-content\/uploads\/2012\/08\/istock_000005985927xsmall.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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/\"},\"author\":{\"name\":\"Ivana Taylor\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/#\/schema\/person\/5a547e9ba0ad62a9ffa6f12466a7a244\"},\"headline\":\"How to Use External and Custom Variables to Save Time in Data Analysis\",\"datePublished\":\"2012-09-05T13:00:19+00:00\",\"dateModified\":\"2012-09-05T13:00:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/\"},\"wordCount\":398,\"publisher\":{\"@id\":\"https:\/\/www.questionpro.com\/blog\/#organization\"},\"articleSection\":[\"Consumer Insights\",\"Market Research\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/\",\"url\":\"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/\",\"name\":\"How to Use External and Custom Variables to Save Time in Data Analysis | QuestionPro\",\"isPartOf\":{\"@id\":\"https:\/\/www.questionpro.com\/blog\/#website\"},\"datePublished\":\"2012-09-05T13:00:19+00:00\",\"dateModified\":\"2012-09-05T13:00:19+00:00\",\"description\":\"One of the things we are always promoting is keeping your surveys short. \u00a0But that can be easier said than done when we need so much information from our\",\"breadcrumb\":{\"@id\":\"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.questionpro.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CX\",\"item\":\"https:\/\/www.questionpro.com\/blog\/category\/cx-2\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Consumer Insights\",\"item\":\"https:\/\/www.questionpro.com\/blog\/category\/cx-2\/consumer-insights\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"How to Use External and Custom Variables to Save Time in Data Analysis\"}]},{\"@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":"How to Use External and Custom Variables to Save Time in Data Analysis | QuestionPro","description":"One of the things we are always promoting is keeping your surveys short. \u00a0But that can be easier said than done when we need so much information from our","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\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/","og_locale":"en_US","og_type":"article","og_title":"How to Use External and Custom Variables to Save Time in Data Analysis | QuestionPro","og_description":"One of the things we are always promoting is keeping your surveys short. \u00a0But that can be easier said than done when we need so much information from our","og_url":"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/","og_site_name":"QuestionPro","article_publisher":"https:\/\/www.facebook.com\/questionpro","article_published_time":"2012-09-05T13:00:19+00:00","og_image":[{"url":"https:\/\/www.questionpro.com\/blog\/wp-content\/uploads\/2012\/08\/istock_000005985927xsmall.jpg"}],"author":"Ivana Taylor","twitter_card":"summary_large_image","twitter_creator":"@questionpro","twitter_site":"@questionpro","twitter_misc":{"Written by":"Ivana Taylor","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/#article","isPartOf":{"@id":"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/"},"author":{"name":"Ivana Taylor","@id":"https:\/\/www.questionpro.com\/blog\/#\/schema\/person\/5a547e9ba0ad62a9ffa6f12466a7a244"},"headline":"How to Use External and Custom Variables to Save Time in Data Analysis","datePublished":"2012-09-05T13:00:19+00:00","dateModified":"2012-09-05T13:00:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/"},"wordCount":398,"publisher":{"@id":"https:\/\/www.questionpro.com\/blog\/#organization"},"articleSection":["Consumer Insights","Market Research"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/","url":"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/","name":"How to Use External and Custom Variables to Save Time in Data Analysis | QuestionPro","isPartOf":{"@id":"https:\/\/www.questionpro.com\/blog\/#website"},"datePublished":"2012-09-05T13:00:19+00:00","dateModified":"2012-09-05T13:00:19+00:00","description":"One of the things we are always promoting is keeping your surveys short. \u00a0But that can be easier said than done when we need so much information from our","breadcrumb":{"@id":"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.questionpro.com\/blog\/how-to-use-external-and-custom-variables-to-save-time-in-data-analyisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.questionpro.com\/blog\/"},{"@type":"ListItem","position":2,"name":"CX","item":"https:\/\/www.questionpro.com\/blog\/category\/cx-2\/"},{"@type":"ListItem","position":3,"name":"Consumer Insights","item":"https:\/\/www.questionpro.com\/blog\/category\/cx-2\/consumer-insights\/"},{"@type":"ListItem","position":4,"name":"How to Use External and Custom Variables to Save Time in Data Analysis"}]},{"@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\/6225"}],"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=6225"}],"version-history":[{"count":0,"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/posts\/6225\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/media?parent=6225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/categories?post=6225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.questionpro.com\/blog\/wp-json\/wp\/v2\/tags?post=6225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}