How to Setup Delighted Integration

This integration will allow you to connect with Delighted and start collecting your Net Promoter Score℠ (NPS) data. It is a matter of minutes to send your data to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

  1. Connecting Delighted
  2. Set the Replication Frequency
  3. Load your Delighted data into your data warehouse
  4. Delighted expected Data Model and schema

Getting Started – Setup Delighted integration at Blendo

1. To add this integration, go to Blendo dashboard. Click “Add a Source”

Setup Delighted integration

Settings you need from Delighted

We will need the API Key from Delighted.

2. Login to your Delighted account from a new tab.

3. Click on Settings in top right side.

Setup Delighted integration

4. Click API (1). Copy Your API Key (2).

Setup Delighted integration

5. Paste the API key into the relevant box provided in Blendo and click Validate & Save.

 

6. Then you will return back to the home dashboard. Click on your new Delighted data source.

 

 

Defining the Replication Frequency

Blendo syncs Delighted data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Load your Delighted data into your data warehouse

Here is how to start loading your Delighted data into your data warehouse:

Load Delighted data into data warehouse

Expected Delighted Data

Getting your Delighted data is one thing. What about these data, though? Let’s see:

  1. How Blendo syncs Delighted data
  2. The tables with Delighted data that we create in your destination data warehouse

How Blendo syncs Delighted data

Historical Data

When Blendo first connects to Delighted Data source, will pull all your historical data.

Sync Schedule

Blendo syncs Delighted data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process

The first time Blendo syncs your Delighted data performs a full replication. Then your Delighted data is replicated incrementally. Meaning that Blendo will replicate only new and updated rows to your destination data warehouse.

What Delighted data do I have available?

Bellow are the tables with Delighted data that we create in your target data warehouse.

Expected Delighted Data Model & Schema Information

For a complete view of the data model of your expected data click here.

Delighted Data Model & Schema

Bounced people

Table Name: bounced_people

The table contains information about bounced people for your Delighted account

Primary Key: person_id

Columns of this table include: bounced_at, email, name.

Survey Responses

Table Name: survey_responses

The table contains information about the survey responses for your Delighted account.

Primary Key: id

Columns of this table include: comment, created_at, person, person_properties, score.

Unsubscribed People

Table Name: unsubscribed_people

This table contains information about unsubscribed people for your Delighted account.

Primary Key: person_id

Columns of this table include: email, name, unsubscribed_at.

Survey responses notes

Table Name: survey_responses_notes

The table contains information about the survey responses notes in Delighted.

Primary Key: id

Columns of this table include: contact_id, timestamp, type, value.

Survey responses tags

Table Name: survey_responses_tags

The table contains information about the Survey responses tags in Delighted.

Primary Key: blendo_id

Columns of this table include: contact_id, list_id.

Questions? Contact us!

in Connecting SaaS Data Sources