Data warehouse Person field types

Acquia Lift data warehouse

The data warehouse uses the Person field layout to describe visitors that have been uniquely identified with first-party cookies, their email addresses, or some other identifier.

The Person field layout uses the following tables to describe your visitors:

person table

Field name Data type Sortable Description
active BOOLEAN No The person is a unique entity; false indicates this person was merged into another person during identity resolution (touches and events remain linked to the original person)
anonymous_visitor BOOLEAN No Person without any identity information, such as an email address or account ID
articles_remaining INT (4 bytes) No Number of articles available for person to access, usable with free previews or limited subscriptions — optional and provided externally
do_not_track BOOLEAN No Indicates whether or not the person has opted out of tracking and personalization
engagement_score INT (4 bytes) No Numeric representation of this person's engagement with the brand that is calculated by customer-specific rules (for example, a visitor with a newsletter subscription is more engaged than a periodic visitor); calculated here as the sum of all engagement scores at the event level over a 90-day period
external_score INT (4 bytes) No Rating value not created or defined by Acquia Lift
first_time_visitor BOOLEAN No Indicates whether person is a first-time visitor
first_touch DATE Yes Time and date of the person's first touch
id INT (4 bytes) Yes Unique person ID — Acquia Lift internal value; person_id fields in other tables refer to this value
identifiers_json VARCHAR (65535) No A JSON representation of all the identifiers associated with the person
last_modified_date TIMESTAMP No Time and date that the row was last modified
last_subscription_plan VARCHAR (50) No Immediately previous subscription plan for the person (for example, Unlimited, Monthly, or Yearly) — optional and provided externally
last_touch DATE Yes Time and date of the person's last touch
persona VARCHAR (100) No The top persona of the person, based on their consumed content
primary_identifier VARCHAR (200) No Tracking ID assigned to a website visitor and stored in their cookies; if there are multiple identifiers, this field reflects the first assigned identifier
primary_identifier_type_id INT (4 bytes) No Person's identifier type — this will always have a value of 2 to reflect the first tracking ID assigned by Acquia Lift
subscriber_status VARCHAR (50) No The person's subscription status — optional and provided externally
subscription_end_date DATE No Date the person's subscription expires — optional and provided externally
subscription_plan VARCHAR (50) No Current person's subscription plan — optional and provided externally
subscription_start_date DATE No Date the person's subscription started — optional and provided externally
db_last_modified_date TIMESTAMP No The UTC time and date when the row was last modified in the database
custom_field_1 VARCHAR (200) No User-defined field

Because this field is also used by Experience Builder, we recommend that you do not use this field for your custom values.

custom_field_2 VARCHAR (200) No User-defined field

Because this field is also used by Experience Builder, we recommend that you do not use this field for your custom values.

custom_field_3 VARCHAR (200) No User-defined field

Because this field is also used by Experience Builder, we recommend that you do not use this field for your custom values.

custom_field_4 VARCHAR (200) No User-defined field
custom_field_5 VARCHAR (200) No User-defined field
custom_field_6 VARCHAR (200) No User-defined field
custom_field_7 VARCHAR (200) No User-defined field
custom_field_8 VARCHAR (200) No User-defined field
custom_field_9 VARCHAR (200) No User-defined field
custom_field_10 VARCHAR (200) No User-defined field
custom_field_11 VARCHAR (200) No User-defined field
custom_field_12 VARCHAR (200) No User-defined field
custom_field_13 VARCHAR (200) No User-defined field
custom_field_14 VARCHAR (200) No User-defined field
custom_field_15 VARCHAR (200) No User-defined field
custom_field_16 VARCHAR (200) No User-defined field
custom_field_17 VARCHAR (200) No User-defined field
custom_field_18 VARCHAR (200) No User-defined field
custom_field_19 VARCHAR (200) No User-defined field
custom_field_20 VARCHAR (200) No User-defined field
custom_field_21 VARCHAR (200) No User-defined field
custom_field_22 VARCHAR (200) No User-defined field
custom_field_23 VARCHAR (200) No User-defined field
custom_field_24 VARCHAR (200) No User-defined field
custom_field_25 VARCHAR (200) No User-defined field
custom_field_26 VARCHAR (200) No User-defined field
custom_field_27 VARCHAR (200) No User-defined field
custom_field_28 VARCHAR (200) No User-defined field
custom_field_29 VARCHAR (200) No User-defined field
custom_field_30 VARCHAR (200) No User-defined field
custom_field_31 VARCHAR (200) No User-defined field
custom_field_32 VARCHAR (200) No User-defined field
custom_field_33 VARCHAR (200) No User-defined field
custom_field_34 VARCHAR (200) No User-defined field
custom_field_35 VARCHAR (200) No User-defined field
custom_field_36 VARCHAR (200) No User-defined field
custom_field_37 VARCHAR (200) No User-defined field
custom_field_38 VARCHAR (200) No User-defined field
custom_field_39 VARCHAR (200) No User-defined field
custom_field_40 VARCHAR (200) No User-defined field
custom_field_41 VARCHAR (200) No User-defined field
custom_field_42 VARCHAR (200) No User-defined field
custom_field_43 VARCHAR (200) No User-defined field
custom_field_44 VARCHAR (200) No User-defined field
custom_field_45 VARCHAR (200) No User-defined field
custom_field_46 VARCHAR (200) No User-defined field
custom_field_47 VARCHAR (200) No User-defined field
custom_field_48 VARCHAR (200) No User-defined field
custom_field_49 VARCHAR (200) No User-defined field
custom_field_50 VARCHAR (200) No User-defined field
Field name Data type Sortable Description
db_last_modified_date TIMESTAMP No The UTC time and date when the row was last modified in the database
linked_person_id INT (4 bytes) No Points to a person associated with the visitor listed in this record's person_id
person_id INT (4 bytes) Yes Points to a specific person in Acquia Lift's records

person_identifier table

Field name Data type Sortable Description
active BOOLEAN No The person is a unique entity; False indicates this person was merged into another person during identity resolution (touches and events remain linked to the original person)
db_last_modified_date TIMESTAMP No The UTC time and date when the row was last modified in the database
identifier VARCHAR (200) Yes Person's identifier information, based on the person_identifier_type_id
last_modified_date TIMESTAMP No The timestamp of the last modification of this record
person_id INT (8 bytes) Yes Points to a specific person in Acquia Lift's records
person_identifier_type_id INT (4 bytes) Yes Person's identifier type, from the following options:
  • 1 - email
  • 2 - tracking identifier
  • 3 - account id
  • 4 - Facebook account
  • 5 - Twitter account
  • 6 - name

person_campaign_state table

Field name Data type Sortable Description
customer_campaign_id INT (4 bytes) No Unique campaign ID — Acquia Lift internal value
customer_segment_id INT (4 bytes) No Points to the segment that the person matched
db_last_modified_date TIMESTAMP No The UTC time and date when the row was last modified in the database
end_event_id INT (4 bytes) No Points to the event that caused the person to leave the campaign
end_inclusion_date TIMESTAMP No Date the person left the campaign
end_touch_id INT (4 bytes) No Points to the touch that caused the person to leave the campaign
person_id INT (4 bytes) Yes Points to a specific person in Acquia Lift's records
start_event_id INT (4 bytes) No Points to the event that caused the person to enter the campaign
start_inclusion_date TIMESTAMP No Date the person entered the campaign
start_touch_id INT (4 bytes) No Points to the touch that caused the person to enter the campaign
test_date TIMESTAMP No Date the person was last tested against the campaign segments
test_event_id INT (4 bytes) No Points to the event last tested against the campaign's segments
test_touch_id INT (4 bytes) No Points to the touch last tested against the campaign's segments

person_ranking_item table

Field name Data type Sortable Description
db_last_modified_date TIMESTAMP No The UTC time and date when the row was last modified in the database
item_date INT (4 bytes) Yes Date for which the ranking item's value has been accumulated
item_name VARCHAR (200) Yes Name of the ranking item — for example, DESKTOP for the device ranking
item_value INT (4 bytes) No Value assigned to the ranking item
last_modified_date TIMESTAMP No Time and date that the row was last modified
person_id INT (8 bytes) No Points to an associated ranking item
person_ranking_id INT (8 bytes) Yes Points to an associated ranking item

person_ranking_summary table

Field name Data type Sortable Description
db_last_modified_date TIMESTAMP No The UTC time and date when the row was last modified in the database
column_meta_data_id INT (4 bytes) Yes Points to the column meta data associated with the ranking in Acquia Lift's records
column_meta_data_name VARCHAR (50) No Display name of the column meta data
customer_site_id INT (4 bytes) Yes Points to the customer's website in Acquia Lift's records
frequency INT (4 bytes) No Value assigned to the ranking summary (for example, the sum of the daily values for the last period)
freq_rank INT (4 bytes) No The rank, by frequency, when compared to other ranking summaries with the same person_id, customer_site_id, and column_meta_data_id
item_name VARCHAR (200) No Name of the ranking summary — for example, DESKTOP for the device ranking
last_modified_date TIMESTAMP No Time and date that the row was last modified
person_id INT (4 bytes) Yes Points to a specific person in Acquia Lift's records
site_external_id VARCHAR (20) No External identifier of the customer's website
site_name VARCHAR (50) No Name of the customer's website

Contact supportStill need assistance? Contact Acquia Support