# Google Analytics 4 schema ERD

Table and field reference for the Fivetran Google Analytics 4 connector.

## Table & Field Reference

### accounts

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| create_time | Instant |  |
| display_name | String |  |
| region_code | String |  |
| update_time | Instant |  |

### custom_dimensions

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| description | String |  |
| disallow_ads_personalization | Boolean |  |
| display_name | String |  |
| parameter_name | String |  |
| scope | String |  |

### properties

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| account | String |  |
| create_time | Instant |  |
| currency_code | String |  |
| delete_time | Instant |  |
| display_name | String |  |
| expire_time | Instant |  |
| industry_category | String |  |
| parent | String |  |
| property_type | String |  |
| service_level | String |  |
| time_zone | String |  |
| update_time | Instant |  |

### google_ads_links

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| ads_personalization_enabled | Boolean |  |
| can_manage_clients | Boolean |  |
| create_time | Instant |  |
| creator_email_address | String |  |
| customer_id | String |  |
| update_time | Instant |  |

### conversion_events

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| create_time | Instant |  |
| custom | Boolean |  |
| deletable | Boolean |  |
| event_name | String |  |

### custom_metrics

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| description | String |  |
| display_name | String |  |
| measurement_unit | String |  |
| parameter_name | String |  |
| restricted_metric_type | Json |  |
| scope | String |  |