Hello, I am trying to pull the search keywords report data using an api call and to replicate the data from the UI.
The problem I have is that I need to replicate the Search Keyword Report in the UI with the Keyword Status filter set to Enabled in GAQL in my api call. Has anyone been able to replicate this report? I cannot seem to be able to pull the same amount of rows in my api call compared to the UI and I am not sure what am I missing. In the UI I set the Keyword status filter to Enabled and I expect around 1700 rows back. In my api I am getting 40000 rows and I am sure it has something to do with the Keyword status filter not being set properly in the query. Does anyone know how to set up the Keyword Status to Enabled in that query please or what the issue may be? SELECT ad_group_criterion.keyword.text, campaign.name, ad_group.name, ad_group_criterion.system_serving_status, ad_group_criterion.keyword.match_type, ad_group_criterion.approval_status, ad_group_criterion.final_urls, metrics.clicks, metrics.impressions, metrics.ctr, metrics.average_cpc, metrics.cost_micros FROM keyword_view WHERE segments.date DURING YESTERDAY AND ad_group_criterion.status != 'REMOVED' Thank you -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/e95ac923-970a-423d-a6cb-28a967ff8c90n%40googlegroups.com.
