Create a customer export

Customer exports allow you to schedule and send customer and product attributes to an SFTP server so you can integrate your customer data into your customer data platform or analytics.

You can customize each export job by specifying an audience, destination, customer and product attributes, and schedule.

All jobs can be run as frequently as once per hour.

Once an export job is set up, you can be notified when it runs.

To learn more about export job and run statuses, see Understand export job and run statuses.

Before you begin

• You have a pre-configured SFTP export integration, which defines the export destination.
• Confirm your destination folder path is valid. Export folders are validated before saving the job.
  • If you are exporting to Files.com, you can choose to export files to a parent or child Namespace's root folder.
• Decide whether to enable GPG (.gpg) encryption.
• If exporting files over 1GB (uncompressed), they will automatically be split into multiple files using sequential wildcards. For more information on what the file name would be, see wildcard in the export file name structure section.
• If you are exporting product attributes, your audience must contain a product event, such as added product to cart, add product to wishlist, remove product from cart, search for product, or view product.

Create a customer export

1. Go to  Data Exports > Customer Exports.
2. Click New customer export job and select the destination integration from the list.
3. Fill out the details of the export job and, when finished, click Save.

Selecting customer and product attributes

You can only select the attributes that are enabled on the associated integration.

If you need additional customer or product attributes not in the dropdown, add them to the SFTP integration in the Definitions tab.

When exporting products users interacted with, only products within the audience lookback window are exported.

For example, if the audience captures customers who made a purchase in the last seven days, the export contains only products purchased during the seven day period.

Aggregate product attribute(s) by customer identifier

When exporting product attributes, you can choose to group products by customer, or to list each product/customer combination as a separate record.

If aggregation is enabled, each customer appears once per file with all associated products grouped within the products array:

{
  "email": "alice@gmail.com",
  "site_uuid": "7284845d-fac1-42f9-a094-977787445b47",
  "first_name": "Alice",
  "products": [
    {
      "id": "prod-85062",
      "name": "Teapot",
      "bc_price": "$138.42"
    },
    {
      "id": "prod-85063",
      "name": "Teacups - Set of six",
      "bc_price": "$57.92"
    }
  ]
}

If aggregation is disabled, each customer/product relationship appears as a separate entry:

[
  {
    "email": "alice@gmail.com",
    "site_uuid": "7284845d-fac1-42f9-a094-977787445b47",
    "first_name": "Alice",
        "id": "prod-85062",
        "name": "Teapot",
        "bc_price": "$138.42"
  },
  {
    "email": "alice@gmail.com",
    "site_uuid": "7284845d-fac1-42f9-a094-977787445b47",
    "first_name": "Alice",
        "id": "prod-85063",
        "name": "Teacups - Set of six",
        "bc_price": "$57.92"
  }
]

Job timezone and file dates

Customer exports jobs default to your local timezone. To use a different timezone, select the timezone from the Job Timezone dropdown.

The date and time data contained in the export files are always recorded in UTC. Job Timezone only affects the export data date range and job schedule, not the timestamp data.

Export file name structure

The export file name is constructed using the file name, extension, and run ID, and other settings that you choose when creating or editing a job.

The file name structure is made up of the following:

<File name>-<date>-<wildcard>-<run ID>.<extension>