Social App Audience Activation - Data Marketplace Buyer

2 days ago

OVERVIEW

Spherical’s Social App Audience Activation delivers a CSV file of Mobile Advertiser IDs (IDFAs and AAIDs) for each selected audience, directly to the client. This file can then be used to upload the audience to social app platforms for targeting use cases.

In this article you will find the process, formatting requirements, delivery options, and steps to add audiences to your file.

Disclaimer:

The Spherical Platform includes functionality that allows you to export audience files, which may include mobile advertising identifiers (MAIDs) and other data, for your use in third-party advertising and content platforms such as Snapchat and similar services.

This export feature is provided solely for your convenience and is designed to assist you in managing and deploying your data in external environments of your choosing. Lotame does not have any relationship, affiliation, integration, or data exchange with such third-party platforms, and we do not transmit any audience data to those platforms on your behalf.

When you download audience files, you will be required to agree to the following:

You are solely responsible for ensuring that your use of the data complies with:

The terms, conditions, policies, and technical requirements of any third-party platform to which the data is uploaded;

All applicable privacy, data protection, advertising, and consumer protection laws, including but not limited to laws governing the use of personal data, tracking technologies, user consent, and digital advertising practices;

Any other laws, regulations, or industry-specific standards that apply to your organization or the sector in which you operate.

You must ensure that you have obtained all necessary rights, permissions, and consents to use and disclose the data contained in the audience files for your intended purposes.

Epsilon-Lotame disclaims all liability for the use, handling, or consequences of audience files outside of our platform, including without limitation, their upload to or use on third-party platforms.

Please ensure you review and comply with the applicable policies and requirements of any platform where you choose to upload or utilize exported audience data. If you are unsure of your legal obligations, consult your legal or compliance teams prior to using this feature.

The Social App Audience Activation feature allows you to request an export file for any given audience that contains MAIDs.

A CSV file of 30 days of MAIDs (IDFAs and AAIDs) for the selected audiences is formatted so that it can be easily uploaded to several social media platforms without any manual changes. The file is delivered weekly to an sFTP or S3 location and contains 30 days of MAIDs.

Note: Lotame currently only supports the exporting of MAIDs (IDFAs and AAIDs) in this file.

These audience files can then be uploaded to social media platforms for audience targeting use cases.

Social Media Platforms

Although Lotame does not maintain direct relationships with certain offerings from the social media platforms listed below, these platforms support audience uploads via the methods described in this article.

Facebook (Note: While we still support Facebook using this method, we suggest you instead use the Meta Integration if possible)
Instagram
Snapchat
Pinterest
TikTok
YouTube (via Google Ads)

File Format Information

File Format

CSV file with a single column of MAIDs (AAIDs and IDFAs)

Format for MAIDs: 8-4-4-4-12 (Eg: AECE52E7-03EE-455A-B3C4-E57283966239)

Option 1: No header row
1. Preferred format for Snapchat & Pinterest
Option 2: With a header row “madid”
1. Preferred format for Facebook & Instagram
Option 3: With a header row “MAID”
1. Preferred format for TikTok
Option 4: With a header row “Mobile Device ID”
1. Preferred format for YouTube (Google Ads)

Note - please confirm with the social app channel what format is required for upload.

Each file contains a list of MAIDs for a particular audience ID for the past 30 days (delivered weekly).

File Name Format

Files will be delivered to a directory structure of the format <YYYYMMDDHH>/<client> or <client>/<YYYYMMDDHH>, where <YYYYMMDDHH> represents the GMT day to which the data applies, and <client> is a permanently static string identifying the data set (ex. Lotame client ID).

There will be 4 subdirectories within this:

Subdirectory 1 - named "no-header" - will contain CSV files without the header (Option 1 above)

Subdirectory 2 - named "madid" - will contain CSV files with the header "madid" for Facebook and Instagram (Option 2 above)

Subdirectory 3 - named "MAID" - will contain CSV files with the header "MAID" for TikTok (Option 3 above)

Subdirectory 4 - named "Mobile Device ID" - will contain CSV files with the header "MAID" for YouTube (Google Ads) (Option 4 above)

Filename within the directory: <audienceId>.csv

File Delivery

AWS S3 Transfer

Lotame supports delivering files to your AWS S3 bucket using our Lotame External ARN. To support, please implement a bucket policy on your s3 bucket that allows:

Access to the Lotame ARN of arn:aws:iam::311305431179:role/LotameS2SExternalRole-us-east-1
For the following S3 actions:
- s3:ListBucket
- s3:GetObject
- s3:PutObject

An example S3 bucket policy clause is below as an example:

{
  "Sid": "AllowLotameWrite",
  "Effect": "Allow",
  "Principal": {
    "AWS": "arn:aws:iam::311305431179:role/LotameS2SExternalRole-us-east-1"
  },
  "Action": [
    "s3:ListBucket",
    "s3:GetObject",
    "s3:PutObject"
  ],
  "Resource": [
    "arn:aws:s3:::<your bucket name>",
    "arn:aws:s3:::<your bucket name>/<base path for Lotame files>/*"
  ]
}

Lotame requires clients to provide the following:

AWS Bucket Name.
A directory structure, as noted below based on the s3 bucket directory you provided above.
- Either <YYYYMMDDHH>/<clientDir> or <clientDir>/<YYYYMMDDHH>.
- The <clientDir> value will be provided by Lotame, and it is static and will not change. <YYYYMMDDHH> value is the GMT date + hour of the file contents and will be created by our upload process for each file delivery.

sFTP Transfer

Lotame Hosted sFTP Server

Lotame provides an sFTP server for file transfer. When clients provide an SSH public key, Lotame will return the sFTP user account and directory path to retrieve the files.

Hostname - booth.crwdcntrl.net
Port - standard (22)

The directory structure is <YYYYMMDDHH>/<clientDir> or <clientDir>/<YYYYMMDDHH>. The <clientDir> value will be provided by Lotame and it is static and will not change. <YYYYMMDDHH> value is the GMT date + hour of the file contents and will be created by our upload process for each file delivery.

Client Hosted sFTP Server

In the case where you want the files sent to your own sFTP server, complete the following steps:

Apply the Lotame SSH key below to your server's trusted keys.

ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEA2xLuBkss5vuD86YPGPc5/YMtN5w6jRc0dcDye13nQijWgasx/64Iz4yG0adaGomkXmrbSFzy5ViK1cq561/XGXuYkjqAd2EHf2su9VFv5kfRnRtGwsfLQWrwXAdyq+CfKrc5QIH9e63DioYEC8vXoQEWYMhdlohRPxcceExdTv5PsffMCDmYjDIYTqJPO0/D2lSokJfLcQcgdkXq8jeTFXqgdEhegLaYhccOqBVrlJQyXMM5eYRrh+nGFxgOrTu02tnOXXClZbE5ysgs6ch7CLOjCBoF+COeUYpaAW+OM+SjWNVvUQC4zDRr+paIC3YKK/SWmPCixdzevGIYwdHBwQ== support@lotame.com

Provide Lotame the DNS or IP address of the sFTP server.
Provide Lotame the username that will allow our SSH key to login.
Create a directory as noted below based at the root of your username's path.

<clientDir>= Your Technical Account Manager will coordinate with naming of this directory. Once created, they are static.

<clientDir>/<YYYYMMDDHH> is the GMT date + hour of the file contents and will be created by our upload process for each file delivery.

File Delivery Frequency

Files will be delivered to you on a weekly basis. Each file is configured for a specific audience. If you require one audience to be provided in multiple file formats for multiple social app channels, we can generate multiple files. Please make sure to submit a request for each type of file format for each audience needed, and state the channel the files are needed for.

How to Use the Social App Audience Activation feature

Before you can begin exporting audience files, a one-time setup is required to configure the file delivery.

Initial Enablement (One-Time Setup)

Submit a Support ticket through this link and include the following:
1. What are you contacting Lotame about today?
  1. Platform Setup / Management
2. What area do you need help with?
  1. Other
3. In the “Other” field, provide:
  1. Target platform(s)
    1. (e.g., Facebook, Instagram, TikTok, Snapchat, Pinterest, YouTube)
  2. Lotame Audience IDs to include in the initial export
  3. Delivery method, one of the following:
    1. Deliver to client S3 bucket
    2. Deliver to client sFTP server
    3. Retrieve from Lotame sFTP server

After submission, Lotame Support will:

Validate your destination (S3 or sFTP)
Configure secure file delivery
Complete your initial setup

Note: This is a one-time setup required to enable file delivery.

When to Contact Support

Support or internal assistance is only required in the following scenarios:

Initial setup or updates to your file delivery destination.
Requesting a new file format (header)
Issues with file delivery

Delivery Expectations & Common Reasons for Delays

Audience file delivery depends on audience eligibility, platform prerequisites, and processing timing. In some cases, delivery may be deferred to a subsequent export cycle.

Factors that may impact delivery include:

Audiences that do not meet minimum Mobile Advertising ID (MAID) scale
Audiences that have expired prior to delivery
Audiences created or modified close to a scheduled export window
Required platform prerequisites not being in place

If delivery does not occur as expected, please contact Lotame Support.

Usage Reporting

Lotame customers must provide monthly reporting for audience usage in accordance with the Master Agreement for each activation channel not listed as an ABC Channel (refer to the ‘Reporting’ section under ‘Fees and Payment Terms’ in the Lotame Master Services Agreement for details).

You can find guides about how to pull usage from social channels below:

How to Disable Feature

Submit a Support ticket form through this link to disable this Social App Audience Activation feature.

Next Managed Service Only Technical Implementation: Meta - Create Application and Retrieve Token (v2)