Export users
Sarah Hum
Jacques Reulet
Merged in a post:
Export Tracked Users
T
Tomato Gecko
Export list of tracked users into Excel
E
Evident Alpaca
We would like to export all the people (all posts) that left a suggestion (email addresses) to filter out everybody that did. This way we can build a campaign and focus on people that didn't ask any request yet.
Sarah Hum
open
Andrew Rasmussen
planned
S
Scarlet Mite
We would like to see this feature to make it easier to comply with GDPR-type requests when a user requests a copy of their personal data.
Ideally the export would contain the user's posts, votes, and comments. Ideally it would be requestable using an API so that it could be automated.
Are you planning to implement this?
Can you offer a workaround in the meantime?
Andrew Rasmussen
Scarlet Mite: Hey Iain, we have an API endpoint where you can retrieve a user. You can also fetch posts and votes, filtered by user/author ID.
Interestingly, we don't have a way to fetch comments filtered by author ID. If you need this filter, I'd be happy to add it for you.
After that, it'd be pretty straightforward for you to write a script that fetches a user's ID from their email, and then fetches all of their posts, comments, and votes.
S
Scarlet Mite
Andrew Rasmussen: Thank you for sharing. We would like to have the comments as well if possible.
We would prefer to be able to retrieve all this data with a single API call if possible.
Is this feature on the roadmap?
Andrew Rasmussen
Scarlet Mite: Hey Iain, I've marked this post as Planned to indicate we intend on building it soon, but haven't started development yet. Stay tuned!
S
Scarlet Mite
Andrew Rasmussen: That's great news! We look forward to it.
T
Tan Skink
Andrew Rasmussen: Hey Andrew! Have there been any updates in terms of progress for this type of feature?
Thank you!
Andrew Rasmussen
Hi Tan Skink, could you tell me a bit more about why you want to export users from Canny? That'd be helpful in building a case for prioritizing this 🙂
T
Tan Skink
Andrew Rasmussen: Jaqcues has directed me to this request, and we are specifically looking to export the Company ID that is associated with a user. We are needing this bit of info to cross references with another document we have, to further understand what types of business' are requesting what types of features.
When you export the entire list of requests, that company ID is not listed in that spreadsheet. If that company ID was in that spreadsheet, it would be so so helpful!
Andrew Rasmussen
Hi Tan Skink, understanding which types of businesses are requesting which types of features sounds like a perfect use case for our user segmentation functionality.
You could make company segments like "more than 500 employees" or "paying more than $10k/yr" and then filter down Canny's feedback to just those segments.
I believe our CSV post export functionality also includes columns on counts for various user segments, if you wanted to do a breakdown/comparison.
Alternatively, if none of this works, you could likely pull this reporting via our API.
Hope this helps!