Rows returned is wrong

47 views

Skip to first unread message

oliver zhao

unread,

Jan 10, 2022, 4:05:57 AM1/10/22

to AdWords API and Google Ads API Forum

Hi,

I'm using GoogleAds API V9.

GAQL Query:

SELECT
                customer.currency_code,
                ad_group.id,
                metrics.average_cpc,
                metrics.average_cpm,
                campaign.id,
                metrics.clicks,
                metrics.conversions_from_interactions_rate,
                metrics.conversions,
                metrics.cost_micros,
                metrics.cost_per_conversion,
                ad_group_criterion.quality_info.creative_quality_score,
                ad_group_criterion.quality_info.post_click_quality_score,
                ad_group_criterion.quality_info.search_predicted_ctr,
                metrics.ctr,
                segments.date,
                ad_group_criterion.position_estimates.first_page_cpc_micros,
                ad_group_criterion.position_estimates.top_of_page_cpc_micros,
                ad_group_criterion.criterion_id,
                metrics.impressions,
                ad_group_criterion.effective_cpc_bid_micros,
                ad_group_criterion.effective_cpm_bid_micros,
                ad_group_criterion.quality_info.quality_score,
                metrics.search_exact_match_impression_share,
                metrics.search_impression_share,
                metrics.search_rank_lost_impression_share,
                metrics.conversions_value,
                metrics.value_per_conversion,
                metrics.view_through_conversions,
                metrics.absolute_top_impression_percentage,
                metrics.top_impression_percentage 
            FROM keyword_view
            WHERE segments.date BETWEEN '20211201' AND '20211201'

as expected, there should be no records which impressions = 0. but I found one in the result.

Thanks,

Oliver

Google Ads API Forum Advisor

unread,

Jan 10, 2022, 11:47:41 AM1/10/22

to adwor...@googlegroups.com

Hello Oliver,

Thanks for reaching out to the Google Ads API support. For us to investigate, could you please provide the complete request and response logs with request ID and request header generated on your end. And the screenshots of impressions on the Google Ads UI where you expected impression = 0
Please use the Reply privately to the author option while sharing the details.

Best regards,

Jakeia Sabrina
Google Ads API Team