SEARCH_QUERY_PERFORMANCE_REPORT empty report

51 views
Skip to first unread message

Luca Fiaschi

unread,
Aug 22, 2014, 5:00:30 AM8/22/14
to adwor...@googlegroups.com
Hi, 
I just noticed a strange behaviour when downloading reports:

the following report definition will return an empty report:


SELECT MatchType,MatchTypeWithVariant, KeywordTextMatchingQuery, AdGroupId, CampaignId,Query FROM SEARCH_QUERY_PERFORMANCE_REPORT WHERE MatchTypeWithVariant IN [NEAR_EXACT,NEAR_PHRASE] DURING 20041011, 20140820

however when adding a performance metric it correctly returns the data. 
For example adding the impressions as:


    SELECT MatchType,MatchTypeWithVariant, KeywordTextMatchingQuery, AdGroupId, CampaignId,Query, Impressions
    FROM SEARCH_QUERY_PERFORMANCE_REPORT
    WHERE MatchTypeWithVariant IN [NEAR_EXACT,NEAR_PHRASE]
    DURING 20041011, 20140820

is this an expected behavior?

Thanks

Josh Radcliff (AdWords API Team)

unread,
Aug 22, 2014, 3:06:48 PM8/22/14
to adwor...@googlegroups.com
Hi,

I confirmed this behavior, and I agree that it's slightly counter-intuitive. One way to avoid this problem would be to filter for Impressions > 0 in your report request.

That being said, I've passed this along to our reporting team to see if this is intentional behavior. If it is, then I'll make sure to update our reporting documentation accordingly. Thanks for pointing it out!

Cheers,
Josh 
Reply all
Reply to author
Forward
0 new messages