> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# utm_parameters table

> Table for utm parameters collected from visits and formsubmissions

## utm\_parameters Table (548)

Table for utm parameters collected from visits and formsubmissions

## Fields

| Name                       | Description                           | Type                                         | Nullable |
| -------------------------- | ------------------------------------- | -------------------------------------------- | :------: |
| utm\_parameters\_id        | Primary key                           | PK                                           |    No    |
| created\_person\_id        | Id of the created person              | FK [person](./person.mdx)                    |    Yes   |
| created\_contact\_id       | Id of the created contact             | FK [contact](./contact.mdx)                  |    Yes   |
| form\_submission\_id       | Id of formsubmission                  | FK [form\_submission](./form-submission.mdx) |    Yes   |
| firsttouch\_source         | First touch UTM Source                | String(255)                                  |    Yes   |
| firsttouch\_medium         | First touch UTM Medium                | String(255)                                  |    Yes   |
| firsttouch\_campaign       | First touch UTM Campaign              | String(255)                                  |    Yes   |
| firsttouch\_term           | First touch UTM Term                  | String(255)                                  |    Yes   |
| firsttouch\_content        | First touch UTM Content               | String(255)                                  |    Yes   |
| firsttouch\_referrerdomain | First touch referrer domain           | String(255)                                  |    Yes   |
| firsttouch\_when           | First touch date                      | DateTime                                     |    Yes   |
| source                     | UTM Source                            | String(255)                                  |    Yes   |
| medium                     | UTM Medium                            | String(255)                                  |    Yes   |
| campaign                   | UTM Campaign                          | String(255)                                  |    Yes   |
| term                       | UTM Term                              | String(255)                                  |    Yes   |
| content                    | UTM Content                           | String(255)                                  |    Yes   |
| referrerdomain             | Referrer domain                       | String(255)                                  |    Yes   |
| when                       | Date of the visit or form submission  | DateTime                                     |    Yes   |
| registered                 | Registered when                       | UtcDateTime                                  |    No    |
| registered\_associate\_id  | Registered by whom                    | FK [associate](./associate.mdx)              |    No    |
| updated                    | Last updated when                     | UtcDateTime                                  |    No    |
| updated\_associate\_id     | Last updated by whom                  | FK [associate](./associate.mdx)              |    No    |
| updatedCount               | Number of updates made to this record | UShort                                       |    No    |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/utm_parameters.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=d0288eefb51e44dbf82b2289b0aebe35" alt="utm_parameters table relationship diagram" width="827" height="793" data-path="media/loc/en/database/tables/utm_parameters.png" />

## Indexes

| Fields               | Types | Description |
| -------------------- | ----- | ----------- |
| created\_person\_id  | FK    | Index       |
| created\_contact\_id | FK    | Index       |
| form\_submission\_id | FK    | Index       |

## Relationships

| Table                                 | Description                                                        |
| ------------------------------------- | ------------------------------------------------------------------ |
| [associate](./associate)              | Employees, resources and other users - except for External persons |
| [contact](./contact)                  | Companies and Organizations.                                       |
| [form\_submission](./form-submission) | A form submission                                                  |
| [person](./person)                    | Persons                                                            |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [form_submission table](/en/database/tables/form-submission.md)
- [contact table](/en/database/tables/contact.md)
- [person table](/en/database/tables/person.md)
- [associate table](/en/database/tables/associate.md)
- [SuperOffice.WebApi.Data.UtmParameters](/en/api/reference/webapi/SuperOffice.WebApi.Data.UtmParameters.md)
- [Get Utm Parameters](/en/api/reference/restful/rest/person/get-utm-parameters.md)