Singular Data Destinations (ETL) is a premium feature. If you're interested in using this feature, reach out to your Customer Success Manager.
Singular can feed data directly into your data warehouse, storage service, or BI platform, where you can use your own BI and visualization tools to process and analyze the data.
By setting up data destinations, you can get your Singular data pushed into your storage service or platform at regular intervals - without requiring any engineering work on your side to implement Singular's Reporting API or process internal BI postbacks.
Which platforms are supported as destinations?
What data can be exported?
You can use data destinations to export two types of data:
Aggregated marketing data including ad spend (campaign cost), creative data, install and re-engagement stats, and other KPIs Singular pulls from ad networks and MMPs, broken down by source (network), app, os, country, and other dimensions. When exporting this type of data, Singular queries it through the Singular Reporting API and pushes it to the data destination.
For full details about the data you can export this way, see Data Destinations: Aggregated Marketing Data Schemas.
User-level data from Singular's attribution logs, including attributions (conversions) and in-app events. This data is available if you are using Singular's attribution service (for mobile, for web, or cross-device). This data resembles what's you would see when you download attribution logs.
For full details about the data you can export this way, see Data Destinations: User-Level Data Schemas.
How often is the data refreshed?
Aggregated marketing data is typically pushed every 6 hours, while user-level data (attributions and events) is pushed every hour.
Note that this does not necessarily represent the freshness of the data, which depends on other variables, including the data source used by Singular.
For user-level data, you can expect 95% of events to be exported to your system within 3 hours after they occurred. A small minority of events may take a longer time to be processed and exported.
How do I set up data destinations?
If data destinations are enabled for your account, you will be able to add new destinations through the Data Destinations page. Log into your Singular account, go to Settings > Data Destinations, and click Add a New Destination to display a list of the supported destinations for your account.
The destinations marked "User-Level" are used to export user-level attributions and events. The others are used to export aggregated marketing data.
However, before you add the destination in Singular, you usually need to perform some configuration steps in the partner platform, e.g. to give Singular permissions to push data to the platform. For instructions for setting up a specific data destination, find the desired destination in the Data Destinations section.
How can I deduplicate the data?
Singular data destination exports don't have a unique key for each row of data. Instead, the data is partitioned, and whenever any information in one of the partitions is changed, Singular fully replaces the existing partition with the new one.
In S3 destinations, each partition is in a separate file. When you process the files, you should look for files that have changed and fully replace your existing data with the new data.
The partition key depends on the type of data:
|Export Type||Partition Key|
|Aggregate data (e.g. "S3 Destination")||Date|
|User-level data (e.g. "S3 User-Level Destination")||Hour (etl_record_processing_hour_utc)|
|Ad revenue user-level data (e.g. "S3 Ad Revenue User-Level Destination")||Date|