How handle less than 10% and greater than 90% Impression Share value when we calculate Total IS%?

[Qaiser Javed]

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

[Milind Sankeshware (AdWords API Team)]

Hi Qaiser,

Looks like you have already posted the question on AdWords community forum. Since your question is product specific, they are better equipped to address product level questions. Please continue the discussion on that thread.

Thanks,
Milind, AdWords API Team.