The Swrve dashboard provides powerful, actionable insights into your users’ behavior and enables you to use this data to engage and re-engage the user. It is also useful to use Swrve data to re-engage users outside the Swrve platform or find corresponding audiences using tools like Facebook’s Custom Audiences. The Swrve User DB data enables you to do this. This article describes how to use the Swrve user DB data for Facebook Custom Audience creation.

Prerequisites

This guide presents an area of advanced analysis, so ensure you have completed the following:

• Fully instrumented Swrve into your app.
• Downloaded the Swrve user DB and loaded it into a database to allow querying. For a tutorial on how to automate this loading process, see Automating user DB imports.
• You are sending a mobile advertising ID such as IDFA, Android Advertising ID or Facebook App User ID to Swrve.

Swrve segments

To start, let’s look at a sample Swrve segment.

Trend Reports show important details about your segments.

Exporting lists of users and advertising IDs by segment

A good first step to take with Swrve user DB data is to attempt to replicate the data in a Swrve Trend Report with an SQL query. Since the Swrve dashboard updates multiple times a day and the user DB exports update at different times during the day, there may be discrepancies between the two reports. It’s good to understand this as a baseline so you know if further analyses need to take the discrepancy into account.

For example, to see how many users fall into the segment you’re interested in, use the following query:

SELECT COUNT(1) AS user_count,
FROM segment_membership
WHERE repeat_purchasers = 1

From here, you can start to export facts you’re interested in about your users. For example, the user’s advertising_id.

SELECT advertising_id
FROM segment_membership
INNER JOIN custom_properties
  ON segment_membership.swrve_data_id = custom_properties.swrve_data_id
WHERE repeat_purchasers = 1

Example result

Upload Custom Audience data to Facebook

With the data from your SQL query, you now have a CSV file to upload to Facebook to create your Custom Audience.