Internal BI Postbacks from Self-Attributed Networks: Field Mapping and Examples

Field Mapping for Self-Attributed Networks

The data that Singular gets from self-attributed networks (SANs), such as Facebook and Twitter,  reflects the network's individual reporting hierarchy. Singular standardizes the data by mapping it to Singular's reporting hierarchy before passing it on to you through BI postbacks.

The table below contains the details of the mapping. Reference it when you build your data processing pipeline in the BI platform.

Note that values are only populated when they are provided by the network. For example, creative_id may only be available for certain campaign types.

Partner Name: Google Ads (incl. Google Search, Google Display, etc.) Apple Search Ads (iOS Search Ads) Facebook Snapchat Twitter Yahoo (Yahoo Gemini)
tracker_ campaign_ name campaign_name iad-campaign-name Campaign Name campaign_name campaign_name campaign_name
tracker_ campaign_ id campaign_id iad-campaign-id Campaign ID campaign_id campaign_id campaign_id
tracker_sub_ campaign_ name   iad-adgroup-name AdSet Name ad_squad_name   adgroup_name
tracker_sub_ campaign_id adgroup_id iad-adgroup-id AdSet ID ad_squad_id line_item_id adgroup_id
tracker_ creative_ name     Ad Name ad_name   creative_name
tracker_ creative_ id creative_id or video_id   Ad ID ad_id tweet_id creative_id
tracker_ publisher_ id placement   "Facebook", "Instagram", "Audience Network"   publisher_app_id  
tracker_ publisher_ site_ name     "Facebook", "Instagram", "Audience Network"      
tracker_ publisher_ site_ id placement       publisher_app_id  

Sample Postback Data

The following are some examples of JSON objects you may receive in postbacks. Note that if a piece of data is not present (not made available by the partner to Singular), the key (column) is not provided in the postback.

Sample Postback: Source - AdWords
{
  "aifa": "123456-abcd-4821-8011-0e9f189a6f27",
  "amount": 0,
  "app_name": "MyAppName",
  "app_version": "3.2.1",
  "campaign": "1234567 - Bidalgo_Android_UAC_tCPA_US_12345 (555-555-5555)",
  "campaign_group": "N/A",
  "city": "San Francisco",
  "click_ip": "10.77.202.1",
  "click_utc_timestamp": 1523845213,
  "country": "US",
  "creative": "N/A",
  "currency": "USD",
  "device_brand": "samsung",
  "device_model": "SM-G965U",
  "event_name": "registration",
  "event_utc_timestamp": 1558611339,
  "install_utc_timestamp": 1523845519,
  "is_first_event": 0,
  "is_organic": 0,
  "is_reengagement": 0,
  "is_viewthrough": 0,
  "limit_ad_tracking": 0,
  "longname": "com.singular.MyAppName",
  "match_type": "deterministic",
  "network": "Google Search - UAC",
  "os_version": 9,
  "partner_site": "GoogleSearch",
  "platform": "Android",
  "singular_click_id": "Q2425hH3_btICGtsxnjhC-xKXin4dF4Xex_mFkdbZGUjnULllQRyzKmovfrnbo9JS94aIulUX9Hdi0771u-mQ",
  "site": "GoogleSearch",
  "tracker_name": "1234567 - Bidalgo_Android_UAC_tCPA_US_12345 (555-555-5555)",
  "user_id": "8934570q38-283c-4adc-b96c-214280222d69",
  "fraud_status": "valid",
  "fraud_reason": ""
}
Sample Postback: Source - Apple Search Ads
{
  "amount": 0,
  "app_name": "MyAppName",
  "app_version": "3.2.0",
  "campaign": "UK:12345639",
  "campaign_group": "brand_exact_copy:12341801",
  "city": "London",
  "click_ip": "10.132.219.1",
  "click_utc_timestamp": 1518649915,
  "country": "GB",
  "creative": "-:-",
  "currency": "USD",
  "device_brand": "Apple",
  "device_model": "iPhone8,2",
  "event_name": "__START__",
  "event_utc_timestamp": 1558594525,
  "idfa": "92dfsd872D18-4433-4D65-8239-7A9454551C17",
  "idfv": "1dsdfdsf984-749B-4FB5-A5B4-8FD0B252D8900",
  "install_utc_timestamp": 1518649971,
  "is_first_event": 0,
  "is_organic": 0,
  "is_reengagement": 0,
  "is_viewthrough": 0,
  "limit_ad_tracking": 0,
  "longname": "com.singular.MyAppName",
  "match_type": "deterministic",
  "network": "iOS Search Ads",
  "os_version": 12.2,
  "partner_site": "MyAppName",
  "platform": "iOS",
  "singular_click_id": "bKcOHKO23602895pJHHOYUIG392rjbhLKJDJbFIFleEwaST3sGkHV8wgyxrLf8KtuVayjH2hyXjFFUvkqSxJ66qUYUI2WqTJ9wmnH0hlLNZKzbXXi8",
  "site": "MyAppName",
  "tracker_name": "UK:12345639",
  "user_id": "aj3jgljg-867c-4d6f-aa56-e35cadfdfdb17",
  "fraud_status": "valid",
  "fraud_reason": ""
}
Sample Postback: Source - Facebook
{
  "aifa": "a987598598-c892-4a69-8abc-fec93c993988",
  "amount": 0,
  "app_name": "MyAppName",
  "app_version": "3.2.0",
  "campaign": "Singular_Android_ABC-NonUS:1234567894420770",
  "campaign_group": "Singular_Android_AutoBid_VO_FB-AllCreatives_24-45_M_1day_ROAS1%:12345678910111213",
  "city": "Santiago de Cali",
  "click_ip": "67.49.84.32",
  "click_utc_timestamp": 1557433018,
  "country": "CO",
  "creative": "Singular_LightVsDarkUI_Video_30s_Square:1234abcd5678",
  "currency": "USD",
  "device_brand": "samsung",
  "device_model": "SM-A520F",
  "event_name": "LevelUp",
  "event_utc_timestamp": 1558627132,
  "fb_ad_id": 1234abcd5678,
  "fb_ad_name": "Singular_LightVsDarkUI_Video_30s_Square",
  "fb_adset_id": 12345678910111213,
  "fb_adset_name": "Singular_Android_AutoBid_VO_FB-AllCreatives_24-45_M_1day_ROAS1%",
  "fb_campaign_id": 1234567894420770,
  "fb_campaign_name": "Singular_Android_ABC-NonUS",
  "install_utc_timestamp": 1557433113,
  "is_first_event": 0,
  "is_organic": 0,
  "is_reengagement": 0,
  "is_viewthrough": 0,
  "limit_ad_tracking": 0,
  "longname": "com.Singular.MyAppName",
  "match_type": "deterministic",
  "network": "Facebook",
  "os_version": "8.0.0",
  "partner_campaign": 1234567894420770,
  "partner_site": "Facebook",
  "partner_sub_campaign": 12345678910111213,
  "platform": "Android",
  "singular_click_id": "sddjhhasdf7a6498y42jbasdjfhp9804r5WqHobec5AbSaHocUAbU4XAe72FMaoE0oYkEeMNOMaFjgn8xYgV6v9F3BqRo9VXUZ-095083c",
  "site": "Facebook",
  "tracker_campaign_id": 1234567894420770,
  "tracker_campaign_name": "Singular_Android_ABC-NonUS",
  "tracker_creative_id": 1234abcd5678,
  "tracker_creative_name": "Singular_LightVsDarkUI_Video_30s_Square",
  "tracker_name": "Singular_Android_ABC-NonUS:1234567894420770",
  "tracker_publisher_id": "Facebook",
  "tracker_publisher_site_name": "Facebook",
  "tracker_sub_campaign_id": 12345678910111213,
  "tracker_sub_campaign_name": "Singular_Android_AutoBid_VO_FB-AllCreatives_24-45_M_1day_ROAS1%",
  "user_id": "0f496ff6-c7f7-4633-899a-7610259861058",
  "fraud_status": "valid",
  "fraud_reason": ""
}
Sample Postback: Source - IronSource
{
  "amount": 0,
  "app_name": "MyAppName",
  "app_version": "3.2.1",
  "campaign": "MyAppName_iOS_DeviceAssist_setup",
  "campaign_group": "MyAppName_iOS_DeviceAssist_setup",
  "city": "Napa",
  "click_ip": "17.120.49.42",
  "click_utc_timestamp": 1558525701,
  "country": "UA",
  "creative": 66775,
  "currency": "USD",
  "device_brand": "Apple",
  "device_model": "iPhone9,3",
  "event_name": "__SESSION__",
  "event_utc_timestamp": 1558597538,
  "idfa": "4251434ew-C312-477D-9766-927744B09A38",
  "idfv": "sdaf32337-5D5D-4ED2-B1F2-8C35A6C98946",
  "install_utc_timestamp": 1558597538,
  "is_first_event": 1,
  "is_organic": 0,
  "is_reengagement": 0,
  "is_viewthrough": 0,
  "limit_ad_tracking": 0,
  "longname": "com.singular.MyAppName",
  "match_type": "deterministic",
  "network": "ironSource",
  "os_version": 12.2,
  "partner_campaign": 345678,
  "partner_site": "Idle World !",
  "platform": "iOS",
  "singular_click_id": "L5X9RN9urXZrtxdduVd_gt2A3gOggW-7Wev3U8-ehfDgfse35hppwuvfDXTc8n_dsq5rTYrSd7nyUISAehxyD6LBov-uW5Cn0iY1vgkZgEg",
  "site": "236335_",
  "tracker_campaign_id": 345678,
  "tracker_campaign_name": "Focus_iOS_CPI_RON_10+_T3T4_Video",
  "tracker_creative_id": 66775,
  "tracker_creative_name": "Influencer_720x1280_30s",
  "tracker_name": "MyAppName_iOS_DeviceAssist_setup",
  "tracker_publisher_id": "World1",
  "tracker_publisher_site_id": "com.someapp.game",
  "tracker_publisher_site_name": "SomeApp Game",
  "fraud_status": "valid",
  "fraud_reason": ""
}

 

Was this article helpful?