Installed Apps Version 1

This table contains installed apps information from devices where Siprocal's SDK is installed. To enable this collection, please refer to the SDK documentation.

The table is a snapshot of the latest installed app information for each device.

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.

`clientid`

Type: STRING

Description

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

`lastmodifieddate`

Type: BIGINT

Description

Date of the last information of installed apps for that device. Unix timestamp in miliseconds.

Value Example

1666633986704

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

`installedapps`

Type: STRING

Description

Stringfied JSON containing the packagename and appname for all installed apps on the device. Packagename are the keys, appname are the values. All lowercase, package name comparison to package name on play store must be case insensitive to match

Value Example

"{"com.reddit.frontpage":"reddit", "com.microsoft.office.onenote":"onenote"}"

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

QUERY_ALL_PACKAGES

`org`

Type: STRING

Description

Human readable partner ID for Siprocal. Internal purposes.

Value Example

partner name

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