Data Models & Queries (Legacy)

Creating Cloud Connect Audiences

Once you have established a Connection, you can write SQL queries directly in Lytics UI to generate profile attributes and audiences. In the Lytics Audience Builder, there are a few changes pertaining to Cloud Connect.

CC-Audience-SQL-holiday

Data Source: This is a new step where you choose to build your audience based on real-time data from Lytics User Profiles or batch data from your data warehouse. All existing audiences are based on the Lytics User Table. You will see your established Connections in the drop-down menu with Cloud Connect enabled.

Audience Definition: When you select a Cloud Connection as your data source, the audience builder will convert to the new SQL Editor.

Query Editor: Write and test standard SQL queries directly in Lytics. Alternatively, copy and paste queries you've tested in your BigQuery or Snowflake instance. When you click Test Query, Lytics will return 100 sample records.

Schema Explorer: Validate that the data from your established Connection appears as expected. You can click into a table from your established Connection to see available fields you can utilize in your query.

Map a Unique Identifier: Select a Lytics user profile field that is a unique identifier to map to an identifier in your incoming data source.

πŸ“˜

When building multiple Cloud Connect audiences with the same connection, data table, and primary key you must select the same Lytics User Field mapping as the existing audience. Selecting a different user field may result in an error when you try to save the new audience.

Query Frequency: Select the interval to rerun the query to keep the audience members updated. The beta options are currently every 1 to 24 hours.

Example Use Case

Consider this scenario to demonstrate why you'd want to create a Cloud Connect audience instead of a standard Lytics audience. Your company sells e-bikes and wants to run a holiday campaign that sends a promotion to any customer who purchased an e-bike in November or December last year. Perhaps you also want to refine your audience to those who are interested in particular bike brands. All of this purchase and product data already exists in your Google BigQuery instance (as shown below).

BQ-SQL-holiday-sample

Instead of directly importing all that purchase history data into Lytics, you can write a SQL query to find which customers meet this audience criteria. By copying this query directly into the Lytics Audience Builder (as shown in the previous screenshot), you'll create a new audience in Lytics that will be updated on the frequency interval you decide.

Once created, your new Cloud Connect audience will appear in your audiences list. The green cloud icon distinguishes Cloud Connect audiences from standard Lytics audiences.

cloud-connect-audiences-list