In-App Events Version 1

The documentation present on this page refers to the table that contains the timestamp register of SDK-tracked events inside an app installed on the device. To collect this information, The event tracking is only available for apps integrated with Siprocal's SDK. This feature was implemented after SDK version 4.0.

The default events tracked by the SDK are:

Application install (drAppInstall)
First activity in the application (firstActivityIsLauched)
Application coming to foreground (drAppForegrounded)
Application going to background (drLastSessionTime)

Any other configured events will appear in the table in the same format as the default ones (as a timestamp register).

This is a historical or log format table.

IMPORTANT:

Please note that there are some [DEPRECATED] fields, you can safely ignore them, even though they will be present in the data exchange. Deprecated fields refer to fields that were collected in the past, and are either not available anymore or cannot be captured for any reason. They are still kept on the database for backwards compatibility reasons;
[EXPERIMENTAL] features are undergoing active development and their definition or collection method may change at any moment without prior notice. We ask not to rely on them for decision making and reporting
Field data collection is made on a best effort basis. Since there are many permisson and device configuration scenarios, it is not possible to guarantee full data collection.

`user_id`

Type: STRING

Description

Same as clientid on other tables: ID that identifies the users' device (deviceId, idfv or google_gaid). Devices may have the string "DR-" added as a prefix to them. This should be removed if willing to match to external sources.

Value Example

6e3c68ee-9003-4710-9caf-35e742cfab66

Possible Values (if category)

Android API Permissions

Technical permission needed to collect the information. Please note this is not a comprehensive list, check the relevant SDK documentation for details

None

`src_pkg`

Type: STRING

Description

Name of the app package

Value Example

com.example.app

Possible Values (if category)

Android API Permissions

Technical permission needed to collect the information. Please note this is not a comprehensive list, check the relevant SDK documentation for details

None

`created_at`

Type: BIGINT

Description

Timestamp record of when the event happened. Unix timestamp.

Value Example

1689610871

Possible Values (if category)

Android API Permissions

Technical permission needed to collect the information. Please note this is not a comprehensive list, check the relevant SDK documentation for details

None

`day`

Type: STRING

Description

Stringfied truncated timestamp record of when the event happened (by day)

Value Example

2023-07-17

Possible Values (if category)

Android API Permissions

Technical permission needed to collect the information. Please note this is not a comprehensive list, check the relevant SDK documentation for details

None

`organization_id`

Type: STRING

Description

Partner ID for Siprocal. Internal purposes.

Value Example

6364r50eg28a70050364bd2

Possible Values (if category)

Android API Permissions

Technical permission needed to collect the information. Please note this is not a comprehensive list, check the relevant SDK documentation for details

None

`event_name`

Type: STRING

Description

Name of the event tracked. NOTE: Besides the possible values denoted on column "Possible Values (if category)", if the app configures a personalized event, it will also appear as a value on this field.

Value Example

drLastSessionTime

Possible Values (if category)

drAppForegrounded; drLastSessionTime; firstActivityIsLauched; drAppInstall

Android API Permissions

Technical permission needed to collect the information. Please note this is not a comprehensive list, check the relevant SDK documentation for details

None