Where can I get "Total: Search Keywords on Display Network" data from API?

[Jimmy]

There is a search keyword campaign in my ads account.

I have already used API to get the "Total: Keywords " data from from  keyword_view, and total clicks/cost from customer.

But I can't find the "Total: Search Keywords on Display Network" data.

Just like in the picture, I want to get 92,861 impressions, $795.40 cost from API, but I don't know how to get it.

I have tried query like this, but got nothing data return.

SELECT metrics.cost_micros, metrics.clicks FROM display_keyword_view WHERE AND segments.date>='2021-03-08' AND segments.date<='2021-03-14'

Do someone know which query should I use? Thank you.

[Google Ads API Forum Advisor Prod]

Hi Jimmy,

Can you please provide your client customer Id so I can take a closer look?

Thanks,
Anthony

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q2DwcBJ:ref

[Jimmy]

Hello:

2066198211,  Thanks.

adsapiforumadvisor 在 2021年3月19日 星期五上午12:00:22 [UTC+8] 的信中寫道：

[Google Ads API Forum Advisor Prod]

Hello,

Please use the keyword_view report and include the field ad_group_criterion.criterion_id. The ids that return 3000000 should total the sum of the Search Keywords on Display Network values. 

Regards,

[Jimmy]

Hello,

I tried the query like this, include the field ad_group_criterion.criterion_id:

SELECT campaign.id, campaign.name, campaign.status, ad_group.id, ad_group.name, ad_group.status, ad_group_criterion.criterion_id, ad_group_criterion.status, ad_group_criterion.approval_status, ad_group_criterion.keyword.text, ad_group_criterion.keyword.match_type, ad_group_criterion.quality_info.search_predicted_ctr, ad_group_criterion.quality_info.post_click_quality_score, ad_group_criterion.quality_info.creative_quality_score, ad_group_criterion.parental_status.type, ad_group_criterion.system_serving_status, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.average_cost, metrics.average_cpc, metrics.ctr FROM keyword_view WHERE ...

I calculate the sum of clicks in every node, then I will get total keywords clicks value [A] (like the yellow mark).

I can get the total account cost value [B] (select from customer, like the green mark).

If I want to get the [C] value, should I just subtract 171 from 411, 

or is there some field I can directly get the 240 clicks in Search Keywords on Display Network? Thank you.

Regards,

adsapiforumadvisor 在 2021年3月19日 星期五下午9:55:05 [UTC+8] 的信中寫道：

[Google Ads API Forum Advisor Prod]

Hi Jimmy,

You will need to subtract the values from [B] and [A] to get [C].