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

Supported fields - Default

Supported fields - Optional

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

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 

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:

1. rev_cpm_deal
2. rev_imp_avg
3. rev_i_score
4. rev_i_score_day
5. rev_i_avg
6. rev_i_avg_day
7. rev_vc_avg
8. rev_vc_score
9. rev_clk_avg
10. rev_clk_score
11. rev_t_clk_score
12. 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:

1. The supported ad types are: Interstitial, rewarded Videos, Video
2. 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)   
3. 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)
     
     
4.  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)