This table summarizes visitor progression through checkout steps.
Note: This table is constrained by IP Address Filters configured in Business Manager.
| 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 |