ccdw_aggr_visit_checkout
This table summarizes visitor progression through checkout steps.
Column Alias | Data Type | Key | Description | Index? |
---|---|---|---|---|
visit_date | DATE | Date of the visit. | No | |
site_id | SMALLINT | FK | Foreign key to ccdw_dim_site . | No |
registered | BOOLEAN | Boolean indicating if the visitor was registered. | No | |
device_class_code | VARCHAR | FK | Device class code from ccdw_dim_user_agent . | No |
locale_code | VARCHAR | FK | Locale code from ccdw_dim_locale . | No |
step_number | INTEGER | The numerical order of the checkout step. | No | |
step_name | VARCHAR | Name of the checkout step. | No | |
num_hits | INTEGER | Number of hits on this checkout step. | No | |
num_visits | INTEGER | Number of visits that reached this checkout step. | No |