Moving your data from your current providers to the Emarsys B2C Marketing Cloud and implementing our data collection scripts are the most important parts of the onboarding process. We offer a number of integration methods to suit your available resources and business needs.
In this article, you will find an overview of these methods and links to the information you need to complete this step with the minimum effort and in the shortest time.
Before you start, you may want to familiarize yourself with the standards and conventions that Emarsys uses to transfer data.
- Where to start?
- Selecting your base currency
- Uploading your product catalog
- Integrating web behavior data
- Importing your contact data
- Synchronizing contact data
- Integrating your sales data
- Checking your integration’s health
- Additional information
Where to start?
Start your e-commerce data onboarding on the Data Sources page, which you can find in the Admin menu. At this stage, this page is a step-by-step integration checklist that guides you through the process. It displays a number of boxes, each representing an integration step. They either link to the page where you can upload the relevant data, or contain instructions on what you need to do to complete the given step.
Selecting your base currency
If you have not configured your base currency yet, you can do so in the Account Settings box on the right-hand side. Base currency is the currency in which you want to track your revenue statistics, regardless of the number of currencies actually used on your website.
Uploading your product catalog
Your first action to integrate your e-commerce data is to make a single upload of your product catalog. This should be a single .csv file, formatted as per our guidelines, or a Google Product Feed.
In your product catalog, you should include all the products you have ever stocked, whether or not you still sell them. This is important for both the contact profile and the product affinity models.
Once you have prepared your product catalog, click Set up product catalog in the Product Catalog box to make your initial upload and set up your schedule for synchronization.
Integrating your web behavior data
To display the tracking code snippet you need to add to your website, click the Show Tracking Code button in the Web Behavior box.
Importing your contact data
Note: The Contact Import box on the Data Sources page is currently inactive. It will be enabled in a future release.
Now you need to import your entire customer database into Emarsys. To do this, you will need to ensure that all the required data fields exist in both databases, and that the .csv file containing the data is correctly formatted.
Contact data synchronization
Once you have imported your entire contact database, you will then need to make sure that your contact data is kept up to date. There are different ways to do this, depending on your requirements.
Synchronizing Emarsys with an external contact databases
This is our most common scenario, where new registrations and updates to existing contacts are collected in an external database (such as a webshop) and the changes (delta) are synchronized either in real time or once a day with the Emarsys database. The recommended option is to use the Emarsys API for this. However, you can also set up automated imports from your own SFTP or FTPS server, or from a WebDAV folder that we set up for you.
You may also be able to use one of our custom integrations with leading e-commerce platforms:
If Emarsys is your only contact database
If Emarsys is the only application that you use to store and manage contact data, you still have a number of options available.
- Using web forms to transfer data to Emarsys.
- Using HTTPS feeds to transfer data to Emarsys
- Importing contact data via the application
- Exporting contact data via the application
- Managing contacts manually
Integrating your sales data
Historical sales data is used by Emarsys to build contact profiles and product affinity models. We recommend that you upload as much data as you have available as this information contributes to fine tuning your contact profiles.
Smart Insight also uses this data to build the eRFM scoring model that your lifecycle segments will be based on, and in this regard you should upload at least two years’ worth of data for this model to be meaningful.
Like your product catalog, your historical sales data should be a single .csv file, formatted as per our guidelines. To upload the file, click Set up sales data uploads in the Sales Data box.
Once you have made your initial upload, the data collection scripts will keep track of the daily activity of your webshop, but you will still need to set up a regular synchronization schedule for any other sales data not tracked by them. This could include returns and cancellations, as well as offline data from your physical stores. We have provided a simple HTTP API for you to do this.
Checking your integration’s health
Once your initial data uploads have been completed, the Data Sources page becomes a status monitoring dashboard where you can check if your data sources have any issues to address, or if the data uploaded is consistent with the data collected in the your web store by the Emarsys data collection scripts.
I am not an Emarsys customer yet. Is there anything I can do to prepare for my data onboarding?
Since you do not need an Emarsys account or a signed contract to get started, you can save time on your overall data onboarding by starting to work on this straight away. All the information you need to prepare your product catalog and historical sales data files, and to implement the Web Extend data collection scripts on your website, is freely available on this site.
To start collecting data before you have an Emarsys account, you just need to request a merchant ID from Emarsys Support. Since the data collected is anonymous until it is associated to an Emarsys account there is no risk to data security to start this process early.
This guide will help you ensure that your import file is correctly formatted and encoded.
Data exchange resources
An overview of the Emarsys database fields and transfer protocols using API, WebDAV and FTPS.
About Emarsys database fields
An introduction to the fields used to store contact data in Emarsys.
About Emarsys forms
An introduction to the forms used in emails and on web pages to capture contact data and registrations.
The Emarsys API
An introduction to the Emarsys API.