---
title: Limits
slug: '1937'
canonical_url: https://docs.coveo.com/en/1937/
collection: coveo-analytics
source_format: adoc
---
# Limits
This article lists the Coveo Analytics limits within Coveo that either come from the [Coveo Platform](https://docs.coveo.com/en/186/) itself or your license.
[Contact Coveo](https://www.coveo.com/en/company/contact-us) when you want to extend your license [limits](https://docs.coveo.com/en/262/).


## Dimensions and the maximum length of their logged values

Each dimension (custom and default) has its own column in the database.
Each column can only contain values of a certain type and a certain length depending on the dimension.
The following table displays the column name and the [DB data type](http://docs.aws.amazon.com/redshift/latest/dg/c_Supported_data_types.html) as well as the limit of characters the column can contain when applicable.

[%header,cols="~,~"]
|===
|Column name
|DB data type (Limit of characters)

|`account_id`
|varchar(128)

|`advanced_query_expression`
|varchar(2048)

|`batch_id`
|char(36)

|`cause`
|varchar(64)

|`cause2`
|varchar(64)

|`client_id`
|UUID(128)

|`custom_datas`
|varchar(32500)

|[`Custom dimension (Boolean) name`]
|Boolean

|[`Custom dimension (datetime) name`]
|timestamp

|[`Custom dimension (number) name`]
|float8

|[`Custom dimension (text) name`]
|varchar(256)

|`datetime`
|timestamp

|`device_category`
|varchar(128)

|`document_author`
|varchar(128)

|`document_category`
|varchar(128)

|`document_title`
|varchar(128)

|`event_outcome`
|integer

|`is_anonymous`
|Boolean

|`is_contextual`
|Boolean

|`is_internal`
|Boolean

|`number_of_results`
|integer

|`operating_system`
|varchar(128)

|`operating_system_with_version`
|varchar(128)

|`origin_device`
|varchar(256)

|`origin_city`
|varchar(256)

|`origin_context`
|varchar(128)

|`origin_country`
|varchar(256)

|`origin_is_mobile`
|Boolean

|`origin_language`
|varchar(256)

|`origin_level_1`
|varchar(128)

|`origin_level_2`
|varchar(128)

|`origin_levelv3`
|varchar(1024)

|`origin_region`
|varchar(256)

|`query_expression`
|varchar(500)

|`query_pipeline`
|varchar(128)

|`response_time_ms`
|integer

|`search_id`
|char(36)

|`split_test_run_name`
|varchar(128)

|`split_test_run_version`
|varchar(128)

|`unique_user_id`
|varchar(128)

|`user_agent`
|varchar(1024)

|`user_id`
|varchar(128)

|`user_ip`
|varchar(50)

|`user_name`
|varchar(128)

|`visit_id`
|char(36)

|`visitor_id`
|varchar(128)

|`web_browser`
|varchar(128)

|`web_browser_with_version`
|varchar(128)

|`with_clicks`
|Boolean

|`with_results`
|Boolean
|===

## Other limits

The following additional limit also applies:

[%header,cols="~,~"]
|===
|Limit
|Value

|Maximum amount of time for queries to execute on a report
|Two minutes. For information on how to improve report loading time, see [Leading practices](https://docs.coveo.com/en/1542#leading-practices).

|Maximum amount of rows on a data export
|Ten million. For information on how to manage exports, see [Manage data exports](https://docs.coveo.com/en/l9fb0345/).
|===