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 |
---|---|---|---|
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 |