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) | Snapchat | 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": ""
}