How get keyword performance report according to group id using PHP?

[Meenu Singh]

I am trying to make a grid same as google adword screen for keyword performance report. I need to show keyword according to adgroup and want to show MAX CPC,clicks,Imr.. etc.

If any one have php example please guide me how to do that?

[Joyce Lava]

Hello Meenu,

Do you mean getting the Keywords Performance Report data based on adGroupId? If yes, then you can do a report query like this below. You can refer in this PHP example code that shows how to generate a report.

SELECT CpcBid, Clicks, Impressions FROM KEYWORDS_PERFORMANCE_REPORT WHERE AdGroupId IN [ ]; //put your adGroupId's

However, if you meant sorting (ORDER BY clause) the report data by AdGroupId, then unfortunately, it is not supported in AdWords API reports as discussed here. That said, there is no way to do a report query and return the data ordered by the specified field (e.g. adGroupId). However, you can sort them manually once you have the report downloaded file.

Please confirm.

Regards,

Joyce, AdWords API Team