Search term view does not return any result, despite search query performance report does

[sealytic...@gmail.com]

Hello,

We have a search query performance report query in adwords, we are getting results from this query. We migrate this query to Google Ads with query migration tool. But after this change it does not return any results. (Queries are below)

The point is that selected account has dynamic search ads too. When we remove segments.keyword.ad_group_criterion, segments.keyword.info.text columns from the Ads Query we are getting results. 

Adwords query does return keyword id and keyword for the same account.

How can we achieve same result in google ads.

Thanks

Adwords Query

SELECT ExternalCustomerId, KeywordId, KeywordTextMatchingQuery, QueryMatchTypeWithVariant, Query, Impressions, Clicks, Cost, ConversionValue, Conversions, AdGroupId, CampaignId, AdNetworkType2,AllConversions,AllConversionValue FROM SEARCH_QUERY_PERFORMANCE_REPORT where ExternalCustomerId = "1234567890" AND AdGroupStatus = 'ENABLED' AND CampaignStatus = 'ENABLED' DURING 20200101,20210101

Ads Query

SELECT customer.id, segments.keyword.ad_group_criterion, segments.keyword.info.text, segments.search_term_match_type, search_term_view.search_term, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.conversions_value, metrics.conversions, ad_group.id, campaign.id, segments.ad_network_type, metrics.all_conversions, metrics.all_conversions_value FROM search_term_view WHERE customer.id = 1234567890 AND ad_group.status = "ENABLED" AND campaign.status = "ENABLED" AND segments.date BETWEEN "2020-01-01" AND "2021-01-01"

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to our API support team.

Could you confirm if your records contain zero impressions? I asked because as per this guide, adding segments fields results in your zero impression records being excluded from the results.

However, so that our team can take a closer look at the no results issue, could you also provide our team with the request and response logs, with the request-id? If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link.

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Reminder: Share your feedback about the Google Ads (AdWords) API! Take the 2021 Google Ads API and AdWords API Annual Survey
 

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2RwKyp:ref

[sealytic...@gmail.com]

Hello,

I tried with impressions > 10 but still same. I shared request id and logs in private message.

Thanks

[Google Ads API Forum Advisor]

Hello,

Thank you for providing the requested info. Can you please remove the segments.keyword.* attributes from your query and then retry your request? In the AdWords API, non-keyword data was being unintentionally exposed, whereas the Ads API enforces that a keyword segmentation is actually a keyword, hence non-keyword data is filtered out. The Ads API logic is consistent with the UI.

Can you please try this and let us know if this is successful?

Thanks,
Matt
Google Ads API Team

Reminder: Share your feedback about the Google Ads (AdWords) API! Take the 2021 Google Ads API and AdWords API Annual Survey
 

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2RwKyp:ref