Data constraints and usage quotas

This is for:

Business Analyst System Administrator

This article lists the constraints and quotas that apply to Coveo Analytics. These can be defined by either the Coveo Platform itself or by your license. To modify your license, contact Coveo.

Dimensions and maximum value length

Each dimension (default or custom) has its own column in the database. Each column supports a specific data type and, when applicable, a maximum value length. The following table displays the dimensions, their respective data type, as well as the maximum number of characters it supports.

Column name DB data type (maximum number 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_level_3

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

Additional system constraints

The following constraints apply to Coveo Analytics usage.

Constraint Value

Maximum query execution time for reports

Two minutes. To improve report loading time, see Leading practices.

Maximum number of rows per data export

Ten million. To improve export performance, see Manage data exports.