Logo Help Portal
  • Getting Started

    Introduction

    • Onboarding overview
    • Project Initiation
    • Email compliance
    • Account Administration

    Data

    • Data exchange
    • Data onboarding
    • Web data collection

    Channels

    • Email onboarding
    • Smart Insight
    • Predict
  • Training
    • Online Self Learning
    • Onboarding Videos
    • Instructor Led Training
    • Webinars
    • Seminars
  • User Guides

    Strategy

    • Personalization
    • Automation
    • Data Monitoring

    Channels

    • Email
    • Mobile Apps
    • Web
    • Ads

    Add-ons

    • Smart Insight
    • Predict
    • Incentive Recommendation
    • AIM
  • News & Support

    News

    • What’s New in the Emarsys Platform
    • Pilot features
    • Articles on Data Protection and GDPR
    • Release notes - archive

    Support

    • Help and Support at Emarsys
    • Managing your user profile
  • |
  • Developers
  • System Status
Need help? Submit a request
English Deutsch Español Français Русский Türkçe 简体中文
Sign in
  • Documentation_-TechRef_- Data Management
  • Relational Data
  • 0 Documentation_-TechRef_- Data Management Relational Data

In this section:

  • Relational Data - overview
  • Personalizing Content With Relational Data
  • Troubleshooting your Relational Data uploads
  • in Emarsys42

    Expand all

    Relational Data - overview

    Updated: October 18, 2018 10:10

    In this article:

    • What Is Relational Data?
    • What options are there for setup and hosting?
    • Use cases

    Product documentation:

    • Relational Data Onboarding
    • Relational Segments
    • Personalizing Content With Relational Data
    • Troubleshooting your Relational Data uploads (ready for upload)

    What is Relational Data?

    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.

    Our database administration tool ensures that your 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
    • Wishlist-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.

    Was this article helpful?

    Have more questions? Submit a request
    Return to top

    You may also be interested in:

    Related articles

    • Relational data onboarding
    • Relational Segments
    • Personalizing Content With Relational Data
    • List of all public API endpoints
    • Email Style Settings
    Copyright © 2019 Emarsys eMarketing Systems. All rights reserved
    Legal Notice Privacy Policy Master Services Agreement Anti-spam Policy
    test new search