Docs
Sign up now
  • Getting started
    • Welcome to Sortment
    • Core Concepts
  • Schema
    • Overview
    • Related and Events Table
    • Setting Up Related Table
    • Setting Up Events Table
    • Custom Properties
  • ENGAGE
    • Audiences
      • Creating Audience
      • Audience Filters
      • Campaign Event Filters
      • Creating Audience Using SQL Builder
      • Managing Audiences
      • Audience Insights
    • Traits
      • Use Cases
      • Calculated Traits
        • Advanced Mode
      • Dynamic Traits
    • Profiles
      • User Profile View
    • Campaigns
      • Overview
      • Building a Campaign
      • Campaign Reports
        • Glossary
      • Conversion Tracking
  • Journeys
    • Getting Started
    • Journey Builder
    • Journey Components
      • Trigger
      • Delays
      • Flow Control
      • Action blocks
    • Tutorial: Creating a journey
    • Journey Settings
  • Connector
    • Overview
    • Getting started
      • Iterable
      • Klaviyo
  • Enable Data Sync
  • Setup
    • Data Warehouses
      • Snowflake
      • BigQuery
      • Redshift
      • Databricks
      • PostgreSQL
    • Cloud Bucket Storage
      • Amazon S3 for Snowflake
      • Google Cloud Storage for BigQuery
      • Amazon S3 for Redshift
      • Amazon S3 for Databricks
    • Communication Channels
      • Email
        • SendGrid
        • SES
        • Mailmodo
      • SMS
        • MSG91
        • Gupshup
      • WhatsApp
        • Meta (Facebook)
          • Add new Phone Number to Meta
        • Gupshup Enterprise
        • WATI
        • Gallabox
        • Yellow.ai
        • Kaleyra.io
    • Real-time Events
      • Setting up Event Source
      • Whitelist Event Payload
  • Settings
    • Sync Schedules
    • Audit Logs
    • Subscription Groups And Contact Fields
    • Delivery Controls
    • Test Profiles
    • Alerts
  • Data and Security
    • Technical Overview
    • Warehouse Data Practices
    • Data Access And Usage
    • Security Compliance
    • Audit Logs
    • Privacy Policy
Powered by GitBook
On this page
  • 1. Overview
  • 2. Data Flow Architecture
  • 3. Key Features of Sortment
  • 5. Integration with Existing Client Systems

Was this helpful?

  1. Data and Security

Technical Overview

This document explains the technical architecture for Sortment, designed to help understand how data flows across the platform.

PreviousAlertsNextWarehouse Data Practices

Last updated 5 months ago

Was this helpful?

1. Overview

Sortment uses a modular, scalable, and warehouse-native architecture that enables effective omnichannel messaging. This setup ensures that marketing and data teams can efficiently manage user events, campaigns, and messaging workflows while leveraging clean, actionable data directly from the data warehouse.

Key Components

  • Data Warehouse (e.g., Snowflake, BigQuery)

  • Bucket Storage (e.g., S3, Cloud Storage)

  • Segmentation Engine

  • Journey Orchestrator

  • Events Consumer (Kafka-based)

  • Notifications Layer (Email, WhatsApp, SMS)

  • Data Sources (Apps, Websites, Segment, Rudderstack)

  • Campaign Automation and Analytics

2. Data Flow Architecture

The data flow within Sortment architecture can be broken into four main phases:

Phase 1: Audience Segmentation and Campaign Orchestration

  1. Segmentation Engine:

    • The team can create user segments on the Data Warehouse using visual builder or AI based on event properties and profiles. This engine converts the filters into queries.

    • Segmentation results can be fed into downstream systems for campaign execution.

    • Audience creation supports SQL-based queries and CSV imports for flexibility.

  2. Campaign Automation:

    • Marketers can use a user-friendly campaign and journey builder to trigger automated messages, reducing reliance on engineering teams.

  3. Journey Orchestrator:

    • Accesses profiles stored in Bucket Storage. This is refreshed at regular sync from Data Warehouse

    • Consumes journey-related events from the Events Consumer.

    • Orchestrates complex user journeys based on real-time and historical data.

Outcome: Audiences are segmented, and dynamic journeys are triggered based on user behaviors and profiles.


Phase 2: Real-Time Event Processing

  1. Data Sources: Events are generated from multiple sources, including:

    • Applications (mobile or web)

    • Websites

    • Third-party CDPs (Segment, Rudderstack)

  2. Event Delivery: These real-time events are sent to the Events Consumer, which is built on a Kafka-based infrastructure to handle high-throughput data streams.

Outcome: Events are ingested in real-time and persisted for campaign conversion tracking and journey triggers and filters.


Phase 3: Event Storage and Campaign Persistence

  1. Events Consumer:

    • Persists all campaign-related events into Bucket Storage (e.g., Amazon S3, Cloud Storage).

    • Sync events to the Data Warehouse for analytical querying.

  2. Profiles Sync:

    • User profiles and event data are regularly synced between the Data Warehouse and Bucket Storage.

  3. Real-Time Capabilities:

    • Events can be used to trigger real-time campaigns with sub-second latency via APIs.

Outcome: Data is stored back in warehouse, available for querying, and ready for real-time campaign triggering.


Phase 4: Omnichannel Campaign Execution

  1. Campaign Event Delivery:

    • The Events Consumer sends campaign events to the Notifications Layer.

  2. Notifications Layer:

    • Distributes messages across multiple channels:

      • Email

      • WhatsApp

      • SMS

  3. Feedback Loop:

    • Events generated from campaign engagement (e.g., opens, clicks, purchases) are sent back as real-time events to the Events Consumer and then Data Warehouse for further processing and analysis.

Outcome: Marketing messages are delivered across preferred channels with real-time triggers and automated workflows.


3. Key Features of Sortment

Warehouse-Native Architecture

  • Direct integration with data warehouses (e.g., Snowflake, BigQuery) ensures real-time access to clean, actionable data without creating data copies.

  • Enables teams to work with accurate and up-to-date data while maintaining security and compliance.

Real-Time Capabilities

  • Supports real-time message triggering with sub-second latency via APIs.

  • High-throughput Kafka-based ingestion ensures scalability for large event volumes and accuracy.

Segmentation and Audience Creation

  • SQL-based and CSV-supported audience creation enables advanced segmentation for campaigns.

  • Segmentation engine allows flexible, self-serve queries for building target audiences.

Campaign Automation

  • Intuitive journey builder to automate customer experiences across channels.

  • Reduces dependency on engineering teams for campaign execution.

Analytics and Insights

  • Provides self-serve insights for measuring campaign performance directly from warehouse data.

  • Allows for experimentation (A/B testing) to improve campaign strategies.

Privacy and Security

  • Warehouse-native architecture eliminates data duplication.

  • Granular access control, secure connections, and SOC 2 certification ensure privacy and compliance.


5. Integration with Existing Client Systems

Sortment is designed to integrate seamlessly with existing client data ecosystems. Below are key integration points:

  • Data Ingestion:

    • Connectors for popular CDPs like Segment and Rudderstack

    • APIs for direct event streaming

  • Data Warehouse Integration:

    • Support for Snowflake, BigQuery, Redshift

  • Storage Compatibility:

    • Cloud providers like AWS S3 and GCP Cloud Storage

  • Notification Platforms:

    • Email providers (e.g., SendGrid, SES)

    • WhatsApp

    • SMS


For further details or queries, please to us.

reach out
Sortment architecture diagram