Import an Audience from your Data Warehouse

In general, audiences should be created in Lytics using the audiences builder, then pushed to actioning platforms via built-in integrations. These audiences update in real-time and can be automated to keep downstream tools in sync.

However, in some cases, there are more narrow and targeted audiences of users who you need to target for one-off campaigns or pushes to downstream tools. In these cases, we recommend creating the audience in your data warehouse then pushing that group of users to Lytics.

Examples of audiences to build in Lytics:

• Users who have visited the site in the last week
• Users who purchased a product within the last three days
• Users who opened an email and have not logged in yet

Examples of one-off audiences to push from an external querying tool:

• Users who attended event A and purchased a product over $100 two quarters ago
• Users who visited a booth during conference A and, on average, ordered at least three products per month over the last two years
• Users who should receive a promotional offer based on a list provided by an outside agency

Pushing a one-off audience to Lytics

In this example, we’ll use Google BigQuery as our data warehouse and querying tool.

Once notifying your account manager, your Lytics instance will be configured to pull data from a table called lytics_custom_audience_push with the following schema:

• customer_id (string)
• custom_audience_name (string)
• custom_audience_value (string)

Instructions

1. Create a table called lytics_custom_audience_push with the above schema.
2. Write your query. The query output must have three columns: the audience name, the audience value, and the customer id.
3. Under query settings, set lytics_custom_audience_push as the destination table for your query results.
4. Lytics pulls data from lytics_custom_audience_push on a rolling basis, so you should see the custom_audiences field in Lytics populate within roughly 6 hours (max).

Example

Let’s say you need to push an audience of VIP users selected for targeting based on their purchase history and attendance at an event.

SELECT user_id, 
       "vip_users" AS custom_audience_name, 
       "true"      AS custom_audience_value 
FROM   user_db u 
       JOIN event_db e 
         ON e.id = u.event_id 
WHERE  u.purchase_avg > 50 
       AND u.purchase_num > 5 
       AND e.id IN ( 748, 573, 934 )

Your lytics_custom_audience_push table should look something like this:

After this query is pushed to the lytics_custom_audience_push table, you can use it in the Lytics audience builder under the custom_audiences field.

Notes

• The lytics_custom_audience_push table is configured to accept strings as values. If you need to push a different data type for the value, let us know. We can also configure a table and mappings for integers, floats, and timestamps.
• One-off audience pushes are typically used for one downstream campaign. If you find yourself repeatedly targeting a one-off audience, talk to your Lytics account manager to have that audience reconfigured as a user attribute.
• If you are using a different data warehouse, you can send the table as a CSV to an SFTP server or S3 bucket for Lytics to pull.