Brightidea has several Community-level reports available that allow Admins to access relevant data from each of their Communities, including Initiatives, Submissions, Users, and Login History.
Admins can view all available reports under Communities Setup > Exports.
Report Types
Initiatives Report
This report will give a summary overview of all Initiatives within the Community. It gives summary number of submissions, what groups its assigned to, who the administrators are, as well as when it was created.
- Report columns:
- Date Created
- Status
- Initiative
- Initiative ID
- Description
- Active Users
- Access Groups
- Sponsor
- Administrators
- URL
- Submissions
- Communities
- Meta Keywords
Submissions Report
This report gives more detailed insight into the Submissions of all Initiatives. Dates can be filtered based on the Idea submission date.
- Report columns:
- Initiative
- Initiative ID,
- Code
- Category
- Submitted
- Submitter
- Submitter email
- Title
- Description
- Status
- Stage
- Step
- Score
- Count of Comments
- Number of Views
- Financial Outcomes
- Projected Net Benefits
- Associated Tags,
- Has Attachment?
- Linked?
- URL
- Previous Status
- Date Entered Status
- Days in Current Status
- Merged
- Merged With
- Submitted From
- Projected and Actual Benefit
- Projected and Actual Cost
- Non-Financial Benefits
Submissions > Vote History Report
Site summary report provides a list of all Sites within your system with additional information about Site status and activity.
- Report columns:
- Initiative
- Initiative ID
- Code
- Title
- Voter
- Voter Email
- Votes
- Pts
- Chips
- Total Pts/Chips
- Vote Date
Submissions with Comment Details Report
This report lists all comment details added to Submissions, including the times when comments were made.
- Report columns:
- Initiative
- Initiative ID
- Code
- Title
- Comment
- Comment Submitter
- Comment Submitter Email
- Comment Date
- Comment ID
- Reply to Comment ID
Submissions Step Change History Report
This report shows the lifecycle of Submissions within a Pipeline. Admins can find out when a Submission entered a Step, how long it stayed there, and where it was moved.
- Report columns:
- Initiative
- Code
- Title
- Step
- Date Entered Step
- Date Left Step
- Days in Step
- Next Step
- User Name
- User Email
- Member ID
Submissions with Outcome Details Report
This report shows the details of Submissions financial outcomes. Administrators can find out outcome start and end dates as well as the outcome amount.
The Outcome Details Export and Business Impact Dashboards will also display Benefits and Costs by year
- Report columns:
- Initiative
- Submission Code
- Submission Title
- Submission Submitted Date
- Outcome Type
- Outcome Amount ($)
- Outcome Period Start
- Outcome Period End
- Outcome Period Span
- Outcome Title
- Outcome Description
- Outcome Date Recorded
- Outcome Attachments
- Outcome Recorder Screen Name,
- Outcome Recorder Email
User Activity Report
This report records all User activity and engagement as points/tallies. Admins can see individual users' activity levels throughout each Community.
- Report columns:
- Screen Name
- Email Address
- Last Site Visit Date
- Creation Date Timestamp
- Creation Date Year
- Counts (Transactions)
- Total Points
- Submissions
- Comments
- Promotes
- Demotes
- Registered
- Invited a Friend
- Friend Registered
- Votes of Support
- Number of submissions viewed
- Points Earned
- Submissions
- Comments
- Promotes
- Demotes
- Registered Invited a Friend
- Friend Registered
- Votes of Support
- Status Change
- Admin Status (Y/N)
- Active
User Groups Report
Export a list of users with their relevant Group membership within the Community.
- Report columns:
- Group
- Screen Name
- Email Address
Login History Report
The Login History report will export the login history for each Community user.
- Report columns:
- Initiative
- Initiative ID
- Screen Name
Email Address - Login Date and Time
- Platform
Note: If SSO is enabled, Admins will see an empty report. SSO users are routed through Enterprise login when accessing Brightidea, and this report is only for Community-level login instances.
Comments