Export users
Sarah Hum
Jacques Reulet
Merged in a post:
Export Tracked Users
D
Dawn pink Hedgehog
Export list of tracked users into Excel
P
Past Reindeer
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
W
Whisper pink Muskox
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
Whisper pink Muskox: 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.
W
Whisper pink Muskox
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
Whisper pink Muskox: 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!
W
Whisper pink Muskox
Andrew Rasmussen: That's great news! We look forward to it.
J
Jasmine green Squirrel
Andrew Rasmussen: Hey Andrew! Have there been any updates in terms of progress for this type of feature?
Thank you!
Andrew Rasmussen
Hi Jasmine green Squirrel, 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 🙂
J
Jasmine green Squirrel
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 Jasmine green Squirrel, 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!