Skip to main content

In case you need to perform some spreadsheet magic with ideas, you can easily export a list of all ideas from Control.

In the example below, you can see the data that’s available in the export:

Idea ID Idea title Idea votes Idea submitted date (UTC) Idea status Idea status last changed date (UTC) Idea public URL Idea product areas Idea public tags
325 Export submitted ideas to the ideation board 2 2020-06-10 16:51:34 Open 2020-06-19 00:32:50 https://community.insided.com/ideas/325 Analytics, Ideation export

 

How To Export Ideation Data

  1. Log in to Control as a community manager or administrator.
  2. Go to Platform > Ideation > Data export.
  3. Press ‘Export all ideas in CSV’

Hey @daniel.boon any chance we can include the voters email addresses in this export? It can help solve for this Idea:
 

 


Thanks for highlighting that idea @mstone! We did actually consider a separated votes export, but we decided against it until we could gather more input/use cases. I believe the above use case would be more handy directly in Control, but can also imagine that it might be useful in an export in some cases.


@daniel.boon any progress on giving the Customer segmentation around Votes (email addresses, etc)? It’s a Really big usecase for prioritization on a Product Manager’s roadmap:

cc @mstone 

20 upvotes that cover an audience base of 15 different co.s is a much stronger usecase than bulk of the voters coming from the same co. is stronger than the employees of the brand (in our case Gainsight) upvoting themselves. Surprised it is not shared already?

Also, pl enable Ideation > Data export for me under Platform, I cant see that view as admin andutta on our community admin console. 

Here’s my view

 


Hello Gamechangers

Is there a way to export IDEAs together with author email address? Currently we can do only the default export with those fields, correct?

Thank you.

Idea ID Idea title Idea votes Idea submitted date (UTC) Idea status Idea status last changed date (UTC) Idea public URL Idea product areas Idea public tags

Hey ​@Grzegorz Byrski - Great question. I honestly also wish the native Ideas export included a few more columns, including the email address.  To solve this, you do have a couple of options.

The first one is fairly non-technical, and simply involves getting very comfortable with doing a VLOOKUP.  That’s a fun skill to have and is relatively straightforward once you get the logic.  You can go to the exports and grab an all-time Topics export to start with.  This will include all topics, but you can get a bit creative by filtering out all the topics where ‘ideation status’ is blank.  That should just leave you with all the ideas.  Now unfortunately, this export ALSO doesn’t have the email address.  But it does have the username.  So if you then grab an all-time User export, you use a VLOOKUP to fill a column next to the username with the email address.  Optionally, if you then wanted to add the email address and/or username to the original ideas export, you can then do that with another VLOOKUP (using the Topic ID as reference).

The second option is a bit more technical but if you’re comfortable exploring something like Zapier or Workato you can ping our API and pull all the data you need into a Google Sheet.  This gives you total flexibility and is an approach I chose myself quite recently so that I had everything I needed in one place.  

There’s also the data lake, of course, if that’s an option for you.  

Hope one of these options is workable for you.  


@Kenneth R thank you for sharing all the possible workarounds, it’s greatly appreciated. VLOOKUP will do the trick for us.


Reply