Loading data into Snapchat Audiences

This guide explains how to load data into Snapchat Audiences for further analysis.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

  • Create a datastream whose data you want to load into Snapchat Audiences. For more information on creating a datastream, see Creating a datastream.

  • Ensure the data extracts of the datastream contain a field that can be used to identify users. This field must be one of the following:

    • Email

    • Phone number

    • Mobile advertising ID

    If you use phone number, ensure the values include the international dialing code.

    Adverity encrypts the identifier fields to ensure that your data is anonymized.

Procedure

To load data from a datastream into Snapchat Audiences, follow these steps:

  1. Add Snapchat Audiences as a destination to the workspace which contains the datastream or to one of its parent workspaces.

  2. Assign the Snapchat Audiences destination to the datastream.

    You can assign as many destinations to a datastream as you want.

    Some destinations require specific Data Mapping, such as Hubspot and Facebook Offline Conversions. If these Data Mapping requirements conflict, the destinations cannot be assigned to the same datastream.

  3. Configure the Data Mapping of your datastream to conform with Snapchat Audiences destination standards.

  4. Configure load settings.

  5. Enable data loading into the destination from the datastream.

Adding Snapchat Audiences as a destination

To add Snapchat Audiences as a destination to a workspace, follow these steps:

  1. Go to the Destinations page.

  2. Click + Create destination.

  3. Search for and click Snapchat Audiences.

  1. Choose how to authorize Adverity to access Snapchat Audiences:

    • To use your details, click Access Snapchat Audiences using your credentials.

    • To ask someone else to use their details, click Access Snapchat Audiences using someone else's credentials.

      If you choose this option, the person you ask to create the authorization will need to go through the following steps.

  2. Click Next.

  1. Log in to your Snapchat Audiences account.

  1. In the Configuration page, fill in the following fields:

    Name

    (Optional) Rename the destination.

    Ad Account

    Select the account into which you want to load data.

  1. Click Create.

Assigning Snapchat Audiences as a destination

To assign the Snapchat Audiences destination to a datastream, follow these steps:

  1. Go to the Datastreams page.

  2. Open the chosen datastream by clicking on its name.

  1. In the Load section, click + Add destination.

  1. Select the Snapchat Audiences checkbox in the list.

  2. Click Save.

  3. For the automatically enabled destinations, in the pop-up window, click Yes, load data if you want to automatically load your previously collected data into the new destination. The following data extracts will be loaded:

    • All data extracts with the status collected if no other destinations are enabled for the datastream

    • All data extracts with the status loaded if the data extracts have already been sent to Adverity Data Storage or external destinations

    Alternatively, click Skip to continue configuring the destination settings or re-load the data extracts manually. For more information, see Re-loading a data extract.

Configuring Data Mapping for Snapchat Audiences

All data that you load into Snapchat Audiences must conform with Snapchat Audiences standards.

To configure Data Mapping for the Snapchat Audiences destination, follow these steps:

  1. Go to the Datastreams page.

  2. Open the chosen datastream by clicking on its name.

  3. In the top navigation panel, click Data Mapping.

  4. In the Source Fields column, find the field in the data extract used to identify users. This field must be one of the following:

    • Email

    • Phone number

    • Mobile advertising ID

  5. In the cell in the Target fields column in the user identifier's row, write one of the following and press Enter. If you cannot find any value, click + Create new to create the target field with type string.

    • If email is the user identifier, write email.

    • If phone number is the user identifier, write phone.

    • If mobile advertising ID is the user identifier, write mobile_ad_id.

    For more information on adding a new field to the Data Mapping, see Mapping source fields.

The Data Mapping changes are saved automatically.

Configuring settings for loading data into Snapchat Audiences

To configure the settings for loading data into Snapchat Audiences, follow these steps:

  1. Go to the Datastreams page.

  2. Open the chosen datastream by clicking on its name.

  1. In the Load section, find the Snapchat Audiences destination in the list, and click Actions on the right.

  2. Click Destination settings.

  1. Fill in the following fields:

    Identifier

    Select the column in the data extract used to identify users. This is the same column you used when you configured the Data Mapping for the datastream.

    List Mode

    Select one of the following:

    • Select Update Existing to add data from the data extract to an existing table.

    • Select Create New List to create a new table for each data extract.

    Custom Audience Name Template

    This field is available when you select Create New List in List Mode. Specify the target table in the destination into which to load data from the datastream. The name can contain alphanumeric characters and underscores. For example, target_table. To specify a schema, use the syntax schemaName.tableName.

    By default, Adverity saves data from each datastream in a different table named [{datastream_name}] Custom Audience (for example, [mailgun_83] Custom Audience).

    • To create a new Snapchat Audiences spreadsheet containing the data you load into Snapchat Audiences, enter a name for the new spreadsheet into this field.

    You can use the following placeholders when creating new table names in the destination:

    Placeholder

    Description

    {datastream_id}

    The datastream ID.

    {datastream_name}

    The datastream name.

    {datastream_type}

    The data source.

    {filename}

    The automatically generated filename of the data extract.

    {scheduled_day}

    The day when the data fetch was scheduled to run.

    {scheduled_month}

    The month when the data fetch was scheduled to run.

    {scheduled_year}

    The year when the data fetch was scheduled to run.

    Custom Audience

    This field is available when you select Update Existing in List Mode. Select the table in the destination into which you want to load data. You can only select tables created by Adverity. You cannot select tables created within Snapchat Audiences.

    Retention in days

    Specify the number of days for which to keep data in the destination.

  2. Click Save.

Enabling data loading into Snapchat Audiences destination

To enable data loading into the Snapchat Audiences destination from the datastream, follow these steps:

  1. Go to the Datastreams page.

  2. Open the chosen datastream by clicking on its name.

  1. In the list in the Load section, find the Snapchat Audiences destination, and enable the toggle.

  2. In the pop-up window, click Yes, load data if you want to automatically load your previously collected data into the newly enabled destination. The following data extracts will be loaded:

    • All data extracts with the status collected if no other destinations are enabled for the datastream

    • All data extracts with the status loaded if the data extracts have already been sent to Adverity Data Storage or external destinations

    Alternatively, click Skip to only load data extracts collected in the future or re-load the data extracts manually. For more information, see Re-loading a data extract.