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.
1. Export your Data
- Click the Ideas icon in the left-hand menu
- Click "All Open Suggestions" at the top of the page.
- Set the filters for which set of ideas you want to export. You can filter ideas by forum, category, status, label and customer activity.
- Choose the option for the "Suggestions and Supporters Export" and "Export."
You will receive the export file via email. It will come from firstname.lastname@example.org. If you don't see it within 15 minutes, be sure to check any spam or email filters that could have caught the email.
2. 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)
3. 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
4. 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 supporters 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
You Might Find Helpful:
- Measure the Impact of Ideas with the Analysis Export
- Use Trend Reports to Measure an Idea's Activity over Time
- Net Promoter Score Report