# Sites: Matomo Matomo Sites Manager Sites ## Documentation Every site (website or app) this Matomo instance tracks - the top-level unit every reporting and tracking call is scoped to. - Catalog: `Matomo` - Schema: `SitesManager` - Primary Keys: `idsite` - Label: Matomo Sites Manager Sites Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Sites` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `currency` | `varchar2` | | ☐ | Three-letter currency code used for the site's e-commerce reports. | | `ecommerce` | `int32` | | ☐ | 1 if e-commerce tracking is enabled for the site, 0 otherwise. | | `idsite` | `int32` | | ☑ | Site ID: the value the id_site parameter of every reporting table refers to. Assigned by Matomo when the site is created, and never written. | | `main_url` | `varchar2` | | ☐ | Primary URL of the site. Written as a single URL. | | `name` | `varchar2` | | ☑ | Site name. Matomo's own parameter is called 'siteName' on insert and update; exposed here under the plainer name every other table already uses for its label column. | | `timezone` | `varchar2` | | ☐ | Timezone the site's reports are computed in, for instance 'UTC' or 'Europe/Amsterdam'. | | `ts_created` | `varchar2` | | ☐ | Date and time the site was created, as returned by Matomo. Matomo does not document which time zone this is expressed in. |