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
Create a new report
Choose the desired period, e.g. Last month to get the report for a previous complete month
In filters, sections build filter Key-values contains [ap_]
In Dimensions list choose Key-values
In Metrics choose "Total targeted impressions"
Press Run export.
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
Create a new report
Choose the desired period, e.g. Last month to get a report for the previous complete month
In Dimensions list choose "Audience segment (billable)" and "Data partner"
In Metrics choose "Ad server impressions"
Press Run export.
You need to do a bit of cleanup before making the final report, therefore need to push data to Google Sheets.
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
