profile_properties

This table represents the content of the profile properties (the profile corresponds to a visitor of the web-site recognized by a long lasting cookie). The profile properties represent calculated data for each profile which should be loaded in the real-time database. By filling this table, the system will will automatically upload and create/update your customer properties in the real-time database.

Field name

Type

Mode

Description

Field name

Type

Mode

Description

profile_id

STRING

REQUIRED

PK - the profile id

property_name

STRING

REQUIRED

PK - the profile property name

property_value

STRING

REQUIRED

PK - the profile property value

confidence

INTEGER

NULLABLE

(optional) a int value giving a confidence value from 0 to 10000

origin

STRING

REQUIRED

please provide a unique key defining the origin system of these data, not used, but useful for debugging / monitoring

creation_tm

TIMESTAMP

REQUIRED

please provide timestampe of the initial creation of this row

last_modified_tm

TIMESTAMP

REQUIRED

please provide timestampe of the last modification of this row