Thanks a lot Josh, that was it for the missing data field ! However for the rounded values, I still have an issue : I have copied an extract of my dataBase :
<https://lh3.googleusercontent.com/-oJV79weK1o8/U1Zaz_pJegI/AAAAAAAAH68/xvlqNxYgSHQ/s1600/Capture.PNG> As you can see, the conversion Rate here is clearly rounded (3 clicks, 33% (and not 33,33%) of ConvRate. *Live edit, looking at your last answe*r : The dataBase looks well configured with the conversionRate in "decimal(19,2)" Le jeudi 17 avril 2014 19:20:59 UTC-3, Josh Radcliff (AdWords API Team) a écrit : > > Hi, > > The blanks in some columns may be because those columns are not included > in the field list for the report in your properties file (see sample > file<https://github.com/googleads/aw-reporting/blob/master/aw-reporting/conf/aw-report-sample.properties>). > > If you modify your file to include the fields that are currently blank > (such as *AdNetworkType1*, *AdNetworkType2*) then you should see the > corresponding columns populated in your database. > > Regarding the numeric values -- are you sure they are being rounded? The > money amounts are most likely formatted in micros as described > here<https://developers.google.com/adwords/api/docs/guides/reporting-concepts#money> > . > > Regards, > Josh, AdWords API Team > > On Thursday, April 17, 2014 5:12:39 PM UTC-4, Thibault Quillard wrote: >> >> Hi Josh, >> >> Thanks a lot, this was indeed a mistake in the database setup ! >> >> (PS : I think I've answered to you only on another message by mistake : >> >> I have another issue of Blanks columns and of rounded values for CTR/Avg >> CPC and a lot of metrics ... ), Does anybody knows where this could come >> from ? >> >> Thank you >> >> >> >> Le mercredi 16 avril 2014 19:38:16 UTC-3, Josh Radcliff (AdWords API >> Team) a écrit : >>> >>> Hi, >>> >>> The logging issues (1 and 2) should be non-fatal. Am I correct in >>> assuming that the process continues after you see those messages? The Aw >>> Reporting project uses SLF4J <http://www.slf4j.org/faq.html>, a logging >>> facade that allows you to use whichever underlying logging framework you >>> prefer. The SLF4J User Manual <http://www.slf4j.org/manual.html> contains >>> more information on how to configure logging. >>> >>> Regarding issue #3, the error suggests that you may not have set up your >>> aw-report-sample.properties file with the proper database credentials. >>> Does the aw-report-sample.properties file you are passing as the >>> -fileargument contain valid database connection information as described in >>> the Configure >>> AwReporting<https://github.com/googleads/aw-reporting#configure-awreporting> >>> section >>> of the README? >>> >>> Cheers, >>> Josh, AdWords API Team >>> >>> On Wednesday, April 16, 2014 10:58:44 AM UTC-4, Thibault Quillard wrote: >>>> >>>> Hi everyone, >>>> I am quite new to the AW API world and wanted to use the github project >>>> AW-Reporting to pull the data in my own database. >>>> >>>> However, running the project gives me 3 mistakes : >>>> >>>> 1) No appenders could be found for logger / Please initialize log4j >>>> properly >>>> >>>> 2) Failed to load class "org.slfj4.impl.StaticLoggerBinder" >>>> >>>> 3) Unexpected error accessing the API: Could not open hibernate >>>> Session for transaction >>>> >>>> >>>> For the first two issues, I have been searching on google and tried to >>>> add a logj4.properties file in the class folder, but without luck. >>>> >>>> Would you know what could the problem come from ? >>>> >>>> Thanks ! >>>> Thibault >>>> >>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. For more options, visit https://groups.google.com/d/optout.
