Column Definitions for Exports

This article covers the different fields that can be included in exports. The fields included will vary based on the export. 

Exports this article is relevant to:

Idea Fields

Suggestion

  • suggestion.id: Unique ID of the suggestion.
  • suggestion.title: Publicly visible title of suggestion.
  • suggestion.body: Publicly visible description of suggestion.
  • suggestion.body_mime_type: While included in the export, this column is blank. 
  • suggestion.portal_url: Unique URL of suggestion on web portal for end-users.
  • suggestion.admin_url: Unique URL of suggestion in admin console for admins.
  • suggestion.cf_{custom segment key}

Names and ID

  • suggestion.forum.name: The forum the suggestion is in.
  • suggestion.category.name: The category the suggestion is in.
  • suggestion.status.name: Name of suggestions current status.
  • suggestion.labels.name: Names of applied labels to the suggestion.
  • suggestion.category.id: Unique ID of the category the suggestion is in.
  • suggestion.status.id: Unique ID of the status of the suggestion.
  • suggestion.parent.id: If the suggestion is merged into another, this will be the unique suggestion ID of the suggestion it is merged in to (the parent).
  • suggestion.ticket.id: When a suggestion is converted to a ticket, this is the unique ID of that ticket
  • suggestion.forum.id: Unique ID of the forum the suggestion is in.
  • suggestion.labels.id: The IDs of the labels on the suggestion.

Created

  • suggestion.created_timestamp: Time that the suggestion was created.
  • suggestion.created_user_agent: The full user agent string in the HTTP request for the suggestion creator.
  • suggestion.created_referrer: Referrer URL for created suggestion.
  • suggestion.created_user_agent_browser: The browser name for the suggestion creator.
  • suggestion.created_user_agent_browser_version: The browser version number for the suggestion creator.
  • suggestion.created_user_agent_os: The operating system for the suggestion creator.
  • suggestion.created_user_agent_mobile: True or false whether the suggestion was created via our mobile SDK.

Activity

  • suggestion.state: Approved or published. Approved means it went to moderation and was approved by an admin. Published means it didn't go through moderation and is on the web portal.
  • suggestion.inappropriate_flags_count: Number of times suggestion has been flagged as inappropriate by end users.
  • suggestion.approved_timestamp: Timestamp for when suggestion is approved.
  • suggestion.updated_timestamp: Timestamp for when suggestion is updated.
  • suggestion.closed_timestamp: Timestamp for when suggestion receives a closed status.
  • suggestion.comments_count: Number of comments on a suggestion.
  • suggestion.notes_count: Number of admin (internal) notes on a suggestion.
  • suggestion.requests_count: Number of pieces of feedback captured from sidebar, in admin console, feedback import or zendesk app.
  • suggestion.votes_count: The number of votes (legacy).

Supporter and Activity

  • suggestion.supporters_count: Number of supporters.
  • suggestion.supporters_accounts_mrr_sum: Sum of the MRR for the accounts that have supporters on the suggestion.
  • suggestion.supporters_nps: NPS of the supporters of the suggestion.
  • suggestion.supporters_nps_rating_detractors_count: Number of supporters on the suggestion who are also detractors (NPS).
  • suggestion.supporters_nps_rating_promoters_count: Number of supporters on the suggestion who are also promoters (NPS).
  • suggestion.supporters_nps_rating_passives_count: Number of supporters on the suggestion who are also passives (NPS).
  • suggestion.customer_activity_average: New supporters, feedback, and comments normalized to 30 days.
  • suggestion.customer_activity_recent: New supporters, feedback, and comments in the last 30 days.
  • suggestion.customer_activity_trend: Recent customer activity / average customer activity.

Created By

  • suggestion.created_by_user.id: Unique ID of the suggestion creator.
  • suggestion.created_by_user.name: Display name of the suggestion creator.
  • suggestion.created_by_user.email_address: Email address of the suggestion creator.
  • suggestion.created_by_user.guid: GUID (if using SSO) of the suggestion creator.

Status

  • suggestion.status_update.body: Body of the message of the most recent status update on the suggestion.
  • suggestion.status_update.created_timestamp: Timestamp of the last status update on the suggestion.
  • suggestion.status_update.created_by_user.id: Unique ID of the user who made the last status update on the suggestion.
  • suggestion.status_update.created_by_user.name: Username of the user who made the last status update on the suggestion.
  • suggestion.status_update.created_by_user.email_address: Email address of the user who made the last status update on the suggestion.
  • suggestion.status_update.id: Unique ID of the last status update event.

User Fields

User Profile Fields

  • user.id: Unique UserVoice ID of the suggestion creator.
  • user.guid: SSO GUID for the user (passed via SAML or JSON SSO).*
  • user.name:  Display name of the suggestion creator, and shows on the front end of the UserVoice site.
  • user.email_address: Email address of the suggestion creator.
  • user.job_title: Job title of the suggestion creator (can only be set by licensed users).
  • user.created_timestamp: Timestamp that the creator of the suggestion was created.
  • user.updated_timestamp: Timestamp of the last update to the user who created the suggestion.
  • user.last_login_timestamp: Timestamp of the last time the suggestion creator logged in.
  • user.allowed_state: Allowed if licensed for your account (contributor, admin, support)*
  • user.supported_suggestions_count: # of suggestions of supported by user.*
  • user.is_admin user.license_type: If licensed, shows contributor, admin, support*
  • user.teams.id:  ID of Contributor Sidebar Team they are on*
  • user.teams.name:  Name of Contributor Sidebar Team they are on.*

User Location Fields

  • user.ip_address: IP address of the suggestion creator.
  • user.geoip_country: Country of the the suggestion creator (determined by users IP).
  • user.geoip_region: Region within the country of the suggestion creator (determined by users IP).
  • user.geoip_city: City of the suggestion creator (determined by users IP).

User NPS Fields:

  • user.nps_rating.value: Suggestion creator's overall NPS
  • user.nps_rating.group: Detractor, neutral or promoter of suggestion creator (overall).
  • user.nps_rating.created_timestamp:  Timestamp of the suggestion creators last NPS rating.
  • user.previous_nps_rating.value: Value (0-10) of the suggestion creators previous NPS.
  • user.previous_nps_rating.group: Detractor, neutral or promoter of suggestion creator's previous rating.
  • user.previous_nps_rating.created_timestamp: Timestamp of suggestion creator's previous NPS rating.
Learn more about our NPS widget.

External User Standard and Custom Fields

  • user.external_user.external_id: User ID passed in via API or JS SDK. Blank if no value passed.
  • user.external_user.name: Standard user field. Blank if no value passed.
  • user.external_user.user_type: Standard user field. Blank if no value passed.
  • user.external_user.created_timestamp: Created_at field for user. Will default to first time UV saw the user if no value passed.
  • user.supported_suggestions_count: Number of suggestions for which this user is a supporter.
  • 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:  
  • user.external_user.email_address: Always the same as the users email address in UserVoice.
  • user.external_user.type: Standard user field. Blank if no value is passed.
  • user.external_user.cf_{custom field key}: User custom field passed via the api or widget. Blank if no value is passed.

Learn more about User Standard and Custom Fields

Account Standard and Custom Fields (passed for the user)

  • user.external_user.account.id: Account ID of the user
  • user.external_user.account.name: Account Name. Blank if no value passed.
  • user.external_user.account.created_timestamp: Timestamp account was created in customers system. Blank if no value passed.
  • user.external_user.account.mrr: Monthly recurring revenue of account. Blank if no value passed.
  • user.external_user.account.ltv: Lifetime value of an account. Blank if no value passed.
  • user.external_user.account.plan: Plan of account. Blank if no value passed.
  • user.external_user.account.uv_created_timestamp: Time stamp of when account was first created in UserVoice.
  • 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 suggestions 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).
  • user.external_user.account.cf_{custom field key]: Custom fields passed for the external account.  Will be blank if no value passed.
Learn more about Account Standard and Custom Fields.


What does "Link_Suggestion" mean? Represents the link between a user and suggestion.

  • link_suggestion_user.id: The ID of the object that connects a specific supporter to a specific suggestion.
  • link_suggestion_user.is_subscribed: whether or not the user is a subscriber on the idea.
  • link_suggestion_user.created_timestamp: the timestamp of when the user supported the idea.

Feedback and Knowledge Base