{"id":3164,"date":"2021-04-02T16:30:58","date_gmt":"2021-04-02T16:30:58","guid":{"rendered":"https:\/\/wiki.pontiac.media\/?page_id=3164"},"modified":"2021-12-14T20:59:52","modified_gmt":"2021-12-14T20:59:52","slug":"liveramp-file-format","status":"publish","type":"docs","link":"https:\/\/wiki.pontiac.media\/?docs=new-test-section\/liveramp\/liveramp-file-format","title":{"rendered":"LiveRamp File Format"},"content":{"rendered":"\n<p>Files uploaded to LiveRamp must be 500MB or smaller and a CSV, TSV or TXT with no spaces in the File Name. There are 3 types of PII that can be uploaded:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Emails<\/li><li>Phone numbers<\/li><li>Name and Postal address<\/li><\/ol>\n\n\n\n<p>You can include one, two, or all three of these. But if you want to use Name and Postal address you must include all of the columns listed under &#8216;Name and postal address&#8217; below (full name and full address).<br>Use the following column headers to identify the type of PII in your file:<br><strong>Name and postal address:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>FIRSTNAME<\/li><li>LASTNAME<\/li><li>ADDRESS1<\/li><li>ADDRESS2 (optional)<\/li><li>CITY<\/li><li>STATE<\/li><li>ZIP<\/li><li>ZIP4 (optional)<\/li><\/ul>\n\n\n\n<p><strong>Plaintext email address:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>EMAIL1<\/li><li>EMAIL2<\/li><li>EMAIL3<\/li><\/ul>\n\n\n\n<p><strong>MD5 hashed email address:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>MD5EMAIL1<\/li><li>MD5EMAIL2<\/li><li>MD5EMAIL3<\/li><\/ul>\n\n\n\n<p><strong>SHA-1 hashed email address:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>SHA1EMAIL1<\/li><li>SHA1EMAIL2<\/li><li>SHA1EMAIL3<\/li><\/ul>\n\n\n\n<p><strong>SHA-256 hashed email address:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>SHA256EMAIL1<\/li><li>SHA256EMAIL2<\/li><li>SHA256EMAIL3<\/li><\/ul>\n\n\n\n<p><strong>Plaintext phone number:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>PHONE1<\/li><li>PHONE2<\/li><li>PHONE3<\/li><\/ul>\n\n\n\n<p><strong>SHA-1 hashed phone number:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SHA1PHONE1&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:513,&quot;3&quot;:{&quot;1&quot;:0},&quot;12&quot;:0}\">SHA1PHONE1<\/span><\/li><li><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SHA1PHONE2&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:513,&quot;3&quot;:{&quot;1&quot;:0},&quot;12&quot;:0}\">SHA1PHONE2<\/span><\/li><li><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SHA1PHONE3&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:513,&quot;3&quot;:{&quot;1&quot;:0},&quot;12&quot;:0}\">SHA1PHONE3<\/span><\/li><\/ul>\n\n\n\n<p><strong>Customer ID (used to de-duplicate rows):<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>CCID<\/li><\/ul>\n\n\n\n<p>See a sample 100 rows of fake data here: <a href=\"https:\/\/sec-wiki.pontiac.media\/wp-content\/uploads\/2021\/04\/simple_onboard_sample_data-pJo-2-1.csv\">Sample File<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":514,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-3164","docs","type-docs","status-publish","hentry","no-post-thumbnail"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/3164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3164"}],"version-history":[{"count":1,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/3164\/revisions"}],"predecessor-version":[{"id":6728,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/3164\/revisions\/6728"}],"up":[{"embeddable":true,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/514"}],"next":[{"title":"Uploading Files to LiveRamp","link":"https:\/\/wiki.pontiac.media\/?docs=new-test-section\/liveramp\/uploading-files-to-liveramp","href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/517"}],"prev":[{"title":"Process Overview","link":"https:\/\/wiki.pontiac.media\/?docs=new-test-section\/liveramp\/process-overview","href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/6742"}],"wp:attachment":[{"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3164"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_tag&post=3164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}