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.
In Cases where the dumps exceed the bucket limit, please contact our the support team to set up a splitting process before sending the dumps
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.
Note:
We send this report twice a day - first time without PST data at 8:00 UTC, then we send it again including PST data at 10:00(same file name and same location)
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.
Active User Level
The active user level data dump includes all users that were active on the app, including users who did not have any impressions and who did not generate any revenue.
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 | √ | ||||||
sdk_version | √ | ||||||
alt_device_id | √ | √ | |||||
Device model | √ | √ | |||||
OS version | √ | √ | |||||
US State | √ |
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
key legend for ad_types:
-1 - unknown
0 - Rich Media
1 - Interstitial
2 - App Wall
3 - Video
4 - Rewarded video
5 - Native
6 - Banner
7 - Offer wall
8 - Native HTML
9 - External
10 - Rewarded
11 - Interactive
Title - Name of the advertiser
Category - App category of the advertiser from the app store
Advid - Identifier of the advertiser. In case the advertiser is a domain, this field will hold the domain of the advertiser.
URL - app store url
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)
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 - Unix Timestamp 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 - Unix Timestamp of when the revenue was generated, will be the same as the time stamp of the action that caused the revenue
Click TS - Unix Timestamp of the click
Video Completed TS - Unix Timestamp of when the video was completed
Version - App version
App Package - Package Name
Placement - Placement identifier
Install Day - Date the user installed
First Day - The first day Soomla registered the user using the app
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 - Unix 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": []},
sdk_version -Add ad network SDK version
Limitations:
- The supported ad types are: Interstitial, rewarded Videos, Video
- In general, ad network SDK version format should be d.d.d / d.d.d.d (i.e 12.23.4 / 12.23.34.4)
- For following Android ad networks, SDK version format will be represented as follows:
- AdMob - afma-sdk-a-v201604999.201004000.1 (We currently don't have a way to get the version for Admob SDK)
- AmazonAds - amznAdSDK-android-5.9.0 (version - 5.9.0)
- Flurry - Flurry_Android_315_12.4.0 (version - 12.4.0)
- Millennial - 6.4.0-0220c20 (version - 6.4.0)
- Mintegral - MAL_13.1.11 (version - 13.1.11)
- Ogury - 3.3.4-moat (version - 3.3.4)
- Vungle - VungleDroid\/6.7.0 (version - 6.7.0)
- For following iOS ad networks, SDK version format will be represented as follows:
- Admob - afma-sdk-i-v7.55.1 (version - 7.55.1)
- AmazonAds - amznAdSDK-ios-3.0.0 (version - 3.0.0)
- Flurry - Flurry_iOS_258_10.0.2 (version - 10.0.2)
- Millennial - 6.8.2-e 85778a9 (version - 6.8.2)Mintegral - MI_6.3.3 (version - 6.3.3)
- HyprMx - could be (4.5.0 / ENABLED)(For Some of HyprMx SDK version we currently don't have a way to get the version and so we will send ENABLED)
Alt_device_id - Alternative Device ID is the IDFV id (since On IOS 14 the IDFA blocked)
Device model - user device
OS version - user OS version
US State - state code which impression happend