DinMo Documentation
  • 📙Core Concepts
  • Guides
    • ⚡Get started with DinMo
      • Initial Configuration of DinMo
        • Connect a Source
        • Create your Models
        • Create a Destination
      • Create and Activate Segments on DinMo
        • Create your first Segment
        • Activate your first Segment
    • 🌐Workspaces & Organizations
    • 💭Need Help?
  • Integrations
    • Data Sources
      • AWS Redshift
      • Databricks
      • Google BigQuery
      • PostgreSQL
      • Snowflake
    • Destination Platforms
      • Actito
        • Synchronize users attributes
        • Export contact lists
      • All My SMS
      • Batch
        • Synchronize contacts (MEP)
        • Synchronize profiles (CEP)
        • Send events (CEP)
      • Braze
        • Synchronize users attributes
        • Send track events
        • Synchronize subscription statuses
        • Export user lists
      • Brevo
        • Synchronize contacts
        • Export contact lists
      • Criteo
        • Export contact lists
      • Dialog Insight
        • Synchronise Contacts
      • Emarsys
        • Export contact lists
        • Synchronize contacts data
        • Synchronize custom table's data (RDS)
      • Firestore
        • Create and update Collection Documents
        • Export Audiences
      • Google Ads
        • Export audiences
        • Enhanced Conversions for Web
        • Upload click or offline conversions
          • Prerequisites and walkthrough
        • Adjust conversion events
        • Retract conversion events
      • Google Display & Video 360
        • Export audiences
      • Google Search Ads 360
      • Hubspot
        • Synchronize objects
      • Intercom
        • Export segments
        • Synchronize contacts
        • Synchronize companies
      • Iterable
        • Synchronize user attributes
        • Export contact lists
      • June Email Marketing
        • Export Contact Lists
      • Klaviyo
        • Export contact lists
        • Synchronise contacts
        • Create subscription list
      • LinkedIn Ads
        • Export user audiences
        • Export company audiences
      • Mailchimp
        • Export segments
      • Meta Ads
        • Export audiences
        • Send conversion events
      • Microsoft Ads (Bing)
        • Export audiences
      • Pinterest Ads
        • Export audiences
        • Send conversions
      • Reddit Ads
        • Export Audiences
      • Salesforce Marketing Cloud
        • Synchronize data extensions
      • SendGrid
        • Synchronize contacts
        • Export contact lists
      • Selligent
      • Snapchat Ads
        • Export Audiences
      • Splio
        • Synchronize contacts
      • TikTok Ads
        • Export Audiences
        • Send Offline Conversions
        • Send Web Conversions
      • X (Twitter)
        • Export audiences
      • Zendesk
        • Synchronize users
        • Synchronize custom objects' data
  • Models
    • Overview
    • Primary Keys
      • Detect duplicate primary keys
    • Calculated Fields
  • Identity resolution
    • Overview
  • Segments
    • Visual Builder
    • Breakdowns
    • Overlap Analysis
  • Activations
    • Overview
    • Sync Scheduling
    • Troubleshooting Syncs
      • Automatic pause or resume Activations
      • Sync warnings
  • AI PREDICTIONS
    • Overview
    • LTV and Churn
    • Product Recommendations
  • WORKSPACE MANAGEMENT
    • Set Up
    • Managing Users & Roles
    • Audit Logs
    • Enterprise Single Sign-On (SSO)
  • Security & Privacy
    • Overview
    • Networking
    • Privacy
    • Data Processing
Powered by GitBook
On this page
  1. Guides
  2. Get started with DinMo
  3. Initial Configuration of DinMo

Create your Models

Once DinMo is connected to a source, creating a Data Model teaches DinMo the business context to the tables stored in the data warehouse.

PreviousConnect a SourceNextCreate a Destination

Last updated 3 months ago

Models define which of the data stored in your source will be available to use in DinMo. They correspond to a specific table stored in your source. Models can be:

  • Segmented using our no-code segment builder

  • Activated, meaning, synchronized to destination platforms

For e-commerce, typical data model includes the following models:

  • Customers (related to the Orders Entity)

  • Orders (related to the Customers and Order Lines Entities)

  • Order Lines (related to the Orders and Products Entities)

  • Products (related to the Order Lines Entities)

Additional models (for instance, web events) are sometimes added if data is available on the source.

  • Step 1: To create your models, go to the Models section in the navigation bar.

Then, for every model of interest, do the following steps:

  • Step 2: Click "New Model" in the upper right.

  • Step 3: Specify whether the model you wish to create contains Users, Events or other types of information (Custom).

For Users models, one row should correspond to one person. For Events models, one row should correspond to one temporal event (for instance, a conversion). For Custom models, one row can represent anything.

  • Step 4: Define your model.

You can then either do it by writing an SQL query, or by picking an existing table in your source.

  • Step 5: In the second step of the creation flow, define the model's schema:

Only the ticked columns will be available in your final model. We recommend only ticking the columns you intend to use on DinMo, in order to limit the number of fields displayed. You may rename the model fields, and define some as categorical Categorical fields are properties which have a limited number of distinct values, for instance, the Product Type, or the Country. By defining a property as categorical, it will be displayed in a much more intuitive manner when creating filters using this property:

  • Step 6: Fill in the required information in the Configure page:

Give your model a display name, and optionally, a description.

Specify which field of the model corresponds to the primary key (called event id for Events models, and user id for Users models). This corresponds to the field uniquely identifying each element of the model.

To ensure that DinMo system operates smoothly and that all downstream tasks produce accurate results, it is essential to ensure the uniqueness of the primary key of each model.

For user models only, you may optionally add additional mappings to teach DinMo the meaning of specific fields (for instance, the email address).

Finally, you may map relationships between this model and other existing models.

You will need to specify for both model which field should be used as the matching key, and what type of relation it corresponds to: "HAS ONE", "BELONGS TO" or "HAS MANY". For instance, a customer has many orders, and an order belongs to a customer.

For more details, consult the corresponding section on .

⚡
Primary Keys