Re: campaign report number mismatch
Hi, There is no way to change the number of decimal places in the numbers returned by reports created through the API. Best, - Eric On Dec 8, 3:43 pm, SW ga...@structuredweb.com wrote: API behaves in similar manner as well. Here is the report I generated today. The report(xml) numbers returned mimics the UI. here is multi days report report table columns column name=date/column column name=campaignid/column column name=campaign/column column name=imps/column column name=clicks/column column name=ctr/column column name=cpc/column column name=impShare/column column name=lostImpShareRank/column column name=lostImpShareBudget/column column name=pos/column /columns rows row date=2010-11-24 campaignid=184592386 campaign=Networking imps=7 clicks=0 ctr=0.0 cpc=0 impShare=0.88 lostImpShareRank=0.13 lostImpShareBudget=0.0 pos=2.5714285714/row row date=2010-11-26 campaignid=184592386 campaign=Networking imps=1 clicks=0 ctr=0.0 cpc=0 impShare=0.4 lostImpShareRank=0.6 lostImpShareBudget=0.0 pos=1.0/row row date=2010-11-27 campaignid=184592386 campaign=Networking imps=3 clicks=0 ctr=0.0 cpc=0 impShare=1.0 lostImpShareRank=0.0 lostImpShareBudget=0.0 pos=1.33/row row date=2010-11-28 campaignid=184592386 campaign=Networking imps=1 clicks=0 ctr=0.0 cpc=0 impShare=1.0 lostImpShareRank=0.0 lostImpShareBudget=0.0 pos=2.0/row row date=2010-11-29 campaignid=184592386 campaign=Networking imps=2 clicks=0 ctr=0.0 cpc=0 impShare=0.5 lostImpShareRank=0.5 lostImpShareBudget=0.0 pos=1.5/row row date=2010-11-30 campaignid=184592386 campaign=Networking imps=25 clicks=0 ctr=0.0 cpc=0 impShare=1.0 lostImpShareRank=0.0 lostImpShareBudget=0.0 pos=2.08/row row date=2010-12-01 campaignid=184592386 campaign=Networking imps=16 clicks=0 ctr=0.0 cpc=0 impShare=0.9401 lostImpShareRank=0.06 lostImpShareBudget=0.0 pos=2.0/row row date=2010-12-02 campaignid=184592386 campaign=Networking imps=5 clicks=0 ctr=0.0 cpc=0 impShare=1.0 lostImpShareRank=0.0 lostImpShareBudget=0.0 pos=1.6/row row date=2010-12-03 campaignid=184592386 campaign=Networking imps=6 clicks=0 ctr=0.0 cpc=0 impShare=0.86 lostImpShareRank=0.14 lostImpShareBudget=0.0 pos=3.67/row /rows /table totals subtotal imps=7 clicks=0 ctr=0.0 cpc=0 impShare=0.88 lostImpShareRank=0.13 lostImpShareBudget=0.0 pos=2.5714285714 name=2010-11-24/subtotal subtotal imps=1 clicks=0 ctr=0.0 cpc=0 impShare=0.4 lostImpShareRank=0.6 lostImpShareBudget=0.0 pos=1.0 name=2010-11-26/subtotal subtotal imps=3 clicks=0 ctr=0.0 cpc=0 impShare=1.0 lostImpShareRank=0.0 lostImpShareBudget=0.0 pos=1.33 name=2010-11-27/subtotal subtotal imps=1 clicks=0 ctr=0.0 cpc=0 impShare=1.0 lostImpShareRank=0.0 lostImpShareBudget=0.0 pos=2.0 name=2010-11-28/subtotal subtotal imps=2 clicks=0 ctr=0.0 cpc=0 impShare=0.5 lostImpShareRank=0.5 lostImpShareBudget=0.0 pos=1.5 name=2010-11-29/subtotal subtotal imps=25 clicks=0 ctr=0.0 cpc=0 impShare=1.0 lostImpShareRank=0.0 lostImpShareBudget=0.0 pos=2.08 name=2010-11-30/subtotal subtotal imps=16 clicks=0 ctr=0.0 cpc=0 impShare=0.9401 lostImpShareRank=0.06 lostImpShareBudget=0.0 pos=2.0 name=2010-12-01/subtotal subtotal imps=5 clicks=0 ctr=0.0 cpc=0 impShare=1.0 lostImpShareRank=0.0 lostImpShareBudget=0.0 pos=1.6 name=2010-12-02/subtotal subtotal imps=6 clicks=0 ctr=0.0 cpc=0 impShare=0.86 lostImpShareRank=0.14 lostImpShareBudget=0.0 pos=3.67 name=2010-12-03/subtotal grandtotal imps=66 clicks=0 ctr=0.0 cpc=0 impShare=0.88 lostImpShareRank=0.12 lostImpShareBudget=0.0 pos=2.1515151515/ grandtotal /totals /report Here is separate client's report for one day only: report table columns column name=date/column column name=campaignid/column column name=campaign/column column name=imps/column column name=clicks/column column name=ctr/column column name=cpc/column column name=impShare/column column name=lostImpShareRank/column column name=lostImpShareBudget/column column name=pos/column /columns rows row date=2010-12-07 campaignid=59397348 campaign=Phone Systems imps=537 clicks=5 ctr=0.00931098696461825 cpc=11256000 impShare=0.39 lostImpShareRank=0.47003 lostImpShareBudget=0.14 pos=2.6592178771/row /rows /table totals subtotal imps=537 clicks=5 ctr=0.00931098696461825 cpc=11256000 impShare=0.39 lostImpShareRank=0.47003 lostImpShareBudget=0.14 pos=2.6592178771 name=2010-12-07/ subtotal grandtotal imps=537 clicks=5 ctr=0.00931098696461825 cpc=11256000 impShare=0.39 lostImpShareRank=0.47003 lostImpShareBudget=0.14 pos=2.6592178771/grandtotal /totals /report I need your help in getting the exact report
campaign report number mismatch
Hi, We are using v13 version of adwords report. I see some discrepancies when looking at the report numbers. The problem is when you see the SUMMARY RECORD on top of the report through adwords user interface, the numbers are not rounded (so assuming right numbers). When you look at the detail records, the numbers are ROUNDED UP. Here is single record example: Detail record exported as csv DateCampaign Id CampaignImpressions Clicks CTR Avg CPC Impression Share (IS) Lost IS (Rank) Lost IS (Budget)Avg Position report data for one day: 12/3/2010 184592386 Networking 6 0 0.00% 0 86% 14% 0% 3.7 Here is the summary record for above Impressions Clicks CTR Avg CPC Impression Share (IS) Lost IS (Rank) Lost IS (Budget)Avg Position 6 0 0.00% $0.00 85.71% 14.29% 0.00% 3.67 Here is same report for multiple days 11/24/2010 184592386 Networking 7 0 0.00% 0 88% 13% 0% 2.6 11/26/2010 184592386 Networking 1 0 0.00% 0 40% 60% 0% 1 11/27/2010 184592386 Networking 3 0 0.00% 0 100%0% 0% 1.3 11/28/2010 184592386 Networking 1 0 0.00% 0 100%0% 0% 2 11/29/2010 184592386 Networking 2 0 0.00% 0 50% 50% 0% 1.5 11/30/2010 184592386 Networking 25 0 0.00% 0 100%0% 0% 2.1 12/1/2010 184592386 Networking 16 0 0.00% 0 94% 6% 0% 2 12/2/2010 184592386 Networking 5 0 0.00% 0 100%0% 0% 1.6 12/3/2010 184592386 Networking 6 0 0.00% 0 86% 14% 0% 3.7 here is the summary record for above: Impressions Clicks CTR Avg CPC Impression Share (IS) Lost IS (Rank) Lost IS (Budget)Avg Position 66 0 0.00% $0.00 88.31% 11.69% 0.00% 2.15 if you add the impressionshare/lost impression share rank or budget columns, the average of those columns doesn't match with what summary record displays. Can someone please explain why there is difference in numbers when you see detail record versus summary records? Also, what formula google uses when displaying average numbers when it comes to percentage columns? -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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