ccdw_aggr_visit_checkout

This table summarizes visitor progression through checkout steps.

Column AliasData TypeKeyDescriptionIndex?
visit_dateDATEDate of the visit.No
site_idSMALLINTFKForeign key to ccdw_dim_site.No
registeredBOOLEANBoolean indicating if the visitor was registered.No
device_class_codeVARCHARFKDevice class code from ccdw_dim_user_agent.No
locale_codeVARCHARFKLocale code from ccdw_dim_locale.No
step_numberINTEGERThe numerical order of the checkout step.No
step_nameVARCHARName of the checkout step.No
num_hitsINTEGERNumber of hits on this checkout step.No
num_visitsINTEGERNumber of visits that reached this checkout step.No