Activating Data Models

Because the queries that power your Cloud Connect Data Models can have costs associated with your database usage, Lytics doesn’t run the scheduled sync automatically.

After you've created a new Cloud Connect Data Model, you'll notice that the Status is listed as Inactive:

In order to activate, click the Activate button on the Data Model page:

Once you click the Activate button, your query will complete its first run within an hour of the Next Sync On timestamp listed under the Details tab and then continue to run at the interval you selected. During each sync, the SQL query will be run against your database, and your Lytics profiles will be updated according to the configuration defined on the Data Model.

Once synced, the Total Records metric on the Data Model summary tab may take up to 2 hours to display. This number represents the number of rows returned by the SQL query.

📘

Tip:

Each Lytics account will have a hard platform limit of 100 million records that can be retrieved and stored in any Cloud Connect Data Model. If a Cloud Connect Data Model will not be used and has been deactivated, it is best to copy the SQL and delete the model to free up space for active data models.

Data Model Field Creation

Upon activation of a Data Model, Lytics will automatically create one customer profile field which represents the membership of a user for the Data Model. Additional fields will be created if the Data Model was configured to include Activated Fields. Below is a guide for how to locate these generated fields within a customer profile or within the Audience Builder (on the Custom Fields tab)

Deactivate Data Model

If you need to disable a Cloud Connect Data Model from syncing at any point, you can do so by navigating to the Data Model and clicking the Deactivate button.

Deactivating the Data Model will not remove its corresponding fields from schema or from Lytics profiles; however, it will cause the values for these fields to become out of date. In order to completely remove the fields from schema/profiles, the Data Model must be deleted.

Total Records vs. Count of Users

Throughout the app, you may see different metrics for Cloud Connect Data Models.

Total Records within the Data Model Summary

On the summary page for your Cloud Connect Data Model, under the Total Records statistic (shown in the graph below), you will see the number of records that are selected by the query based on the unique number of primary keys in the origin database. This may be equal to or less than the number of total rows imported and may be significantly higher than the number you see in the audience builder when utilizing this Data Model.

Count of Users within the Audience Builder

When adding Cloud Connect Data Model membership or activated fields to audience logic in the Audience Builder, you may see a smaller size than the Total Records on the summary. The count of users within the Audience Builder is the number of users in your Lytics account who met the qualifications for the query based on the matching Lytics user field configured on the Data Model. This number reflects the number of records that would be included if you were to run an export of the audience.

Most common reasons for why this number may be smaller than the Total Records metric are the following:

• If the "Create New Profiles" option isn't selected on the Data Model, the count of users in the Audience Builder will only include profiles that already existed in your Lytics accounts
• Audience Builder will exclude any profiles which are marked as being Unhealthy. Learn more about unhealthy profiles here - https://docs.lytics.com/docs/user-profile-health#unhealthy-profiles

Exporting Data Models

Once activating a Data Model, its associated fields will be stored as user fields on the customer profile (to see the naming convention here) . Therefore, in order to export the members of the Data Model, you will first need to create an audience in the Audience Builder. You can create an audience of only members or layer in additional audience rules to get the most out of your customer data.

For example, you could build a Cloud Connect audience using account-level data for a B2B use case and add one of Lytics behavioral scores to refine your targeting based on your desired user engagement level.

To learn how to export audiences, visit our Activating Audiences documentation here.