Getting a list of placements for a campaign - what's missing from my request?

[Omer Cohen]

I want to get the performance of targeted placement-URLs  (Mobile Apps) in my campaign(s).
How can I do that?
What's missing from my AWQL / API requests?

I am trying in 2 approaches;
In either way, I receive a list of Excluded placements for that campaign,
but NOT the Placements I want to target


Via AWQL:

SELECT CampaignId, Url,  IsPathExcluded
FROM    URL_PERFORMANCE_REPORT
WHERE   CampaignId = 213667385 DURING 20150126,20150126"

Or via API:

{
 'fields': ['CampaignId', 'Id', 'CriteriaType', 'PlacementUrl'],
 'predicates': [
 {
 'field': 'CriteriaType',
 'operator': 'IN',
 'values': ['MOBILE_APPLICATION', ]
 },
 {
 'field': 'CampaignId',
 'operator': 'IN',
 'values': cids,
 }

via CampaignCriterionService

Background info:
This is how I added targeted mobileapps / placements (which eventually do NOT appear in the above reports):

{
 'xsi_type': 'BiddableAdGroupCriterion',
 'adGroupId': adgroup_id,
 'criterion': {
 'xsi_type': 'MobileApplication',
 'appId': placement_url,
 }

via adgroupCriterionService

[Josh Radcliff (AdWords API Team)]

Hi,

I would recommend adding a statistic field to your report request, e.g., Impressions. This will ensure that your report returns rows based on impressions served and not just the structure of your account.

Also, for placements you can use either the PLACEMENT_PERFORMANCE_REPORT or the AUTOMATIC_PLACEMENTS_PERFORMANCE_REPORT (for automatic placements) to get placement-related data. I'd include a statistic field on those requests as well.

Cheers,

Josh, AdWords API Team

[Inaal Haolam]

Hi, i will continue Omer's question:

I looked into  AUTOMATIC_PLACEMENTS_PERFORMANCE_REPORT , but could not find a PlacementUrl or Url field in that report.

Also, 

I would like ,for  a specific reason, to get a list of ALL "positive" placements, not only placements with statistical data (e.g. impressions=0)

I did not find a way to get those.

Thank you

[Josh Radcliff (AdWords API Team)]

Hi,

If you want to see the URLs from which your ads were actually served and not just the placement criteria you have in your ad group, you can use the URL_PERFORMANCE_REPORT. This will only show you URLs with impressions for your ad group, however. It will not show you all possible URLs that match your placement criteria.

Thanks,

Josh, AdWords API Team