Export Users

Perhaps you want to follow up with a set of users on an idea. This can be done with status updates, but you can also export the users on an idea to an Excel file, which will include their email address and other information, including user fields.

Exporting Voters on an idea

1. Click into the idea, and then click the “Users” tab. 
2. Click the "Cloud" icon and choose "Export current dataset".

How it Works:

• The export link title in the email includes the date and UTC timestamp of the export, as well as the idea ID, to help you keep track of exports.
• Idea information is not included since you are exporting users on a single idea.

Exporting users from the Users grid

1. Click the "More" icon in the left-hand navigation. Then "Users & Accounts"
2. Click the "Cloud" icon and choose "Export current dataset".

How it Works:

• The export will include account and user fields, but will not include a list of ideas the user has voted for.
• If you have passed in multiple external ID's for a user, then the export will contain a row for each external user ID
• The link title in the export email contains the date and UTC timestamp of the export.
• On the user's grid, you can search and it will export the search results. However, if you search person@domain.com, it will search for anything with “person”, “domain” or “com.” You will get better results searching just “domain” to get users with "domain" in their email address.
• On the users' grid, you can also filter user license type (or end-users who don't have a license) and export those.
• Tip: Use the search bar functions to narrow down your selection for export. Exports sizes are capped at 50k records. If you need a larger amount of data records pulled, we recommend using the API. 

Export users on an account (Premium Only)

1. Click the “More” icon in the left-hand navigation. Then "Users & accounts"
2. Click the “Accounts” tab. 
3. Click on an account, and then click the “Users” tab. 
4. Click the "Cloud" icon and choose "Export current dataset".

How it Works:

• The export will include the UserVoice users connected to that account, and all external user records for each of those users even if they are not connected to that account.
• The link title in the export email contains the date and UTC timestamp, as well as the account ID.

Specific Columns & Definitions found in this Export

View our article, Column Definitions for Exports, for other columns that can be included in this export.

• user.external_user.last_seen_timestamp: Last time the user logged in on your web portal or submitted an idea, ticket, etc. via the widget.
• user.external_user.uv_updated_timestamp: Last time the idea was updated by an external user.
• user.external_user.account.ltv: Lifetime value of an account. Blank if no value passed.
• user.external_user.account.last_login_timestamp: Last time an external user connected to the account logged into UserVoice, or was seen via the widget js.
• user.external_user.account.supported_suggestions_count: # of ideas supported by the account.
• user.external_user.account.requests_count: # of pieces of feedback for all external users connected to the account.
• user.external_user.account.users_count: # of external users connected to the account.
• user.external_user.account.users_nps: NPS for the account (uses the most recent rating for each user on that account, and then subtracts % of detractors from promoters).