Import customers to Synerise by file upload

Published November 07, 2022

Modules

Difficulty

Selected Clients

Industry

Importing your customer database to Synerise is a great way to get started with your email marketing efforts, as it will allow you to immediately start building relationships with your customers.

In this use case, we will focus on how to use the Automation module to easily import a ready-to-use data base from a CSV file without any transformation.

Prerequisites

Create a CSV file with your customer database. You can add a few basic columns: firstName,lastName,email. Prepare your file based on this document. You can also find the general requirements for the .CSV file format here.

Example CSV file might look like this:

firstName,lastName,email,
Dwight,Addams,dwight.addams@test.com,
Martin,Smith,martin.smith@test.com,
Kurt,Doe,kurt.doe@test.com,
John,Smith,john.smith@website.com,

Important: If you decide to import without a transformation diagram (without data transformation), it is very important to name the columns in the file appropriately, because they will later be connected with client’s attributes. The column names should correspond with the API fields described here. Any additional column outside this list in the API documentation will be treated as a custom client attribute.

Tip: If you are importing a newsletter database, apart from the email attribute, we suggest that you should also add columns with a marketing agreement called agreements.email with a value 1 or 0.

Prepare a workflow

The scenario for this use case involves a one-time import of .csv file with a customer database directly to Synerise.

Go to Automation > Workflows > New workflow.
Enter the name of the workflow.

Define the launch date

As the trigger node, add Scheduled Run.
In the configuration of the node:
1. Change the Run trigger option to one time.
2. Select Immediately.
3. Confirm by clicking Apply.
The configuration of the Scheduled Run node

Select file to import

Add a Local File node.
In the configuration of the node:
1. Upload the file.
2. Confirm by clicking Apply.

Add Import Profiles node

Choose Synerise node.
On the Local File node, click THEN.
From the list that opens, select Synerise > Import Profiles.

Add the finishing node

Add the End node.
In the upper right corner, click Save & Run.
Imported profile

You can monitor the flow of the workflow in the Transformation logs tab. It contains information about each execution of the workflow.

Result: New imported profiles can be visible in your CRM module.

Check the use case set up on the Synerise Demo workspace

You can check the workflow configuration directly in Synerise Demo workspace.

If you don’t have access to the Synerise Demo workspace, please leave your contact details in this form, and our representative will contact you shortly.