Manage data exports

This is for:

In this article

Add or edit an export
Download an export
Delete an export
Review past exports
Add a schedule for exports
Review exports created by a schedule
Download the last export created by a schedule
Delete a schedule
Reference
Required privileges

In the Data Exports (platform-ca | platform-eu | Data platform-au) tab of the Coveo Administration Console, you can extract and download your UA data to a CSV file for further analysis.

Add or edit an export

In the Data Exports (platform-ca | platform-eu | Data platform-au) tab, do one of the following to access the Add/Recreate a Data Export panel:

To create a new export, click Create CSV Export.
To use an existing export as a starting point, click the export, and then click Recreate a Data Export in the Action bar.

Notes

If the Create CSV Export button is grayed out and unresponsive, you don’t have all the required privileges to perform this action.
The Recreate a Data Export option is clickable when the export status is Available and when your Coveo organization export limit isn’t exceeded.
Export data shows timestamps in GMT.
If you plan to create the same export several times, we recommend that you add a schedule for exports instead.

Set report period

In the Add/Recreate a Data Export panel, click the date range to access the Report Period dialog, and then select the date range you want to review.

Note

You can select a period that’s incomplete (for example, the current month), in which case your date range selection will always include the latest available events until the period ends (for example, the first day of the following month).

For example, you’re reviewing data per Month and want to see how statistics are trending for the first two weeks of the current month, therefore you click .

Add global dimension filters

Click to access the dialog to add global dimension filters, and then create one or more dimension filters to scope the exported data.

Example

You want to export all events (searches, clicks, custom, keywords, groups) that happened in Canada that aren’t Page Views (logged each time a visitor views a page on your website), so you add the following filters:

Country is Canada

Custom Event Value is not PageView

"Content to Export" section

Under Content to export, choose the type of usage analytics data to export by selecting one or more of the following checkboxes:

<n> Searches
<n> Clicks
<n> Custom events
<n> Groups
<n> Keywords.

where <n> represents the number of each event to be exported for the selected report period and applied filters.

The export ZIP file contains one CSV file per selected option.

"Option" section

Select the Use dimension display name checkbox if you want the export to show the same dimension names as they appear in UA reports, for example, Origin 1 (Page/Hub).

Note

By default, exports show the dimension API names.

For example, originLevel1.

"Filter Dimensions to Export" section

In the right section of the panel, expand the Filter Dimensions to Export section, and then ensure that all relevant dimensions are selected.

Notes

You can use the Filter box or 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.

Complete export

When you’re done adding or editing the export, click Add data export.

The export appears in the Data Exports tab table.

Notes

When you create an export starting from an existing one, a new export is generated, meaning the original export is still available.
If your export exceed the row limit, you will be alerted with an error message, and the export won’t appear in the Data Exports tab table. We recommend narrowing your export by adjusting the report period or the "Content to Export" section.

Download an export

By default, the exported analytics database contains five tables.

In the Data Exports (platform-ca | platform-eu | Data platform-au) tab, in the list of exports, click the export that you want to review, and then click Download in the Action bar to download the ZIP file on your computer.
In the Are you sure dialog, click Confirm.

Note

You can’t download an expired or a failed export.

Delete an export

In the Data Exports (platform-ca | platform-eu | Data platform-au) tab, in the Past exports section, click the export that you want to delete, and then click Delete in the Action bar.
In the confirmation prompt that appears, click Delete.

Review past exports

The Past Exports section of the Data Exports (platform-ca | platform-eu | Data platform-au) tab presents the data export management activities in reverse chronological order. Each row represents an export, indicating the following export details:

Set period
Applied filter(s) (if any)
Creation date
Author
Status
Size

An export expires 30 days after it’s created and the status is shown as Expired. Although you can’t download an expired export, you can use it to recreate a new one.

After 60 days, the export is automatically deleted and removed from the Past Exports section.

Add a schedule for exports

In the Data Exports (platform-ca | platform-eu | Data platform-au) tab, select Schedules.
In the Schedules section, do one of the following:
- Click Create Schedule.
- Click a schedule to use as a starting point, and then click More > Edit in the Action bar.

Notes

If the Create Schedule button is grayed out and unresponsive, you don’t have all of the required privileges to perform this action.
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 to upgrade your limit.

Recurrence

In the Recurrence section of the Add/Edit a Schedule panel, 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.