I'm writing an application that is going to give various levels of campaign reporting data. I've been able to get account level, campaign level, and adgroup level data, but there seems to be no way to get all of the keyword values on the account, or all of the keyword values on an adgroup. What i CAN get is the individual keyword performance by running
SELECT metrics.clicks, metrics.impressions, metrics.cost_micros,
ad_group.name,
campaign.name FROM keyword_view
and i can get the campaign and agroup in which they belonged, but there seems to be no way to select the actual keyword value in the query? I tried "keyword.text" which i've seen thrown around a few places but this fails on fetch.
I've gotta be missing something; seems crazy that i can pull keyword metrics but not the keyword value.