---
title: Manage data exports
slug: l9fb0345
canonical_url: https://docs.coveo.com/en/l9fb0345/
collection: coveo-analytics
source_format: adoc
---
# Manage data exports
The [**Data Exports**](https://platform.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) ([platform-ca](https://platform-ca.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-eu](https://platform-eu.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-au](https://platform-au.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/)) feature in the [Coveo Administration Console](https://docs.coveo.com/en/183/) is a helpful tool that lets you extract your [Coveo Analytics data](https://docs.coveo.com/en/259/) to CSV files.
This enables you to perform custom analysis, merge your data with other datasets, or archive it for future reference.
With the [required privileges](#required-privileges), you can [create data exports](#add-or-recreate-an-export) as needed or [create a schedule](#add-or-edit-an-export-schedule) for when you want exports to be automatically generated.

The **Past exports** subtab presents the data export management activities in reverse chronological order (newest activities at the top), where each row represents an export.
You can download your exports to CSV files, provided that the **Status** of the export is set to **Available**.

> **Important**
>
> An export expires 30 days after it's created, and the status is set to **Expired**.
> Although you can't download an expired export, you can use it to [recreate a new one](#add-or-recreate-an-export).
> 
> After 60 days, the export is automatically deleted and removed from the **Past exports** subtab.

## Add or recreate an export

. Access the [**Data Exports**](https://platform.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) ([platform-ca](https://platform-ca.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-eu](https://platform-eu.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-au](https://platform-au.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/)) tab.

![Data Exports tab | Coveo](https://docs.coveo.com/en/assets/images/coveo-analytics/raw-data-past-exports-tab.png)

. In the **Past exports** subtab, do one of the following:

* To add a new export, click **Create CSV export**.

* To recreate an export, click the applicable export, and then click **Recreate a data export** in the Action bar.

> **Notes**
>
> * The **Recreate a data export** option is clickable when you're within your [Coveo organization](https://docs.coveo.com/en/185/) [export limit](https://docs.coveo.com/en/1937#other-limits).
> 
> * If you plan to create the same export several times, [add an export schedule](#add-or-edit-an-export-schedule) instead.

. In the **Add/Recreate a data export** panel that opens, click the date picker to access the report period dialog, and then select the date range you want to review.

. Click icon:filter-add-2[alt=filter-add-2,width=16] to access the dialog to [add global dimension filters](https://docs.coveo.com/en/1675/), and then create one or more filters to scope the exported data.

. Under **Content to export**, choose the type of data to export by selecting one or more of the corresponding checkboxes.

* You can further scope the content to export by selecting or deselecting the relevant dimensions located under the **Filter dimensions to export** section.

> **Notes**
>
> * You can use the **Origin** dropdown menu to find the dimensions you're looking for.
> 
> * Not all dimensions can be exported.
> 
> * In each CSV file contained in the export, each selected dimension appears in a single column.

* In the **Option** section, select the **Use dimension display name** checkbox if you want the export to show the same dimension names as they appear in [Coveo Analytics reports](https://docs.coveo.com/en/266/), for example, **Origin 1 (Page/Hub)**.

> **Note**
>
> By default, exports show the dimension API names (for example, `originLevel1`).

. Click **Add data export**.

The export appears at the top of the **Data Exports** tab table.

> **Notes**
>
> * When you recreate an export, a new export is generated, meaning the original export is still available.
> 
> * If your export exceeds the [row limit](https://docs.coveo.com/en/1937#other-limits), you'll be alerted with an error message, and the export won't appear on the **Data Exports** tab table.
> In this case, narrow your export by adjusting the report period or the content to export.

### Download an export

. Access the [**Data Exports**](https://platform.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) ([platform-ca](https://platform-ca.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-eu](https://platform-eu.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-au](https://platform-au.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/)) tab.

. In the **Past exports** subtab, click the export that you want to review, and then click **Download** in the Action bar to download the ZIP file on your device.

[NOTES]
**Notes**
#### * By default, the exported analytics database contains [five tables](#data-export-tables).

* Export data shows timestamps in GMT.

* You can't download an expired or a failed export.
#### See [Data export tables](#data-export-tables) for details about the data export content in the CSV file.

### Delete an export

. Access the [**Data Exports**](https://platform.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) ([platform-ca](https://platform-ca.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-eu](https://platform-eu.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-au](https://platform-au.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/)) tab.

. In the **Past exports** subtab, click the export that you want to delete, and then click **Delete** in the Action bar.

. In the confirmation prompt that appears, click **Delete**.

## Add or edit an export schedule

. Access the [**Data Exports**](https://platform.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) ([platform-ca](https://platform-ca.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-eu](https://platform-eu.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-au](https://platform-au.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/)) tab.

. In the **Schedules** subtab, do one of the following:

* To add a new schedule, click **Create schedule**.

> **Note**
>
> Your Coveo organization is limited on the number of exports allowed.
> When you see the following Status: `The export limit is exceeded for your account.`, delete existing exports or contact [Coveo Support](https://connect.coveo.com/s/case/Case/Default) to upgrade your limit.

* To edit an existing schedule, click the applicable schedule and then click **Edit** in the Action bar.

. In the **Add/Edit a schedule** panel that opens, under the **Recurrence** section, select the rate at which exports are created between the following values: **Daily**, **Weekly**, or **Monthly**.

> **Notes**
>
> * Exports are added at the end of the period referred by the selected recurrence.
> For example, when you select **Daily**, exports are added after midnight of each day.
> 
> * An export scheduled with a recurrence counts as a new export every time it runs.
> For example, when you select **Daily**, the export added after midnight is considered a new export.
> 
> * A maximum of three exports are kept per schedule.
> The oldest export is automatically deleted when the maximum is reached.

![Data Export Schedule Panel | Coveo](https://docs.coveo.com/en/assets/images/coveo-analytics/data-export-schedule.png)

. Click icon:filter-add-2[alt=filter-add-2,width=16] to access the dialog to [add global dimension filters](https://docs.coveo.com/en/1675/), and then create one or more dimension filters to scope the exported data.

. Under the **Content to export** section, choose the type of data to export by selecting one or more of the corresponding checkboxes.

* You can further scope the content to export by selecting or deselecting the relevant dimensions under the **Filter Dimensions to Export** section.

> **Notes**
>
> * You can use the **Filter** box or the **Origin** dropdown menu to find the dimensions you're looking for.
> 
> * By default, all dimensions are selected.
> 
> * Not all dimensions can be exported.
> 
> * In each CSV file contained in the export, each selected dimension appears in a single column.

. Under **Option**, select the **Use dimension display name** checkbox, when you want the export to show the same dimension names as they appear in Coveo Analytics reports, for example, **Origin 1 (Page/Hub)**.

> **Note**
>
> By default, exports show the dimension API names.
> 
> For example, `originLevel1`.

. Click **Add schedule** or **Save**.

### Review exports created by a schedule

. Access the [**Data Exports**](https://platform.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) ([platform-ca](https://platform-ca.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-eu](https://platform-eu.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-au](https://platform-au.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/)) tab.

. In the **Schedules** subtab, click the desired schedule, and then click **View Exports** in the Action bar.

. In the **View exports from schedule** panel, you can perform the same actions as in the **Past exports** section, such as downloading, recreating, and deleting exports.

### Download the last export created by a schedule

. Access the [**Data Exports**](https://platform.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) ([platform-ca](https://platform-ca.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-eu](https://platform-eu.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-au](https://platform-au.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/)) tab.

. In the **Schedules** subtab, click a schedule, and then click **Download last export** in the Action bar.

### Delete a schedule

. Access the [**Data Exports**](https://platform.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) ([platform-ca](https://platform-ca.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-eu](https://platform-eu.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/) | [platform-au](https://platform-au.cloud.coveo.com/admin/#/orgid/usage/raw-data/data-exports/)) tab.

. In the **Schedules** subtab, click the schedule you want to remove, and then click **Delete** in the Action bar.

. In the confirmation prompt that appears, click **Delete**.

## Data export tables

The five tables in the CSV files contain columns titled with the API names of the dimensions you use in reports.
Therefore, knowing which API name refers to which dimension can be difficult.
The following tables list the API names and the actual dimensions they refer to in alphabetical order.

In addition to these default columns, any created [dimension](https://docs.coveo.com/en/258/) has its own column (see [Manage dimensions on custom metadata](https://docs.coveo.com/en/1522/)).

### `click` table

[options="header"]
|===
|API name |Dimension
|`anonymous`
|Is Anonymous
|`cause`
|Click Cause
|`c_facettitle`
|Facet Title
|`c_facetvalue`
|Facet Value
|`city`
|City
|`clickId`
|N/A

This column contains the unique ID for each click event.

|`clickRank`
|Click Rank
|`collectionName`
|Collection Name
|`country`
|Country
|`customDatas`
|N/A

This column contains all custom dimensions and their value, displayed in the following format and separated by comma: `"customDimensionName":"customDimensionValue"`

|`datetime`
|Click Date Time
|`device`
|Device
|`deviceCategory`
|Device Category
|`documentTitle`
|Document Title
|`documentUrl`
|Document URL
|`language`
|Language
|`mobile`
|Is Mobile (deprecated)
|`originContext`
|Origin Context
|`queryPipeline`
|Query Pipeline
|`region`
|Region
|`searchId`
|N/A

The `searchId` is used in tables as the link between clicks and searches, keywords and searches, and groups and searches.

|`sourceName`
|Source Name
|`systemUriHash`
|Search Result (see Search result (formerly Document))
|`userId`
|User ID
|`username`
|User Name
|`visitId`
|Visit ID
|`visitorId`
|Visitor ID
|===

### `searches` table

[options="header"]
|===
|API name |Dimension
|`advancedQueryExpression`
|Advanced Query Expression
|`anonymous`
|Is Anonymous
|`batchId`
|N/A

Values in this column are destined for future use.

|`cause`
|Search Cause
|`city`
|City
|`country`
|Country
|`datetime`
|Search Date Time
|`device`
|Device (deprecated)
|`deviceCategory`
|Device Category
|`c_facettitle`
|Facet Title
|`c_facetvalue`
|Facet Value
|`id`
|N/A

The `searchId` is used in tables as the link between clicks and searches, keywords and searches, and groups and searches.

|`language`
|Language
|`mobile`
|Is Mobile
|`numberOfResults`
|Number of Results
|`originContext`
|Origin Context
|`pageNumber`
|Page Number
|`pageSize`
|N/A

Values in this column are destined for future use.

|`queryExpression`
|Query
|`queryPipeline`
|Query Pipeline
|`region`
|Region
|`responseTimeMS`
|N/A

This column contains the time taken by each query to return.

|`searchOriginLevel1`
|Origin 1 (Page/Hub)
|`searchOriginLevel2`
|Origin 2 (Tab)
|`searchOriginLevel3`
|Origin 3 (Referrer)
|`userAgent`
|User Agent
|`userId`
|User ID
|`username`
|User Name
|`visitId`
|Visit ID
|`visitorId`
|Visitor ID
|`withClicks`
|Has Clicks
|`withResults`
|Has Results
|===

### `custom_events` table

The `custom_events` table is a special one that contains the non-search and non-click events in the system.
Two different IDs can be used to create a relation between the custom events and the other tables:

* The `visitId` can be used to relate a custom event with all queries and clicks in the same visit (for example, all the queries that preceded a **Case Deflection** event in a user visit on your community site).

* The `lastSearchId` contains the query (if any) that immediately preceded the custom event.
Therefore, it's possible to do a relation between a custom event and the last query done by the user who triggered the custom event.

[options="header"]
|===
|API name |Dimension
|`anonymous`
|Is Anonymous
|`city`
|City
|`country`
|Country
|`customEventId`
|N/A

This column contains the unique ID for each custom event.

|`dateTime`
|Custom Event Date Time
|`device`
|Device
|`deviceCategory`
|Device Category
|`eventType`
|Event Type
|`customEventValue`
|Event Value
|`c_facettitle`
|Facet Title
|`c_facetvalue`
|Facet Value
|`language`
|Language
|`lastSearchId`
|N/A

The `lastSearchId` contains the query (if any) that immediately preceded the custom event. `lastSearchId` is used as a link between a custom event and the last query done by the user who triggered the custom event.

|`mobile`
|Is Mobile
|`originContext`
|Origin Context
|`region`
|Region
|`userId`
|User ID
|`userName`
|User Name
|`visitId`
|Visit ID
|`visitorId`
|Visitor ID
|===

### `keywords` table

[options="header"]
|===
|API name |Dimension
|`keyword`
|Keyword
|`searchId`
|N/A

The `searchId` is used in tables as the link between clicks and searches, keywords and searches, and groups and searches.
|===

### `groups` table

[options="header"]
|===
|API name |Dimension
|`groupName`
|Group
|`searchId`
|N/A

The `searchId` is used in tables as the link between clicks and searches, keywords and searches, and groups and searches.
|===

## Required privileges

The following table indicates the required privileges to view and edit the elements of the [**Raw Data**](https://platform.cloud.coveo.com/admin/#/orgid/usage/raw-data/) ([platform-ca](https://platform-ca.cloud.coveo.com/admin/#/orgid/usage/raw-data/) | [platform-eu](https://platform-eu.cloud.coveo.com/admin/#/orgid/usage/raw-data/) | [platform-au](https://platform-au.cloud.coveo.com/admin/#/orgid/usage/raw-data/)) page and associated panels (see [Manage privileges](https://docs.coveo.com/en/3151/) and [Privilege reference](https://docs.coveo.com/en/1707/)).

[cols="3",options="header"]
|===
|Action
|Service - Domain
|Required access level

|View data exports
|Analytics - Analytics data  
Analytics - Dimensions  
Analytics - Data exports  
Analytics - Named filters  
Analytics - Permission filters  
Organization - Organization
|View

.3+|Manage data exports
|Analytics - Dimensions  
Analytics - Named filters  
Analytics - Permission filters  
Organization - Groups  
Organization - Organization
|View

|Analytics - Analytics data
|Push

|Analytics - Data exports
|Edit
|===