keywords text not coming as their exact type in KEYWORDS_PERFORMANCE_REPORT

48 views
Skip to first unread message

Sunil Kumar

unread,
Feb 7, 2017, 7:07:50 AM2/7/17
to AdWords API Forum, nitish...@gmail.com
Hi,

In my adwords account i have 3 types of keywords, namely:
1. "+jeddah+kolkata"              phrase type
2. [+jeddah+kolkata+exact]    exact type
3. +jeddah+kolkata+broad      broad type
4. [abc]    exact type
5. abc broad type

However, when i my downloading the KEYWORDS_PERFORMANCE_REPORT using the below query, i am getting these 3 keywords with double quotes at the beginning and at the end also which is not required. Can i get the keyword text as per their type.

Ex. :  Above keywords in the downloaded report are coming as:
"+jeddah+kolkata"             phrase type
"+jeddah+kolkata+exact"        exact type
"+jeddah+kolkata+broad"        broad type
abc broad
abc exact

Desired output:

"+jeddah+kolkata"                  phrase type
[+jeddah+kolkata+exact]         exact type
+jeddah+kolkata+broad           broad type
abc broad
[abc] exact

Query used:
SELECT CampaignName, CampaignId, AdGroupName, AdGroupId, Id, Criteria, Status, IsNegative, KeywordMatchType, Date FROM KEYWORDS_PERFORMANCE_REPORT WHERE Status IN [ENABLED, PAUSED] AND AdGroupStatus IN [ENABLED, PAUSED] AND CampaignStatus IN [ENABLED, PAUSED] DURING TODAY

Shwetha Vastrad (AdWords API Team)

unread,
Feb 7, 2017, 1:56:18 PM2/7/17
to AdWords API Forum, nitish...@gmail.com
Hi Sunil,

In API version v201607 and above, string values that can start with a - or + character will be wrapped in quotes with no leading space. Previously, these values were not double-quoted and had a leading space, but double-quoting the values is more consistent with the rest of the reporting API. 

The Criteria field in the Keywords Performance Report corresponds to the string representation of the criteria and will be returned as is in the downloaded report. You need to use the value available in the KeywordMatchType column to determine the match type of the keyword.

Regards,
Shwetha, AdWords API Team.
Reply all
Reply to author
Forward
0 new messages