--- schema_version: "1" id: c9ed3a6ed0217e55e8f82be7782ef66288e25a5a1023a0443ec9059160c7250f title: ccdw_aggr_visit_referrer collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_ccdw_aggr_visit_referrer.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_visit_referrer.html source_site: developer.salesforce.com content_type: documentation content_hash: 0a0240ff29b976e75c3b7b3b8e2f3d41730a9542755423fc63a29a763c53bb2a products: - Composable Storefront - Salesforce APIs --- # ccdw_aggr_visit_referrer This table summarizes visits by referrer information. > **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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_site.md). | No | | `registered` | BOOLEAN | | Boolean indicating if the visitor was registered. | No | | `device_class_code` | VARCHAR | **FK** | Device class code from [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md). | No | | `locale_code` | VARCHAR | **FK** | Locale code from [`ccdw_dim_locale`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_locale.md). | 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 |