Report Usage for Data Marketplace Distributions to Social Media Platforms

LiveRamp's Advertiser Direct solution (fka Consumer Social) allows brands and agencies to utilize third-party audiences across a wide variety of verticals from the LiveRamp Data Marketplace for optimization on Facebook, Twitter, Pinterest, LinkedIn, and Snapchat.

All advertisers (and agencies acting on behalf of advertisers) are required to report their usage of all LiveRamp Data Marketplace data distributed to the Advertiser Direct social media platforms on a monthly basis.

Note

All Twitter usage reporting is performed automatically. You do not need to perform any usage reporting actions.

Note

Facebook Data Marketplace usage reporting should be set up to run automatically (except in cases where an exception has been made). To implement automated usage reporting for Facebook Data Marketplace data, you must add LiveRamp as a partner in your Facebook Ad Account with the “View Performance” role. Follow the steps in “Adding LiveRamp as a Partner in Facebook”. If you’re already distributing data to Facebook through LiveRamp's Direct Integration, LiveRamp already has the “View Performance” role within your Facebook Ad Account. You might only need to notify your LiveRamp representative that you want to enable automated usage reporting.

  1. For those platforms where automated reporting is not utilized, follow the appropriate platform-specific instructions below to create a usage report.

  2. Follow the instructions in the "Send the Usage Reporting File to LiveRamp" section of this article to send the usage report to LiveRamp.

You will need to include a mapping between the segment info (segment name and ID) and the platform-specific campaign IDs and ad set IDs for each segment used (as described below). If there are multiple people on your team who distribute Data Marketplace segments to these platforms, make sure that you have a system to keep track of the segment name and ID for each segment used, and the campaign IDs and ad set IDs that Data Marketplace data has been used for.

Warning

Due date: The usage report for a given month’s usage is due by the 10th of the following month.

Follow the steps in the appropriate section below to create a platform-specific usage report, and then follow the instructions in the "Send the Usage Reporting File to LiveRamp" section of this article to send the usage report to LiveRamp.

Facebook Data Marketplace usage reporting should be set up to run automatically, except in cases where an exception has been made.

Automated Usage Reporting for Facebook Distributions

To utilize automated usage reporting for Facebook Data Marketplace data, LiveRamp needs to be added as a partner in your Facebook Ad Account with the “View Performance” role. Follow the steps in “Adding LiveRamp as a Partner in Facebook”.

Tip

Distributing to Facebook through a Direct Integration? If you’re already distributing first-party data to Facebook through LiveRamp's Direct Integration, LiveRamp already has the “View Performance” role within your Facebook Ad Account. You might only need to notify your LiveRamp representative that you want to enable automated usage reporting.

Manual Usage Reporting for Facebook Distributions

If you've received an exception from LiveRamp to send manually-pulled Facebook reports, follow these steps.

Tip

Quicker the second time! Once you’ve created your first report, you can reuse that report for subsequent months by changing the data range.

  1. From a web browser, navigate to https://www.facebook.com/adsmanager/reporting and enter your login information.

  2. Click Create (either in the top-left corner or in the center of the screen).

    FB Usage Reporting create button-E-8.jpg
  3. Enter a name for your report, select all of the ad accounts that are receiving LiveRamp Data Marketplace segments through LiveRamp, and then click Create.

    FB Usage Reporting create report popup-be0.jpg

    Tip

    To make it easy to recognize the report for future use, we recommend naming it “LiveRamp Monthly Reporting”.

  4. From the Choose a Layout popup, select "Pivot Table" and then click Continue.

    C-Manual_Usage_Reporting_for_Facebook_Distributions-select_Pivot_Table_.png
  5. Under the Breakdowns tab on the left side of the page, make sure only “Campaign Name” and “Ad Set Name” are checked.

    FB Usage Reporting breakdowns tab-r2M.jpg
  6. Under the Metrics tab on the left side of the page, make sure that only the following columns are checked:

    • Account ID

    • Account Name

    • Reporting Starts

    • Reporting Ends

    • Schedule

    • Impressions

    • Amount Spent

    • Included Custom Audiences

    • Excluded Custom Audiences

    FB Usage Reporting metrics tab-dsI.jpg
  7. Drag the columns to arrange them columns into the order shown below (if necessary):

    • Campaign Name

    • Ad Set Name

    • Account ID

    • Account Name

    • Reporting Starts

    • Reporting Ends

    • Schedule

    • Impressions

    • Amount Spent

    • Included Custom Audiences

    • Excluded Custom Audiences

    C-Manual_Usage_Reporting_for_Facebook_Distributions-ordered_categories.png

    Tip

    You can remove any unneeded columns by clicking on the column and selecting "remove."

  8. For any campaigns with multiple targeting tactics, click the Campaign Name column and then select “Apply Filter”.

    FB Usage Reporting apply filter selection-z4s.jpg
  9. Click the appropriate radio button, enter the appropriate campaign names, and then click Apply to include or exclude the appropriate campaigns so that only Campaigns that used Data Marketplace Segments are included.

    FB Usage Reporting filter apply button-72k.jpg
  10. Use a similar method to make sure to exclude any Ad Sets that did not include Data Marketplace segments. This ensures that LiveRamp only invoices you for Ad Sets that used Data Marketplace segments.

  11. Click Save in the top-right corner.

    FB Usage Reporting save button-BLI.jpg
  12. From the list of reports, click the report name for the report you just created.

    FB Usage Reporting report link-7C4.jpg
  13. From the Reporting Date drop-down list, select the "Last month" preset, and then click Update.

    FB Usage Reporting setting dates-BaU.jpg
  14. Click the Export icon in the upper-right corner.

    FB Usage Reporting export button-BvE.jpg
  15. Check the radio button for “Export as .xlsx (raw data)” and then click Export.

    FB Usage Reporting export popup-yjw.jpg
  16. After the file has downloaded, modify the file name to ensure that all usage reporting is properly attributed (Facebook exports the file with a file name in the following format by default: “LiveRamp-Monthly-Reporting-[Month-Day-Year-Month-Day-Year]”:

    • For Advertisers: Change “LiveRamp-Monthly-Reporting” to “Facebook-[Country Code]-[Advertiser Name]” (for example, “[Country Code]-[Advertiser Name]-May-1-2018-May-31-2018”)

    • For Agencies reporting on behalf of an Advertiser: Change “LiveRamp-Monthly-Reporting” to “Facebook-[Country Code]-[Agency Name-Advertiser Name]” (for example, “[Country Code]-[Agency Name-Advertiser Name]-May-1-2018-May-31-2018”)

    Note

    Use the two-digit country code for your country or region (for example, "UK" for the United Kingdom or "US" for the United States).

  17. Follow the instructions in the "Send the Usage Reporting File to LiveRamp" section of this article to send the usage report to LiveRamp.

To report monthly usage for Pinterest Data Marketplace distributions:

  1. From a web browser, navigate to Pinterest and enter your login information.

  2. From the Ads Manager Welcome page, select the Ads tab and then select “Reporting”.

    1559315360600-zd4.png
  3. Click the date range button.

    1559315362990-lYc.png
  4. From calendar popup, select the first and last day of the previous month.

    1559315359849-SZc.png
  5. Select the Ad Groups tab.

    1559315359943-r98.png
  6. Check the check boxes for the Ad Groups that used LiveRamp-distributed audiences.

    1559315359775-q-8.png
  7. Click the pencil icon to open the Table quick edit popup.

    1559315359565-4yY.png
  8. Select the Details tab.

    1559315360044-ulQ.png
  9. Check the Parent details check box.

    1559315360118-fYI.png
  10. Select the Overall Performance tab.

    1559315360346-38g.png
  11. Make sure that only the Spend check box is checked.

    Tip

    Want to save this layout? Click Save for later if you want to save the custom table for later use or make it your default table.

    1559315360187--fw.png
  12. Select the Export tab and then select “Report: Current Table View”.

    1559315360282-f9k.png
  13. After the file has downloaded, modify the file name to ensure that all usage reporting is properly attributed (Pinterest exports the file with a file name in the following format by default: “metrics-[start date]_to_[end date].csv”):

    • For Advertisers: Change “metrics” to “Pinterest-[Country Code]-[Advertiser Name]” (for example, “Pinterest-[Country Code]-[Advertiser Name]-2019_04_01_to_2019_04_30.csv”)

    • For Agencies reporting on behalf of an Advertiser: Change “metrics” to “Pinterest-[Country Code]-[Agency Name-Advertiser Name]” (for example, “Pinterest-[Country Code]-[Agency Name-Advertiser Name]-2019_04_01_to_2019_04_30.csv”)

    Note

    Use the two-digit country code for your country or region (for example, "UK" for the United Kingdom or "US" for the United States).

  14. Follow the instructions in the "Send the Usage Reporting File to LiveRamp" section of this article to send the usage report to LiveRamp.

Twitter Data Marketplace usage reports are pulled automatically via API. You do not need to manually send monthly usage reports for distributions to Twitter. Email DataMarketplace@liveramp.com if you have any questions.

To report monthly usage for LinkedIn Data Marketplace distributions:

  1. From a web browser, navigate to LinkedIn and enter your login information.

  2. Navigate to Campaign Manager.

  3. Click into the appropriate ad account.

    1559316893744-73Y.png
  4. Check the check boxes for all Campaign Groups that are leveraging LiveRamp-distributed segments.

    1559316894618-qj8.png
  5. Click the Time range drop down, click Last month, and then click Update to select the previous month.

    1559316894133-Lpg.png
  6. Click Export.

    1559316894517-orE.png
  7. From the Report Type drop-down list, select "Campaign Performance."

    1559316894417-8Uc.png
  8. Under “Time breakdown”, select “All” and then click Export.

    1559316894001-ZrY.png
  9. After the file has downloaded, modify the file name to ensure that all usage reporting is properly attributed (LinkedIn exports the file with a file name in the following format by default: “campaign_[campaign # placeholder]_campaign_performance_report.csv”):

    • For Advertisers: Change the file name to “LinkedIn-[Country Code]-[Advertiser Name]-[date range]” (for example, “LinkedIn-[Country Code]-[Advertiser Name]-04_01_2019_to_04_30_2019.csv”)

    • For Agencies reporting on behalf of an Advertiser: Change the file name to “LinkedIn-[Country Code]-[Agency Name-Advertiser Name]-[date range]” (for example, “LinkedIn-[Country Code]-[Agency Name-Advertiser Name]-04_01_2019_to_04_30_2019.csv”)

    Note

    Use the two-digit country code for your country or region (for example, "UK" for the United Kingdom or "US" for the United States).

  10. Follow the instructions in the "Send the Usage Reporting File to LiveRamp" section of this article to send the usage report to LiveRamp.

To report monthly usage for Snap Data Marketplace distributions:

  1. From a web browser, navigate to Snap and enter your login information.

  2. Select the Ad Sets tab.

    1559317267699-3VU.png
  3. Click the calendar drop down, click Custom, and then select the prior month.

    1559317162454-2zg.png
  4. Check the check boxes for all Ad Sets that are leveraging LiveRamp-distributed segments.

    1559317162645-JS0.png
  5. Click the three vertical lines on the right side to open the Customize Columns popup window.

    1559317162933-X1Y.png
  6. In the Details section, check the check boxes for "ID”, “End”, and “Start”.

    1559317163434-_E0.png
  7. Scroll down to the Delivery category and check the check box for “Paid Impressions."

    1559317163113-hNY.png
  8. Scroll down to the Spend category and check the check box for “Spend”.

    1559317165451-SNE.png
  9. Reorder the columns as shown below.

    1559317165311-jWc.png
  10. Click Save.

    1559317165548-rQQ.png
  11. Click the download button to open the Export Configuration popup window.

    1559317165641-W9I.png
  12. Under “INTERVAL BREAKDOWN”, select “Breakdown by month” and then click Export.

    1559317165826-LjU.png
  13. Follow the instructions in the "Send the Usage Reporting File to LiveRamp" section of this article to send the usage report to LiveRamp.

Once you've downloaded and renamed the usage reporting file:

  1. Provide a mapping between the campaign ID(s), the ad set ID(s), and the segment name and segment ID for each segment used:

    Caution

    LiveRamp must have the segment names and segment IDs to create the invoice.

    1. Open the file that you just downloaded.

    2. Insert two additional columns to the right of the existing columns and enter the column headings listed below:

      • LiveRamp Segment Names

      • LiveRamp Segment IDs

    3. Following the example format shown below, provide pipe-delimited segment name(s) and pipe-delimited segment ID(s) (e.g, “10011111 | 10013393”) for each segment used.

      Usage Reporting extra columns.jpg

    Tip

    You can find the segment names and segment IDs for syndicated segments on the Data Marketplace Segments page. See "View More Info and Stats for Data Marketplace Segments" for more information on downloading segment names and segment IDs.

    To find segment names and segment IDs for custom segments, create a support case (see "Using the LiveRamp Community Portal" for instructions).

  2. Email the file to LiveRamp using one of the methods listed below:

Include any additional invoicing requirements, such as amounts by campaign or insertion order, within the email.

After the usage is reported, LiveRamp creates an invoice based on the media spend reported and sends it to the designated billing contact(s) provided. If you need to update the billing contact, contact datausage@liveramp.comor your LiveRamp account representative.

Note

For questions on monthly reporting or billing, email datausage@liveramp.com.