ccdw_aggr_promotion_activation

This table summarizes promotion activation metrics.

Column AliasData TypeKeyDescriptionIndex?
activation_dateDATEDate of promotion activation.No
site_idSMALLINTFKForeign key to ccdw_dim_site.No
device_class_codeVARCHARDevice class code from ccdw_dim_user_agent.No
registeredBOOLEANBoolean indicating if the user was registered.No
locale_codeVARCHARLocale code from ccdw_dim_locale.No
promotion_idINTEGERFKForeign key to ccdw_dim_promotion.No
campaign_idINTEGERFKForeign key to ccdw_dim_campaign.No
num_visitsINTEGERNumber of visits associated with the promotion activation.No
num_activationsINTEGERTotal number of promotion activations.No