Export Excel File with Questions and Total Responses Side by Side

What were you thinking? I feel ripped off. I did my first survey in Fall 2020 and a follow up this April. I had to print the screen to get a report comparable to the report I had last Fall. What junk!

19 Comments
DeniseC5392
Consulting & Training

I completely agree with @MikeB82916. I would like to see the same results from the "survey page" that we used to get from the "Legacy survey." As it stands the results are unacceptable and I will most likely be switching platforms once my subscription expires. We run surveys for data analysis, and what is offered in the survey page is poor at best. 

Caitlin_M
Administrator

Hi @DeniseC5392. Could you further explain what's missing from the results or what you would like to see? 

Caitlin_M
Administrator
Status changed to: Open Questions

Hi @ShawnH02. How would you like your reporting to look? Is there a certain layout you prefer? Survey pages is a newer feature so we're welcoming any type of feedback to improve upon it.

Caitlin_M
Administrator
Status changed to: Voting Open

Reply from @ShawnH02 

 

Attached are the results of a survey from last september...supposedly the version that was retired. I could not find a way to export such a report in the current version. I had to print the page which included items that were too small to read at the top. Not professional looking. Really cutting corners here.

What exported was just a list of names and email addresses next to each of the questions. No comparison percentages.

Thank you for the follow up. If you need anything else, please let me know.

 

Previous legacy survey resultsPrevious legacy survey results

Previous Legacy survey results

Thank you so much for the follow-up. I'm going to open this idea up for voting. I included a screenshot of your example for a visual with your information blurred out

Caitlin_M
Administrator

Reply from @DeniseC5392:

Yes, in the older versions of the Legacy Surveys I could download a pdf with graphics such as pie charts and text of responses. Now, all that I can do is download an excel file. If you could allow us to analyze the data in the survey pages and we were able to do in the Legacy Surveys that would be great. Right now, it is almost pointless using CC for surveys as the data isn’t easily readable.

 

Thank you for the explanation. I'm going to merge your feedback into a larger thread surrounding the display of exported responses.

RandyR559
Participant

What is the best way to analyze survey data collected via Constant Comment?

CUAA
Regular Participant
The way the results are exported are completely useless. Is there an alternative way to export that keeps the results of multiple questions with the person answering? this is a giant flaw in your platform.
NielsVHI
Participant
The survey reporting is the worst thing I've ever seen. Yes it collects the information, but it formats it out of order when exported and also gives you no access to see the individual survey because all of the reports are combined together.
JenniferP7090
Participant
What a nightmare. When I download the results the questions don't even stay in the right order. Impossible to read in a basic excel spreadsheet. Only one format to download this mess is ridiculous. Am considering dropping this extra service and going back to Survey Monkey. (The survey feature as a whole is a huge disappointment. Not being able to send the actual survey as an email and only being able to put a link in another email- forcing another click is bad programming.)
AdminA802
Participant

The newer survey response export is a mess!  The questions and responses should be column headings, not additional data in the respondent's row.  C'mon!  This is basic spreadsheet stuff.  Get your constant and variable data straightened out.  Now I get a separate records (rows) for each time a respondent answers each question - not helpful, especially when I write follow-up questions.  I need to scroll through all the records pertaining to question one and hope I find that person's corresponding follow-up response among the rows of question two records.  How did this ever get past your test phase?

KyleeS
Frequent Participant

Has anyone researched alternatives to CC? If updates are not implemented to the survey tool asap, it will be worthless to us since we can't export data in a usable way. I was hoping we had longer, but from the email yesterday the legacy tool will end in June.

RandyR559
Participant

We are considering leaving as well due to the survey module. We have utilized CC to track client intake information. In addition to the survey reporting being a mess the new page survey module only leaves the survey open for six months. Pretty hard to track results for a fiscal year if the survey maximum is six months! If someone finds a good alternative to CC please post!

 

CS_Parks
Frequent Participant

I understand CC wanting to streamline the survey feature, but I feel it's been stripped of so many nice features offered on the Legacy survey platform. 1. The pdf export to a bar chart summary is gone. This report was a nice snapshot of results for our managers. Now I have to screenshoot each question and throw in another document to create this summary. 2) The csv file exports as a mess, with the questions in backwards order. It took me hours to clean up. Plus the question is repeated for every survey respondent. The Legacy export of this document was organized in the manner of the survey, listed the question(s) once, listed the question(s) in order, and then the responses - a much cleaner export. 3) Additionally, the Legacy csv export had two tabs. There was a summary tab in which I would take the organized data and make pie charts for the managers. The new survey feature no longer includes that tab and information in the export. The new survey platform reporting feature is very disappointing.

BrianneM8
Participant
For us the greatest value provided by Contact Contact was the way the results of the responses to the surveys we sent were formatted. All responses from a recipient were on a single row and so it made for easy comparison. The new format has a operate row for every response from every respondent, this is not functional from our perspective and we will have to revaluate using the service.
MadeleineC6
Occasional Participant

Reporting results from surveys using the new tool is a nightmare. I just spent my morning putting the totally unusable results (no PDF summary, no usable spreadsheet with a "details" tab to read comments) into a Word document of my own making to share with my board/conference director. No way I would send a list of over 2000 line items with absolutely no way to make heads nor tails of it to my client, so why is Constant Contact giving me such a rotten result? Whoever decided this survey tool was ready for prime time and pulled the trigger should lose his or her job. Anyone can see that CC has missed the most important part of a survey - sharing the results with others. I can't believe this is happening. Do I start shopping for another email marketing product and steer my client associations in a different direction. A total debacle. This shouldn't have happened, someone was asleep at the wheel. 

Dave43311
Participant
Why did you change the way the survey results come out when you export them? They no longer come out like a normal Excel file where you can easily sort and work with the data?
KristaB98685
Occasional Participant

The new survey export format is not helpful and actually has created ADDITIONAL work for me instead of making it easier. It exports into excel which is great, but all of the responses are showing up in two columns (portrait)instead of each question being in each column (horizontal). I used to be able to sort the spreadsheet in different ways based on different answers (like if someone selected a certain date for training). The way you have it now is completely unusable. HOW could this change have been thought of as a good idea? I don't see how it would work for anyone? There isn't even space between each person who answered the survey, so everyones answers are all jumbled together. Crazy!

MadeleineC9
Occasional Participant

So true, KristaB! Since the new survey tool was implemented, I've had to spend an hour or more creating a meaning report that I can share with board members. What is the most important thing about a survey? Reporting the results! And the only way to share results with others now would be to give a whole lot of people access to the account (terrible) or create a report yourself (equally terrible because it used to take 2 minutes). CC better be working on a fix for the survey tool results and other shortcomings of the new platform (i.e., no longer possible to rate a list of items, you have to repeat the question over and over, also no way to collect respondent information). 

KyleeS
Frequent Participant

Are these comments making any difference with Constant Contact? 

What happens with product feedback?

Find out about the life-cycle of a product idea when it is posted on our Feedback board.

Read More

What's New

See the latest Constant Contact product release notes and updates.

Learn More