keyword_view query

[이은혜]

The query in use is keyword_view, and we want to get ad_group_criterion information on the same day as segment.date. Of these, only when the keyword search type is 'EXACT' on the google ads site, it is searched, and other searches are not performed. 

[Google Ads API Forum Advisor]

Hi there,

Thank you for reaching out to Google Ads API support. Could you privately provide us with logs of request and response to the API when log level is set to 'DEBUG' so that we can see what you are seeing?

The request and response appears similar to the JSON Mappings in our REST documentation with additional information such as  request ID. Our client libraries have loggers with logging instructions, to see these instructions you can click on the client library you use in the sidebar of our client library guide and click on "Logging”.

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2YqD8w:ref

[이은혜]

Thank you for your quick response. 

sent with request id. Is this what you want??

2022년 3월 23일 (수) 오전 12:10, Google Ads API Forum Advisor <ads...@forumsupport.google>님이 작성:

[이은혜]

i found the answer!

It was Exclude zero metrics by segmenting.

answer url : https://developers.google.com/google-ads/api/docs/reporting/zero-metrics#exclude_zero_impressions_by_segmenting

Thank you!

2022년 3월 23일 수요일 오후 1시 49분 53초 UTC+9에 이은혜님이 작성:

[Google Ads API Forum Advisor]

Hi there,

Your answer was one of the possibilities I was thinking about. Since this occurs when keyword is exact type I wasn't sure. Is this issue settled?

[이은혜]

I couldn't solve it....

I changed only the searchtype in the data with values, but it still doesn't come out. what's the problem..?

2022년 3월 23일 수요일 오후 10시 34분 58초 UTC+9에 adsapi님이 작성:

[Google Ads API Forum Advisor]

Hi,

I am also a member of the Google Ads API team and let me provide support to your concern.

To further investigate the issue, could you provide the complete request and response logs with request ID and request header generated on your end? 

If you haven't enabled the logging of the API transactions for the specific client library that you are using, then please refer to the specific guide below:
Java - https://developers.google.com/google-ads/api/docs/client-libs/java/logging
.Net - https://developers.google.com/google-ads/api/docs/client-libs/dotnet/logging
PHP - https://developers.google.com/google-ads/api/docs/client-libs/php/logging
Python - https://developers.google.com/google-ads/api/docs/client-libs/python/logging
Ruby - https://developers.google.com/google-ads/api/docs/client-libs/ruby/logging
Perl - https://developers.google.com/google-ads/api/docs/client-libs/perl/logging

You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2YqD8w:ref

[이은혜]

I found that criteria_id is generated according to searchtype.

It was a phenomenon that did not come up when searched with criteria_id whose match type is EXACT.

Thank you for your help.

2022년 3월 24일 목요일 오후 3시 32분 27초 UTC+9에 adsapi님이 작성:

[Google Ads API Forum Advisor]

Hi there,

Here's an example  keyword_view query that returned BROAD match keywords with metrics:

SELECT ad_group_criterion.keyword.match_type, ad_group_criterion.keyword.text, ad_group_criterion.labels, ad_group_criterion.type, ad_group_criterion.url_custom_parameters, ad_group_criterion.tracking_url_template, ad_group_criterion.quality_info.search_predicted_ctr, ad_group_criterion.quality_info.quality_score, ad_group_criterion.quality_info.post_click_quality_score, ad_group_criterion.quality_info.creative_quality_score, ad_group_criterion.placement.url, ad_group_criterion.percent_cpc_bid_micros, ad_group_criterion.negative, ad_group_criterion.final_urls, ad_group_criterion.final_url_suffix, ad_group_criterion.final_mobile_urls, ad_group_criterion.effective_percent_cpc_bid_source, ad_group_criterion.effective_percent_cpc_bid_micros, ad_group_criterion.effective_cpv_bid_source, ad_group_criterion.effective_cpv_bid_micros, ad_group_criterion.effective_cpm_bid_source, ad_group_criterion.effective_cpm_bid_micros, ad_group_criterion.effective_cpc_bid_source, ad_group_criterion.effective_cpc_bid_micros, ad_group_criterion.display_name, ad_group_criterion.disapproval_reasons, ad_group_criterion.cpv_bid_micros, ad_group_criterion.cpm_bid_micros, ad_group_criterion.cpc_bid_micros, ad_group_criterion.bid_modifier, ad_group_criterion.approval_status, segments.date, metrics.clicks, metrics.conversions, metrics.cost_micros, metrics.impressions FROM keyword_view WHERE segments.date DURING LAST_MONTH

As an example you may check 'customers/4506521631/adGroupCriteria/98094910050~299640875248' on 2022-02-28.

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2YqD8w:ref