GAQL search_term_view returning fewer records than SEARCH_QUERY_PERFORMANCE_REPORT

[b...@venturestreet.com]

I am trying to migrate my Adwords API SEARCH_QUERY_PERFORMANCE_REPORT calls to Google Ads API search_term_view query.  My  SEARCH_QUERY_PERFORMANCE_REPORT use pulls all SEARCH records for a date range for an entire account.  The query below is returning fewer records.  For example,  SEARCH_QUERY_PERFORMANCE_REPORT return 89 records for one campaign and search_term_view  returns only 2.  Overall, I am missing about half of the records.

Here is my search_term_view query:

SELECT segments.date

, campaign.id

, ad_group.id

, ad_group_ad.ad.id

, segments.search_term_match_type

, search_term_view.search_term

, segments.keyword.ad_group_criterion

, metrics.impressions, metrics.clicks

, metrics.cost_micros

, metrics.conversions

, segments.year

, segments.ad_network_type 

FROM search_term_view 

WHERE segments.date BETWEEN '2022-01-01 AND '2022-01-01' 

AND segments.ad_network_type IN ('SEARCH') 

AND metrics.impressions > 0

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

Could you share with us the following details below so our team can better check on the issue?

• the AdWords API
  • complete SOAP logs (request and response with requestId)
• the Google Ads API
  • complete logs (request and response with request-id)

Please reply privately author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Thanks,

Nirmita Google Ads API Team

ref:_00D1U1174p._5004Q2a2e6l:ref