This article provides information on user and activity type exports in Exports V2.
Overview
This section outlines common behaviors and shared characteristics across all export types in Exports v2. These patterns ensure consistency in how data is extracted, interpreted, and consumed across reporting tools.
- Common Data Model: Most export files are structured using the topic model from the CC Data Lake, rather than SQL-based thread tables. This shift ensures consistency across exports, dashboards, and analytics platforms.
- Historical Date Limits: Data tied to events or activities (such as views, logins, or moderation actions) is available from January 01, 2021, onwards.
- Filtering Logic: All exports are provided for the selected time range, except for the User export, which additionally has an option to request the all-time user list.
- URL Format Changes: Topic and post URLs now follow a simplified format for easier use. For example, /topic/show?tid=16260
For more information on exports V2, refer to the Change Document for Exports V2 article.
User Export
Exports v1 excluded content from hidden groups and categories excluded from stats. Exports v2 does not filter out these criteria, leading to higher counts in activity fields.
| v2 Field Name | Description | Comparison to v1 & Notes |
| username | Username within the community. | Same as v1. |
| | User's email address. | Same as v1. |
| userRank | User's rank. | Same as v1. |
| userRole | Collection of user roles. | Same as v1. |
| total_topics | Cumulative topics posted. | Data Difference: v2 includes hidden or excluded category content. |
| total_comments | Cumulative replies posted. | Data Difference: v2 includes hidden or excluded category content. |
| total_answeredcomments | Cumulative Best Answers achieved. | Data Difference: v2 includes hidden or excluded category content. |
| total_likes | Cumulative likes given. | Data Difference: v2 includes hidden or excluded category content. |
| join_dates | Date of registration. | Same as v1. |
| last_activity | Date or time of last activity (excluding Control Panel). | Same as v1. |
| [Profile Fields] | Custom fields (First Name, Company, Job Title, and so on) | Same as v1. |
| last_login | Date or time user last logged in. | New Field. Displays data starting from January 01, 2021. |
| total login count | Cumulative number of logins. | New Field: Displays data starting from January 01, 2021. |
| Content helpfulness votes -positive | Count of helpful votes received. | New Field: Displays data starting from January 01, 2021. |
| Content helpfulness votes -neutral | Count of neutral votes received. | New Field: Displays data starting from January 01, 2021. |
| Content helpfulness votes -negative | Count of not helpful votes received. | New Field: Displays data starting from January 01, 2021. |
| user_id | Unique user ID. | New Field |
| user_profile_link | URL to user profile. | New Field |
Login Export
Login Export provides the login details of all user login events, based on the identity_access_* models from data-lake.
| v2 Field Name | Description | Comparison to v1 & Notes |
| username | Username. | Same as v1. |
| userRank | User Rank. | Same as v1. |
| userRole | User Roles. | Same as v1. |
| time | Timestamp of login. | Same as v1. |
| event_type | Activity type (for instance, user_login). | Same as v1. Displays data starting from January 01, 2021. |
Moderator Actions Export
This export tracks actions taken by moderators. The columns remain similar, but the Event Types (Values) have been significantly renamed and expanded.
| v2 Field Name | Description | Comparison to v1 & Notes |
| username | Username | Same as v1 |
| userRank | User Rank | Same as v1 |
| userRole | User Roles | Same as v1 |
| time | Timestamp of action | Same as v1 |
| topic_url | Complete URL for the topic | Same as v1 |
| event_type | The specific activity performed. | Major Value Changes: See mapping below. |
Event Type Mappings: From v1 to v2
- topic_setsticky → content_topic_sticky_state_enabled
- topic_unsetsticky → content_topic_sticky_state_disabled
- topic_move → content_topic_moved_to_another_category
- topic_assignedmoderator → content_topic_assigned_moderator
- (unassign) → content_topic_unassigned_moderator
- topic_open → content_topic_opened_for_replies
- topic_close → content_topic_closed_for_replies
- topic_markedquestion → content_question_answered
- topic_unmarkedquestion → content_question_answer_removed
- topic_untrash → content_topic_restored
- topic_trash → content_topic_trashed
- post_untrash → content_reply_restored
- post_trash → content_reply_trashed
- post_edit → content_topic_edited
- (reply edit) → content_reply_edited
- topic_label → content_topic_moderation_label_set
- (label unset) → content_topic_moderation_label_unset
- topic_updatetitle → topic_updatetitle
- post_modbreak → post_modbreak
New Event Types in v2
- content_reply_moved_to_another_topic_type
- content_reply_moved_to_existing_topic
- content_reply_permanently_deleted
- content_topic_permanently_deleted
- content_reply_approved_by_moderator
- content_topic_approved_by_moderator
- content_reply_pinned / content_reply_unpinned
- content_topic_converted
- content_reply_promoted_to_new_topic
- content_topic_created_from_reply
- content_topic_product_areas_changed
- content_reply_highlight_changed