Exporting data from CREMA

Key Summary

• You can export both Reviews data and Products data from the CREMA database as a CSV file.
• The data export process involves selecting the data type and period, setting a secure password for the exported zip file, and providing an email address for delivery.
• Be aware that exported data may take up to 1 day to arrive in your email, and CREMA does not retain passwords for these files, so secure storage is essential.
• A history of all data export requests from the past 365 days is available for viewing within the system.

You have the capability to export data from the CREMA database directly to your email address as a CSV file. The types of data available for export include Reviews data and Products data.

❗ IMPORTANT

• It may take up to 1 day for the exported data to arrive in your email inbox.
• Please ensure that you securely store the file password, as we do not retain any password information. This means we cannot recover it for you if it is lost.

In this article

• Export the data
• View the data request history
• Available components for each data

STEP 1. Export the data

To export your data from the CREMA database, please follow these detailed steps:

1. Navigate to the Review menu, then select Export data, and finally click on the Request for data tab.
2. Select your desired data type (e.g., Reviews data, Products data) and the specific data period for the export. Please note that you can download a maximum of 12 months of data at one time.
3. Set a strong password for the CSV zip file that will contain your exported data. The password must be between 10 and 16 characters long and include at least two of the following character types: uppercase letters, lowercase letters, numbers, or special characters (!@$%^&*).
4. Enter the email address where you wish the exported data to be sent.
5. Click the Request for data button to initiate the export process.

STEP 2. View the data request history

You can easily monitor the status and history of your data export requests under the Data request list tab. This section provides a comprehensive record of all previously exported data requests from the past 365 days, including today's requests.

Available components for each data

The following detailed data components are available for export, categorized by data type:

• Reviews Data
  • Review ID, Review code, Order number, Review date, Purchased date, Fulfilled date, Review text, Customer ID, Customer name, Customer grade, Custom questions, Product number, Product name, Product price, Product option, Reward, Rewarded date, Review submission, Rating, Tag, Number of photos, Number of videos, Photo URL, Video URL, Number of comments, Comment text
• Products Data
  • Product number, Product name, Group product, Number of staff reviews, Number of featured reviews, Product URL, Number of reviews, Number of photos/videos, Review submission rate, Rating

Frequently Asked Questions (FAQ)

What are the limitations when exporting data?

👉 You can export a maximum of 12 months of data at a time. Please also note that it may take up to 1 day for the exported data to arrive in your email inbox.

What are the password requirements for the exported CSV zip file?

👉 The password for the exported zip file must be between 10 and 16 characters long. It is also required to include at least two of the following character types: uppercase letters, lowercase letters, numbers, or special characters (!@$%^&*).

How can I check the status or history of my data export requests?

👉 You can view the complete history of all your data export requests, including their status, by navigating to the Data request list tab. This section records all requests made over the past 365 days.