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

File format:

As default we will generate JSON files, however you can ask for CSV format(with or without headers) - for that please contact Soomla CS team.

As default the files will be delivered uncompressed, you can ask to get then compressed by GZIP.

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 - Default

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	√	√	√	√	√	√	√
ts					√		√
imp_num						√
revenue_ts							√
click_ts							√
video_completed_ts							√
app_package							√
traffic_source							√

Supported fields - Optional

Field	User	Advertiser	App	User and Advertiser	User and Advertiser Clicks	Waterfall	Impression
revenue models **							√
ad_types_names	√	√	√	√	√	√	√
extra_uid	√			√	√		√
upload_date	√	√	√	√	√	√	√
advertisers_info - title		√		√	√
advertisers_info - category		√		√	√
advid		√		√	√		√
advit		√		√	√		√
advertisers_info - url				√	√
app_key							√
custom_data							√
version							√
click_score							√
placement							√
install_day(first_day)							√
install_ts							√
creative							√

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

Advit - Type of Advid ID given as a numerical value (at imp_all report - this field will present numerical value as default, however you can ask CS team to provide an explicit values instead)

URL - app store url

Advid - Numerical identifier of the advertiser

id	adv type	data dump value	description
-1	UNKNOWN	other
0	DOMAIN	www	Ad network's internal name of the advertiser (not full url)
1	PACKAGE_NAME	googleplay	Google store package name
2	AMAZON_ID	amazon	Amazon store id
3	ITUNES_ID	appstore	iTunes id
4	APP_NAME	appname	App name in the store (We don't have an indiction for the exact store)
5	DIRECT	other	Advid is link to download the APK

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. For banners and native the value of imp num is not calculated so imp_num = -1.

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

ad_types_names - Add type names

extra_uid - Extra user id from the SDK

upload_date - the date of uploading the file

install_ts - timestamp of install app after impression

click_score - the click score (can be 0 or 1)

custom_data - publisher custom data that sent using the SDK (JSON object)

Revenue models - The report will include these additional columns:

rev_cpm_deal
rev_imp_avg
rev_i_score
rev_i_score_day
rev_i_avg
rev_i_avg_day
rev_vc_avg
rev_vc_score
rev_clk_avg
rev_clk_score
rev_t_clk_score
rev_t_clk_avg

creative - provides with the creative details on key value pair, includes the following keys:
creative_type, video_urls , end_card_urls, image_urls, icon_urls, source_urls
example:


"creative": {
 "creative_type": "video",
 "video_urls": [
 "https://www.youtube.com/watch?v=AUsP-d4"
 ],
 "end_card_urls": [
 "https://lh3.googleusercontent.com/E9I4vh6U6Hc2fOX5nX2_7LH_I576-LtzL6KbRdMTb6pVsdWNeh_ZhmfbYSSjDn4Q=rw-v2",
 "https://lh3.googleusercontent.com/gJ2_7DCknQQ97ukQDakLQ9bW_u0pG7ycCVbD5A677EfJFlYFQceZiK_f5aZpCKLRABk=rw-v2",
 "https://lh3.googleusercontent.com/BEJbqXrw73uUAkjHhAY7lGwumzwttr7xo5WonTqBnmDBMbJixVNAid1IpHDWcg6Kc7w=rw-v2",
 "https://lh3.googleusercontent.com/pZEp5YGiuBBxBp4rnIMrsn1OzvAFx0nsGqX5-fPAsyjrXOjJ2GTmyT-bmp_uS9_fnW18=rw-v2"
 ],
 "image_urls": [
 "https://lh3.googleusercontent.com/xwphCxXlzI_B-r1kMk2kAgQ_24-vGpKm0KgwY_wNe_fh4NYms4RHEOrW0Q97pIPHCN2jw=w215-h215-rw"
 ],
 "icon_urls": [],
 "source_urls": []},