Campaign Downloads Version 1

This table contains the Siprocal campaigns download information, per individual dispatch. The download refers to the content (image, text, etc) of the campaign sent to the device by Siprocal's servers.

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

`campaignid`

Type: STRING

Description

ID of the campaign associated with the ad

Value Example

5fd0f23c6ab07d01215476a7

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

`downloadtime`

Type: BIGINT

Description

Timestamp of the download of campaign in the device. Unix Timestamp format.

Value Example

1686352654

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

`jobid`

Type: STRING

Description

Batch ID through which the dispatch was delivered

Value Example

64a3423d5e6a27414eadd3177_0_9

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

`adid`

Type: STRING

Description

Unique reference to the campaign/clientid/batch inside the platform. Important: Differs from field with same name on Campaign Dispatches table

Value Example

63d17ab4534e24795f3f0773a0

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

`timestamp`

Type: BIGINT

Description

Date when the data about the download was received by the Siprocal servers. Formatted as an integer with the date values as YYYYMMDDHHmm

Value Example

202306092317

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

`organizationid`

Type: STRING

Description

Partner ID for Siprocal. Internal purposes.

Value Example

6364r60eg28a70050364bd2

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