Persona assignments in RDS (SQL Server)

Why use predictions for persona assignments?

Ah personalization, the holy grail of growth teams everywhere. Too bad it’s so difficult to do well.

The best way to personalize email is the simplest: organize your customers into personas, then produce straightforward variations of your email content for each persona. This way, you can have both copy and creative perfectly aligned with the interests of each persona so that your customers feel like you get them.

Faraday makes discovering your brand's bespoke personas intuitive & easy, and delivering them to any channel in your stack a breeze.

With persona assignment predictions in RDS (SQL Server), you'll give your team the ability to personalize engagement to perfection through insights from AI-generated personas.

Follow the steps below to get your persona assignments predictions into your RDS (SQL Server) account.


In this guide, we'll show you how to:

  • Organize your customer data into cohorts
  • Describe prediction models for personas with persona sets
  • Deploy persona assignments predictions to RDS (SQL Server) using Pipelines

Getting started with persona assignments in RDS (SQL Server)

Make sure you have a Faraday account (signup is free!) and that it's not in test mode.

Requirements for this persona assignments recipe

You'll need the following cohorts available in your Faraday account:

Screenshot of the cohorts listing that includes Customers You'll also need the following connections available in your Faraday account:

Screenshot of the connections listing that includes RDS (SQL Server)

Building predictions for persona assignments in RDS (SQL Server)

Now you'll create the prediction objective(s) necessary to complete this use case with Faraday.

Getting started with RDS (SQL Server) personalization

Persona sets use machine learning to organize people into unique, coherent subgroups (called personas) that you can use to personalize your outreach.

Creating a persona set for your Customers

Let's make a persona set that organizes your customers into personas.

  • In the navigation sidebar, choose Persona sets. Screenshot of the persona sets list
  • Click the New persona set button.
  • Fill out the form:
    • For Choose a cohort, pick the cohort that best represents your customers.
    • Leave the advanced settings at their defaults.
    • Enter a memorable name, like "Customers". Screenshot of the new persona set form, filled out
  • Click the Save persona set button.

Faraday will do some magic in the background, so you can proceed with the rest of the instructions. When your persona set is done building, you'll get an email, and you can review your personas.

Screenshot of the persona sets listing that includes Customers

Using Pipelines to deploy predictions to your stack

Now you'll configure the pipeline that deploys your predictions to aws_rds_sql_server.

Create your pipeline for persona assignments in RDS (SQL Server)

  • In the navigation sidebar, choose Pipelines. Screenshot of the pipelines list
  • Click the New Pipeline button.
  • Fill out the form:
    • For Payload, choose the following:
      • Persona set: Customers
    • For Population to include, choose the following:
      • A cohort representing your customers
    • Enter a memorable name, like "Persona assignments in RDS (SQL Server)". Screenshot of the new pipeline form, filled out
  • Click the Save pipeline button.

Your pipeline will start building in the background. You can proceed immediately with the next set of instructions.

Deploying your pipeline to RDS (SQL Server)

RDS (SQL Server)

  • In the Deployment area, find the RDS (SQL Server) module and click Add. Screenshot of the ready pipeline with no targets yet
  • Fill out the popup:
    • Provide the specified parameters for RDS (SQL Server).
    • Click Next.
    • Choose the Identified option.
  • Click the Next button. Screenshot of the new target form, filled out
  • Skip the "Advanced Settings" by clicking the Finish button.
  • Click the Finish button.
  • Click the Test deployment button and confirm the results meet your expectations. Screenshot of a target after hitting its test button the first time Faraday will finish building your pipeline in the background. When it's done, you'll get an email—return to the pipeline and click the Enable pipeline button to activate it.

How to use your persona assignments predictions in RDS (SQL Server)

With your pipeline deployed, your persona assignments are loaded into a CSV and ready to be plugged into your favorite marketing activation platform, where you can kick off personalized campaigns.

🔒 It's a best practice to permanently delete any file that contains personally identifiable information (PII) after use. Any deployment from Faraday that is unhashed contains PII, and should be deleted after uploading it to your destination for security purposes.