{"_id":"58ed1e5e800bfc0f003767e0","__v":0,"user":"55de06e19db51a0d0064947d","category":{"_id":"58ed1bdc068f780f00f64602","__v":0,"project":"55de06fa57f7b20d0097636b","version":"55de06fa57f7b20d0097636e","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2017-04-11T18:09:32.839Z","from_sync":false,"order":11,"slug":"data-transfer-and-integration","title":"Data Transfer and Integration"},"parentDoc":null,"project":"55de06fa57f7b20d0097636b","version":{"_id":"55de06fa57f7b20d0097636e","project":"55de06fa57f7b20d0097636b","__v":14,"createdAt":"2015-08-26T18:35:38.642Z","releaseDate":"2015-08-26T18:35:38.642Z","categories":["55de06fb57f7b20d0097636f","55f1962e3936d52d00fb3c8f","55f1970339e3e8190068b2b8","55f1970d229b772300779a1f","55f1971cfd98c42300acc605","55f1d5c7fd98c42300acc69f","563cbfe4260dde0d00c5e9d4","5644cf437f1fff210078e690","57dc1bbd3ed3450e00dc9ea7","58a600a2243dd30f00fd8773","58ed1bdc068f780f00f64602","58f13b3a4f0ee50f00e24e81","58f173f792f9020f009cad16","591b42f8e633fd0f00077c5a"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2017-04-11T18:20:14.705Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":2,"body":"The merged attributes format gives a single “wide” format to ingest all known attributes from PushSpring’s taxonomy about a device advertising identifier. Each row of the file contains a device advertising identifier, an integer signifying the type of device advertising identifier, the last seen IP address for the device, the country of the device, followed by columns for each of the personas, calculated attributes, and demographic segments.  This format is the simplest to ingest into most data warehousing systems.\n\nThe integer in the id_type column delineates the kind of device identifier, and will be one of the following values:\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"Id\",\n    \"h-1\": \"Meaning\",\n    \"0-0\": \"1\",\n    \"0-1\": \"iOS IDFA\",\n    \"1-0\": \"2\",\n    \"1-1\": \"Android Device Id (SHA1)\",\n    \"2-0\": \"3\",\n    \"2-1\": \"Android Advertising Identifier\"\n  },\n  \"cols\": 2,\n  \"rows\": 3\n}\n[/block]\nThe comscore_gender column values:\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"comscore_gender\",\n    \"h-1\": \"Meaning\",\n    \"0-0\": \"0\",\n    \"0-1\": \"Unknown\",\n    \"1-0\": \"1\",\n    \"1-1\": \"Male\",\n    \"2-0\": \"2\",\n    \"2-1\": \"Female\"\n  },\n  \"cols\": 2,\n  \"rows\": 3\n}\n[/block]\nThe comscore_age column values:\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"comscore_age\",\n    \"h-1\": \"Meaning\",\n    \"0-0\": \"0\",\n    \"0-1\": \"Unknown\",\n    \"1-0\": \"1\",\n    \"1-1\": \"18-24 Year Olds\",\n    \"2-0\": \"2\",\n    \"2-1\": \"25-34 Year Olds\",\n    \"3-0\": \"3\",\n    \"3-1\": \"35-44 Year Olds\",\n    \"4-0\": \"4\",\n    \"4-1\": \"45-54 Year Olds\",\n    \"5-0\": \"5\",\n    \"5-1\": \"55-64 Year Olds\"\n  },\n  \"cols\": 2,\n  \"rows\": 6\n}\n[/block]\nThe comscore_income values:\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"comscore_income\",\n    \"h-1\": \"Meaning\",\n    \"0-0\": \"0\",\n    \"0-1\": \"Unknown\",\n    \"1-0\": \"1\",\n    \"1-1\": \"Under $25K\",\n    \"2-0\": \"2\",\n    \"2-1\": \"$25K - $39K\",\n    \"3-0\": \"3\",\n    \"3-1\": \"$40K - $59K\",\n    \"4-0\": \"4\",\n    \"4-1\": \"$60K - $74K\",\n    \"5-0\": \"5\",\n    \"5-1\": \"$75K - $100K\",\n    \"6-0\": \"6\",\n    \"6-1\": \"Over $100K\"\n  },\n  \"cols\": 2,\n  \"rows\": 7\n}\n[/block]\n**Sample File**: \n[https://s3-us-west-2.amazonaws.com/public.pushspring.com/sampleexportformats/mergedattributes/merged_sample.csv.gz](https://s3-us-west-2.amazonaws.com/public.pushspring.com/sampleexportformats/mergedattributes/merged_sample.csv.gz)","excerpt":"","slug":"format-2","type":"basic","title":"Merged Format"}
The merged attributes format gives a single “wide” format to ingest all known attributes from PushSpring’s taxonomy about a device advertising identifier. Each row of the file contains a device advertising identifier, an integer signifying the type of device advertising identifier, the last seen IP address for the device, the country of the device, followed by columns for each of the personas, calculated attributes, and demographic segments. This format is the simplest to ingest into most data warehousing systems. The integer in the id_type column delineates the kind of device identifier, and will be one of the following values: [block:parameters] { "data": { "h-0": "Id", "h-1": "Meaning", "0-0": "1", "0-1": "iOS IDFA", "1-0": "2", "1-1": "Android Device Id (SHA1)", "2-0": "3", "2-1": "Android Advertising Identifier" }, "cols": 2, "rows": 3 } [/block] The comscore_gender column values: [block:parameters] { "data": { "h-0": "comscore_gender", "h-1": "Meaning", "0-0": "0", "0-1": "Unknown", "1-0": "1", "1-1": "Male", "2-0": "2", "2-1": "Female" }, "cols": 2, "rows": 3 } [/block] The comscore_age column values: [block:parameters] { "data": { "h-0": "comscore_age", "h-1": "Meaning", "0-0": "0", "0-1": "Unknown", "1-0": "1", "1-1": "18-24 Year Olds", "2-0": "2", "2-1": "25-34 Year Olds", "3-0": "3", "3-1": "35-44 Year Olds", "4-0": "4", "4-1": "45-54 Year Olds", "5-0": "5", "5-1": "55-64 Year Olds" }, "cols": 2, "rows": 6 } [/block] The comscore_income values: [block:parameters] { "data": { "h-0": "comscore_income", "h-1": "Meaning", "0-0": "0", "0-1": "Unknown", "1-0": "1", "1-1": "Under $25K", "2-0": "2", "2-1": "$25K - $39K", "3-0": "3", "3-1": "$40K - $59K", "4-0": "4", "4-1": "$60K - $74K", "5-0": "5", "5-1": "$75K - $100K", "6-0": "6", "6-1": "Over $100K" }, "cols": 2, "rows": 7 } [/block] **Sample File**: [https://s3-us-west-2.amazonaws.com/public.pushspring.com/sampleexportformats/mergedattributes/merged_sample.csv.gz](https://s3-us-west-2.amazonaws.com/public.pushspring.com/sampleexportformats/mergedattributes/merged_sample.csv.gz)