List of Default CSV Output Fields: Place, User, Content, and Activity
The CSV exports contain events related to places, user objects, content objects, and user activities.
Attention
Currently, Analytics Export is limited to 10,000 rows per CSV export.
Note: This list is currently missing some entries and will be updated.
Default CSV Output Fields
Common Fields
| Field | Description | Example |
|---|---|---|
Action | The recorded action. For the list of actions, see List of data export events. | ACTIVITY_PEOPLE_SEARCH |
ActivityTime | ms since the epoch (UNIX timestamp) when activity occurred | 1561199268454 |
ActivityTime.Date | Human readable date when activity occurred | 2019-06-22 |
ActivityTime.Hour | Human readable time when activity occurred | 10:27:48 |
Actor.Status | User status | registered |
Actor.CreationDate | ms since the epoch (UNIX timestamp) when the user was created | 1555074452820 |
Actor.CreationDate.Date | Human readable date when the user was created | 2019-05-12 |
Actor.CreationDate.Hour | Human readable time when the user was created | 13:47:49 |
Actor.Email | User email | li.lils@test.com |
Actor.Profile.Department | User department as specified in the user profile | TO department |
Actor.Profile.Location | User location as specified in the user profile | Washington |
Actor.Profile.HireDate | ms since the epoch (UNIX timestamp) when the person was hired | 1561199268454 |
Actor.Profile.HireDate.Date | Human readable date when the person was hired | 2019-06-22 |
Actor.Profile.HireDate.Hour | Human readable time when the person was hired | 10:27:48 |
Actor.FirstName | User first name | Li |
Actor.LastName | User last name | Lils |
Actor.Url | URL of the user in the community | https://testcommunity.com/people/li.lils |
Actor.Name | Name of the user | Li Lils |
Actor.ObjectType | Type of the actor | user |
Actor.Username | Username of the actor | li.lils@test.com |
Place and User CSV Fields
| Field | Description | Example |
|---|---|---|
ActorActionObject.Status | Status of the user | registered |
ActorActionObject.CreationDate | ms since the epoch (UNIX timestamp) when the user was created | 1555074452820 |
ActorActionObject.CreationDate.Date | Human readable date when the user was created | 2019-05-12 |
ActorActionObject.CreationDate.Hour | Human readable time when the user was created | 13:47:49 |
ActorActionObject.Profile.HireDate | ms since the epoch (UNIX timestamp) when the person was hired | 1561199268454 |
ActorActionObject.Profile.HireDate.Date | Human readable date when the person was hired | 2019-06-22 |
ActorActionObject.Profile.HireDate.Hour | Human readable time when the person was hired | 10:27:48 |
ActorActionObject.Email | User email | li.lils@test.com |
ActorActionObject.Profile.Department | User department | |
ActorActionObject.Retired | Indicates if the user account is deactivated | |
ActorActionObject.FirstName | User first name | |
ActorActionObject.Profile.Location | User location as specified in the user profile | Washington |
ActorActionObject.Url | URL of the user in the community | https://testcommunity.com/people/li.lils |
ActorActionObject.Name | Name of the user | |
ActorActionObject.Created | ||
ActorActionObject.ObjectType | Type of the object | user |
ActorActionObject.Relation | ||
ActorActionObject.GraphType | ||
ActorActionObject.RelatedUser.ObjectType | ||
ActorActionObject.RelatedUser.Name | ||
ActorActionObject.LastName | Last name of the user |
Content CSV Fields
| Field | Description | Example |
|---|---|---|
ContentActionObject.CreationDate | ms since the epoch (UNIX timestamp) when the object was created | 1561199268454 |
ContentActionObject.CreationDate.Date | Human readable date when the object was created | 2019-06-22 |
ContentActionObject.CreationDate.Hour | Human readable time when the object was created | 10:27:48 |
ContentActionObject.Keywords | ||
ContentActionObject.FileName | ||
ContentActionObject.ResolutionDate | ms since the epoch (UNIX timestamp) when the object was marked as resolved | 1561199268454 |
ContentActionObject.ResolutionDate.Date | Human readable date when the object was marked as resolved | 2019-06-22 |
ContentActionObject.ResolutionDate.Hour | Human readable time when the object was marked as resolved | 10:27:48 |
ContentActionObject.AssumedResolved | Indicates that the question is marked as Assumed Answered | true |
ContentActionObject.Url | URL of the object | https://testcommunity.com/docs/DOC-10 |
ContentActionObject.MimeType | MIME type of the object | |
ContentActionObject.Open | true | |
ContentActionObject.ObjectType | Type of the object | search |
ContentActionObject.ContainerId | ID of the containing place | |
ContentActionObject.DueDate | ms since the epoch (UNIX timestamp) of the due date | |
ContentActionObject.DueDate.Date | Human readable due date | |
ContentActionObject.DueDate.Hour | Human readable due time | |
ContentActionObject.NumHelpfulAnswers | Number of helpful answers | |
ContentActionObject.AttachmentSize | Attachment size | |
ContentActionObject.Resolved | Indicates if the object is marked as resolved | |
ContentActionObject.NumRecipients | Number of shares of the object | 2 |
ContentActionObject.Status | Status of the object | PUBLISHED |
ContentActionObject.AuthorId | ID of the author of the object | |
ContentActionObject.Owner.Name | ID of the owner of the object | |
ContentActionObject.ContainerType | Type of the container | blog |
ContentActionObject.Owner.ObjectType | Type of the owner | |
ContentActionObject.Subject | Title of the object | Release notes |
ContentActionObject.Completed | Indicated if the object is marked as final |
Destination Fields
| Field | Description | Example |
|---|---|---|
Destination.Status | Status of the object container | ACTIVE |
Destination.CreationDate | ms since the epoch (UNIX timestamp) of the container creation date | 1561199268454 |
Destination.CreationDate.Date | Human readable container creation date | 2019-06-22 |
Destination.CreationDate.Hour | Human readable container creation time | 10:27:48 |
Destination.ObjectType | Type of the container | community |
Destination.DisplayName | Display name of the container | betta-space |
Destination.Url | URL of the container | https://testcommunity.com/community/betta-space |
Destination.Name | Title of the container | Betta space |
Web Fields
| Field | Description | Example |
|---|---|---|
Web.AppVersion | ||
Web.ReferringSource | ||
Web.AppID | web | |
Web.ReferringUser | ||
Web.UserAgent | Identifier of the application type, operating system, software vendor or software version of the requesting software user agent | Mozilla/5.0 (Windows NT 10.0 |
Web.AppSpecRequestOrigin | ||
Web.AppSpecConnectionType | ||
Web.SessionId | Web session ID | c02798c5b6b60 |
Web.AppSpecDeviceVersion |
Main Objects in Activity CSV:
activity.actionObject: The object on which the action was taken (for example, the viewed user).activity.actor: The user taking the action.activity.destination: The space or social group where the acted on content is located.