How to include the question in header of a poll response export?
Clients often want to export poll responses and struggle with how to include the question in the column headers. If you make a visitor report, the column doesn't include the poll question so it can be confusing if you have multiple polls in the same guide.
You can workaround this with the following strategy:
1) Go to Guide Details page and click on Guide Metrics
2) Scroll down to the Guide Activity table. Make sure it's set to 'By Visitor', and click the Manage Columns button
3) For each poll response, add a column… select type: Poll Response, then Guide Name, and then the specific poll question. You'll notice that the column name includes both the Guide Name and the question.
4) Export the entire Guide Activity table to CSV
Check out this second example. The guide title is 'Support Case Creation' and the two questions were 'Urgency/Priority' and 'What is the issue'
Comments
Big thanks to Angela Holly for the help in creating this workaround!
If they submit multiple entries the columns only pull the latest answer, this the row won't match. The polls in Pendo are an absolute mess, there is now way to group questions together on a report at all.
Any particular reason I do not get Guide columns in reports or the Guide Activity table settings? We should just have a "download poll responses" button like every other survey app in the world :(
Please sign in to leave a comment.