Search Impression Share mathematically wrong

129 views
Skip to first unread message

beter...@gmail.com

unread,
Aug 17, 2021, 4:59:14 PM8/17/21
to AdWords API and Google Ads API Forum
I am getting paradoxical Search Impression Share results, both using the API and the UI when querying Search Impression Share broken down by campaign versus not broken down by campaign.

One of my campaigns is showing "<10%" with  2,769 impressions.
That means that the total universe of possible impressions of this campaign is between
27,690 (in case it is the maximum, 10%)
and
276,900 (in case it is the minimum, 1%, or even a bigger universe (ex: 0.01%), making it even more paradoxical)

All other campaigns show precise Search Impression Share numbers, making it possible to infer the exact universe of possible impressions of all of them.

With those numbers we can see that:
1 - If the account total is correct, the "<10%" campaign is wrong. Should be 23%
2 - If the  "<10%" campaign is correct (between 1 and 10%), the account total is wrong. Should be between 22% and 57% - It shows 63.67%

This is a very specific case that seems to be an outlier.
All the campaigns are Search Campaigns inside the Google Network (no partners).


Results for August, 01, 2021 
Filter: "Campaign name does not contain "dsa""
Account: cpd_br_oap_goog_neoperformance_search_brs_noecom_elseve
Account id: 741-200-1528

I am attaching an image (dots and commas follow the international standard) and an excel sheet with all the calculations.
Captura de Tela 2021-08-17 às 17.46.20.png

This is a key metric for our clients, please advise.


BugParceladeImpressão-01-01-2021.xlsx

beter...@gmail.com

unread,
Aug 17, 2021, 5:09:27 PM8/17/21
to AdWords API and Google Ads API Forum
Adding screenshot from the UI:

First, the account total, not broken down by campaign.
Captura de Tela 2021-08-17 às 18.03.18.png

And here broken down by campaign:
ImpressionShareByCampaign.png

Google Ads API Forum Advisor

unread,
Aug 19, 2021, 1:09:06 PM8/19/21
to beter...@gmail.com, adwor...@googlegroups.com
Hi,

I replicated your issue in the UI, the higher the number of 'total universe of possible impressions' there is the lower the percentage on aggregate should be, and the percentage is too high based on the minimum case of having  27690 impressions. 

The Ads API attempts to provide the functionality that is presented in the UI, if the UI has an issue then the API will also have the same issue. I can only suggest you bring this to product support to resolve this.

Regards,

Google Logo
Aryeh Baker
Google Ads API Team
 


ref:_00D1U1174p._5004Q2Lo5Vv:ref

beter...@gmail.com

unread,
Aug 24, 2021, 1:37:46 PM8/24/21
to AdWords API and Google Ads API Forum
Tks Aryeh.
I´ve opened a case with product support. I Will post here the final resolutions.

Regards
Reply all
Reply to author
Forward
0 new messages