I am not trying to save a file just save it into a database. I am doing this dynamically, as my service allows users to signup and show their data via a dashboard of our own.
The desired response I wanted from the report would be CAMPAIGN_PERFORMANCE_REPORT (Jan 1, 2016-Jul 7, 2016) Day,Campaign ID,Campaign,Impressions,Clicks,Cost,Conversions,Cost / conv. 20160707, <campaign id>,0,0,0,0.0,0 20160706, <campaign id>,2,0,0,0.0,0 20160705, <campaign id>,0,5,0,0.0,0 20160704, <campaign id>,1,0,1,0.0,0 20160703, <campaign id>,0,0,0,1.0,1 20160702, <campaign id>,0,0,0,0.0,0 20160701, <campaign id>,0,0,0,0.0,0 Total, --, --,0,0,0,0.0,0 as you can see in the above example it loads data from days with all 0's. On Thursday, July 7, 2016 at 5:34:28 PM UTC+10, Peter Oliquino wrote: > > Hi, > > I tested your AWQL query using my own test account and found that your > query should work fine in getting the (test account) results. In addition, > you will need to specify a file path in the $reportUtils in order for you > to be able to download the file into a CSV (or other format > <https://developers.google.com/adwords/api/docs/guides/reporting#supported-download-formats>) > > output file. > > Please also note that report generation is supported only at the account > level, meaning, the clientCustomerId specified in your auth.ini > <https://github.com/googleads/googleads-php-lib/blob/master/src/Google/Api/Ads/AdWords/auth.ini> > file > should be that of a client account instead of a manager account. You could > check our reporting guide > <https://developers.google.com/adwords/api/docs/guides/reporting> for > more information and also check here > <https://developers.google.com/adwords/api/docs/samples/php/reporting#download-a-criteria-performance-report-with-awql> > for > a more concrete example of generating a report (including the option on how > to suppress the headers) using PHP. > > I hope this helps. > > Thanks, > Peter > AdWords API Team > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/e1222acc-5154-4acc-85de-31316a73e509%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
