Too often, marketers have limited access to their data. They must submit ad-hoc requests to data teams, rely on analysts to provide customer insights, and sporadically collect and upload manual customer list CSVs into their marketing and advertising platforms.

In this Quickstart, Snowflake and Hightouch will walk you through how to equip your business teams with powerful self-serve tools that transform Snowflake into a marketing engine that drives growth for your business.

Using Hightouch, data teams from leading enterprises enable their marketing teams to independently improve campaign conversion, deliver captivating personalized customer experiences, and accelerate their marketing efforts - all with the power of the Marketing Data Cloud.

Hightouch offers teams the ability to implement a Composable Customer Data Platform. The product has all the features needed to transform Snowflake into a marketing-friendly platform that drives growth.

Hightouch Overview

What You Will Learn

This Quickstart is for both business teams and data teams but will focus on how data teams can set up visual UIs for their business teams to use. You'll be hands-on with a semantic layer, audience builder, and analytics suite, with the end goal of taking home a demo that should excite both your data and marketing teams.

At the end of this Quickstart, you will successfully:

Note: To complete this quickstart, you must have access to the advanced features of Hightouch. If completing outside of Snowflake hands-on labs, please reach out to the Hightouch team to get access.


You will need a Snowflake Account with ACCOUTADMIN access to install Hightouch via Partner Connect. If you don't have the correct permissions, you'll need to start a trial account, which the next section details.

Important: You will need to set up a new workspace in Hightouch specifically for this lab. If you already have a Hightouch account, please create a new Workspace through Partner Connect as described in this section.

Log in to Snowflake

If you already have a Snowflake account, you can use your credentials to log in. If you do not already have an account, you can visit to sign up for a 30-day free trial. You will want to make sure that the account you use in Snowflake has the permissions to create a new database, schema, and warehouse to be used by Hightouch.

Set-up Hightouch through Partner Connect

You can set up a database, schema, and warehouse for use with Hightouch by setting up Hightouch through Partner Connect in Snowsight. See the detailed instructions on the Hightouch Blog for more details.

  1. Click the Partner Connect tab under Data Products.

Partner Connect

  1. Search for Hightouch (or scroll to the Data Integration section), and select it.

Select Hightouch

  1. View the Database, Warehouse, User, and Role that will be created for the integration, and click Launch.

Click Launch

  1. When the creation is complete, you will see a pop-up telling you that the creation has finished. Click Activate to be taken to Hightouch to log in.

Click Activate

  1. Create a new Workspace starting as "SNOWHOL-firstname-lastname". Failure to follow this step will delay your start of the in-person lab. If you are not running this quickstart as a part of a lab, ignore the naming convention for this step and reach out to Hightouch after creating your workspace.

New Workspace

  1. Log in to Hightouch using your Hightouch credentials, and you will have a Data Source from Snowflake created in Hightouch.
  1. Download the HT_HOL_setup.sql file.
  2. Within Snowflake's Snowsight UI, select Create Worksheet from the SQL file
  3. From the sidebar on the left, navigate to the Projects > Worksheets
  4. Click the "..." in the top right corner and select "Create Worksheet from SQL File" from the drop-down menu

Create Worksheet

  1. Run the entire worksheet to setup the tables required for the HOL. You can select all and hit "run" on the top right. Alternative, the keyboard shortcut is ctrl+enter (Windows) or command+return (Mac).

Destinations are the tools and services you want to send your data to. You need to connect your destination to Hightouch before you can set up any syncs to destinations. For the purpose of this live Hands-on-Lab, your workspace will come pre-configured with destinations. Please SKIP this Adding a Destination section.

Adding a Destination

  1. Click within the integrations tab on the side nav, then click destinations.
  2. Click Add destination

Add Destination

  1. Select the destination you want to add - in this case, Facebook Custom Audiences and click Continue.
  2. Authorize connecting to your destination or enter the relevant credentials and inputs. These differ depending on the destination. In this case, you will click "Use System user token."
  3. Click Continue. Before continuing, Hightouch validates that you have the necessary access and permissions. If the test fails, you need to confirm and re-enter your credentials.
  4. Give your destination a Destination name. This name is how your destination appears in the Hightouch workspace. It helps to include details about the destination's business purposes and owners, particularly if you plan on connecting multiple instances of the destination, for example, a development and prod version. In this case, use Facebook Audiences Dev
  5. Click Finish.

Schemas define the data Hightouch should read from in Snowflake. Think about this as setting up your semantic layer with a visual ERD in Hightouch. Once you've set up your schema, which is a one-time setup*, you and your marketing team can build thousands of audiences with just a small set of initial models and events.

By following along with the setup in this section, you'll learn how to create a simple schema like this that ties users to Purchase, Add to Carts, and Product View events.

Parent Model - Schema Creation

In this example, the parent model would be the dataset of all customers. The example data set will include the following columns:

  1. Navigate to the Schema tab under Customer Studio
  2. Ensure that your Data Source is correct (ex. Clone of Snowflake)
  3. Select "Create Parent Model"

Parent Model - Create Model

  1. Hightouch has a few modeling methods. For this parent model, select Table Selector and then select the PUBLIC.USERS table
  2. Preview results to ensure you can see the underlying data
  3. Click Continue

Parent Model - Click Continue

  1. Enter a name for your parent model. In this case, we will use "Users."
  2. Optionally, enter a description.
  3. Select a primary key. This should be a column with unique values. In this case, we will use ID to represent our user identifier
  4. Select columns for the model's primary label and secondary label. Hightouch displays these column values when previewing audiences.
  5. Click Create parent model.

Parent Model - Click Create

Great, now your parent model Users have been created. Your team can now begin building audiences off of this data. That said, they'll likely want to utilize more than just user data, so we will go ahead and add event models to create audiences using customer behavioral events.

Event Model - Parent Model

Create First Event Model

An events model might include Product Viewed events with columns for:

  1. To create an event model, hover over the parent model (Users) and click the + icon
  2. Select "Create a related event"

Event Model - Create Event

  1. Rather than using the table selector this time, we will use SQL to define the model. Click the table selector dropdown and change it to SQL query

Event Model - SQL Model

  1. Input the SQL query that defines your desired event. In this case, we will use the following query:
select * from PUBLIC.EVENTS WHERE event_type = 'product_viewed'
  1. Click Preview to inspect the underlying data, then click Continue

Event Model - Preview

  1. Enter a name for your event model, in this case, Viewed Product, then optionally, enter a model description.
  2. Select the relationship's cardinality (how this joins to the parent model). You can select from 1:1, 1:many, or many:1. In most cases, parent models have a 1:many relationship with events. Select 1:many
  3. To relate rows from the events model to rows in the parent model, select the relevant foreign key columns from the parent and event models. In this case, we will use ID from our parent model and USER_ID from the event mode
  4. If there are multiple columns that the parent and related model must match on, enable Multiple join keys and make additional selections. In this example, we will only match with one key.
  5. Click Create event

Event Model - Click Create

Create Additional Event Models

Great! With your first event model created, the Product Viewed event can now be used to build audiences. We will now go ahead and repeat this process to add two more additional events.

Related Model - Starting Point

  1. Once again, hover over the Users model and click +
  2. Select Create a related event

Related Model - Create Related

  1. Again, we will use a SQL query to define our event model. Select SQL query from the modeling dropdown
  2. Enter the SQL query that defines the Add to Cart event:
select * from PUBLIC.EVENTS WHERE event_type = 'add_to_cart'
  1. Preview the model and click Continue

Related Model - Click Continue

  1. Add your model name, "Added to cart" and optionally, enter a description.
  2. Select the relationship's cardinality as 1:many
  3. To relate rows from the events model to rows in the parent model, select ID from the Users parent model and USER_ID from the event model
  4. Click Create Event

Related Model - Create Event

  1. Great, the new event model has been added! Now, we will go ahead and add the final event model for Purchases. Again, hover over the parent model and click the +

Related Model - Click Plus

  1. Change the modeling method to SQL editor and enter the SQL query:
select * from PUBLIC.EVENTS WHERE event_type = 'purchase'
  1. Preview the data and click Continue

Related Model - Preview Data

  1. Enter "Purchased" as your model name and optionally, enter a description
  2. Select the relationship's cardinality as 1:many
  3. To relate rows from the events model to rows in the parent model, select ID from the Users parent model and USER_ID from the event model
  4. Click Create Event

Related Model - Final Create

Great! Your Schema has been fully configured. Your team can now use any information from your users table and any events from your Purchased, Added to Cart, and Viewed Product event models when creating audiences in Customer Studio.

Final Schema - Part One

As a last step, you can click into your models to configure the columns with additional settings like previews (to ensure the fields show as suggestions in the audience builder) and redactions (to hide unwanted fields).

For this quickstart, navigate to each event model, click columns, click the settings gear, and turn all column suggestions on.

Final Schema - Part Two

Note: The schema builder can be as large as desired and can additionally support related models to bring in data from related objects like accounts, households, vehicles, pets, etc. However, for this Quickstart, we will not use any related models.

Final Schema - Part Three

With your Schema defined, any Hightouch user can now use Customer Studio to explore, build, and sync audiences across marketing tools and advertising channels. Hightouch's powerful no-code audience builder gives marketers everything they need to operate independently on the data in Snowflake - all while giving data teams peace of mind through enterprise-grade governance controls.

Building an Audience

  1. To create your first audience, navigate to the Audiences tab under Customer Studio, then click Add Audience

Build Audience - Add Audience

  1. Select the parent model to build audiences from - in this case, we will use our Users parent model
  2. Click "Add filter" and then scroll through to see your available segmentation fields. You'll notice you can filter on Properties, Relations, Events, Audiences, or Custom Traits. Search for the Purchased event through the dropdown or by clicking the events filter

Build Audience - Search Event

  1. Select Purchased

Build Audience - Select Purchased

  1. Add a Time Window of within 365 days to only include customers who have purchased in the last year
  2. Add additional logic on the specific purchase event by clicking "+where property is..." and select Category equals Shoes
  3. With your audience defined, click the Show Insights tab on the top right to see the Audience size and explore users within the audience
  4. To get a better understanding of your audience makeup, click the Breakdown tab and then click "+add breakdown"

Build Audience - Add Breakdown

  1. Click through the various visual types by toggling "SHOW AS" to bar charts, pie charts, and tables. You can also toggle settings to show all data, switch axes, and show a percentage. In this case, use a pie chart to explore how the audience is distributed.

Build Audience - Show As

  1. Once you feel comfortable with your audience, click "Continue" and name the audience "Purchased Shoes p365d [Your First Initial and Company Name]". Note: adding the name at the end is simply for this lab to ensure that your audience name is unique in the demo destinations.
  2. You can additionally add a description or create folders for organization; however, in this case, we will simply click "finish."

Create a sync

With our audience now created, we can now sync it out to any destination. To do so, we will need to create a sync.

  1. Click "Add Sync" in the top right corner of the audience page.

Build Audience - Add Sync

  1. Click the destination you want to sync the audience to - we will use our Facebook Custom Audiences Dev destination.
  2. Configure the audience settings. Note: This process is NOT required each time you create an audience, thanks to Sync Templates that you can easily create for each destination. We will create this in the next section.
  3. Ensure that "Create a new Facebook audience" is selected, and then leave the audience name blank. The Hightouch audience name will be used when uploading to Facebook.
  4. Next, we need to define the columns from our Snowflake table that we would like to sync to Facebook Custom Audiences ID fields.

Sync Creation - Map Fields

  1. Under the field hashing setting, choose "YES" to allow Hightouch to hash values since the data is not hashed yet.
  2. Leave the Shared Audience section blank.
  3. Choose to Remove the Facebook Custom Audiences record from the specified audience - this ensures that as users fall out of our audience criteria, they are removed from the Facebook audience.
  4. Click "Continue."
  5. Optionally, enter a description for the sync. In this case, you can leave it blank.
  6. Finally, select the schedule on which you would like this sync to run. Hightouch offers a number of different sync scheduling options to meet your various needs. In this case, we will select the schedule type of "Interval" and then choose an interval of "Every 1 Hour(s)."

Sync Creation - Choose Interval

  1. Click "Finish." Your sync will now Run for the first time. All records that fit the audience criteria will be sent to the Facebook destination along with the specific fields we mapped in the earlier steps.
  2. With the audience sync in place, you can additionally QA the sync, set up alerting, monitor activity, set up sync logs (writing the audience back to Snowflake), and edit any settings for future syncs. In this case, we will simply continue.

Create a Sync Template

As you can imagine, while the flexibility is great for configuring each setting of your sync, managing many audiences can become tedious. Hightouch's sync templates allow marketers to set up syncs with just one click.

Sync templates let you define sync configuration settings once for a particular destination. You create the sync template and then use it to add syncs for each audience requiring the same configuration settings and schedule.

  1. Navigate back to "Schema" within the Customer Studio tab.
  2. Click "Settings" and go to the Sync Templates tab.

Sync Templates - Add Template

  1. Click "Add Sync Template" to launch the template creation flow.
  2. Select your existing User parent model.
  3. Select your existing Facebook destination.
  4. Configure your sync as you would typically: create your specific field mappings (see below) and make sure to toggle on "Remove the Facebook Custom Audiences record from the specified audience."

Sync Template - Configure Sync

  1. Click "Continue" and select an hourly interval as your sync schedule.
  2. Optionally enter a template name - in this case, you can leave as-is.
  3. Click "Finish", and that's it! Your marketing team can now use this sync template for any future audience syncs.

Experiment with Splits

As a marketer gearing up for your next campaign, you're likely thinking about critical questions like "Which channel should I leverage?" or "What copy or offer will resonate best?" The key to unlocking these answers lies in continuous testing and iteration.

Hightouch's Splits feature powers rapid A/B and multivariate testing. With Splits, Hightouch segments your audience(s) into randomized groups across your channels and writes the segments back to Snowflake to streamline experimentation and analysis.

You can specify:

Using Splits, you can run experiments such as:

  1. To create a split, we will first create another audience by clicking into Audiences in the Customer Studio tab and then clicking Add Audience.
  2. Select your Users parent model.
  3. Create a cart abandon audience.

Splits - Cart Abandon

  1. With your logic defined, you can Click "Show Insights" and use the Overlap tab to see the overlap of this new audience with your Purchaser audience by selecting it from the dropdown.

Splits - Show Insights

  1. Once you check the overlap, click "Continue."
  2. Name the audience "Cart Abandoners p30d [Your First Initial and Company Name]" and optionally add a description.
  3. Click "Finish."
  4. With the audience now created, click the "Splits" tab within the Cart Abandoners audience.
  5. Toggle to Enable Split Groups.

Splits - Split Groups

  1. You can now choose how many splits you would like Hightouch to randomly create within your audience, the weighting that each split should be, and the destinations that each split should be sent to - users in holdout groups will only be synced into a Snowflake table so that you have a control group to analyze lift against. For now, leave the splits as-is at 80/20 between the treatment and control. Click save changes.
  2. Click the "+ Add sync" within the Splits window to create a sync for the split group.
  3. Select the Facebook sync template you created in the previous section and click "Add Syncs."

Splits - Add Syncs

  1. With the sync created, the Treatment group is now sent to Facebook as an audience, while the Holdout is ONLY sent to Snowflake for analysis.

Splits - Treatment

Analyze data with Campaign Intelligence

No matter how great your ideas are, marketing success hinges on your ability to try new things, understand what's working, and iterate quickly. Unfortunately, understanding what's working is a massive challenge today for most teams. They struggle to analyze performance across channels and data silos, are often stuck with basic metrics, and have to rely on technical teams for deeper insights.

Campaign Intelligence tackles these challenges head-on. It gives marketers an easy, self-service platform for marketing analytics on top of their complete campaign and customer data in Snowflake. Combined with the rest of Hightouch, marketers can now build audiences, orchestrate cross-channel experiments, and measure campaign ROI–all within one platform.

Create a Performance Analysis

  1. Click into "Charts" under the Intelligence tab.

Campaign Intelligence - Charts

  1. Select "Purchased" as your Metric.
  2. Change the group by to "Category".
  3. Change your date range to "30d".

Campaign Intelligence - Date Range

You can now explore how certain events or metrics trend over time across audiences or are grouped by specific attributes.

Create a Funnel Analysis

  1. Toggle the chart type from "Performance" to "Funnel".
  2. Under Steps, set up your specific funnel.
  1. Under Conversion criteria, change the attribution window to "30 days."

Funnel Analysis - Attribution Window

  1. You can now identify metrics like the % of dropoff between funnel steps. Additionally, limiting the analysis to specific audiences or grouping by certain columns from your parent model will allow you to dig deeper to identify trends and better understand user behavior. Hover over the drop-off area (light green) in the "Added to Cart" step. You can now see the % of users who viewed a product but did NOT add to cart.

Funnel Analysis - Added to Cart

  1. Click in the light green area to display the Create Audience modal.
  2. Click "Create Audience" to automatically set up an audience with the criteria specific to this cohort of users to allow you to quickly target these users with relevant messaging on advertising and marketing channels.

Funnel Analysis - Create Audience

  1. Click "Continue."
  2. Name the audience "Funnel Dropoff - ATC [Your First Initial and Company Name]" and click Save.
  3. Click "Create Sync" in the top right corner on the audience page and select your Facebook Sync Template.

Funnel Analysis - Create Sync

  1. Click "Add Syncs," and your audience will be sent to Facebook. Users who abandoned your site before adding to the cart can now be retargeted on Facebook to drive more users to complete the next step of your purchase funnel.

As you can imagine, the Intelligence, Audiences, and Splits features all come together to enable marketing teams with an iterative optimization loop - enabling marketers to independently launch campaigns, experiment on them, analyze performance, and then apply those insights to further optimize existing and future campaigns.

Congratulations! You have successfully learned how to transform your Data Cloud into a Self-Serve Marketing Engine.

What you learned

Related Resources

Want to learn more about Hightouch and the Composable CDP? Check out the following resources: