How to find data usage information in Google 360 for Publishers former DFP

How to extract numbers of 1st party AudienceProject data usage from Google 360 the former DFP? 

How to report on AudienceProject targeting data usage in Ad Manager (ex DFP)

This guide covers how we/customer can understand how many impressions were targeted using AudienceProject segments or key-values.

Key-values

  1. Create a new report
  2. Choose the desired period, e.g. Last month to get the report for a previous complete month
    Key_Values1.png
  3. In filters, sections build filter Key-values contains [ap_]
    Filters.png
  4. In Dimensions list choose Key-values
    Dimensions.png
  5. In Metrics choose "Total targeted impressions"
    Metrics.png
  6. Press Run export.
Export.png

You can export to Google Sheet if you would like to do deeper analytics. Please keep in mind, that none-AudienceProject key-values can be exported if they have ap_ in key or value, so check the report to ensure you extracted the data you would like.

 

Audiences

  1. Create a new report
  2. Choose the desired period, e.g. Last month to get a report for the previous complete month
    Date_range.png
  3. In Dimensions list choose "Audience segment (billable)" and "Data partner"
    data_partner.png
  4. In Metrics choose "Ad server impressions"
    Ad_server_impressions.png
  5. Press Run export.
  6. You need to do a bit of cleanup before making the final report, therefore need to push data to Google Sheets.
    Cleanup_pushdata.png
  7. In Sheets you need to build conditions:
  • Audience segment (billable) -> Starts with [AudienceProject]
  • Data partner -> (Blanks)

Sum-up visible rows and you have the final number

audience_segments.png

How did we do?

AdForm publisher integration instructions

How to report on AudienceProject segment usage in DFP

Contact