Difference between filtered as incliduZeroImpressions is false and without filter (include is true)

[Harish R]

Hi Team

We are trying to download the Keywords, Criteria and Adgroup with maximum available columns but we are unable to download the data for few accounts due to huge size of data.

After going thru the documentation we could see that by using includeZeroImpressions as False predicate in the API call we will be able to eliminate the rows for which all the Measures are 0.

We tried to download the data using this condition and we can see that the data volume is getting reduced drastically. Earlier we were getting around 280 Million rows in 1 report for 1 day but now after adding that condition we are getting ~3000 rows for the same report.

 

Our basic analysis are as below

We are calculating Average for GoogleAdwordsKeywords[AveragePosition], GoogleAdwordsKeywords[QualityScore] and GoogleAdwordsAccount[CPC](CPC is calculated column from COST/CLICKS). Since the data volume is getting reduced drastically (after eliminating rows with all Impressions as 0) by using the above mentioned filter predicate we can see that there would be a huge difference in the calculated value of the measures. 

Please advice us in this scenario, is there huge difference in total cost/clicks with filter includeZeroImpressions.

Thanks and Regards

Harish

[Google Ads API Forum Advisor Prod]

Hi Harish,

Thank you for posting your concern.

Could you confirm if my understanding is correct that you are manually calculating the value for AveragePosition, QualityScore and CPC? I asked this because these fields are available and can be used in the report types specified in the provided links. The value of these fields will not be affected whether the includeZeroImpressions will be set to true or false.

Let me know if I misunderstood your concern and provide more details about it.

Regards,
Ejay
Google Ads API Team

ref:_00D1U1174p._5001U8KkeF:ref

[Harish R]

Hi Team,

We are calculating the Average of CPC as given below,

select avg(CPC) from [Division].[vw_Fact_GoogleAdwordsAccount] 
 where [Brand ID]=1639 and [Country ID]=12  -- 0.212782284775737
  
 select avg(CPC) from [Division].[vw_Fact_GoogleAdwordsAccount] 
 where [Brand ID]=442 and [Country ID]=12  -- 0.1861262317846

How the AveragePosition, CPC and QualityScore is calculated by API? We have to make sure that, we are following the same procedure…

Thanks and Regards

Harish

[Google Ads API Forum Advisor Prod]

Hi Harish,

Thank you for your reply.

My apologies as your concern is product related and outside of our expertise. With this, you may post your concern to Google Ads Community forum as they are more equipped to provide answer to your question about these fields and to know also how these fields are computed.