Skip to main content

Report Usage for Data Marketplace Distributions to Advertiser Direct Destinations

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

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

  • If you are using multiple segments that are priced differently in the same audience or group at the destination platform (such as within one ad group or ad set, depending on the platform’s terminology), the price for the highest-priced segment that each consumer matches to will be applied to the impressions for that consumer (no matter what pricing model the platform uses). For example, if you are using segment A that is priced at 250% PoM and another segment B that is priced at 15% in the same audience or group, the 250% would apply toward the impressions for any consumers who were included in segment A.

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

  • 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.

Overall Steps to Report Usage

  1. For those platforms where automated reporting is not used, 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.

Platform-Specific Usage Reporting Instructions

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 dialog, 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 date picker, 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. The Table quick edit dialog appears.

    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 been 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 been 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 dialog 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 dialog 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.

To report monthly usage for TikTok Data Marketplace distributions:

  1. From TikTok Ads Manager, select the Campaign tab and then select the appropriate time frame and the campaigns that were live and/or registered any impressions during this time frame. Click Bulk create/Edit and select the Export Ads report.

    C-TikTok_Usage_Reporting-bulk_create_edit_button.png

    A report with details on various audiences used across these campaigns downloads.

    Note

    If the bulk export function fails, locate the individual ad group and select Edit. You can locate the audience name from the Edit Ad Group pane one ad group at a time. Skip to step 3 below.

    C-TikTok_Usage_Reporting-bulk_export_fails.png
  2. Open the downloaded Excel report and look at columns "Include Audience ID'/'Exclude Audience ID". If there is data, those ad groups used audiences. Select the Audience List tab in the Excel report to confirm if these segments are the third-party audiences/Lookalike audiences from your data provider and note the Audience IDs and Names for inclusion in the billing report.

    C-TikTok_Usage_Reporting-Audience_List_tab.png
  3. From the Campaign tab, select Ad Groups. Based on the info from the previous steps, identify which ad groups used third-party audiences/lookalike audiences. Select those ad groups and export the table by clicking the download icon in the top right.

    C-TikTok_Usage_Reporting-ad_group.png
  4. Use the downloaded report from the previous step and make sure the following columns are included:

    • Advertiser name

    • Campaign name

    • Ad account ID

    • Audience ID

    • Audience name

    • Impressions

    • Total spend

    • LiveRamp segment name

    • LiveRamp segment ID

If you're a Customer Profiles customer who's used Data Marketplace data to filter your first-party data before distributing to Google Customer Match (GCM), you are required to provide our Data Marketplace billing team with a usage report on a monthly basis.

Note

To pull a usage report from GCM:

Note

Screenshots shown were current at the time of publication.

  1. Log in to your Google Ads account.

  2. From the gray left navigation bar, select “Audiences”.

    C-Report_Usage_for_Data_Store_Data_in_GCM-audiences_menu_selection_1-6_M.jpg
  3. From the menu options that appear below, select “Audiences”.

    C-Report_Usage_for_Data_Store_Data_in_GCM-audiences_menu_selection_2-Oio.jpg
  4. Filter Type by “Customer List”.

    C-Report_Usage_for_Data_Store_Data_in_GCM-filter-mDg.jpg
  5. Click “Download” and then select “Email now”.

    C-Report_Usage_for_Data_Store_Data_in_GCM-download-Dc4.jpg
  6. Enter “datausage@liveramp.com” as the recipient.

    C-Report_Usage_for_Data_Store_Data_in_GCM-recipient-PQ0.jpg
  7. Select “Excel.csv” or “.xlsx” from the file type dropdown.

    C-Report_Usage_for_Data_Store_Data_in_GCM-file_types-B2U.jpg
  8. Make sure the check box for “Title and date range” is checked.

    C-Report_Usage_for_Data_Store_Data_in_GCM-range-H54.jpg
  9. Name your report.

    C-Report_Usage_for_Data_Store_Data_in_GCM-name-3p4.jpg

    Tip

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

  10. Click Send.

Send the Usage Reporting File 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 standard 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:

If you require invoices to be split by brand or client, you will need to create child accounts for each brand or client that requires a separate invoice. Applicable destination accounts must be linked to the specific child account for that brand or client. For more information on creating these accounts, see the "Create a Client Child Account" section above.

If you require invoices to be split by campaign, to include an insertion order or purchase order number, or have any additional invoicing requests, include those requests on the usage submission email or contact your LiveRamp account representative.

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.com or your LiveRamp account representative.

Note

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