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.3333333333"></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.9400000000000001" 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.6666666667"></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.3333333333"
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.9400000000000001" 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.6666666667"
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.47000000000000003"
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.47000000000000003"
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.47000000000000003"
lostImpShareBudget="0.14" pos="2.6592178771"></grandtotal>
</totals>
</report>
I need your help in getting the exact report numbers in API. All the
numbers in xml report seem ROUNDED UP as well.
Please help
Thanks
On Dec 8, 12:45 pm, AdWords API Advisor <[email protected]>
wrote:
> Hi,
>
> This doesn't appear to be a question about the AdWords API, but rather
> the AdWords web interface. Please post your question to the general
> AdWords forum:
>
> http://www.google.com/support/forum/p/AdWords?hl=en
>
> Best,
> - Eric Koleda, AdWords API Team
>
> On Dec 7, 12:17 pm, SW <[email protected]> wrote:
>
>
>
>
>
>
>
> > 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
>
> > Date Campaign Id Campaign Impressions 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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
