📘 Model Overview – Creating Models in AudienceSync

🧠 Introduction

Models in AudienceSync help you define and organize data from multiple sources, making it easier to build efficient, query-ready datasets.

This guide walks you through the end-to-end model creation process—from selecting a data source to defining your model using SQL, Table Selector, or dbt.

🗂️ Understanding the Model Creation Workflow

The model-building process in AudienceSync is streamlined across six main steps:

✅ Step 1: Navigate to the Models Section

Log into your AudienceSync dashboard.

From the sidebar, click Define → Models.

➕ Step 2: Add a New Model

Click Add Model to start.

Choose your preferred modeling method:

SQL Query

Table Selector

dbt Model

🛢️ Step 3: Select a Data Source

Choose a connected data warehouse from your list of integrations.

This will serve as the foundation for your model.

⚙️ Step 4: Select a Modeling Method

Choose one of the following:

SQL Query – Write a custom query to define your model.

Table Selector – Use a visual interface for building models.

dbt Model – Reference prebuilt dbt models for advanced transformation.

✍️ Step 5: Define Your Model

If using SQL Query:

Write your SQL directly in the editor.

Click Run Query to preview results and confirm the structure.

🏁 Step 6: Finalize Your Model

Provide a descriptive name and brief description for clarity and future reference.

🔑 Unique Primary Key Requirement

Every model must include a unique primary key.

Why it matters:

A unique key ensures each record can be uniquely identified.

It's critical for accurate data synchronization—tracking only new or updated rows.

How to configure:

During model setup, select a column with unique values.

If no such column exists, consider creating a composite key or transforming the data to ensure uniqueness.

Once complete, your model is ready for activation within AudienceSync!

Intro to Models