Export Member Data:

Member Id: This is a unique Id created for each member during their registration in the community.

The Status column:

Member/Sent: This status reflects that the member has been sent a verification email.

Member/Verified: This status reflects that the member has been sent a verification email and has verified the email address.

Member/Assumed: This status reflects that the member has been verified manually from the backend by the IdeaScale support team.

Member/Unknown: This status reflects that the member has been silently uploaded and hence no verification email being sent to the member.

Pending/Assumed: The member has not been approved by the moderator but has been verified manually from the backend by the IdeaScale support team.

Pending/Verified: The member has not been approved by the moderator but has been sent a verification email and has verified the email address.

Banned/Unknown: The member has been banned from the community and they were silently uploaded or added as member in the community.

Banned/Verified: The member has been banned from the community but had verified the email address through the verification email.

Banned/Assumed: The member has been banned from the community and had been verified manually from the backend by the IdeaScale support team.

Merged/Verified: The member was merged with another email address and had both the email address verified.

Merged/Assumed: The member was merged with another email address and had both the email address verified manually from the backend by the IdeaScale support team.

Export Idea Data
• Date/Time - Submission date and time.
• Idea ID - The unique id of the ideas.
• Idea Number - Number of the idea.
• Idea Status - Status in which the idea is.
• Author Name -  Name of the author.
• Author Email Address - Email address of the author.
• Campaign - Name of the campaign.
• Campaign Group (If any) - Name of the campaign group.
• Net Votes - Total votes on the idea.
• Votes Up - Number of up votes.
• Votes Down - Number of down votes.
• Comment Count - Number of comment.
• Idea Title - Title of the idea.
• Idea detail - Description of the idea.
• Tags - Any tags used for an idea.
• Idea URL - The link to the idea.
• Attachment - Any attachments in an idea.
• Custom Fields Names - Custom fields answered in a idea.

Export Stage Data 

Sheet 1 contains:
• Date Range – Dates selected for the data.
• Campaigns – Name of the campaign selected.
• Ideas at Start of Period - How many ideas were already in the   stage at the beginning of the time period.
• New Ideas - How many ideas moved into the stage during  the time period.
• Promoted Ideas - Ideas that moved to the next Stage.
• Ideas at End of Period – How many ideas were in the stage  at the end of the time period.
• Total Ideas - How many ideas spent any length of time in the  stage during the time period including ideas that passed    through the stage.
• Average Time Idea in Stage - Average amount of time each  idea is in the Ideate Stage.
• Summary of all Stages – This includes all the ideas in  different stages along with its number and the promotion of  ideas into the next stage until the end of the period.
 
 Sheet 2: This sheet contains all the data for the specific stage.
 
 • Stage Name - Specific stage name.
 • Stage Type – Specific stage type.
 • Idea Number – Number of the idea.
 • Idea Title – Title of the idea.
 • Idea Description – Detail of the idea.
 • Idea Campaigns – Idea in which campaign.
 • Tags – Any tags used for the idea.
 • Contributors – Names of the contributor for the idea.
 • Upvotes – Number of upvotes for the idea.
 • Downvotes – Number of downvotes for the idea.
 • Upvotes-Downvotes – Total number of votes.
 • Number of Comments – Number of comments for the idea.
 • Attachments – Any kind of attachments if any.
 • Idea Submitter – Name of the idea submitter.
 • Idea Owner – Name of the idea owner if assigned.


Rest for all the exports it is mostly the above ones that will be displayed in the reports.

Did this answer your question?