Data inconsistent when pulled from different resources... ad_group_criterion.negative is not returning when combined with keyword_view.. check details in the ticket

96 views
Skip to first unread message

Darshan Pradhan

unread,
Apr 25, 2019, 5:48:26 PM4/25/19
to AdWords API and Google Ads API Forum
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
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
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
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
    }
  }
}






Reply all
Reply to author
Forward
0 new messages