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:
Historical Date Limits: The Idea Export v2 provides insights into ideation data from January 01, 2021, onwards. This limitation affects vote counts since votes cast prior to this date are not recorded. As a result, you may notice discrepancies between the number of votes displayed in Control and those found in exported datasets. It is important to consider this constraint when analyzing the Idea Export data to ensure an accurate understanding of community engagement metrics.
| 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. |