Skip to main content

Feature Spotlight: Consolidated Reporting

Today's feature spotlight is on consolidated reporting. This is one of the most appreciated features we have in our reporting capabilities. Many times when running ongoing surveys, we do things like week over week, month over month, quarter over quarter and so on. Have you ever wondered how you can merge the data from two of these identical surveys into one source for analyzing the trends? Continue reading for a step by step overview and walkthrough of how to consolidate data from two or more surveys into one report and export it in excel. We also have included a great video walkthrough from the Survey Analytics Customer Success Team as well!

In Case You Didn't Know...

As always in our feature spotlights, you can click on any of the images in the post to open the step by step instructions in a gallery style presentation view.

To give you a general quick rundown of consolidated reporting, it is a quick and easy way to merge data from two surveys together to analyze any patterns or archive for the future to look back upon. It is great to use for any survey you may have run more than once to combine the two or more data sets into one report.

Please note that in order to run a consolidated report, the two surveys must be identical. If they aren't, the consolidated report will not run correctly. The consolidated report will be available to export in the Excel format as an .xls file. Continue reading to see how to run a consolidated report in Survey Analytics.

To run a consolidated report, first make sure you are on the survey which you wish to consolidate with the data from another survey. After that, click on the Analytics tab (or use the hotkey shortcut "a") and in the left hand navigation under the Analytics & Tabs section, click Consolidate Report. In this instance, I had a survey that I ran six months apart to two separate e-mail lists of leads and I needed to combine the data to report it to my boss for an overview.

If you are just going to consolidate data from one survey, simply click on the survey and run the consolidated report. If you are consolidating data from more than one survey, hold command and click for Mac or control and click for Windows to select more than one survey - and then you may proceed to run the consolidated report.

If you wait momentarily, you will be able to get the excel file shortly after clicking run consolidated report. The exported file will be in the .xls format and include the merged percentages and charts you need to analyze the data. If you want to come back later for the report, it will be available in your Survey Analytics account download center.

If you would rather see this demonstration in the video format, below is a great video that is just under two minutes long from Customer Success Team Member Dan Fleetwood on how to set up consolidated reports in your account today. 

Did you enjoy this post? Sign up for our weekly blog digest.


  1. Writing reports means a lot if you want to achieve academic success. Moreover, on you can even hire someone to write a paper if you need

  2. the information you provide on this website has helped me tremendously.I do accept as true with all the ideas you’ve offered in your post. Benedict Cumberbatch Costume

  3. Shopify vs Squarespace , who wins the battle? This question seems easier to answer though its not. If it comes to a detailed comparison, you better gather all the facts and look into the analytical report to boot your productivity.


Post a Comment

Popular posts from this blog

Results of the Presidential Job Index Survey (week ending 7/1/2010)

Quick update on the results for the presidential job index survey for the week ending 7/1/2011. As a reminder this is a weekly survey that we conduct and we publish the results for the survey every Friday. To participate in this week's survey, please download the SurveySwipe application and take the survey.

Remember, you get points that you can redeem for various rewards when you take our surveys. We have already distributed several paid apps like Angry Birds for free.


Almost 900 respondents took the survey.
52% vs 53% last week of the respondents approve of the job that President Obama is doing.
Respondents included 28% Democrats (31% last week), 25% Republicans (22% last week), 24% independents (27%) last week and 2% with the Green Party (3% last week).

You can view the reports here or directly on your phone.

Top 5 Infographics of the Week: Cyber Security

Earlier this week, we experienced a power outage with our data center at Internap. During this short period of time, our customers were unable to access the site. Luckily, it didn't last long and we are back up and running now thanks to our dedicated support team that responded quickly and worked diligently.

Cyber security is, and always has been, a very important issue for us as we continue to grow and meet the demands of a technology-driven society. Nothing is more paramount than the safety of your valuable data. And apparently we weren't the only ones affected, as LinkedIn was experiencing difficulties on the same day and Internap had 3 massive outages earlier this year. Check out these infographics with stats on the importance of cyber security and the impact it can have on small-medium sized businesses.

Top 5 Infographics of the Week: Internet of Things

In 2008, the number of things connected to the internet exceeded the number of people on Earth. By 2050, we are expected to surpass 50 million different devices connected to the internet. And we're not just talking smartphones and tablets - we mean everything. Wearable tech, household appliances, smart homes, public transportation, hospitals and even cattle have all been using sensors to transmit data automatically. It is an exciting yet scary time to be alive. The various interactions between these different entities are opening up doors for more apps, more software and more auxiliary services. With so many "things" connected online, the possibilities for information exchange becoming wider everyday. Check out the top 5 infographics to learn more about the IoT.