Analytics Services - Exports Schema
This article explains format and schema of the data that is exported from Analytics Services APIs.
Exports are CSV files that contain all rows available for the interval requested in the export job. Exports can be performed for activities, activity outcomes, and seats. CSV schemas for each export are defined below. For more information on how to create export jobs to export data, see Exporting User Activity.
Activity CSV Schema
The Activity CSV export is a snapshot of statistics for the activities performed within Sales Navigator. Here is the schema of the Activity CSV Export:
| Column Name | Data Type | Optional in response | Description |
|---|---|---|---|
| activityId | string | no | Unique ID for the sales activity |
| activityType | string | no | Type of activity. See Activity Types |
| createdAt | string | no | The time the sales activity took place, in MM-DD-YYYY HH:MM:SS format (UTC) |
| seatId | long | no | Identifier of the seat holder who took the action |
| memberIdentityKey | string | yes | Unique identifier of the Lead associated with the activity. Some activities are not related to leads, i.e. saving an account, and will not contain memberIdentityKey |
Activity Types
Here are the supported types of activities for export in Sales Navigator Analytics Services:
| Activity Type | Description |
|---|---|
| SAVED_LEAD | Seat holder saved a lead |
| SAVED_ACCOUNT | Seat holder saved an account |
| SEARCH_PERFORMED | Seat holder performed a search |
| PROFILE_VIEWED | Seat holder viewed a profile |
| INMAIL_SENT | Seat holder sent an InMail |
| MESSAGE_SENT | Seat holder sent a LinkedIn or Sales Navigator message |
| CONNECTION_MADE | Seat holder made a connection |
Activity Outcome CSV Schema
The Activity Outcome CSV export is a snapshot of statistics for the outcome of activities performed within Sales Navigator. Here is the schema of the ActivityOutcome CSV Export:
| Column Name | Data Type | Optional in response? | Description |
|---|---|---|---|
| activityId | string | no | Unique ID of the activity associated with this outcome event |
| activityType | string | no | Type of outcome. See Activity Outcome Types |
| createdAt | string | no | The time the sales outcome took place, in MM-DD-YYYY HH:MM:SS format (UTC) |
| memberIdentityKey | string | yes | Unique identifier of the associated lead. Some activities are anonymous and will not contain a memberIdentityKey, e.g. viewing PointDrive without logging into LinkedIn |
Activity Outcome Types
The activityType column in the Activity Outcomes export is a key that describes the type of outcome present. The following outcomes are currently supported:
| Activity Type | Description |
|---|---|
| INMAIL_ACCEPTED | Member accepted InMail |
| INMAIL_REJECTED | Member rejected InMail |
Seats CSV Schema
The Seats CSV export is a snapshot of statistics for seat holders for each day that they are an active user of Sales Navigator. Here is the schema of the Seats CSV Export:
| Column Name | Data Type | Optional in response? | Description |
|---|---|---|---|
| contractId | long | no | Unique ID for the sales contract |
| seatId | long | no | Unique ID for the sales seat |
| recordedAt | string | no | When seat information was captured, in MM-DD-YYYY HH:MM:SS format (UTC) |
| createdAt | string | no | Timestamp for when seat was created, in MM-DD-YYYY HH:MM:SS format (UTC) |
| firstName | string | no | First name of the seat holder |
| lastName | string | no | Last name of the seat holder |
| string | no | Email address of the seat holder | |
| ssi | float | no | Overall SSI score of the seat holder |
| ssiCreateProfessionalBrand | float | no | SSI score representing professional brand of the seat holder |
| ssiFindRightPeople | float | no | SSI score representing connectivity of the seat holder |
| ssiEngageWithInsights | float | no | SSI score representing engagement with insights by the seat holder |
| ssiBuildStrongRelationship | float | no | SSI score representing relationship building of the seat holder |
| totalConnections | int | no | Total number of connections in LinkedIn of the seat holder |