Automation of search_term_view report and discrepancies in results

[ArikN]

Hello All , 

I used a little Python code snippet in order to generate a search_term_view report on specific time frames , 

The select i am using is :

"SELECT segments.date, customer.id, customer.descriptive_name, campaign.id, campaign.name, ad_group.id, ad_group.name, search_term_view.status, search_term_view.search_term, ad_group_ad.ad.id, ad_group_ad.ad.type, ad_group_ad.ad.text_ad.headline, ad_group_ad.ad.text_ad.description1, ad_group_ad.ad.text_ad.description2, ad_group_ad.ad.expanded_text_ad.headline_part1, ad_group_ad.ad.expanded_text_ad.headline_part2, ad_group_ad.ad.expanded_text_ad.headline_part3, ad_group_ad.ad.expanded_text_ad.description, ad_group_ad.ad.expanded_text_ad.description2, ad_group_ad.ad.expanded_dynamic_search_ad.description, segments.keyword.ad_group_criterion, segments.keyword.info.text, search_term_view.search_term, segments.ad_network_type, segments.keyword.info.match_type, ad_group_ad.ad.display_url, ad_group_ad.ad.final_urls, metrics.cost_micros, metrics.impressions, metrics.clicks, metrics.conversions, metrics.interactions FROM search_term_view WHERE segments.date BETWEEN \'2019-03-01\' AND \'2019-04-01\'"

However - there is a big discrepancies between the total numbers (impressions,clicks etc) that i generate on google ads (on the same time frame of course) -  search term report , 

What am i missing ?

Thanks

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for reaching out.

To help me investigate, could you provide the clientCustomerId you used to download the report? Kindly use the reply privately to author option when providing the details. Also, make sure that you are comparing the right report from the Google Ads UI, you can see the equivalent report of the search_term_view report by referring to this mapping guide under "Search Terms Report".

Regards,
Dannison
Google Ads API Team

ref:_00D1U1174p._5001UBm9ne:ref