Data Export Service CSV Output Fields

Document created by thales on Dec 3, 2014Last modified by yuval.z on Mar 25, 2015
Version 2Show Document
  • View in full screen mode

NOTE: This document is for Analytics V1. For information about Analytics V2, refer to V2 Data Export Service CSV Output Fields.

 

The Data Export Service provides endpoints to get activity written to a CSV file. The following list provides examples and descriptions of each field in the CSV file. Note:The fields within your report may be slightly different based upon custom fields you may have created.


Read more about Using the Jive Data Export (Analytics) Service


Field

ExampleDescription
ActionACTIVITY_CREATE_THREAD
ActivityTime1415633303629Unix Time (Epoch Time) when activity occurred
ActivityTime.Date11/10/2014Date when activity occurred
ActivityTime.Hour15:28:23Time when activity occurred
Actor.Profile.Location
Actor.CreationDate1397150777278Unix Time (Epoch Time)
Actor.LastNameDoeLast name
Actor.NameJohn DoeFull Name
Actor.Statusregistered
Actor.CreationDate.Date4/10/2014User account creation date
Actor.ObjectTypeuser
Actor.Urlhttps://jivecommunity.com/people/johndoeURL for user profile
Actor.Emailjohndoe@xyz.comUser email address
Actor.CreationDate.Hour17:26:17
Actor.UsernameJohndoeTime when user account was created
Actor.FirstNameJohnUser first name
Actor.Profile.HireDate
Actor.Profile.HireDate.Hour
Actor.Profile.Department
Actor.Profile.HireDate.Date
ContentActionObject.Open
ContentActionObject.ResolutionDate.Date
ContentActionObject.Resolved
ContentActionObject.Owner.Name
ContentActionObject.MimeType
ContentActionObject.ResolutionDate.Hour
ContentActionObject.AssumedResolved
ContentActionObject.Urlhttps://jivecommunity.com/thread/116715URL of object being reported
ContentActionObject.CreationDate.Hour15:28:23Time when object was created
ContentActionObject.ContainerTypesocialgroupContainer type storing object (socialgroup/community/usercontainer)
ContentActionObject.Keywords
ContentActionObject.DueDate.Hour
ContentActionObject.NumHelpfulAnswers
ContentActionObject.DueDate.Date
ContentActionObject.SubjectThis is a test Discussion QuestionSubject of object
ContentActionObject.NumRecipients
ContentActionObject.AttachmentSize
ContentActionObject.DueDate
ContentActionObject.Completed
ContentActionObject.AuthorId
ContentActionObject.CreationDate1415633303442Unix Time (Epoch Time) when object was created
ContentActionObject.ResolutionDate
ContentActionObject.StatusPUBLISHEDStatus of object
ContentActionObject.CreationDate.Date11/10/2014Date when object was created
ContentActionObject.ObjectTypethreadObject type
ContentActionObject.FileName
ContentActionObject.Owner.ObjectType
ContentActionObject.ContainerId1157
Destination.NameCollaboration ExampleName of container where object resides
Destination.StatusACTIVE
Destination.CreationDate.Date7/3/2014Date destination was created
Destination.ObjectTypesocialgroupDestination type
Destination.Urlhttps://jivecommunity.com/groups/collaboration-exampleDestination URL
Destination.CreationDate.Hour1:38:19Time when destination was created
Destination.CreationDate1404351499776.00Unix Time (Epoch Time) when destination was created
Destination.DisplayNamecollaboration-example
Web.SessionIdfdc13ca92ac20342a3g198e428ab579e
Web.ReferringSource
Web.ReferringUser
Web.AppVersion
Web.UserAgentMozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0
Web.AppSpecConnectionType
Web.AppIDWeb.AppSpecDeviceVersion Web.AppSpecRequestOrigin

 

Attachments

    Outcomes