How to distinguish smart_campaign_search_term_view status?

[Chen Xiaowei]

I use " SELECT campaign.id,campaign.status,campaign.serving_status, smart_campaign_search_term_view.campaign,smart_campaign_search_term_view.search_term, metrics.clicks, metrics.cost_micros, metrics.impressions FROM smart_campaign_search_term_view WHERE segments.date >= '2021-11-20' AND segments.date <= '2021-12-19' AND campaign.id = '15434054821'  ORDER BY metrics.cost_micros DESC "

to get smartcampaigns' search term view report and successfully get a request,but it can't distinguish the search_term_view status.It return both Added and Excluded status，and I see there‘s no status Resource fields in smart_campaign_search_term_view.

I wonder if API could show status like UI.

Besides,I find that sometimes it return part of search terms, some click&cost&impression=0's search terms donot returned.If API would filter some results？

Thanks，Vivi

[Google Ads API Forum Advisor]

Hi Chen,

Thank you for posting your concern.

You may try instead the search_term_view report, filter the campaign.advertising_channel_type by SMART and include the search_term_view.status.

Let me know if you can get the information that you are looking for.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2TOFMZ:ref

[Chen Xiaowei]

I‘ve tryed  search_term_view and filter the advertising_channe_type by  SMART, it returns null.

[Google Ads API Forum Advisor]

Hi Chen,

I work with Ernie and reproduced this issue of status being "NONE" for all smart campaign search terms in search_term_view, regardless of exclusion or non exclusion.

I raised with my team your request for status field in smart_campaign_search_term_view. This request is subject to review. You may monitor our blog for an update.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2TOFMZ:ref

[Chen Xiaowei]

So thankful for your reply！And I have another problem that sometimes  it return part of result.For example,in the UI it shows some search terms's clicks&spend equals 0,but some of them canont be returned in API with  smart_campaign_search_term_view.I wonder if API would filter some results?

Thanks.

[Google Ads API Forum Advisor]

Hi Chen,

Thank you for providing more details to your concern.

Could you confirm if the impression of those smart campaign search terms is zero as well? If yes, then it appears that you encountered one of the scenarios discussed in the document below that caused some of the details to not be included in the report.

https://developers.google.com/google-ads/api/docs/reporting/zero-impressions

Please let me know if you have further questions.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2TOFMZ:ref

[Chen Xiaowei]

Yeah，there‘re zero impressions too.Thanks for your reply!!!