Hi,
I am seeing some inconsistency in data being returned from google ads api.
The pull of ad_group_criterion.negative using keyword_view(with negative =
true) is returning no results where as similar query directly against
ad_group_criterion yields count. Possibly a bug?
*UN-SUCCESSFUL REQUEST RESPONSE TO KeywordsView Resource
(**ad_group_criterion.negative
= true)*
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by com.google.protobuf.UnsafeUtil
(file:/Users/dpradhan/.m2/repository/com/google/protobuf/protobuf-java/3.5.1/protobuf-java-3.5.1.jar)
to field java.nio.Buffer.address
WARNING: Please consider reporting this to the maintainers of
com.google.protobuf.UnsafeUtil
WARNING: Use --illegal-access=warn to enable warnings of further illegal
reflective access operations
WARNING: All illegal access operations will be denied in a future release
2019-04-25 17:44:45,556 INFO [Gax-3] logging.RequestLogger
(RequestLogger.java:157) - SUCCESS REQUEST SUMMARY. Method:
google.ads.googleads.v1.services.GoogleAdsService/Search, Endpoint:
googleads.googleapis.com:443, CustomerID: 2533687629, RequestID:
wMXM-DRcHba1NsZ1vKcDVQ, ResponseCode: OK, Fault: null.
2019-04-25 17:44:45,852 DEBUG [Gax-3] logging.RequestLogger
(RequestLogger.java:161) - SUCCESS REQUEST DETAIL.
Request
-------
MethodName: google.ads.googleads.v1.services.GoogleAdsService/Search
Endpoint: googleads.googleapis.com:443
Headers: {developer-token=REDACTED, login-customer-id=2569949686,
x-goog-api-client=gl-java/11.0.1 gapic/ gax/1.35.0 grpc/1.16.1}
Body: customer_id: "2533687629"
query: "SELECT segments.date, campaign.id, campaign.name, ad_group.id,
ad_group.name, ad_group.status, ad_group_criterion.criterion_id,
ad_group_criterion.keyword.text, ad_group_criterion.keyword.match_type,
ad_group_criterion.position_estimates.first_page_cpc_micros,
ad_group_criterion.position_estimates.top_of_page_cpc_micros,
ad_group_criterion.status, ad_group_criterion.negative,
metrics.impressions, metrics.interaction_rate, metrics.interactions FROM
keyword_view WHERE segments.date DURING LAST_30_DAYS AND ad_group.status =
\'ENABLED\' AND ad_group_criterion.negative = true limit 10"
page_size: 1000
Response
--------
Headers:
Metadata(content-disposition=attachment,content-type=application/grpc,request-id=wMXM-DRcHba1NsZ1vKcDVQ,date=Thu,
25 Apr 2019 21:44:45 GMT,alt-svc=quic=":443"; ma=2592000; v="46,44,43,39")
Body: field_mask {
paths: "segments.date"
paths: "campaign.id"
paths: "campaign.name"
paths: "ad_group.id"
paths: "ad_group.name"
paths: "ad_group.status"
paths: "ad_group_criterion.criterion_id"
paths: "ad_group_criterion.keyword.text"
paths: "ad_group_criterion.keyword.match_type"
paths: "ad_group_criterion.position_estimates.first_page_cpc_micros"
paths: "ad_group_criterion.position_estimates.top_of_page_cpc_micros"
paths: "ad_group_criterion.status"
paths: "ad_group_criterion.negative"
paths: "metrics.impressions"
paths: "metrics.interaction_rate"
paths: "metrics.interactions"
}
Failure message: null
Status: Status{code=OK, description=null, cause=null}.
data count= 0
counts= cost 0, conversion : 0.0 , impression 0
*SUCCESSFUL REQUEST RESPONSE TO KeywordsView Resource
(**ad_group_criterion.negative
= false)*
WARNING: Illegal reflective access by com.google.protobuf.UnsafeUtil
(file:/Users/dpradhan/.m2/repository/com/google/protobuf/protobuf-java/3.5.1/protobuf-java-3.5.1.jar)
to field java.nio.Buffer.address
WARNING: Please consider reporting this to the maintainers of
com.google.protobuf.UnsafeUtil
WARNING: Use --illegal-access=warn to enable warnings of further illegal
reflective access operations
WARNING: All illegal access operations will be denied in a future release
2019-04-25 17:40:20,421 INFO [Gax-3] logging.RequestLogger
(RequestLogger.java:157) - SUCCESS REQUEST SUMMARY. Method:
google.ads.googleads.v1.services.GoogleAdsService/Search, Endpoint:
googleads.googleapis.com:443, CustomerID: 2533687629, RequestID:
F6RmHYbA4DZRggdxdhEuQA, ResponseCode: OK, Fault: null.
2019-04-25 17:40:20,991 DEBUG [Gax-3] logging.RequestLogger
(RequestLogger.java:161) - SUCCESS REQUEST DETAIL.
Request
-------
MethodName: google.ads.googleads.v1.services.GoogleAdsService/Search
Endpoint: googleads.googleapis.com:443
Headers: {developer-token=REDACTED, login-customer-id=2569949686,
x-goog-api-client=gl-java/11.0.1 gapic/ gax/1.35.0 grpc/1.16.1}
Body: customer_id: "2533687629"
query: "SELECT segments.date, campaign.id, campaign.name, ad_group.id,
ad_group.name, ad_group.status, ad_group_criterion.criterion_id,
ad_group_criterion.keyword.text, ad_group_criterion.keyword.match_type,
ad_group_criterion.position_estimates.first_page_cpc_micros,
ad_group_criterion.position_estimates.top_of_page_cpc_micros,
ad_group_criterion.status, ad_group_criterion.negative,
metrics.impressions, metrics.interaction_rate, metrics.interactions FROM
keyword_view WHERE segments.date DURING LAST_30_DAYS AND ad_group.status =
\'ENABLED\' AND ad_group_criterion.negative = false limit 10"
page_size: 1000
Response
--------
Headers:
Metadata(content-disposition=attachment,content-type=application/grpc,request-id=F6RmHYbA4DZRggdxdhEuQA,date=Thu,
25 Apr 2019 21:40:20 GMT,alt-svc=quic=":443"; ma=2592000; v="46,44,43,39")
Body: results {
campaign {
resource_name: "customers/2533687629/campaigns/REDACTED"
id {
value: 53115108
}
name {
value: "FMAG | Birthday Gift | Exact"
}
}
ad_group {
resource_name: "customers/2533687629/adGroups/REDACTED"
id {
value: 2164576308
}
name {
value: "Birthday Gifts - Main"
}
status: ENABLED
}
metrics {
impressions {
value: 1
}
interaction_rate {
}
interactions {
}
}
ad_group_criterion {
resource_name: "customers/2533687629/adGroupCriteria/REDACTED"
status: ENABLED
position_estimates {
first_page_cpc_micros {
value: 210000
}
top_of_page_cpc_micros {
value: 210000
}
}
criterion_id {
value: 14786871
}
keyword {
text {
value: "great birthday gifts"
}
match_type: EXACT
}
negative {
}
}
keyword_view {
resource_name: "customers/2533687629/keyword
... TRUNCATED. See README.md to configure/disable log truncation.
Failure message: null
Status: Status{code=OK, description=null, cause=null}.
{
"campaign": {
"resourceName": "customers/2533687629/campaigns/REDACTED",
"id": "53115108",
"name": "FMAG | Birthday Gift | Exact"
},
"adGroup": {
"resourceName": "customers/2533687629/adGroups/REDACTED",
"id": "2164576308",
"name": "Birthday Gifts - Main",
"status": "ENABLED"
},
"metrics": {
"impressions": "1",
"interactionRate": 0.0,
"interactions": "0"
},
"adGroupCriterion": {
"resourceName":
"customers/2533687629/adGroupCriteria/2164576308~14786871",
"status": "ENABLED",
"positionEstimates": {
"firstPageCpcMicros": "210000",
"topOfPageCpcMicros": "210000"
},
"criterionId": "14786871",
"keyword": {
"text": "great birthday gifts",
"matchType": "EXACT"
},
"negative": false
},
"keywordView": {
"resourceName": "customers/2533687629/keywordViews/REDACTED"
},
"segments": {
"date": "2019-03-26"
}
}
*SUCCESSFUL REQUEST RESPONSE TO AD_GROUP_CRITERION resource*
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by com.google.protobuf.UnsafeUtil
(file:/Users/dpradhan/.m2/repository/com/google/protobuf/protobuf-java/3.5.1/protobuf-java-3.5.1.jar)
to field java.nio.Buffer.address
WARNING: Please consider reporting this to the maintainers of
com.google.protobuf.UnsafeUtil
WARNING: Use --illegal-access=warn to enable warnings of further illegal
reflective access operations
WARNING: All illegal access operations will be denied in a future release
2019-04-25 17:36:33,282 INFO [Gax-3] logging.RequestLogger
(RequestLogger.java:157) - SUCCESS REQUEST SUMMARY. Method:
google.ads.googleads.v1.services.GoogleAdsService/Search, Endpoint:
googleads.googleapis.com:443, CustomerID: 2533687629, RequestID:
1CGBih2sBLvy4lviSYwK1w, ResponseCode: OK, Fault: null.
2019-04-25 17:36:34,002 DEBUG [Gax-3] logging.RequestLogger
(RequestLogger.java:161) - SUCCESS REQUEST DETAIL.
Request
-------
MethodName: google.ads.googleads.v1.services.GoogleAdsService/Search
Endpoint: googleads.googleapis.com:443
Headers: {developer-token=REDACTED, login-customer-id=2569949686,
x-goog-api-client=gl-java/11.0.1 gapic/ gax/1.35.0 grpc/1.16.1}
Body: customer_id: "2533687629"
query: "Select ad_group.id, ad_group.status,
ad_group_criterion.criterion_id, ad_group_criterion.resource_name,
ad_group_criterion.age_range.type,
ad_group_criterion.app_payment_model.type, ad_group_criterion.bid_modifier,
ad_group_criterion.cpc_bid_micros, ad_group_criterion.cpm_bid_micros,
ad_group_criterion.cpv_bid_micros, ad_group_criterion.keyword.match_type,
ad_group_criterion.keyword.text, ad_group_criterion.negative,
ad_group_criterion.user_interest.user_interest_category,
ad_group_criterion.user_list.user_list,
ad_group_criterion.youtube_video.video_id FROM ad_group_criterion WHERE
ad_group_criterion.status IN (\'ENABLED\') AND ad_group.status IN
(\'ENABLED\') and ad_group_criterion.negative = true LIMIT 10 "
page_size: 1000
Response
--------
Headers:
Metadata(content-disposition=attachment,content-type=application/grpc,request-id=1CGBih2sBLvy4lviSYwK1w,date=Thu,
25 Apr 2019 21:36:33 GMT,alt-svc=quic=":443"; ma=2592000; v="46,44,43,39")
Body: results {
ad_group {
resource_name: "customers/2533687629/adGroups/REDACTED"
id {
value: 1857151188
}
status: ENABLED
}
ad_group_criterion {
resource_name: "customers/2533687629/adGroupCriteria/REDACTED"
criterion_id {
value: 100516358
}
keyword {
text {
value: "romantic gifts for her"
}
match_type: EXACT
}
negative {
value: true
}
}
}
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/27ee7bad-37ba-431a-b8d8-8c0cde9aada4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
