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