Hi Members! I have a problem. I am getting data by using AdWords API report "Keyword PErformance Report". Sample data is given below: *Cal_IS (Calculated IS ) total is 75.83% that is differ from Adwords UI, Adwords UI IS total = 73.39 difference is about 2.44%*.
I know the difference is because of two records at serial no 8 and 13
because in these two records impressions = 0 and IS% is "<10%". *Now how
AdWords handle "<10%" or in some cases ">90%" values. *
Any idea please share your knowledge. File is attached herewith.
SNO QualityScore Impressions SearchImpressionShare (IS) Total Eligible
Impressions (TEI) = (Impressions/IS) Cal_IS = (Impressions/TEI)*100
1 3 1 50% 2 50
2 3 15 100% 15 100
3 3 1 14.29% 6.99790063 14.29
4 3 11 57.89% 19.00155467 57.89
5 3 10 62.50% 16 62.5
6 3 40 95.24% 41.99916002 95.24
7 3 8 72.73% 10.99958752 72.73
8 3 0 10% 0 0
9 3 1 25% 4 25
10 3 1 100% 1 100
11 3 2 100% 2 100
12 3 1 100% 1 100
13 3 0 10% 0 0
Total 91 119.9982028 75.83
Calculated IS 75.83
AdWords UI IS Total 73.39
Total Diff 2.44
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [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
---
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 [email protected].
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/a83aa5dc-6c43-4b6c-8572-b4a4e4766a2e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
IS_Calculation.xlsx
Description: MS-Excel 2007 spreadsheet
