# GoHighLevel datasets and fields

> The 6 datasets Maven lands from GoHighLevel, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/gohighlevel

Maven lands 6 datasets from GoHighLevel in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the [GoHighLevel integration page](https://mavendata.ai/integrations/gohighlevel).

## Connection and sync

You connect GoHighLevel with API credentials from the GoHighLevel account. Maven stores them encrypted.

Each GoHighLevel sync takes a fresh copy of the current records, so the workspace always reflects what is in GoHighLevel now.

## Datasets

### Locations

GHL location detail.

| Field | Type |
| --- | --- |
| ghlcrm location ID | Text |
| name | Text |
| address | Text |
| city | Text |
| state | Text |
| country | Text |
| postal code | Text |
| timezone | Text |
| business email | Text |
| business phone | Text |
| website | Text |
| currency | Text |
| company ID | Text |
| created at | Timestamp |
| updated at | Timestamp |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| location ID | Text |

### Contacts

CRM contacts (leads + customers) — email, phone, source, tags, owner.

| Field | Type |
| --- | --- |
| ghlcrm contact ID | Text |
| email | Text |
| phone | Text |
| first name | Text |
| last name | Text |
| full name | Text |
| company name | Text |
| source | Text |
| tags | Text |
| assigned to | Text |
| type | Text |
| address | Text |
| city | Text |
| state | Text |
| country | Text |
| postal code | Text |
| website | Text |
| last activity at | Timestamp |
| dnd | True/false |
| dnd settings | Text |
| first attribution URL | Text |
| first attribution campaign | Text |
| first attribution UTM source | Text |
| first attribution UTM medium | Text |
| first attribution UTM content | Text |
| first attribution referrer | Text |
| first attribution campaign ID | Text |
| first attribution gclid | Text |
| first attribution fbclid | Text |
| first attribution msclkid | Text |
| first attribution medium | Text |
| first attribution medium ID | Text |
| last attribution URL | Text |
| last attribution campaign | Text |
| last attribution UTM source | Text |
| last attribution UTM medium | Text |
| last attribution UTM content | Text |
| last attribution referrer | Text |
| last attribution campaign ID | Text |
| last attribution gclid | Text |
| last attribution fbclid | Text |
| last attribution msclkid | Text |
| last attribution medium | Text |
| last attribution medium ID | Text |
| created at | Timestamp |
| updated at | Timestamp |
| custom fields | Text |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| location ID | Text |

### Opportunities

Sales opportunities — pipeline, stage, status, monetary value, assignee.

| Field | Type |
| --- | --- |
| ghlcrm opportunity ID | Text |
| contact ID | Text |
| pipeline ID | Text |
| pipeline stage ID | Text |
| name | Text |
| status | Text |
| monetary value | Number |
| assigned to | Text |
| source | Text |
| lost reason ID | Text |
| last status change at | Timestamp |
| last stage change at | Timestamp |
| last action at | Timestamp |
| forecast expected close date | Date |
| forecast original close date | Date |
| forecast slippage count | Integer |
| forecast days slipped | Integer |
| forecast last slipped at | Timestamp |
| forecast probability | Number |
| effective probability | Number |
| followers | Text |
| external object ID | Text |
| created at | Timestamp |
| updated at | Timestamp |
| custom fields | Text |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| location ID | Text |

### Pipelines

Opportunity pipelines + stages flattened.

| Field | Type |
| --- | --- |
| pipeline stage key | Text |
| pipeline ID | Text |
| pipeline name | Text |
| stage ID | Text |
| stage name | Text |
| stage position | Integer |
| show in funnel | True/false |
| show in pie chart | True/false |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| location ID | Text |

### Campaigns

Marketing campaigns (email + SMS + automation) — dimension only.

| Field | Type |
| --- | --- |
| campaign ID | Text |
| name | Text |
| status | Text |
| type | Text |
| created at | Timestamp |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| location ID | Text |

### Users

Location users and owners used to resolve CRM assignee labels.

| Field | Type |
| --- | --- |
| ghlcrm user ID | Text |
| name | Text |
| first name | Text |
| last name | Text |
| email | Text |
| phone | Text |
| role | Text |
| user type | Text |
| is deleted | True/false |
| platform language | Text |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| location ID | Text |
