You can do more complex segmentation by leveraging all the data in your warehouse, including event data and third-party data. Your warehouse is the only place where all of this data coexists.
You can keep your Delighted segments in sync with the rest of your business tools. For example, you might want to send a survey to users who've been invited to a beta program. You also might want to sync these attributes to a CRM like Salesforce or HubSpot. Hightouch integrates with 200+ SaaS tools used for email marketing, customer support, sales, and more. Define your audience once and activate your data everywhere.
Segments can be defined using the tools that your teams are most comfortable with. You can filter and transform data from your warehouse using SQL or our visual query builder—whichever you prefer. (You can even sync customers to or send surveys through Delighted segments based on work you've already done in dbt or Looker!)
Hightouch sits on top of your data warehouse and can read from Snowflake, Redshift, BigQuery, Databricks, Postgres, MySQL, and many other data sources. You can even fetch data from Google Sheets and Airtable. Hightouch can help activate your data wherever it resides.
We've written dedicated guides for each supported data source. Take your pick:
If you're missing the credentials necessary to connect to your data source,
try inviting your teammates to Hightouch. You can have unlimited collaborators
in your workspace.
Waiting for credentials to your data warehouse? No problem. You can connect to one of our sample databases to get started right away. For the rest of this tutorial, we'll use our demo Postgres database, which contains a users table with names, emails, locations, and other user attributes. This sample source is available when you log in for the first time—no setup required.
Next, we'll write a SQL query to define which users should be synced to our Delighted customers resource. You can follow the same pattern to sync to other support Delighted resources,
In Hightouch, a model represents a query that filters or transforms the records in your data source. Models are used to determine exactly which records to sync between sources and destinations.
When you connect to a data warehouse, your models will probably be written in SQL. You can also import models from tools like dbt and Looker.
In this example, we'll keep it simple. Suppose you want to sync all your customers to Delighted. To accomplish this, you'll want to create a model that looks like this:
SELECT*FROM users;
Click on Models in the left sidebar.
Click on Add model in the top right corner.
Select Demo Database as your source and click Continue to proceed.
Select SQL Editor as your modeling method.
Paste the SQL query from above into the editor on the left side of the page.
Click Preview to execute the query.
Click Continue to proceed.
Give your model a name and unique slug (for example, "All Users" and all-users).
Select ID as the primary key for your model.
Click Finish to create your model.
We just created a model using a SQL query that retrieves all our current users. Next, we'll configure our sync to add these users to Delighted.
Select All Users as your model and click Continue to proceed.
Select Delighted as your destination and click Continue to proceed.
Give your destination a name and unique slug (for example, "Delighted All Customers Sync" and Delighted-all-customers-sync) and click Finish to proceed.
Select People from the object dropdown.
Select Upsert from the mode radio options.
Select email and we will map it to Email from the external ID mapping field.
Select first_name and we will map it to Name in the fields that we'd like to sync to Delighted.
Select Yes in the Sending Survey section.
Select Do Nothing in the Delete section.
Click Continue to proceed to the last step.
Select Interval to tell your sync to run on a set interval.
Configure your sync schedule to run every 5 minutes.
Click Finish to create your sync.
And We're done. Your Delighted sync configuration is complete.
Hightouch allows you to set custom attributes. Any mappings from this section will be synced to the custom properties of each associated survey sent. You can add as many properties as you need.
Properties are a powerful way to analyze survey results on Delighted. To learn more about it, visit Properties Overview.
When configuring your Delighted sync form, there are a couple of choices provided to you when it comes to sending surveys. You can either:
Not send surveys to all synced records.
Send surveys to all synced records. Records that are created will be sent a survey. Records that are updated and are out of Delighted's survey throttling interval will be sent a survey.
Send surveys based on each record dynamically by providing a Boolean column. To use this feature, toggle Use Column, and select that respective column from the dropdown.
To date, our customers haven't experienced any errors while using this destination. If you run into any issues, please don't hesitate to . We're here to help.
Hightouch provides complete visibility into the API calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks to learn more.