Logo Help Portal
  • Getting Started

    Introduction

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

    Data

    • Data exchange
    • Data onboarding
    • Web data collection
    • Strategic Platform Integrations

    Channels

    • Email onboarding
    • Smart Insight
    • Predict
  • Training

    Resources

    • Introduction
    • Online Self-learning
    • Onboarding Videos

    Events

    • Instructor-led Training
    • Webinars
    • Seminars
    • Training Calendar
  • User Guides

    Strategy

    • Personalization
    • Automation
    • Data Monitoring

    Channels

    • Email
    • Mobile Apps
    • Web
    • Ads
    • SMS

    Add-ons

    • Smart Insight
    • Predict
    • Incentive Recommendation
    • AIM
    • Relational Data
  • News & Support
    Forrester Wave CCCM (Independent Platforms) Report Q4 2019

    News

    • What’s New in the Emarsys Platform
    • Updates from the CSA
    • Pilot-Features
    • Articles on Data Protection and GDPR

    Support

    • Help and Support at Emarsys
    • Managing your user profile
    • Preparing for Black Friday 2019
    • Black Friday 2019 - Best practices
  • |
  • Partners

    Enhance Partners

    • Getting Started as an Emarsys Partner
    • The Emarsys Integration Platform
    • Automation Center Integrations
  • Developers
  • System Status
Need help?
English Deutsch Español Français Русский Türkçe 简体中文 Test New Chat
Sign in
  • Data Management
  • Relational Data
  • 0 Data Management Relational Data

In this section:

  • Overview:: Relational Data - Overview
  • End-user guides:: Personalizing content with Relational Data
EDIT
Expand all

Overview:: Relational Data - Overview

Updated: November 13, 2019 01:00
360002165413
Overview:: Relational Data - Overview

The Emarsys Relational Data Service (RDS) enables you to load your business-specific data to the Emarsys Platform, in order to use it for segmentation and message personalization purposes.

Relational Data is a paid add-on available for: Essential Advanced Max AI
Relational Data is found under the menu: Add-ons > Relational Data

In this article

  • What is Relational Data?
  • What options are there for setup and hosting?

Product documentation

  • Relational Data onboarding for clients using client-hosted databases
  • Relational Data onboarding for clients using Emarsys-hosted databases
  • Relational Segments
  • Personalizing Content With Relational Data
  • Troubleshooting your Relational Data setup

What is Relational Data?

Relational Data allows you to integrate your business-specific databases with the Emarsys platform. In a relational database structure you can combine different data sources to make complex data easily accessible.

The connected databases can be of two types: Client-hosted (external) or Emarsys-hosted (internal).

  • Client-hosted (external) databases are hosted and maintained by the customer. Segment template creation and segment creation are both available. For information, see Relational Data onboarding for clients using Client-hosted databases.
  • In case of Emarsys-hosted (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. For information, see Relational Data onboarding for clients using Emarsys-hosted databases.

Segment definition

You can create segment definitions by connecting different data tables in the core of the system and providing flexible segmentation.

The flexible Segment Template helps you fetch data from any number of cloud-based databases, or even your locally hosted database, and import it to Emarsys for further use. Instead of storing the data, Relational Data connects to other databases, making the whole process compliant with the strictest data privacy regulations. It provides hundreds of segmentation scenarios for marketers without imposing any IT barriers. For detailed information, see Relational Segments.

Personalization

RDS also allows you to use objects called views in the email campaigns to target your customers with one-to-one personalized content based on predefined business rules. For detailed information, see Personalizing Content With Relational Data.

Examples: Use cases

Relational Data 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

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.

What options are there for setup and hosting?

Relation Data setup can either be performed by you (Self-service), can be a hosted self-service setup or performed by Emarsys (Fully Managed).

Each of these have their own variations depending on your data management requirements. Details of these options are provided below. For more information, please contact your Success Manager.

Level of service

Service Hosting Self-service Hosted Self-service Fully Managed Setup
Customer hosts database Yes No No
Customer use and modify segment templates, data structure and personalisation Yes
Yes
No
IT personnel recommended on-site Yes
No
No*

* Use of the Emarsys Scripting Language may require programming skills.

Was this article helpful?

Have more questions? Submit a request
Return to top

Emarsys is a Leader

You may also be interested in:

Related articles

  • Relational Data onboarding for clients using client-hosted databases
  • End-user guides:: Personalizing content with Relational Data
  • End-user guides:: Creating relational segments
  • Relational Data onboarding for clients using Emarsys-hosted databases
  • Overview:: Open Data - Overview
Copyright © 2019 Emarsys eMarketing Systems. All rights reserved
Legal Notice Privacy Policy Master Services Agreement Anti-spam Policy