{"_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"},"githubsync":"","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":"","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]\n\n[block:callout]\n{\n  \"type\": \"info\",\n  \"title\": \"Comscore has been deprecated\",\n  \"body\": \"The comscore_gender, comscore_age, and comscore_income column values are deprecated and no longer be used.\"\n}\n[/block]\nThe pushspring_gender column values:\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"pushspring_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 pushspring_age column values:\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"pushspring_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    \"6-0\": \"6\",\n    \"6-1\": \"65+ Year Olds\"\n  },\n  \"cols\": 2,\n  \"rows\": 7\n}\n[/block]\nThe pushspring_income values:\n[block:parameters]\n{\n  \"data\": {\n    \"h-0\": \"pushspring_income\",\n    \"h-1\": \"Meaning\",\n    \"0-0\": \"0\",\n    \"0-1\": \"Unknown\",\n    \"1-0\": \"1\",\n    \"1-1\": \"Under $35K\",\n    \"2-0\": \"2\",\n    \"2-1\": \"$35K - $50K\",\n    \"3-0\": \"3\",\n    \"3-1\": \"$50K - $75K\",\n    \"4-0\": \"4\",\n    \"4-1\": \"$75K - $100K\",\n    \"5-0\": \"5\",\n    \"5-1\": \"$100K - $150K\",\n    \"6-0\": \"6\",\n    \"6-1\": \"Over $150K\"\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] [block:callout] { "type": "info", "title": "Comscore has been deprecated", "body": "The comscore_gender, comscore_age, and comscore_income column values are deprecated and no longer be used." } [/block] The pushspring_gender column values: [block:parameters] { "data": { "h-0": "pushspring_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 pushspring_age column values: [block:parameters] { "data": { "h-0": "pushspring_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", "6-0": "6", "6-1": "65+ Year Olds" }, "cols": 2, "rows": 7 } [/block] The pushspring_income values: [block:parameters] { "data": { "h-0": "pushspring_income", "h-1": "Meaning", "0-0": "0", "0-1": "Unknown", "1-0": "1", "1-1": "Under $35K", "2-0": "2", "2-1": "$35K - $50K", "3-0": "3", "3-1": "$50K - $75K", "4-0": "4", "4-1": "$75K - $100K", "5-0": "5", "5-1": "$100K - $150K", "6-0": "6", "6-1": "Over $150K" }, "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)