With our Relational Data Service you can connect your own external contact databases to Emarsys and use the data fields contained in them to create segments or populate personalization variables.
In this article
Product documentation
What is Relational Data?
Relational Data is our database administration tool which ensures that your external data sets are transparent; you can see, browse, and manage your database right from the Emarsys user interface.
It is the best solution for:
- Sending offers and recommendations
- Wish-list-related notifications and price-drops
- Replenishment, renewal, abandoned cart or reminder campaigns
- Business-specific use cases where your own data is crucial
What options are there for setup and hosting?
Relation Data setup can either be performed by you (Self-service) or by Emarsys (Fully Managed).
Each of these have their own variations depending on your data hosting and personalization requirements. Details of these options are provided below; for more information, please contact your Success Manager.
Self-service Setup (Client Hosted Data)
| Requirement | Description |
|---|---|
| Database infrastructure | Hosted and maintained by you. |
| Segment templates, data structure and personalization | Defined, implemented and modified by you. |
| Lead time and data requires development? | No |
| On-site IT personnel recommended? | Yes |
| Level of service | Options | Customers maintain their own infrastructure |
Customers define, use and modify segment templates, data structure and personalization |
Lead time and data load needs development |
IT personnel recommended on-site |
|---|---|---|---|---|---|
| Self service | yes | yes | no | yes | |
| Hosted self service | no | yes | yes | yes | |
| Fully Managed Setup | no | no | yes | no* | |
* Use of the Emarsys Scripting Language may require programming skills.
The connected databases can be of two types: external or internal.
- External databases are hosted and maintained by the customer. Segment template creation and segment creation are both available.
- In case of internal databases, they are hosted by Emarsys and they always use mySQL. Segment template creation is only available for the self service option, while with full service, only the segment templates created by Emarsys are available for segmentation.
With this option, you host the databases where your data is stored and take care of all the implementation steps necessary. Emarsys offers a limited degree of implementation support where necessary.
Use cases
Reminder for retention
Contract renewal with incentives.
When a contract is about to expire, an SMS or email will be sent with the focus on a new mobile phone. This is an aggressive campaign with big discounts.
Upsell
An airline wants to send offers for activities and accommodation.
Between the date of booking and before the actual flight date, a campaign is sent with personalized offers for products or activities to buy, and suggestions for accommodation, based on the destination city. This is an automated campaigns sent on a daily basis.
Abandoned cart
E-commerce website brings customers back to complete unfinished purchases.
A web shop is targeting customers who have added products to their cart but have not finished their purchase at the payment step. The campaign is to be sent every six hours. There is a link to the checkout page included to let the customer continue the purchase where they left off. The personalized subject line shows the most expensive product.