Using the Analysis Export in Google Sheets – UserVoice

With our Analysis Export (learn more about this feature here), you are able to export ideas, voters and the user and account traits for those voters.

You can use the export to build your own report in Google Sheets. In this article, we will help you get started by walking you through the basics of getting a report set up in Google Sheets.

However, make sure you have someone on your team familiar with Google Sheets or Excel to help you adapt this to your organization's specific needs.

Export your Data

Navigate to the idea grid by clicking the lightbulb in the left-hand menu.
Click "All open ideas", choose your desired forum, or choose your desired saved view.
Set the filters, if any, for which set of ideas you want to export. You can filter ideas by forum, category, status, label and customer activity.
Click the cloud icon at the top right of the ideas grid.
Choose "Export Current Dataset"
Choose the option "Analysis Export

Make sure to limit the number of rows to be less than 5000, which should ensure a smooth experience on Google Sheets. You can do that by limiting the time frame of the export or the ideas included.

You will receive the export file via email. It will come from no-reply@yoursubdomain.uservoice.com. If you don't see it within 15 minutes, be sure to check any spam or email filters that could have caught the email.

Copy our Google Sheets Template

Make a copy of our read-only Google Sheets Template. You will need to be signed into Google Drive to copy the template.

Add your Exported Data

Open your copied Google Sheets Template
Open the tab labeled "Raw Data"
Click "File" at the top -> Import
Select "Upload"

Select the CVS file you exported earlier
Choose "Replace current sheet" and "Comma" before hitting import

Use the Tabs and Formulas in the Template to Analyze your Ideas

To help you get started building your report, we've built an Idea and NPS tab into the export.

Ideas: This tab will show the ideas, and count of unique users and their accounts that have requested the idea.

NPS Groups: If you're using our NPS Widget, this tab will show you that of the voters of the ideas, how many are Promoters, Detractors and Passives.

TIP: To further refine your report, we recommend using the...

"Filter" option on the right to refine your results

Order and Sort options

Common Questions:

Q. I'm having trouble building the formulas I need.

A. You will need a resource on your end to help you build out the report to meet your organization's specific needs. Our support team is not able to help with building or setting up reports.

Q. Why don't I have Accounts listed in my export?

A. For this sheet to work, you will need to be passing in Account Traits. You can learn more about passing account traits here.

Q. Are there more ways I can use this export?

A. Absolutely! We recommend checking out our main article that walks through other ways to use this feature.

Q. Why don't I see NPS for my users?

A. You will need to use our Net Promoter Score Widget to capture the user's NPS. This article walks through this widget, and how it works.

Q. Can I use this export with other tools?

A. Yes, you can. It can be used with tools like Excel, Power BI, and many others.

Q. A single voter is counted multiple times:

A. If a user is connected to multiple accounts, they will get a record for each account they are connected to in the export. Make sure to sort by user ID to count unique voters.

Q. Why do all of a user's accounts show as supporting the idea?

A. When a user is connected to multiple accounts, we don't have a way to track which account they were representing when voting for the idea. We will count each account connected to that voter for that idea.