Data Export Service CSV Output Fields

Version 2

    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