Level of AdWords Keyword infomation in GA API

[csweeper]

In GA UI, there was no way to extract AdWords keyword + AdGroup +
Campaign combo in one report unlike AdWords keyword report.

Is it possible to get AdWords keyword information along with tied
AdGroup and Campaign thru GA API?

Thanks.

[Nick]

Hi,

So yes, you can :)

You can get at this relationship through custom reporting in the
UI...except that it's a drilldown for each dimension.
The API will also allow you to query this relationship, but returns
tabular data with all of the dimensions defined in each row.

-Nick

[csweeper]

Thank you, Nick

I tried Custom Reporting, but still I can not generate a screen or
Excel csv that shows campaigns, AdGroups, and keywords in one screen
something like below:

Campaigns AdGroups Keywords Visits
Campaign1 AdGroup1 key1 10
Campaign1 AdGroup2 key1 20
Campaign2 AdGroup1 key3 5
Campaign2 AdGroup1 key2 2

Above format is a typical tabular report format of Google AdWords.
Does GA UI or API support the type of report format per raw?
I need this type of format because there are many duplicate keywords
accross campaigns and AdGroups.
Thank you.

[Nick]

Correct, through the UI you can get at the data relationships but not
in the format you're looking for.

The API does support the output you are looking for.

-Nick