Developer Docs

Column Definitions for Exports

Dan Potts
  • Updated

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

Note: In December 2019, we updated our terminology in our user interface from Suggestion to Idea and Supporter to Voter. The export fields do not reflect this change.

 Exports this article is relevant to:

  • User Export (Items marked with an * are specific to User Exports (whether on an idea, accounts page or users grid)
  • Analysis Export

Idea Fields

Idea (previously called Suggestion)

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

Names and ID

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

Created

  • suggestion.created_timestamp: Time that the idea was created.
  • suggestion.created_user_agent: The full user agent string in the HTTP request for the idea creator.
  • suggestion.created_referrer: Referrer URL for created idea.
  • suggestion.created_user_agent_browser: The browser name for the idea creator.
  • suggestion.created_user_agent_browser_version: The browser version number for the idea creator.
  • suggestion.created_user_agent_os: The operating system for the idea creator.
  • suggestion.created_user_agent_mobile: True or false whether the idea 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 idea has been flagged as inappropriate by end-users.
  • suggestion.approved_timestamp: Timestamp for when idea is approved.
  • suggestion.updated_timestamp: Timestamp for when idea is updated.
  • suggestion.closed_timestamp: Timestamp for when idea receives a closed status.
  • suggestion.comments_count: Number of comments on a idea.
  • suggestion.notes_count: Number of admin (internal) notes on a idea.
  • 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).

Voter (previously called Supporter) and Activity

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

Created By

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

Status

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

User Fields

User Profile Fields

  • user.id: Unique UserVoice ID of the idea creator.
  • user.guid: SSO GUID for the user (passed via SAML or JSON SSO).*
  • user.name:  Displayname of the idea creator, and shows on the front end of the UserVoice site.
  • user.email_address: Email address of the idea creator.
  • user.job_title: Job title of the idea creator. Can only be set by licensed users.
  • user.created_timestamp: Timestamp that the creator of the idea was created.
  • user.updated_timestamp: Timestamp of the last update to the user who created the idea.
  • user.last_login_timestamp: Timestamp of the last time the idea creator logged in.
  • user.allowed_state: Allowed if licensed for your account (contributor, admin, support)*
  • user.supported_suggestions_count: # of ideas of vote on 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 idea creator.
  • user.geoip_country: Country of the idea creator (determined by users IP).
  • user.geoip_region: Region within the country of the idea creator (determined by users IP).
  • user.geoip_city: City of the sidea creator (determined by users IP).

User NPS Fields:

  • user.nps_rating.value: Idea creator's overall NPS
  • user.nps_rating.group: Detractor, neutral or promoter of idea creator (overall).
  • user.nps_rating.created_timestamp:  Timestamp of the idea creators last NPS rating.
  • user.previous_nps_rating.value: Value (0-10) of the idea creators previous NPS.
  • user.previous_nps_rating.group: Detractor, neutral or promoter of idea creator's previous rating.
  • user.previous_nps_rating.created_timestamp: Timestamp of idea 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 ideas for which this user is a voter.
  • 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.email_address: Always the same as the user's 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 customer's system. Blank if no value passed.
  • user.external_user.account.revenue: 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: Timestamp 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 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).
  • 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 an idea

  • link_suggestion_user.id: The ID of the object that connects a specific voter to a specific idea.
  • link_suggestion_user.is_subscribed: whether or not the user is a voter on the idea.
  • link_suggestion_user.created_timestamp: the timestamp of when the user voted for the idea.
 

Related articles