Data dumps are the best way to get all the data from SOOMLA into your BI platform. There are multiple types of data dumps in different granularity levels designed to fit different use cases.

Supported storage infrastructures

AWS S3
Google Cloud Storage

Types of Data Dumps

User Level

The user level data dump provides an aggregated user level look at all the data for a specific day. The data is broken down by user, date, platform, network, ad type, and country.

Advertiser Level

The advertiser level report provides data on the advertiser level inside your app. This data is broken down by ad title, day, platform, country, network and ad type.

App Level

The app level report provides an aggregated look at the data in your app. This data is broken down by day, platform, country, network and ad type.

User and Advertiser

The user and advertiser level report provides an aggregated look at user level data in your app per advertiser they have seen. This data is broken down by user, advertiser, country, ad network, and ad type.

User and Advertiser Clicks

The user and advertiser clicks level report provides an aggregated look at the advertisers a user has clicked on in your app. This data is broken down by user, advertiser, country, ad network, ad type, and click.

Waterfall Stats

The user and advertiser clicks level report provides an aggregated look at revenue generated by each impression number in your app. This data is broken down by impression number, date, platform, country, ad network, and ad type.

Impression Level

The impression level report provides all the data for each impression in your app to provide a granular look at user activity. This data is broken down to a very granular level with all the information SOOMLA has on each impression provided.

Supported fields

Field	User	Advertiser	App	User and Advertiser	User and Advertiser Clicks	Waterfall	Impression
impressions	√	√	√			√
revenue	√	√	√	√		√	√
clicks	√	√	√			√
user_id	√			√	√		√
device_id	√						√
activity_date	√					√
day		√	√
platform	√	√	√			√	√
country	√	√	√	√	√	√	√
ad_network	√	√	√	√	√	√	√
ad_type	√	√	√	√	√	√	√
title		√		√	√
category		√		√	√
advid		√		√	√		√
advit		√		√	√		√
url				√	√
ts					√		√
imp_num						√
app_key							√
revenue_ts							√
click_ts							√
video_completed_ts							√
version							√
app_package							√
placement							√
install_day							√
traffic_source							√

Fields Description

Impressions - Number of times a user has seen an ad

Revenue - Amount of revenue generated

Clicks - Number of times a user clicks

User ID - Unique user level identification

Device ID - IDFA (Identification for advertisers)

Activity Date - The date when the activity took place

Day - Date of the aggregated activity

Platform - IOS or Android

Country - Country where the action took place

Ad Network - Network that displayed the ad where the action was taken

Ad Type - Name of the ad type

Title - Name of the advertiser

Category - App category of the advertiser from the app store

Advid - Numerical identifier of the advertiser

Advit - Type of Advid ID given as a numerical value

-1 = UNKNOWN
0 = DOMAIN
1 = PACKAGE_NAME
2 = AMAZON_ID
3 = ITUNES_ID
4 = APP_NAME

URL - URL of the advertiser

TS - The time stamp of when the action took place, either impression or click. This will be the same as the time stamp for the click, impression, or other action that took place.

Imp Num - Impression number in the sequence of a user, if it is the first impression a user has made it would be 1 and so on

App Key - Unique application identifier from SOOMLA

Revenue TS - Time stamp of when the revenue was generated, will be the same as the time stamp of the action that caused the revenue

Click TS - Time stamp of the click

Video Completed TS - Time stamp of when the video was completed

Version - App version

App Package - Package Name

Placement - Placement identifier

Install Day - Date the user installed

Traffic Source - Source of the users install