AWQL; getting the keyword name

[newbie]

I almost have all the data I need using the following AWQL query from the AdWords API:

 String query = "SELECT Device, ID, Impressions, Clicks, Cost, AverageCpc, AveragePosition FROM CRITERIA_PERFORMANCE_REPORT " +

                "WHERE Status IN [ENABLED] AND Clicks > 0 DURING LAST_7_DAYS";

I have searched for hours, but cannot find the right column name to get the actual keyword text.  I mean, if I can get it's ID, surely I can get the text display value too, no?

[Sreelakshmi Sasidharan (AdWords API Team)]

Hello, 

The Criteria in CRITERIA_PERFORMANCE_REPORT will have the actual keyword text. Please note the column names are case sensitive and you will need to use "Id" as show below:

SELECT Criteria, Device, Id, Impressions, Clicks, Cost, AverageCpc, AveragePosition, CriteriaType FROM CRITERIA_PERFORMANCE_REPORT WHERE Status IN [ENABLED] AND Clicks > 0 DURING LAST_7_DAYS

Please let me know if you have any additional questions. 

Thanks,
Sreelakshmi, AdWords API Team

[newbie]

That was the magic word, thanks so much!

[kenneth rudisill]

me too. i have a proble like you, i still not fixed

[Sreelakshmi Sasidharan (AdWords API Team)]

Hello, 

Could you please elaborate the issue you are facing? Are you not able to get the actual keyword text using the Criteria field in CRITERIA_PERFORMANCE_REPORT? If so, could you share your report definition along with the client customer id and highlight the specific keyword for which you are facing issues? You could use reply privately to author while sharing the details.