{"id":13888,"date":"2026-07-13T19:47:47","date_gmt":"2026-07-13T19:47:47","guid":{"rendered":"https:\/\/wiki.pontiac.media\/?docs=ctv-documentation\/audiences\/liveramp\/liveramp-tutorial"},"modified":"2026-07-15T21:58:43","modified_gmt":"2026-07-15T21:58:43","slug":"liveramp-tutorial","status":"publish","type":"docs","link":"https:\/\/wiki.pontiac.media\/?docs=ctv-documentation\/audiences\/liveramp\/liveramp-tutorial","title":{"rendered":"Liveramp Tutorial"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">Overview<\/h4>\n\n\n\n<p>LiveRamp is a data management platform (DMP) that allows you to upload personally identifiable information (PII) that you have about your audience. This can include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Name and postal addresses (NAP)<\/li>\n\n\n\n<li>Email addresses<\/li>\n\n\n\n<li>Phone numbers<\/li>\n\n\n\n<li>Client customer IDs (your internal customer IDs)\n<ul class=\"wp-block-list\">\n<li>This functions as an audience key that allows LiveRamp to delete duplicates in an uploaded file. If there is no customer ID, LiveRamp will use either the email addresses or NAPs provided.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>You can upload a csv, tsv, or txt file containing information into LiveRamp, which will match the submitted information with cookies and allow you to target these individuals across the Internet through Pontiac.<\/p>\n\n\n\n<p>We recommend clients allow for a two-week lead time when working with LiveRamp. The maximum number of records allowed per seat at any given time is 300,000. Please do no not send any files or screenshots of files containing PII through the Help Center or to anyone on the Pontiac team.\u00a0<\/p>\n\n\n\n<p>Estimated Schedule:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1-2 days to upload the files:\n<ul class=\"wp-block-list\">\n<li>Once you upload the file there will be a delay in this file showing up in the Audience folder, it may take up to 48 hours to appear.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>5-8 days for the files to be mapped:\n<ul class=\"wp-block-list\">\n<li>This is a manual process, so this stage can take some time. Typically, this takes 5-8 days for the first file in an Audience, but it is usually quicker for subsequent files.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>1-2 days for distribution to Microsoft:\n<ul class=\"wp-block-list\">\n<li>Once mapping is completed you will get a notification email to distribute the audience. Select the file(s) that you wish to send to Microsoft. After you have selected your desired files, select \u2018Add to Distribution\u2019 at the bottom of the page and notify your Account Manager. It will take 1-2 days for the segment to appear in Microsoft.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>1-2 days for the file to be onboarded, matched &amp; fully populated in Pontiac:\n<ul class=\"wp-block-list\">\n<li>Once the segment appears in Xandr, your Account Manager will onboard the audience to Pontiac. While the audience will be available to associate to a Line, it may still be in the matching stage and could take an additional 1-2 days to fully populate in Xandr\/Pontiac.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Terminology<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>File:<\/strong>\u00a0A set or list of PII uploaded to LiveRamp as a CSV, TSV or TXT file. Each file uploaded will be converted into an Onboarded audience in Pontiac.<\/li>\n\n\n\n<li><strong>Audience:<\/strong>\u00a0In the LiveRamp dashboard, an \u2018Audience\u2019 is a folder to which files with the same type of PII and column headers can be uploaded. Your first Audience folder will be created for you when the account is created. The folder will be \u2018mapped\u2019 based on the column headers of the first file uploaded. All subsequent files uploaded to an Audience will need to contain the same column headers. Notify your Account Manager if you need a new Audience folder created for a different type of data.<\/li>\n\n\n\n<li><strong>Mapping:<\/strong>\u00a0This process is done manually by the LiveRamp team to determine which PII identifiers are in each column of the file, allowing the data to be properly ingested.<\/li>\n\n\n\n<li><strong>Matching:<\/strong>\u00a0The process of matching personally identifiable information (PII) to the cookies for that individual, allowing them to be targeted on the open web.<\/li>\n\n\n\n<li><strong>Distribution:<\/strong>\u00a0The publishing process through which data is delivered to Xandr and subsequently made available for targeting in Pontiac.<\/li>\n\n\n\n<li><strong>Records:<\/strong>\u00a0The number of unique individuals in a file. There is a maximum of 300,000 distributed records per LiveRamp account at any given time.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Account Setup<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>To start using a LiveRamp account, all Pontiac users will need to sign a LiveRamp user agreement. This agreement can be found in the \u2018Admin\u2019 tab under \u2018Seat Settings\u2019 in the \u2018Addendum\u2019 section. To sign this agreement, check the \u2018Accept LiveRamp Addendum\u2019 box at the bottom of the contract and click \u2018Submit\u2019. By checking this box, you are agreeing to the terms of the agreement.<\/li>\n\n\n\n<li>Once you have completed these steps, reach out through the Help Center with the email address you would like to be used for the account.\u00a0The Pontiac Team will create an account on your behalf using the email address provided.\u00a0 Once your account is set up, you will receive an email from LiveRamp asking you to follow a link for creating a Password. After establishing your Password, you will be able to sign into LiveRamp with your email address and new password.<\/li>\n<\/ol>\n\n\n\n<p>You can download and review the LiveRamp addendum here:&nbsp;<a href=\"https:\/\/wiki.pontiac.media\/?docs=getting-started-with-pontiac\/contracts-and-policies\/liveramp-addendum\">LiveRamp Addendum<\/a><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">File Format<\/h4>\n\n\n\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\">\n<li>Emails<\/li>\n\n\n\n<li>Phone numbers<\/li>\n\n\n\n<li>Name and Postal address<\/li>\n<\/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 \u2018Name and postal address\u2019 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\">\n<li>FIRSTNAME<\/li>\n\n\n\n<li>LASTNAME<\/li>\n\n\n\n<li>ADDRESS1<\/li>\n\n\n\n<li>ADDRESS2 (optional)<\/li>\n\n\n\n<li>CITY<\/li>\n\n\n\n<li>STATE<\/li>\n\n\n\n<li>ZIP<\/li>\n\n\n\n<li>ZIP4 (optional)<\/li>\n<\/ul>\n\n\n\n<p><strong>Plaintext email address:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>EMAIL1<\/li>\n\n\n\n<li>EMAIL2<\/li>\n\n\n\n<li>EMAIL3<\/li>\n<\/ul>\n\n\n\n<p><strong>MD5 hashed email address:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>MD5EMAIL1<\/li>\n\n\n\n<li>MD5EMAIL2<\/li>\n\n\n\n<li>MD5EMAIL3<\/li>\n<\/ul>\n\n\n\n<p><strong>SHA-1 hashed email address:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SHA1EMAIL1<\/li>\n\n\n\n<li>SHA1EMAIL2<\/li>\n\n\n\n<li>SHA1EMAIL3<\/li>\n<\/ul>\n\n\n\n<p><strong>SHA-256 hashed email address:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SHA256EMAIL1<\/li>\n\n\n\n<li>SHA256EMAIL2<\/li>\n\n\n\n<li>SHA256EMAIL3<\/li>\n<\/ul>\n\n\n\n<p><strong>Plaintext phone number:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>PHONE1<\/li>\n\n\n\n<li>PHONE2<\/li>\n\n\n\n<li>PHONE3<\/li>\n<\/ul>\n\n\n\n<p><strong>SHA-1 hashed phone number:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SHA1PHONE1<\/li>\n\n\n\n<li>SHA1PHONE2<\/li>\n\n\n\n<li>SHA1PHONE3<\/li>\n<\/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\">\n<li>CCID<\/li>\n<\/ul>\n\n\n\n<p>See a sample 100 rows of fake data here:&nbsp;<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\n\n\n<h4 class=\"wp-block-heading\">Uploading Files to LiveRamp<\/h4>\n\n\n\n<p><strong>(1-2 Days)<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Once you have signed into your account, you should be brought to this page:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"542\" src=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-9-1024x542.png\" alt=\"\" class=\"wp-image-6748\" srcset=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-9-1024x542.png 1024w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-9-300x159.png 300w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-9-768x406.png 768w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-9.png 1334w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>You are now ready to upload data files into the audience your AM created for you. From the Homepage (which you can access by clicking on the triangle symbol next to \u2018Connect\u2019 in the upper-left corner, pictured above), select \u2018Upload a File\u2019 and follow the prompt.<\/li>\n\n\n\n<li>Within the File Upload page, select the name of your audience from the drop-down \u2018Upload to an Audience\u2019 menu. Your first Audience folder will be created for you when the account is created. Each file uploaded to an Audience must contain the same data columns, as this is mapped for matching with the first file. If you need to upload files with different columns, your Account Manager can create additional Audience folders for you.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"515\" src=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-10-1024x515.png\" alt=\"\" class=\"wp-image-6750\" srcset=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-10-1024x515.png 1024w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-10-300x151.png 300w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-10-768x386.png 768w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-10.png 1264w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Once you have selected the audience, a box will appear prompting you to either drag in or select the appropriate file. You should proceed to upload the desired csv, tsv, or txt.<\/li>\n\n\n\n<li>Once you select your file, click \u2018Upload File\u2019 in the \u2018Upload Status\u2019 window to begin processing.<\/li>\n\n\n\n<li>Once \u2018Upload Status\u2019 says the file upload is complete, you will have the option to select a button that says, \u2018Go to Audience\u2019. If you click this immediately after uploading, another tab will open in your window to bring you to the \u2018Manage\u2019 page for that audience. You will likely not see any segments listed within the audience as can take 24-48 hours for the newly uploaded segment to appear.<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\">Mapping Process<\/h4>\n\n\n\n<p><strong>(5-8 Days)<\/strong><\/p>\n\n\n\n<p>The first file uploaded to each audience is mapped to determine which data points are in each column of the document so that the PII can be properly ingested. This is a manual process completed by LiveRamp and it can take up to 5-8 days<strong>.<\/strong><\/p>\n\n\n\n<p>LiveRamp will send you an email when your file has been mapped and is ready for distribution. If you see delays in this process that exceed 8 days, let your Account Manager know and they will contact LiveRamp support to try to expedite this process.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Distributing Files to Xandr<\/h4>\n\n\n\n<p><strong>&nbsp;(1-2 Days)<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In order to publish your segment(s), you must configure Xandr as a destination. This only needs to happen once.\u00a0 From the menu, select \u2018Data Out\u00a0 \u2013 \u2018Active Destinations\u2019 \u2018New Destination Account\u2019.<\/li>\n\n\n\n<li>You will be brought to a page listing many possible destinations. Use the search bar to look up \u2018Xandr Invest\u2019.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"459\" src=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-11-1024x459.png\" alt=\"\" class=\"wp-image-6753\" srcset=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-11-1024x459.png 1024w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-11-300x134.png 300w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-11-768x344.png 768w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-11.png 1258w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>When you hover over the icon, you will be prompted to \u2018Activate\u2019 the destination.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"547\" src=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-12-1024x547.png\" alt=\"\" class=\"wp-image-6755\" srcset=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-12-1024x547.png 1024w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-12-300x160.png 300w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-12-768x411.png 768w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-12.png 1255w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>You will be brought to a page titled \u2018Configure Properties\u2019. In the \u2018Destination Specific Settings\u2019, enter the client ID \u20183344\u2019.<\/li>\n\n\n\n<li>After you have set up Xandr as a destination, you will be able to push your audience segment to distribution. Select \u2018Active Destinations\u2019 from \u2018Data Out\u2019 in the sidebar.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"523\" src=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-13-1024x523.png\" alt=\"\" class=\"wp-image-6756\" srcset=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-13-1024x523.png 1024w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-13-300x153.png 300w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-13-768x392.png 768w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-13.png 1224w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\">\n<li>Select \u2018Manage\u2019 from within the Xandr box<\/li>\n\n\n\n<li>Select the file(s) that you wish to send to Xandr. After you have selected your desired files, select \u2018Add to Distribution\u2019 at the bottom of the page.\u00a0<strong>From distribution, it will take 1-2 days for the segment to appear in Xandr.<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"566\" src=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-14-1024x566.png\" alt=\"\" class=\"wp-image-6757\" srcset=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-14-1024x566.png 1024w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-14-300x166.png 300w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-14-768x424.png 768w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-14.png 1256w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Audience Onboarding &amp; Matching<\/h4>\n\n\n\n<p><strong>&nbsp;(1-2 Days)<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Once you have added a segment to distribution for Xandr, reach out to the Pontiac Team through the Help Center to say that you have pushed a segment. Please provide the segment name.<\/li>\n\n\n\n<li>The Pontiac Team will inform you when the file has been onboarded to your Pontiac seat.<\/li>\n\n\n\n<li>You will now have access to your audience Segment within the Pontiac console. Your audience will be located within the Audiences tab under \u2018On Boarded.\u2019<\/li>\n<\/ol>\n\n\n\n<p>Note, while the segment may be available in Pontiac rather quickly, the file may still be in the matching process and the segment may take 1-2 days to fully populate in Xandr\/Pontiac.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Removing Segments that are no longer in use<\/h4>\n\n\n\n<p>Any segments that are no longer being used in the Pontiac console or in LiveRamp should be removed from distribution. Your Account Manager will send a friendly reminder at the end of each month, reminding you to remove the segments that are no longer being used. The maximum number of records allowed per seat at any given time is 300,000.<\/p>\n\n\n\n<p>To remove the segments from distribution, click on the out section in LiveRamp, and then click the \u2018Manage\u2019 button in Xandr Invest. There you will see all your segments that have been uploaded. Click the box next to the segment that you wish to remove from distribution. At the bottom, there will be a green button that states, remove from distribution. Once you click \u2018remove,\u2019 the process will be complete.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"568\" src=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-15-1024x568.png\" alt=\"\" class=\"wp-image-6760\" srcset=\"https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-15-1024x568.png 1024w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-15-300x166.png 300w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-15-768x426.png 768w, https:\/\/wiki.pontiac.media\/wp-content\/uploads\/2021\/12\/image-15.png 1286w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"author":17,"featured_media":0,"parent":13885,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-13888","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\/13888","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\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13888"}],"version-history":[{"count":3,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/13888\/revisions"}],"predecessor-version":[{"id":13894,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/13888\/revisions\/13894"}],"up":[{"embeddable":true,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/13885"}],"wp:attachment":[{"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13888"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_tag&post=13888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}