User-level Exports

When using the Singular platform, you can access your raw user-level data through our "Export logs" screen.

Using the export tool:

  1. Choose the relevant date range.
  2. Choose the "Unified Exports". The Unified Exports includes a new naming system for the fields, better typings (e.g. ISO 8601 timestamps), and additional fields. Please note, the data in the Unified Exports is only available starting 2018-02-22.  
  3. Select the app.
  4. Select the relevant app site.
  5. Choose the type of the records that you want to export.
  6. Drag and Drop the relevant fields you would like to export. 
  7. (Optional) Add a filter on specific partners.
  8. Click "Export".

Export_Logs.png

A few things to notice:

  • The current export is limited to 5M records per each request. We suggest limiting your date range (i.e. to a single day) in order to prevent reaching this limit.
  • If you would like to change the list of fields exported by default in your log export, or add a request for a new field to be exported, feel free to contact your account manager.
  • The timestamped fields (e.g. touchpoint__timestamp) will be exported in your configured timezone. Timestamps that are unix-time based (e.g. touchpoint__unix_timestamp) are in the UTC timezone.

 

Supported fields per event type:

Clicks:

 

Field Name Meaning Example
GAID SHA1 The sha1 of the gaid of the touchpoint ffa6706ff2127a749973072756f83c532e43ed02
GAID MD5 The md5 of the gaid of the touchpoint 128ecf542a35ac5270a87dc740918404
GAID The Google Advertising Id of the touchpoint dcd84702-d175-41ab-adfa-9f4ff9d49316 
Android ID SHA1 The sha1 of the aid of the touchpoint ffa6706ff2127a749973072756f83c532e43ed02
Android ID MD5 The md5 of the aid of the touchpoint 128ecf542a35ac5270a87dc740918404
Android ID The Android Id of the touchpoint dcd84702-d175-41ab-adfa-9f4ff9d49316 
App Longname The app longname of the touchpoint com.example.amazing_app
Extra The extra fields of the touchpoint redirect=false&rt=json&game_id=123233
IDFA The idfa of the touchpoint dcd84702-d175-41ab-adfa-9f4ff9d49316
IDFV The idfv of the touchpoint  >dcd84702-d175-41ab-adfa-9f4ff9d49316
IDFA SHA1 The sha1 of the ifa of the touchpoint ffa6706ff2127a749973072756f83c532e43ed02
IDFA MD5 The md5 of the ifa of the touchpoint 128ecf542a35ac5270a87dc740918404
IP The IP address of the touchpoint 10.20.30.40
Is Re-engagement If the touchpoint was drove by a re-engagement campaign  true/false
Campaign The partner campaign of the touchpoint 128ecf542a35ac5270a87dc740918404
Campaign ID The partner campaign id of the touchpoint Chartboost_IOS
Campaign Name The partner campaign name of the touchpoint Charboost_Example_IOS
Click ID The partner click id of the touchpoint 128ecf542a35ac5270a87dc740918404
Creative The partner creative of the touchpoint EMEA_30seconds_LUKE
Creative ID The partner creative id of the touchpoint 128ecf542a35ac5270a87dc740918404
Creative Name The partner creative name of the touchpoint EMEA_30seconds_LUKE
Partner The partner name (network name) of the touchpoint Facebook
Publisher The partner publisher of the touchpoint 1235551
Publisher Concatenated The partner publisher (concat) of the touchpoint 1235551
Publisher ID The partner publisher id of the touchpoint 1235123
Publisher Name The partner publisher name of the touchpoint My Awesome App
Sub Campaign The partner sub campaign of the touchpoint Charboost_Example_IOS 
Sub Campaign ID The partner sub campaign id of the touchpoint  1511
Sub Campaign Name The partner sub campaign name of the touchpoint  Non-Incent KR
Sub Publisher The partner sub publisher of the touchpoint  15511
Sub Publisher ID The partner sub publisher id of the touchpoint 321291 
Sub Publisher Name The partner sub publisher name of the touchpoint  Sub Pub
Platform The platform of the touchpoint ios
Timestamp The ISO 8601 formated timestamp of the arrival of the touchpoint to the Singular servers 2018-02-26T12:55:38+00:00
Timestamp Unix UTC The UTC unix timestamp of the arrival of the touchpoint to the Singular servers 1519646873
Singular Campaign Group The singular campaign group of the touchpoint  Google Display (Apps)
Singular Campaign Name The Singular campaign name of the touchpoint 12323534543 - AdWords_EMEA
Security Hash The Singular security hash of the touchpoint ffa6706ff2127a749973072756f83c532e43ed02
Tag ID The Singular tag id of the touchpoint 123123125543
touchpoint__udid The udid of the touchpoint 2b6f0cc904d137be2e1730235f5664094b831186
UDID The UTC unix timestamp of the arrival of the touchpoint to the Singular servers 1519650478
User Agent The user agent of the touchpoint Mozilla/5.0 (iPhone; CPU iPhone OS 11_0_3 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Mobile/15A432

 

 

 

Installs:

Field Name Meaning Example
App Longname The app longname of the event that drove the attribution com.example.amazing_app
App Version The app_version that the event that drove the attribution originated from 2.5
City The city that the event that drove the attribution originated from Bangkok
Country The country that the event that drove the attribution originated from FR
Device ID The device id of the event that drove the attribution dcd84702-d175-41ab-adfa-9f4ff9d49316
Device ID Type The device id type of the event that drove the attribution idfa
Device Make The make of the device that the event that drove the attribution originated from Apple
Device Model The model of the device that the event that drove the attribution originated from iPhone8,1
IDFV The IDFV of the event that drove the attribution dcd84702-d175-41ab-adfa-9f4ff9d49316
Install Source The app store that was used for the install com.amazon.venezia
OS Version The operating system version of the event that drove the attribution 9.3.5
State The state that the event that drove the attribution originated from South Carolina
Event Timestamp The ISO 8601 formatted timestamp of the event that drove the attribution in the customer's timezone 2018-02-25T00:55:08.000-05:00
Event Timestamp Unix UTC The Unix timestamp of the event that drove the attribution in UTC timestamp 1519570010
Google Click ID The Google Click ID (in cases of Google AdWords attribution) CJjsqefUkAJSHDJ_gPdDiEAAA
Is Fingerprinted If the attribution method is "fingerprinting" true/false
Touchpoint IP The IP of the touchpoint that drove the attribution 90.80.70.60
Is Re-engagement If the touchpoint of the attribution was driven by a re-engagement campaign true/false
Creative The partner creative of the touchpoint that drove the attribution EMEA_30seconds_LUKE
Partner The partner name (network name) of the touchpoint that drove the attribution Chartboost
Publisher Concatenated The partner publisher (concat) of the touchpoint that drove the attribution 4368483
Bid Type The pricing model set in the partner of the touchpoint that drove the attribution CPM
Singular Campaign Group The singular campaign group of the touchpoint that drove the attribution MM_18-22_2018-01-24
Singular Campaign Name The singular campaign name of the touchpoint that drove the attribution 12323534543 - AdWords_EMEA
Touchpoint Timestamp The ISO 8601 formatted timestamp of the touchpoint that drove the attribution in the customer's timezone 2018-02-25T00:55:08.000-05:00
Touchpoint Timestamp Unix UTC The Unix timestamp of the touchpoint that drove the attribution in UTC timestamp 1519549529

 

Events:

Field Name Meaning Example
Adjusted Timestamp The ISO 8601 formatted timestamp of the event in the customer's timezone. If the event was generated more than 24 hours ago (more than 24 hours of "lag"), the lag will be maxed to 24h, so the event will be assigned to "yesterday") 2018-02-25T07:03:59+00:00
Adjusted Timestamp Unix UTC The UTC Unix timestamp of the event. If the event was generated more than 24 hours ago (more than 24 hours of "lag"), the lag will be maxed to 24h, so the event will be assigned to "yesterday") 1519553362
App Longname The app longname of the event com.example.amazing_app
Args The arguments sent with the event {"pcc":"AED","r":36.990001678466797}
Device ID The device id of the event dcd84702-d175-41ab-adfa-9f4ff9d49316
Device ID Type The device id type of the event idfa
IP The IP address of the event 10.20.30.40
Name The name of the event Purchase
OS Version The operating system version of the event 11.0.3
Servier Timestamp The ISO 8601 formatted timestamp of the arrival of the event to the Singular servers in the customer's timezone 2018-02-25T07:03:59+00:00
Server Timestamp Unix UTC The UTC Unix timestamp of the arrival of the event to the Singular servers 1519555642
Session ID The session id of the event dcd84702-d175-41ab-adfa-9f4ff9d49316
Revenue Populated if event is a revenue event.  The revenue amount, in currency type "Currency" 43.20
Currency Populated if event if a revenue event.  The ISO-4217 3 digit currency code corresponding to the amount of revenue in "Revenu" USD

 

Postbacks: 

Field Name Meaning Example
Is Attributed Only If the postback is attributed only true/false
App Longname The app longname of the event that drove the attribution, of the attribution that drove the postback com.example.amazing_app
Platform The platform of the event that drove the attribution, of the attribution that drove the postback ios
Event Timestamp The ISO 8601 formatted timestamp of the event that drove the attribution, of the attribution that drove the postback, in the customer's timezone 2018-01-26T04:55:17.000-05:00
Creative The partner creative of the touchpoint that drove the attribution EMEA_30seconds_LUKE
Partner The partner name (network name) of the touchpoint that drove the attribution Facebook
Publisher Concatenated The partner publisher (concat) of the touchpoint that drove the attribution 13540
Singular Campaign Group The singular campaign group of the touchpoint that drove the attribution MM_18-22_2018-01-24
Singular Campaign Name The singular campaign name of the touchpoint that drove the attribution 12323534543 - AdWords_EMEA
Install Timestamp The ISO 8601 formatted timestamp of the touchpoint that drove the attribution in the customer's timezone 2017-12-13T14:22:57.000-05:00
Postback HTTP Body The HTTP body of the postback {}
Postback Timestamp The ISO 8601 formatted timestamp of the creation of the postback in the customer's timezone 2018-02-25T00:53:12.000-05:00
Postback Timestamp Unix UTC The UTC Unix timestamp of the creation of the postback 1519559807
Device ID The device id of the event that drove the postback dcd84702-d175-41ab-adfa-9f4ff9d49316
Device ID Type The device id type of the event that drove the attribution idfa
Is Do Not Track If the event that drove the postback is marked as "do not track" true/false
Event Name The name of the event that drove the postback __SESSION__
Event Timestamp Unix UTC The UTC Unix timestamp of the event that drove the postback 1519544339
Target URL The URL that the postback was sent to recipient.com
Response HTTP Body The HTTP response body of the postback sent {\\"is_fb\\":false}
Response Time The interval, in seconds, that it took for the HTTP response of the postback 141
HTTP Retries Count The number of HTTP retries of sending the postback 0
Response HTTP Code The HTTP response status of the postback sent 200
Postback Recipient The recipient of the postback Google AdWords
Postback Sent Timestamp The ISO 8601 formatted timestamp, of the send, of the postback in the customer's timezone 2018-02-25T00:07:45.000-05:00
Postback Sent Timestamp Unix UTC The UTC Unix timestamp, of the send, of the postback 1519563810
Postback Type The type of the postback (event/attribution) event

 

 

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.