ccdw_aggr_visit_referrer
This table summarizes visits by referrer information.
| 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 |
referrer_medium | VARCHAR | The medium of the referrer (for example, "organic", "paid"). | No | |
referrer_source | VARCHAR | The source of the referrer (for example, "google", "facebook"). | No | |
num_visits | INTEGER | Total number of visits from this referrer. | No |