> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/google-analytics-bigquery/google-analytics-bigquery-supported-columns.md).

# Google Analytics (BigQuery) - Supported Columns

Every column the Google Analytics (BigQuery) connector can download.

These are the columns available to a Google Analytics (BigQuery) connector. The recommended template uses a small subset, listed on the [Google Analytics (BigQuery)](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/google-analytics-bigquery.md) page. The rest can be added to a connector through the Advanced Editor, which stops that connector receiving template updates.

## Dimensions

| Column            | Type     |
| ----------------- | -------- |
| `date`            | DateTime |
| `timestamp`       | DateTime |
| `clientId`        | String   |
| `deviceCategory`  | String   |
| `country`         | String   |
| `hostname`        | String   |
| `landingPage`     | String   |
| `webSource`       | String   |
| `webMedium`       | String   |
| `webCampaign`     | String   |
| `webAdGroup`      | String   |
| `term`            | String   |
| `gclid`           | String   |
| `session_engaged` | String   |
| `sessionId`       | Long     |
| `webId`           | String   |
| `keyword`         | String   |
| `event_name`      | String   |
| `date`            | DateTime |
| `clientId`        | String   |
| `event_name`      | String   |
| `sessionId`       | Long     |
| `hostname`        | String   |
| `webId`           | String   |
| `conversionType`  | String   |

## Metrics

| Column            | Type    |
| ----------------- | ------- |
| `pageViews`       | Int     |
| `hits`            | Int     |
| `conversions`     | Int     |
| `conversionValue` | Decimal |
| `bounces`         | Int     |
| `sessions`        | Int     |
| `sessions`        | Int     |
| `conversions`     | Int     |
| `conversionValue` | Decimal |

## Other columns

| Column          | Type |
| --------------- | ---- |
| `n_session_row` | Int  |