{"id":27024,"date":"2016-07-15T10:43:09","date_gmt":"2016-07-15T17:43:09","guid":{"rendered":"http:\/\/www.questionpro.com\/blog\/?p=27024"},"modified":"2023-07-27T07:02:16","modified_gmt":"2023-07-27T07:02:16","slug":"combining-survey-data-advanced-reporting","status":"publish","type":"post","link":"https:\/\/www.questionpro.com\/blog\/combining-survey-data-advanced-reporting\/","title":{"rendered":"Combining Survey Data for Advanced Reporting"},"content":{"rendered":"

Combining survey data<\/h2>\n

\"CombiningMy boss conducted two different surveys in our organization to check employee satisfaction, one for the employees and other for their supervisors. There were few similar questions in both surveys. For example, the survey sent out to the Employees had a\u00a0question – \u00a0\u2018How satisfied are you with the support received from your supervisors?\u2019. The supervisors then had a similar\u00a0question – \u2018How happy are you with the support provided by the management?\u2019 My boss wanted a consolidated data for all the similar questions. Combining survey data can be tricky as it involves downloading the data from both the surveys and then consolidating the data. However, even if I do that I cannot have this data available in the survey, instead, I would have to maintain the data outside the tool. QuestionPro understands how difficult it would be to combining survey data from different surveys, and hence we have our upcoming \u2018Consolidate data\u2019<\/strong> feature. Using this feature one can easily combine data from different surveys.<\/p>\n

In order to copy data from one survey to the other, the question format should be the same. For example, both of the questions should be single select or multi-select etc. Once you select the question you wish to map, the tool automatically shows questions of the similar format. As both of the questions provided above are of similar format, you can easily map these questions and consolidate the data. Combining survey data will ensure that all the data is consolidated in one survey, which will make the reporting much easier. In the above case, after pulling the data into one survey, it would be easier for my boss to analyze the data and get better insights.<\/p>\n

Steps for combining survey data<\/h2>\n

I was so excited that I carried out simple 4 steps for consolidating survey data<\/a>.<\/p>\n

Step 1.<\/strong> First set the survey to which you wish to copy the data to.
\nLogin >> Surveys >> Reports >> Consolidate data<\/p>\n

\"combining<\/p>\n

Step 2.<\/strong> Select the survey from which you wish to copy the data from under \u2018Copy data from\u2019 and click on \u2018+Add Question Mapping\u2019<\/p>\n

Step 3.<\/strong> Select the question you wish to map. The adjacent drop-down will show the questions with the similar format that can be mapped to this question.<\/p>\n

Step 4.<\/strong> Click on \u2018Consolidate data\u2019
\n\"combining<\/p>\n

What are the questions supported for ‘Consolidate data’ feature?<\/h2>\n

The below question types are supported for Consolidate Report Data:<\/p>\n