How to get all VALID results from DisplayKeywordPerformaceReport

[T.Motodate]

Hi.

I have some question about the below related to DisplayKeywrodPerformanceReport.

To get all data of keyword on display network, I used the below AWQL through PHP AdWords Lib Ver.201601.

<AWQL>

SELECT CampaignName

     , AdGroupId

     , AdGroupName

     , Id

     , Criteria

     , Status

     , CpcBid

FROM DISPLAY_KEYWORD_PERFORMANCE_REPORT

WHERE CampaignName = [Our Campaign's Name]

AND AdGroupStatus != REMOVED

DURING [START],[END]

The target campaign has more than 200,000 keywords on display network.

However, I could get just only about 500 results with this AWQL.

I also tried the below AWQL.

<AWQL2>

SELECT CampaignName

     , AdGroupId

     , AdGroupName

     , Id

     , Criteria

     , Status

     , CpcBid

     , Cost      <<< Added New Column

FROM DISPLAY_KEYWORD_PERFORMANCE_REPORT

WHERE CampaignName = [Our Campaign's Name]

AND AdGroupStatus != REMOVED

DURING [START],[END]

Then, I could get just only about 200 results.

Compared to the result between <AWQL> and <AWQL2>,

<AWQL2> seemed to exclud the results with cost 0 AUTOMATICALLY.

So, I guess that the result of <AWQL> also filtered data AUTOMATICALLY with some condition.

<Questions>

To get all VALID results from DisplayKeywordPerformanceReport, are there any work arounds of this issue?

Best Regards.

[Shwetha Vastrad (AdWords API Team)]

Hi,

By default, only rows which have non-zero Impressions are returned when the includeZeroImpressions request header is not specified or is set to false. To get all the keywords in a campaign, you would need to explicitly include zero impressions.

Regards,

Shwetha, AdWords API Team.

[T.Motodate]

Thank you very much, Shwetha!

According to you, now I get all valid results from DisplayKeywrodPerformanceReport with the below way!

1) add "includeZeroImpressions' to option for the method ReportUtils::DownloadReportWithAwql.
2) add "Impressions >= 0" IN AWQL's where section.

Now my issue's been solved.
I close this topic.

2016年7月7日木曜日 2時53分05秒 UTC+9 Shwetha Vastrad (AdWords API Team):