News

No more CSVs or static lists. Pull data from your warehouse to your marketing tools with SQL Traits in Personas.

Mar 12, 2019

By Doug Roberge, Alex Millet


The marketer’s role within an organization has changed. It has evolved from focusing on brand-first experiences that can’t be tied directly to business impact to driving data-backed strategies that show quantifiable results. Along the way, marketers pushing the boundaries on technology rely on a common thread: access to accurate, real-time data. 

Unfortunately, this kind of access to detailed and real-time data is not possible for most marketers. Whenever they want to create a new campaign, they need to ask their analytics team to write a SQL query in their data warehouse, download a CSV, and then upload it to a marketing tool. This process could take days at best and months at worst. And, the process only grants access to web and mobile data. Few marketers can understand the data within a broader context of CRM, POS, and help desk data to augment their messaging. 

There is a better way. 

Introducing SQL Traits 

SQL Traits is a new feature in Personas that allows you to use SQL to pull customer data directly from your warehouse into Personas and activate it in your marketing tools. With SQL Traits, you can unlock data in your warehouse that has previously been inaccessible to advertising, marketing automation, and out-of-the-box analytics tools. This includes account data from Salesforce, historical sales data from POS systems, or totally new predictions from your data science team. Any piece of data that’s stored in your warehouse is now available for segmentation and personalization. 

asset xEOhJGnH

Specifically, SQL Traits enables you to:

  • Access new types of data for marketing. These new data types include object cloud source data like Zendesk, Salesforce or Stripe, historical customer data, data from back end systems, like your POS, or models that your data science team has built. 

  • Build any segment imaginable. If it’s possible in SQL and the data is in your warehouse, it’s possible with SQL Traits. You can build audiences with complex calculations from data that exists across tables and data sources. 

  • Give your analysts and data engineers time back. The ability to query your data warehouse directly can save hundreds of hours of engineering work by eliminating the need for duplicative data pulls, manual CSV downloads, and simple data transformations. Not to mention, it speeds up marketing’s ability to test and innovate.

Request a Personas demo to see SQL Traits in action.

Use SQL Traits to improve the relevancy of each customer interaction

With more context around your customers, you have the power to deliver personalized messages throughout their customer journey. And, with fewer data blindspots, there is a much smaller chance of showing an irrelevant promotion or sending an incorrectly personalized email.

Printed, a one-stop creative gallery and directory, is using SQL Traits to:

  • Have control and visibility of all audience rules, including the ability for marketing to update them easily

  • Combine multiple data inputs to create email campaigns that span the customer’s journey:  From welcome to onboarding to usage and reactivation

  • Integrate data from their rewards program into their email marketing for added personalization

Grailed, a community marketplace for men's clothing, is using SQL Traits to:

  • Double the number of campaigns they run per week

  • Connect historical information on their buyers, such as lifetime spend with their push and email tools

  • Calculate the number of times a buyer has purchased a specific brand tier and use that information to determine which brand to highlight in the next email campaign

Frame.io, a post-production video editing software company, is using SQL Traits to:

  • Send emails to account owners when someone else on their team hits an account limit

  • Use LTV predictions to create advertising audiences that they are comfortable spending more on

  • Configure trial expiration dates with the Personas SQL editor to drive personalized trial-ending emails based on account activity during the trial period

asset ylWIvpBE

Other use cases for B2B companies:

  • Import lead fields from Salesforce and create an audience of closed, lost leads that triggers a nurture campaign

  • Run a query in Stripe that pulls the

    stripe_ltv

    field for every account to target ads and create more effective lookalike campaigns

  • Get a list of users that currently have a ticket open or a negative NPS from Zendesk to remove them from any upsell email campaigns or ad campaigns

Use cases for B2C companies:

  • Identify how a user has engaged with previous Facebook ad campaigns to determine what type of campaign they should receive next

  • Compute the number of emails that have been delivered, opened, and clicked to determine if you should keep emailing someone, or if they’re not engaged, switch to ads

  • Import new customer LTV predictions from your data science team to determine whom you should bid more for and whom you should exclude from ad campaigns

How you can put SQL Traits to work

Once you have access to Personas, you can start using SQL Traits. Within the Computed Trait builder, you simply select SQL Traits, select the correct warehouse, write or paste in your query, preview your audience, and send it to your selected destinations. The editor in Personas works just like an editor that you would use in a BI tool. 

Once your SQL Trait is setup, Personas will run your query on a recurring basis and import only the users and traits that have changed. For each row of your query results, we’ll send an identify or group call with all the columns returned as traits. For example, if you write a query that returns the following results:

asset fz18FFIq

We will send an identify call with the following payload:

asset l4lMyP3l

We currently support Redshift, Snowflake, BigQuery, and Postgres. Check out the docs for more detail.

Strong data infrastructure is your growth foundation

Building your traits and audiences and getting them to the right place is only one piece of the customer engagement puzzle. The success of what you build is dependent on the quality and completeness of the data you are using. If you’re working with an incomplete or inaccurate data set, your product experiences and marketing messages will fall flat.

Personas SQL Traits tackles one of the big hurdles that marketers face: data access. Quality and data completeness, two other critical parts of the equation, require a foundation of strong data infrastructure. At Segment, we call this Customer Data Infrastructure. A combined solution for companies that allows you to easily collect your customer data from a variety of different data sources and standardize it to ensure quality, all while elevating the customer as the most essential unit.

Get started with SQL Traits

If you’re already using the advanced version of Personas, the new trait type will be available in the Segment app. Try it for yourself! If you’re not currently a Personas customer or you are a Personas Essentials customer and want to learn more, request a demo here

The State of Personalization 2023

Our annual look at how attitudes, preferences, and experiences with personalization have evolved over the past year.

Get the report
SOP 2023

The State of Personalization 2023

Our annual look at how attitudes, preferences, and experiences with personalization have evolved over the past year.

Get the report
SOP 2023

Share article

Want to keep updated on Segment launches, events, and updates?

We’ll share a copy of this guide and send you content and updates about Twilio Segment’s products as we continue to build the world’s leading CDP. We use your information according to our privacy policy. You can update your preferences at any time.