Hello,
we are using the following report to get stats from keywords including their assigned labels:
var report = AdsApp.report(
'SELECT Criteria, Clicks, Impressions, Labels ' +
'FROM KEYWORDS_PERFORMANCE_REPORT ' +
'WHERE Status = ENABLED AND AdGroupStatus = ENABLED AND CampaignStatus = ENABLED ' +
'AND AdGroupName DOES_NOT_CONTAIN "zz" ' +
'AND Criteria CONTAINS "atollo" ' +
'AND AdNetworkType2 = SEARCH ' +
'AND Device IN ["DESKTOP"] ' +
'DURING LAST_WEEK ');
Facing the sunset of the AdWords API, we tried the Query Migration Tool, getting this result:
SELECT ad_group_criterion.keyword.text, metrics.clicks, metrics.impressions, ad_group_criterion.labels, segments.ad_network_type, segments.device FROM keyword_view WHERE ad_group_criterion.status = "ENABLED" AND ad_group.status = "ENABLED" AND campaign.status = "ENABLED" AND
ad_group.name NOT REGEXP_MATCH ".*zz.*" AND ad_group_criterion.keyword.text REGEXP_MATCH ".*atollo.*" AND segments.ad_network_type = "SEARCH" AND segments.device IN ("DESKTOP") AND segments.date DURING LAST_WEEK_MON_SUN
But "ad_group_criterion.labels" doesn´t seem to be the right attribute, showing only "undefined" results.
Can you get the keyword labels in an report including metrics?
Thanks!
Greetings
Martin