Data warehouse Event field types

Acquia Lift data warehouse

The data warehouse uses the Event field layout to describe discrete visitor actions, such as a content view of an article or a click-through on a subscription offer. An event has a Touch record as its parent.

Events also contain information about the specific content that a visitor is consuming.

Field name Data type Description
campaign_id VARCHAR (200) Campaign ID associated with an Acquia Lift personalized event action
capture_identifier VARCHAR (22) Event identifier
content_pub_date DATE Date the content was published
content_section VARCHAR (400) Section name of the content (for example, restaurants)
content_title VARCHAR (400) Title of the content
content_type VARCHAR (200) Content type (for example, article)
content_uuid VARCHAR (1000) Unique content ID associated with a content view and a click-through event
custom_field_1 VARCHAR (200) User-defined field
custom_field_2 VARCHAR (200) User-defined field
Because this field is also used by Experience Builder for personas, we recommend that you do not use this field for your custom values.
custom_field_3 VARCHAR (200) User-defined field
custom_field_4 VARCHAR (200) User-defined field
custom_field_5 VARCHAR (200) User-defined field
custom_field_6 VARCHAR (200) User-defined field
custom_field_7 VARCHAR (200) User-defined field
custom_field_8 VARCHAR (200) User-defined field
custom_field_9 VARCHAR (200) User-defined field
custom_field_10 VARCHAR (200) User-defined field
custom_field_11 VARCHAR (200) User-defined field
custom_field_12 VARCHAR (200) User-defined field
custom_field_13 VARCHAR (200) User-defined field
custom_field_14 VARCHAR (200) User-defined field
custom_field_15 VARCHAR (200) User-defined field
custom_field_16 VARCHAR (200) User-defined field
custom_field_17 VARCHAR (200) User-defined field
custom_field_18 VARCHAR (200) User-defined field
custom_field_19 VARCHAR (200) User-defined field
custom_field_20 VARCHAR (200) User-defined field
custom_field_21 VARCHAR (200) User-defined field
custom_field_22 VARCHAR (200) User-defined field
custom_field_23 VARCHAR (200) User-defined field
custom_field_24 VARCHAR (200) User-defined field
custom_field_25 VARCHAR (200) User-defined field
custom_field_26 VARCHAR (200) User-defined field
custom_field_27 VARCHAR (200) User-defined field
custom_field_28 VARCHAR (200) User-defined field
custom_field_29 VARCHAR (200) User-defined field
custom_field_30 VARCHAR (200) User-defined field
custom_field_31 VARCHAR (200) User-defined field
custom_field_32 VARCHAR (200) User-defined field
custom_field_33 VARCHAR (200) User-defined field
custom_field_34 VARCHAR (200) User-defined field
custom_field_35 VARCHAR (200) User-defined field
custom_field_36 VARCHAR (200) User-defined field
custom_field_37 VARCHAR (200) User-defined field
custom_field_38 VARCHAR (200) User-defined field
custom_field_39 VARCHAR (200) User-defined field
custom_field_40 VARCHAR (200) User-defined field
custom_field_41 VARCHAR (200) User-defined field
custom_field_42 VARCHAR (200) User-defined field
custom_field_43 VARCHAR (200) User-defined field
custom_field_44 VARCHAR (200) User-defined field
custom_field_45 VARCHAR (200) User-defined field
custom_field_46 VARCHAR (200) User-defined field
custom_field_47 VARCHAR (200) User-defined field
custom_field_48 VARCHAR (200) User-defined field
custom_field_49 VARCHAR (200) User-defined field
custom_field_50 VARCHAR (200) User-defined field
customer_id INT (4 bytes) Internal Acquia Lift customer ID
customer_site_external_id VARCHAR (20) External identifier for customer site, indicating which website sent the capture
customer_site_id INT (4 bytes) Customer site row reference, indicating which website sent the capture
db_last_modified_date TIMESTAMP The UTC time and date when the row was last modified in the database
decision_slot_id VARCHAR (1000) Decision slot ID associated with a decision or a goal event
decision_slot_name VARCHAR (1000) Decision slot name associated with a decision or a goal event
decision_rule_id VARCHAR (1000) Decision rule ID associated with a decision or a goal event
decision_rule_name VARCHAR (1000) Decision rule name associated with a decision or a goal event
decision_content_id VARCHAR (1000) Decision content ID associated with a decision or a goal event
decision_content_name VARCHAR (1000) Decision content name associated with a decision or a goal event
decision_goal_id VARCHAR (1000) Decision goal ID associated with a decision or a goal event
decision_goal_name VARCHAR (1000) Decision goal name associated with a decision or a goal event
decision_goal_value VARCHAR (1000) Decision goal value associated with a decision or a goal event
decision_view_mode VARCHAR (1000) Decision view mode associated with a decision or a goal event
decision_policy VARCHAR (1000) Decision policy associated with a decision or a goal event
decision_rule_segment_id VARCHAR (1000) Decision rule segment ID associated with a decision or a goal event
decision_rule_segment_name VARCHAR (1000) Decision rule segment name associated with a decision or a goal event
decision_rule_type VARCHAR (1000) Decision rule type associated with a decision or a goal event
discount_code VARCHAR (200) Campaign's discount code, if applicable
engagement_score INT (4 bytes) Numeric representation of how this event describes a person's engagement with the brand — can be set as explicit value using the Acquia Lift APIs
event_category_id INT (4 bytes) Code for the event (refer to the name field for its human-readable name) — Acquia Lift internal value
event_date TIMESTAMP Event date-time
id INT (8 bytes) Unique event ID — Acquia Lift internal value
image_thumb_url VARCHAR (4000) Link to thumbnail image associated with article content
keywords VARCHAR (4000) Keywords associated with the content
last_modified_date TIMESTAMP Time and date that the row was last modified
name VARCHAR (200) Name of the event (for example, Content View)
offer_id VARCHAR (200) Offer ID for Acquia Lift personalized offer
page_type VARCHAR (200) Page type (examples include article page, tag page, and home page)
page_url VARCHAR (4000) Page URL
persona VARCHAR (4000) Personas associated with the content
person_id INT (8 bytes) Link to an existing id for a person — Acquia Lift internal value
referrer VARCHAR (4000) Referrer URL
touch_id INT (8 bytes) Link to an existing id for a touch — Acquia Lift internal value

Acquia Lift Classic values

Acquia Lift Classic also uses the following values, in place of the various Decision values used by current versions of Acquia Lift.

Field name Data type Description
target_action_name VARCHAR (200) Variation set name associated with the event, for campaign and conversion events
target_campaign_id VARCHAR (200) Campaign ID associated with the event, for campaign and conversion events
target_campaign_name VARCHAR (200) Campaign name associated with the event, for campaign and conversion events
target_goal_value VARCHAR (200) Goal value associated with the event, for conversion events
target_offer_id VARCHAR (200) Variation set ID associated with the event, for campaign and conversion events

Contact supportStill need assistance? Contact Acquia Support