Idea Export
The Idea Export provides a focused look at ideation data within your community. This export is part of the Exports V2 framework, ensuring data consistency with the CC Data Lake and providing a granular view of how ideas are moving through their lifecycle.
As a reminder, all Community Export V2 data and Dashboard metrics are processed in UTC. The date filter applies to the idea creation date.
Idea Export Schema
The Idea Export captures essential information about each idea, its current status, and community engagement through votes. Below is the data schema for the primary fields found in the Idea Export:
| Field Name | Definition |
| Idea ID | Unique identifier that identifies the topic within Ideas. |
| Topic public ID | Unique identifier that identifies the topic platform-wide. |
| Idea title | The headline or summary name of the idea. |
| Idea votes | The total count of community votes received by the idea. |
| Idea submitted date (UTC) | The date and time when the idea was first posted (always in UTC). |
| Idea status | Label indicating the stage of an idea. |
| Idea status last changed date (UTC) | The date and time when the idea's status was most recently updated. |
| Idea public URL | The direct link to the idea on the community frontend. |
| Idea product areas | The specific product area assigned to the idea. |
| Idea public tags | Collection of public tags assigned. |
| Idea assigned to | Username of the moderator currently responsible for the idea. |
| Category name | The name of the community category where the idea resides. |
| Last activity date | The date of the most recent interaction (reply, vote, or edit) on the idea. |
| Author User Name | Author's user name |
| Author User Rank | Author's rank label in Control |
| Author User RankTitle | Author's rank label in Community |
| Author User Role | Collection of Author's role names. |