Api Google Adwords我们如何在当月但每天获得一个广告系列的报告？

Question

i need to generate the report using the api google adwords , for just one campain , during the current month but per each day , here is my query :

  $reportQuery = 'SELECT CampaignId,CampaignName, Impressions, Clicks, Cost '
        . ' FROM CAMPAIGN_PERFORMANCE_REPORT '
        . ' WHERE CampaignId = '.$campaignId.' DURING this_month';

i would like to get the result in this format :

date | impressions | clicks | ...
01/11| 12356785    | 23561  | ...
02/11| 23567985    | 3561   | ...
03/11| 82356785    | 56892  | ...
04/11| 62356785    | 562234 | ...

Is it possible ? if not how we can get the report without downloading the file ? Thanks

Answer 1

Adding the Date field to your query should do the trick. As mentioned here, Date has "Segment" behavior, so it will give you a new line with all the other metrics for every single one of its own values.