# ccdw_dim_traffic_source

This table describes attributed external traffic sources.

| Column Alias             | Data Type | Key    | Description                                             | Index? |
| ------------------------ | --------- | ------ | ------------------------------------------------------- | ------ |
| `traffic_source_id (PK)` | SMALLINT  | **PK** | Unique identifier for a traffic source.                 | Yes    |
| `source`                 | VARCHAR   |        | The traffic source (for example, "google", "facebook"). | No     |
| `medium`                 | VARCHAR   |        | The traffic medium (for example, "organic", "paid").    | No     |
| `channel_type`           | VARCHAR   |        | The channel classification for the traffic source.      | No     |